Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Wrong Balances showing for Profit / Loss on Balance Sheet

Posted on by 22,647

History

Client year end Nov 30

Did year end close Jan 25

Found needed to make some Adjustments to Closed year Feb 22

Everything appears to have posted correctly and all reports were correctly printed and recorded.

Issue

When looking at financial statements printed for end of November - after the Year end - the Profit / Loss figure agrees to the Profit / Loss figure on the Income statement.

After preparing and posting a number of closed year adjustments (done Feb 22) the client re-runs the Financial statements for November - the Profit / Loss figure for Balance Sheet does not agree with the Profit / Loss figure for the Income statement.

While we would expect that the Adjustments done to the closed period would effect the numbers, why would there be a difference between the two values on two different reports.

Before you ask, the Balance Sheet is in Balance - the only thing strange is the value shown in P/L statement is different than the Balanace Sheet. 

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    Sorry I did not post the solution for the problem.

    The client and I invested a huge number of hours looking at the data, looking at the reports and trying to determine what was causing the problem.

    We eliminated the data as a problem as we were able to get a Smartlist dump of the Profit and Loss accounts and got to match a number we were seeing on the reports.  That was the Balance Sheet value.  So then we knew that the problem was on the Income Statement.

    Focused on the report and we tearing the report apart line by line.  Looking for missing accounts.

    There were no missing accounts.

    What we did not look so closely at was the filters on the columns - bottom line determined that the issue was a filter on the column that did not include one of the department values unless the Roll Up was done a certain way.

    Once we removed the filter all was corrected and the values on the reports all agreed.

    Thanks to everyone for your time and effort in looking into this matter.

  • JoshP Profile Picture
    JoshP on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    Hi Bill,

    Sorry for the delayed response as this originally did not get flagged as a Management Reporter question. Are you still having the same issue where balances are different between reports? If so, please provide some additional details:

    What is the full version number of MR are you using?

    Can you re-create the same issue on a very simple test report? Include just the account in question, one or two FD columns, and no reporting tree.

    Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    Here are a couple of places I'd look...

    Is there a plug on the balance sheet somewhere?

    Is one report being run with posted and unposted activity and the other being run with only posted activity?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    Thanks for the advice to look before trashing.

    Balance Sheet - P/L - value shows - 2,973,090.37

    Income Statement - Net Profit shows - 2,992,777.87

    A difference of 19,687.50

    There is a single P/L that had that amount in evidence and has since May of 2015 and which appears when I drill on both the Balance Sheet and the Income Statement.

    What makes this account interesting is that in May the original transaction was done to enter the Revenue - however it was coded to the wrong GL account - in May is was corrected by JE and moved from one Revenue account to another.

    What is strange is that prior to the prior period adjustments the Balance Sheet P/L and the Income Statement Net Profit both agreed.

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    The equivalent in the MR world is to recreate the datamart which essentially involves removing the integration, deleting the DM database and then re-adding and re-enabling.

    Before going that route, have you tried running the balance sheet with Account Level detail and then drilling in to the Net Income line for that company?  You could then run the Trial Balance in GP for the same account range and date and compare the accounts to see for sure if it's a data issue and which accounts are causing the issue to determine for sure if everything posted correctly.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Wrong Balances showing for Profit / Loss on Balance Sheet

    To add more interesting twists - we are running Management Reporter and running the Data Mart connection.

    As best I can tell there are no errors in the data retrieved for other companies - like 14 of them.

    I know with FRx I would have likely tossed the G32 and forced a refresh - what is the equivalent in the Management Reporter world?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans