Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM Historical Aged Tri...
Microsoft Dynamics GP (Archived)

PM Historical Aged Trial Balance

(0) ShareShare
ReportReport
Posted on by Steve Hoffort 97

I'm having a very strange issue with the PM HiATB.  It is showing approximately 25% more than actual for end of the month.  I've checked the numbers and used Reconcile to GL and all other trial balances and reconciliation tools are accurate.  I'm not sure why for my one client that the Historical Aged Trial Balance for end of last month is showing 2 million owing more than actual.  I've run check links and tried to find duplicate or uncleared data in tables but to no avail.  I've found void transactions with current transaction amounts in the tables, but when I look for them in the HiATB, they don't appear so that isn't it either.

This does appear peculiar but if anyone has any experience with this sort of issue in the past, please help me to shed some light on

*This post is locked for comments

  • Steve Hoffort Profile Picture
    Steve Hoffort 97 on at
    RE: PM Historical Aged Trial Balance

    I would like to thank you both for your response to the issue that I'm having with the PM HiATB.  However, the problem appears to run deeper into the business logic of the module.  From what I see, I'm most likely going to be required to open a support incident with Microsoft.  

    Here's what I'm finding:

    I started looking first only at vendor DETEQS01 and discovered that there were invoices paid and moved to the history table (PM30200) that did not have a corresponding payment in the Apply to History table (PM30300).  This of course should never happen.

    I created and ran a script to extract all invoices with a current transaction amount of zero that did not have a corresponding entry in the PM30300 table.

    I found 4,508,748.84 total invoices (sheet at Aug 16 2019)

    I then removed all invoices that had a Date Invoice Paid Off later (DINVPOF) than July 31 and it came to 2,426,146.30

    If I take the balance showing on the HiATB at July 31 of 8,887,557.53 and subtract the 2,426,146.30 I end up with 6,461,411.23 then subtracting the GL balance 6,268,822.55 leaves 192,588.68

    I still am puzzled as to the nearly 200K remaining but I’m quite a bit closer

    Why the offsetting applied transaction isn’t being created (and not every time) is a mystery to me at this time

  • Rosemary Profile Picture
    Rosemary 10 on at
    RE: PM Historical Aged Trial Balance

    Good day,

    I do agree with Bill, if users go back and apply payments with different dates, that is other than the period of the TB.

    I have also seen when doing a Historical TB the period has to be open and the date has to be 'GL Posting' date and not 'Document date'.

    Not sure if this is applicable for GP 2016.

    Regards,

    Rosemary

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: PM Historical Aged Trial Balance

    I know this is not a complete answer to your issue, but I almost always find that the reason for reports to be out of sync is most often related to miss dated and or misapplied documents.  Such that if you have payments dated in August and Invoices dated in July and run the PM HATB for July - you might find the values show wrong.

    Not saying this is your issue - but it is one that I have encountered.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans