I created a column for prior year YTD and current year YTD and am adding them together. That works great for everything except Retained Earnings/Net Income. Is there anyway within either the row set or column set to take the prior year net income and add it to the retained earnings account and only include the current year net income in the net income account?
*This post is locked for comments
Hi all,
At column definitions, I've created three columns; B, C, D. First column is standard one. Second column is for closing transactions. I used Attribute filter: Transaction Posting Type = [Close] Third column is the difference of first and second columns. (D=B-C)
Print Control is NP for B and C columns.
There is no closing transaction for 1st to 11th months. The closing transactions are at the last column and all those accounts' balances are zero.
If you generate the report for these months (1-11), all figures will be all zero at the C column. So the report will work properly
If you generate the report as 12th period, all figures will be all zero at the B column, but you will see the sign of account balance reversed. Our formula is: B-C => 0 - (-X) = X
I found a method in my own way.
If anyone have any other solution with standard functionalities of MR, I would ask him to share.
I am having the same issue. Has anyone come up with a solution?
Hi Katy,
I am having the same problem. Did you find a solution? Thank you in advance!
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
