I am using an admin role and is trying to show the total corporate tax and net income per period through a transaction saved search. (Should match the Income Statement) The base currency of the subsidiary is GBP and the ultimate parent's is USD.
In the saved search, I am using the Amount field which should show the translated amount in USD because my Consolidated Exchange Rate is set to Per Account. Also, I did not restrict my view in my Set Preferences.
Interestingly, my total tax is translated correctly in the saved search but not the net income/loss.
My criteria are:
Period is This Fiscal Year
Account Type is Other Income, Other Expense, Income, Expense, COGS
Posting is Yes
Subsidiary is Sub A
RESULTS
Period (Group)
Amount (Sum) - net income/loss
CASE WHEN ..... THEN {amount} ... - total corporate tax
Any other reason why the net income/loss in the saved search will not match the Income Statement?