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

Notifications

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) / management reporter ba...
Microsoft Dynamics GP (Archived)

management reporter balances for one natural account does not equal Dynamics GP

(0) ShareShare
ReportReport
Posted on by Community Member

I have a strange occurrence that one account number with 62 variants due to other segment combination, doesn't match the correct info in GP.  I am using the Data Mart.  I have recreated three times but the same results.  I have created a new Column, Row and reporting tree and get these wrong amounts.  It isn't consistent differences and no patterns are there.  I'm hoping someone may have come across this.  Also, no AA or MDA being used.

Thanks

Mike

*This post is locked for comments

I have the same question (0)
  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Have you tried drilling down to the 62 variants in MR and compare them to the 62 variants on a GL TB in GP?  Is it one account or multiple accounts that's throwing it off?

    Your mentioning "it isn't consistent differences" is interesting.  So if you run the same report twice, you don't get the same results or is it inconsistent differences per month?

  • Community Member Profile Picture
    Community Member on at

    I have and found it strange.  Most of the accounts have incorrect balances but there are a few that are correct.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    If you don't use a tree, do you get the same results?

  • Community Member Profile Picture
    Community Member on at

    I hadn't thought of that.  I created a simple report with that one account number using the whole account and that balances perfect to the GL TB.  I'm just confused how this could happen to one account number.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Could there be some potential duplication of variants of accounts on the tree?  Are there other accounts that have the same variants?

    Are you specifying units of the trees at all in your row or column formats.  I've seen duplication and/or wrong balances on some complex reports when you have a fairly complex tree and start specifying tree units on the other formats.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    After drilling around I discovered a stuck batch that was sitting in the GL work table.  I then looked back at MR and noticed that they has selected posted and unposted transactions.  After clearing the transactions the statement is fine.  I also set the report to posted only.  Thanks for your help!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans