OK so I have a very large discrepancy in two accounts my payroll clearing and the payroll account.
The steps I ran were as follows.
I created a GP macro to enter about 89 transactions in the financial>Bank transactions area in gp.
However I did not notice that 6 of the entries had repeating zeroes in the decimal place. This caused GP to enter them in the trillions of dollars. At the end of the macro I got a sql error that is would not be able to enter a null value and the batch got stuck in GP. However all of the transactions posted to both accounts. I removed the batch from the sy00500 table. I fixed the macro and reran it with the correct amounts. At this point I got a call from the CFO at the company stating that we had duplicated allot of transactions and that there was a problem with 6 of them being in the trillions of dollars. He voided out the small value duplicates however we are not able to void out the large amount ones.
So I jumped into sql and modified the GL20000 and gl10000 and put the correct amounts into the transaction that had the trillions of dollars. Now if I do a summary inquiry on the accounts in question they are still stating the 19 trillion dollar issue. But if I go to the detail inquiry the totals at the bottom are correct.
At this point I do not know how to resolve the issue any help would be greatly appreciated
The steps I ran were as follows.
I created a GP macro to enter about 89 transactions in the financial>Bank transactions area in gp.
However I did not notice that 6 of the entries had repeating zeroes in the decimal place. This caused GP to enter them in the trillions of dollars. At the end of the macro I got a sql error that is would not be able to enter a null value and the batch got stuck in GP. However all of the transactions posted to both accounts. I removed the batch from the sy00500 table. I fixed the macro and reran it with the correct amounts. At this point I got a call from the CFO at the company stating that we had duplicated allot of transactions and that there was a problem with 6 of them being in the trillions of dollars. He voided out the small value duplicates however we are not able to void out the large amount ones.
So I jumped into sql and modified the GL20000 and gl10000 and put the correct amounts into the transaction that had the trillions of dollars. Now if I do a summary inquiry on the accounts in question they are still stating the 19 trillion dollar issue. But if I go to the detail inquiry the totals at the bottom are correct.
At this point I do not know how to resolve the issue any help would be greatly appreciated