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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Historical reports for...
Finance | Project Operations, Human Resources, ...
Suggested answer

Historical reports for AP are showing zero's where there used to be numbers. Data in AP tables is correct

(0) ShareShare
ReportReport
Posted on by The Doctor 12

After the Fall 2020 upgrade, the Historical Aging AP report is showing incorrect amounts for vendors.  It was not this way before the upgrade to Fall 2020 from 18 R2.  The Historical Aging for AR is fine and numbers are spot on.

I have been looking through the known issues and trying to find something specific to this but not yet.

Any thoughts for fixing this particular issue?

Thanks,

Robert

p.s.  bonus question:  Management Reporter 2012 with CU16 Income report for 12 months of 2020 shows doubling of amounts starting in May.  Jan-April are good and match to GL.  May on is basically doubled and certainly doesn't match.  Again, this was after the Fall 2020 upgrade.

Thanks

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Historical reports for AP are showing zero's where there used to be numbers. Data in AP tables is correct

    Hi Robert,

    Regarding your MR question, you'll want to check the MR Data Mart Integration logs, in the MR Configuration Console.  If you see a message that change tracking is not enabled, you'll want to click Reconfigure Change Tracking.  You'll find this in the MR console, on the right side on the integration screen.  When you click Reconfigure Change Tracking, you'll need to enter the sa user and password.  When you click OK, the login prompt will disappear.  You won't see a message saying it completed or was successful.  You may then need to rebuild the data mart, depending on how long the error was occurring.  Change tracking only looks back 3 days, so if the error was happening for longer than that, you'd need to rebuild the data mart.  

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Historical reports for AP are showing zero's where there used to be numbers. Data in AP tables is correct

    Hello, this is Andrea and I can assist you with your HATB question today.

    It sounds as though you are running into known Quality Issue 93574, “18.3 feature Remove MC Fully applied documents from PM HATB not working correctly”.

    Essentially, there was a new feature included in the October 2020 release that broke the HATB by making incorrect changes to the pmHATBLoadDexTempTables stored procedure. This will cause unexpected results when printing the HATB when marked to exclude ‘Fully Paid Documents’

    Here’s the link to the feature in which this quality issue cropped up, and there is a link on the blog where you can download the ‘correct’ stored procedure:


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

    The good news is that the fix for this quality issue was included in the 2020 Year End Update.


    However, you can also fix the problem now by reverting back to the 18.2

    pmHATBLoadDexTempTables stored procedure.

    Here’s what you can test:

    1. Make a backup of the company database.
    2. Run the script (linked to from the blog above) to update the pmHATBLoadDexTempTablesstored procedure against the company database.
    3. Run the HATB again, and verify it is now accurate.

    I hope this helps!

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,339

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 824 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 600 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=bing+news+qu+answ+4+ts+++andlrla+m+dt+accounts+payable+turnover+certificate+templates+for+powerpoint+presentation" - Nested quantifier +.