Notifications
Announcements
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.
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 663 Super User 2026 Season 1
Abhilash Warrier 289 Super User 2026 Season 1
Martin Dráb 232 Most Valuable Professional
