MR Previous Year Ending Balance for just 1 row

(0) Share

Report

Posted on by RJarrell

277

Does anyone know how to pull the previous year ending balance for just 1 row in MR? This is for a direct cash flow statement. It is a revenue account so the BB is zero.

Thanks!

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

RJarrell 277 on at

Like (0)

Report

RE: MR Previous Year Ending Balance for just 1 row

Yep, I was reading the report wrong so it turns out I don't need the previous years balance. I had been looking at this report for far too long.

That being said, there is a way to pull previous year amounts into a row.

You need to add a column for the previous year and set it to NP. You can then create a row that pulls through the amount. So something like the example below.

Then you can use a calculated field to pull the amount from the hidden column into the active column.

Column Example:

B C

YTD -1 YTD

NP

Example:

Line 500 - NP - Set to account 70-6000

Line 550 - CAL - C=B.500