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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Transactions on AP HATB not showing

(0) ShareShare
ReportReport
Posted on by 52

User printed an AP HATB Detail in March of 2020 for 12/31/2019. User ran the same report in January of 2021 and the report is missing transactions. Running the report for 12/31/2020 has the same type of missing transactions. Totals are also missing in the Summary report. If I run the AP HATB sql scripts from the GP community (Cowmaster), I get transactions in the results. If I change the dates, the results change with it.  Possible reasons why it would not show on the HATB.

I have run check links on  Transaction History and Open. I have run reconcile on all vendors, a single vendor etc. Currently running file maintenance on all Purchasing.

Categories:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Microsoft Employee on at

    If you are on the October update, GP 18.3.1173, there is a known issue with the HATB report not pulling data correctly, and you can run download the stored proc linked at the top of this blog below to fix it.   It is an 'alter' script.   This has been fixed in the year-end update 18.3.1200.  

    https://community.dynamics.com/gp/b/dynamicsgp/posts/microsoft-dynamics-gp-fall-2020-remove-mc-fully-applied-documents-from-hatb

    Hope that resolves it for you if you are on that version. 


    Cheryl Waswick

    Microsoft support

  • renzweiler Profile Picture
    52 on at

    Resolved. Thanks!. Saw the title and dismissed due to MC. Lesson learned.

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!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans