Is There Not a Such Thing as a Rolling Cash Flow Statement?

(0) Share

Report

Posted on by Community Member

Hello:

Yes, yes, I know all about the creation and calculation of the four columns that show the beginning balance of cash for current and year to date in Management Reporter and the old FRx.

But, can you not conduct a rolling cash flow statement for prior months?

Several people over the last three months have tried to help a GP end user do that. I came in, just now, to take a look and saw that the other consultants tried using BASE-1, BASE-2, etc. for the prior monthly periods.

But, the beginning balance for those prior periods would not display. Why not?

John

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Greg Byer 2,586 on at

Like (0)

Report

Hi John,

You should be able to do this by carrying out the calculation for the next set of columns. If we use the demo Cash Flow report in MR, there are two columns for the YTD. Column C has YTD/BB and Column D has YTD. Column E is then a calc that subtracts the two. If we created another set, we can use BASE-1 for the Period for the next two FD columns. So we'd have Column F with BASE-1 and Periodic, Column G with BASE-1 and YTD/BB, and Column H with BASE-1 and YTD. Column I would then substract H and G.

In the row definition, we'd need to adjust the calculation that is there. The demo report has B=B.1180, E=C.1180. We'd need to add to this and add F=F.1180, I=G.1180.

You could then carry that out for the remaining months you wanted on the report.

Was this reply helpful? Yes No