Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Management Reporter *caution: the above total doesn't match the account balance record

Posted on by 750

I am getting this error on the transaction level of my MR Reports.  I have seen others experience the same, but can't seem to find a resolution.

management reporter *caution: the above total doesn't match the account balance record

 

I am currently setup to pull via LEGACY as DataMart has not been reliable.  MR Version 2.1.12000.26

 

Anyone else experiencing this?

*This post is locked for comments

  • Napolo Profile Picture
    Napolo 750 on at
    RE: Management Reporter *caution: the above total doesn't match the account balance record

    Thank you, Harry.

    I talked with our consultant.  Error is only populating at the transaction level. Finance and Account level are fine.  We are assuming it is because the budget does not breakdown by transaction. The total appears, but each detailed row is 0.00 and the caution alert is shown.

    At this point, we are not going to utilize transaction detail if we have a budget column.  This is to avoid confusing end users.

    Wish we could turn that alert off on the transaction level, but we couldn't find a setting to do so.

    Thanks again!

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Management Reporter *caution: the above total doesn't match the account balance record

    Nicole -

    If you are having a problem with the detail budget information not matching a total, you may be dealing with a problem I wrote a blog article about. The problem is the Year1 column in the database was not properly updated for one or more rows of data.

    redbeardblogging.blogspot.com/.../management-reporter-budget-data-not.html

    --Identify problem records in the Budget Master Detail file by running this query
    select BMH.YEAR1, BMD.YEAR1,* from GL00200 BMH
    left join GL00201 BMD on BMH.BUDGETID = BMD.BUDGETID 
    where BMD.YEAR1 = 0
  • Napolo Profile Picture
    Napolo 750 on at
    RE: Management Reporter *caution: the above total doesn't match the account balance record

    I have isolated where this is occurring.  It is when the Column Definition is changed from FY15 Budget to FY16 Budget Category, if that helps a bit.

  • Napolo Profile Picture
    Napolo 750 on at
    RE: Management Reporter *caution: the above total doesn't match the account balance record

    It appears to be pulling in Jun Net Change into the July reports. We have not yet closed our Fiscal year, but I don't think that should affect the output.  The Account and Financial level is accurate. It is only skewing the transaction level.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans