Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Management Reporter no...

Management Reporter not picking up correct balance on net income account

(0) Share

Report

Posted on by Community Member Microsoft Employee

on a new balance sheet created in Management reporter, the ytd and prior ytd value for an account is not correct. frx and the trial balance are correct. I cannot identify where the value comes from, the current year value for the account is 3,515,018, and the report displays 0, last year value = 12,793,443.47 and the report displays 10,335,785.

All other account balances are correct

Any suggestions would be appreciated!

Thank You!

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Management Reporter not picking up correct balance on net income account

My experience on this is that you need to refresh the Data Mart database. It would also be good to run the Management Reporter diagnostics SQL statements and clean up any data shows up from running the diagnostic statements before refreshing the Data Mart database.