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?
