Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 91

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 91 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 2 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 22,647 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans