We voided some old A/P checks in May and for some reason several did not post to GL. On the check register notice that all the fields from Ref Nbr over are blank. How can we fix this?
*This post is locked for comments
Karla,
Correction on my above post. If the Void Check Entry batch is suspended, update the status of the Void Check Entry batch to H and then delete it in the Void Check Entry screen. Sorry about the typo.
Karla,
It appears that you have already verified that the original check does not have an Apadjust or an Aptran record. If that is true, then you won't be able to void these checks. I didn't bother sending the statements as it appears you have already run them.
What is the status of the Void Check Entry batch? Did it suspend? I believe it would suspend since necessary records are missing for the original check. If the Void Check Entry batch is suspended, you could update the status of the Void Check Entry batch to V.
For the checks you are trying to void, you can update them via SQL. I just entered a perclosed value but you should change it to what you want the period closed for these voids.
Update apdoc set status = 'V', perclosed = '201105' where refnbr = 'xxxxxx' and docclass = 'C' and status = 'O' and acct = 'xxxx' and sub = 'xxxx'
Please let me know if you need any other statements or suggestions.
Carolyn,
Thanks for responding!
I did some more digging and it also appears that they did not post to GLTran, APTran or APAdjust. They only show up in APDoc. This is true with the original checks and the voids.
Yes, I have access to SQL and would like to do more validating, do you want to post the statements here or email them to me?
Karla
Hello Karla,
Without looking at the data using SQL Server, I would say that some of the database records for those checks are missing and that is why the payment information is missing on the check register. The checks cannot be voided unless all database records are in the database.
If you have access to SQL Server, I could give you some statements to look for the records to validate my assumption.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
