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 - ...
Microsoft Dynamics GP (Archived)

Management Reporter - Income Statement Formulas

(0) ShareShare
ReportReport
Posted on by Community Member

For the Variance column on the Income Statement our VP of Finance is requesting to have the Income section of accounts show as Positive figures and the COGS & Expenses to show as Credits.    The US company is reporting in US dollars and so is the Canadian company.  

We are using the Variance reporting, known as favorable/(unfavorable), the type of account is also taken into consideration. For example, in revenue accounts, if actual results are higher than those budgeted, the variance is displayed as favorable (Positive Number). However, if actual expenses are higher than budget, then that variance is displayed as unfavorable (Inside Brackets). 

I have come across some websites that mention to use the XCR function for the Gross Profit, but that is for only one account.  This need to be done for about fifteen accounts and three sub-totals.  

Any suggestion on how to get Management Reporter to flip the sign on those accounts?

Regards,

Kevin 

*This post is locked for comments

I have the same question (0)
  • serbach Profile Picture
    serbach 571 on at

    Kevin,

    I use this method for monthly P&L reports:

    1. In the Row Def at the very bottom I added two Non-Printing CAL rows. One formula is simply a 1; the other is -1.
    2. Above the Revenue section in the Row Def I added a CBR row. The formula references the Row Code of the CAL row with the 1 in it (in our case, 4960).
    3. Above the Expense section in the Row Def I added another CBR row. That formula references the Row Code of the CAL row with the -1 in it (in our case, 4990).
    4. Above the Gross Profit section, another CBR row referring to the 1 row.
    5. Above the Overhead section, another CBR row referring to the -1 row.
    6. Above the Net Profit section, a final CBR row referring to the 1 row.
    7. In the Column Def explanations below, U is the prior period, V is the current period.
    8. In the Column Def the $ Variance column looks like this: (V-U)*BASEROW.
    9. The % Variance column looks like this: IF U<0 THEN -BASEROW*(V-U)/U ELSE BASEROW*(V-U)/U.

    That gives us the proper Favorable/(Unfavorable) signs no matter what section of the report.

    Sincerely,

    Steve Erbach
    WOW Logistics Company
    Appleton, WI

  • serbach Profile Picture
    serbach 571 on at

    Sorry, in the Column DEF the two Variance columns I mention are CALC columns.

    Steve Erbach

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