Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Documents won't clear from PM HATB

(0) ShareShare
ReportReport
Posted on by 270

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

  • Suggested answer
    Tricia Mummert Profile Picture
    Tricia Mummert 270 on at
    RE: Documents won't clear from PM HATB

    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

  • Tricia Mummert Profile Picture
    Tricia Mummert 270 on at
    RE: Documents won't clear from PM HATB

    I entered the check date in the PM30200.DINVPDOF field.  Is there another field that should also be populated?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Documents won't clear from PM HATB

    When you manually applied the docs, did you set the date fully paid fields?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans