Share
Report
7,365I have come across a strange situation with a void of a manual payment. This is GP 10 SP1. I have not talked with the user yet, I have just been told to see why the checkbook isn't balancing. This is what looks like happened.
Checkbook Balance is lower than G/L Balance by $66,934.98
User entered an unapplied manual payment to record an AFC payment. They overrode the Payment No. (PYMT000XXX) with "EFT." Manual Payment is for $33,267.49 (exactly half of the checkbook/GL difference coincidentally)
For one reason or another, this got voided. Maybe it went to batch recovery, maybe it had errors, I’m not sure. But it is voided. Then it was reentered successfully using a normal Payment Number.
T
he GL Shows two credits and one debit to “cash” as expected. The Checkbook Register shows a proper payment and then a voided one. However, the voided one is now listed as a WDL type instead of a CHK
Smartlist shows that this Voided Transaction has a checkbook amount of $33,267.49 whereas all the other voided ones are $0.00
If my balance is off by double the $33,267.49, I think that the void actually didn’t work to the subledger, perhaps due to the next number that it needed to grab from the Payment Number (had been overridden with EFT). But it never brought the checkbook balance back up on the void, and I think it is also counting against the checkbook as a Withdrawal (given it is marked as a WDL).
I have tried Checklinks and that didn’t work.
I have run SQL scripts to select this transaction side by side with another legitimate voided transaction to see the difference. There seems to be an extra entry for this transaction in the CM20100 table.
Does anyone have any suggestions before I go in and try to reset values in SQL? Like CMTrxType to 3 instead of 4 and set my transaction amounts to 0.00 in the CM20200 table? I can do this first in a test environment.
*This post is locked for comments
All responses (
Answers (
