I have a client on GP 9 that has had a few payables check run posting interruptions between 2009 and 2012 that were not properly cleared up at the time. The problem was compounded when they either cut new checks or created credit memos to try and clear the original invoices off of the PM HATB report.
The client has a test database populated with this data for me to use. I have identified the checks and corresponding vouchers that should have been applied with those checks. I also identified the tables in which records appeared to be missing. Using one check which should have been applied to one voucher, I added the missing payment record in the following tables: PM30200, PM00400, PM30600, PM80500, and PM80600. I also updated the missing APFRDCNM information in the PM30300 for the existing voucher record.
When I view the data using the Inquiry windows, everything appears fine - the check shows that it is applied to the voucher; the voucher shows that it is applied by the check (plus 2 credit memos, but I haven't tried to clean that up yet). However, the PM HATB still shows the voucher and the payment even though I am choosing to exclude fully paid documents.
Check Links has been run on all of the Payables logical tables, and I ran the Reconcile utility for this particular vendor for summary, fiscal year and calendar year.
How do I clear the voucher and payment off of the payables historical aged trial balance?
*This post is locked for comments
I found the problem. I had to void the other documents that were created to try to clear up the problem initially because they affected the applied amount of the original voucher.
Many thanks to Siva Venkataraman for his Payables HATB With Aging By Payment Terms (using GL Posting Date) SQL script found here: msdynamicstips.com/.../payables-hatb-with-aging-by-due-date-using-gl-posting-date
I entered the check date in the PM30200.DINVPDOF field. Is there another field that should also be populated?
When you manually applied the docs, did you set the date fully paid fields?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156