web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter Ca...

Microsoft Dynamics GP (Archived)

Management Reporter Cash Flow Statement

(0) Share

Report

Report

Posted on by Community Member

Does any one have a recommendation on how to setup the Cash Flow Statement in Management Reporter to accommodate the following:

Additions to Capital Assets - Decrease in Cash Flow

Retirement of Capital Asssets - Increase in Cash Flow

Same GL Account Numbers.

Is there a way in Management Reporter to say "If Net Change is debit, then increase in cash; else, zero"

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

RE: Management Reporter Cash Flow Statement

The best thing to do is set up two accounts. Generally the use of cash and the source of cash are two separate line items in a cash flow statement. Netting them to one line doesn't accurately reflect what is going on.

Management reporter has basic formulas; add, subtract, sum.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Management Reporter Cash Flow Statement

In your row definition put your Capital Assets line as a non-printing row, then in a row under it make a calculation row with a formula like "IF @450>0 THEN @450 ELSE 0" (row 450 being your Capital assets row)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Management Reporter Cash Flow Statement

Great! I will try that. Thank you.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans