Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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

  • serbach Profile Picture
    serbach 571 on at
    RE: Management Reporter - Income Statement Formulas

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

    Steve Erbach

  • serbach Profile Picture
    serbach 571 on at
    RE: Management Reporter - Income Statement Formulas

    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

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans