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!
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.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
