
Apparently our AP users were able to simultaneously pay the same voucher with two different checks. Then they realized there was a duplicate check and created a void check for it, which will not release and is now an S status batch (partially released). What is the best way to correct this? I am comfortable making changes in the tables however I want to make sure I fix it all the way through, if anyone can assist with which tables/fields I need to look at please advise!...
thanks!
*This post is locked for comments
I have the same question (0)Hello amz,
The void check batch will never release. Update the Status of that batch in the Batch table to H and delete the batch in the screen.
Then, I would start by looking at the APAdjust table. Are there entries in that table for both checks? Run this statement and insert the numbers of both checks:
Select * from apadjust where adjgrefnbr in ('xxxxxx','xxxxxx')
If you have two apadjust records, perhaps delete one of them. Then set the status of that check in APdoc to V and the Doctype to VC. Then create a journal entry to correct the issue in GL.
Did you look at the voucher balance? Is it negative or still zero? Check the APdoc for the voucher.
Let me know if you find something and have additional questions.