Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Receivables Documents ...
Microsoft Dynamics GP (Archived)

Receivables Documents Not Showing on the Historical Aged Trial Balance

(0) ShareShare
ReportReport
Posted on by Community Member

Hello:

A GP 2015 R2 end user is comparing the balance shown for one customer on the Receivables Detailed Historical Aged Trial Balance (HATB) with data that he exported for that customer from SmartList's Receivables Transactions report.

The HATB report option is excluding "Zero Balance", "No Activity", and "Unposted Applied Credit Documents".

He shows how all documents from the SmartList with a Document Status of "History" are not showing on the HATB.

Now, all of these historical documents have $0.00 for SmartList's "Current Trx Amount" column.  But, I don't think that that's what is preventing these Historical documents from appearing.

The end user is wondering why these documents do not appear on the HATB and, therefore, affect the customer's balance as shown on the HATB.

Can anyone think of a reason?

Thanks!

John

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Let's put it this way, Mariano.  Even if you made an educated guess, I'd be more comfortable with your guess than another person's fact!  You're that good!

    John

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Glad that work out for you! I don't always get them on the first answer, but I get them eventually, LOL!

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Hi Mariano:

    That was it.  Five credit memos containing the amount of the historical balance did not have apply records, yet, were in history.  

    It's a matter of using the RM Transaction Unapply tool to bring these credit memos back into open and re-apply them.

    Thank you!

    John

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    The next thing to do is to look at that document in the tables -- make sure the apply records are correct and in history, make sure there are no apply records in work/open for this document, and making sure the document status is correct in the key table.

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Hi Mariano:

    I apologize.  I had forgotten to mention that I had already done this.

    John

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Run a reconcile first on that one customer and then re-run the HATB report. Perhaps, there's something wrong in the summary balance.

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Thanks, Mariano!

    The end user says that this is the only customer whose balance does not reflect the total amount of the historical documents.

    And, the cutoff date that we're using is 04/30/2018.

    But, could the end user be simply mistaken?

    John

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Clearly not! The Historical Aged Trial Balance is a snapshot of what customers owed as of a certain date. I would NEVER expect it to match the SmartList showing only historical documents. Depending on your cut off date, some of those documents that are now in history may have had a balance as of the cut off date, therefore would have been open back then.

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Hi Mariano:

    I get the same result.

    But, I should mention that I discovered this morning that the documents appear on the HATB but the total amount of the historical documents does not affect the balance.

    The customer's balance, therefore, does not match the total of the historical documents of the SmartList.

    John

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receivables Documents Not Showing on the Historical Aged Trial Balance

    Excluding zero balance excludes customers who owe nothing to the business, therefore excluding their documents from the report too. I would go back and uncheck this option.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans