For example, let's assume the following scenario:

 

Retained Earnings = Acct 3310000, balance = $1,000,000

Net Income = Acct 5699999, balance = $100,000 

 

I've created a report that shows me this, but I need to submit the report to our parent company as:

 

 

I've created a variable that I call "Net Income Adjustment", and manually enter in the net income amount for each period.  I have coded the report to then add that amount whenever it presents Retained Earnings.  The report lines are ordered not by numeric account value, but by the specific sequence I desired, so my logic looks like this:

 

if {glaccounts.acctcd} = "3310000" then
Sum ({@Per 10 Balance}, {@Line Sequence}) - {@Net Inc Adj Per 10 YTD}

 

This is working fine, but the trouble is, I don't want to have to manually enter the net income.  It slows me down, and seems unnecessary, considering that the net income amount is already available under a different account.  However, it seems that because the Net Income resides in a different account, whenever I try to simply point that adjustment variable to the Net Income account, it comes up with a zero, because the account has to be 3310000 to be valid for the arguement.

 

I've tried creating a subreport where I calculate the net income, and then create an assignment of the calculation to a shared data variable, and then placing that shared data in the main report, hoping it would then be "decoupled" from the account, but it doesn't seem to work that way.

 

I've thought about just changing the account validation to read "3310000 or 5699999", but this report isn't actually a true Balance Sheet, in that it does also present other information, including the actual Net Income, so I think doing that would distort my Net Income presentation.

 

Does anyone have a suggestion of how I can harness the existing system calculation of Net Income to automate this process?

 

Seems like such a simple problem...

 

Thanks,

 

Paul