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!
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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148