web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / Payables Transaction A...
Microsoft Dynamics GP (Archived)

Payables Transaction Appearing Only on the Historical Aged Trial Balance (HATB)

(0) ShareShare
ReportReport
Posted on by Community Member

Hello:

A payables credit transaction is appearing only on the Detailed Historical Aged Trial Balance (HATB) and not anywhere else in GP or in the company database.

I have checked the "usual suspects" in the database, as follows: PM20000, PM30200, PM30300, and PM30600.

But, again, the transaction appears only on the report.

How do we fix this?

Thank you!

John

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    What is the value of your date fields in the PM20000, PM30200 & PM30300? There are 27 date fields in those tables, but for me the answer would reside in one of those fields.

    Kind regards,

    Leslie

    On my blog, I have a description of 26 of those fields dynamicsconfessions.blogspot.com/search

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Hi Leslie:

    Thank you, as always, for your response!

    The transaction, actually, does not appear in any of the tables.  What would be the best approach?

    Thanks, again!

    John

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    John,

    at this point I would find every instance of that document number in the entire database. AND the search tool is free. Go to Apex Search, and download the FREE tool and search the database for instances of that record or batch number. If some other number is more specific, search for that.

    Kind regards,

    Leslie

    ANYONE WHO DEALS WITH SQL WILL LOVE THIS FREE TOOL!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans