I have P&L Forecast with a variance amount column. The Revenues rows have the correct variances for FAV/(UNFAV) but the Expense rows do not. My formula on the variance column is IF D<0 THEN D-C ELSE C-D. which works fine for the revenue but not the expenses. What is correct setup?
*This post is locked for comments
I have the same question (0)
Laurel - this is likely because of the Normal Balance setting in your Normal Balance (F) of your Income Statement Row Definition, where you'll probably find a 'C' in the Revenue Rows.
The Normal Balance cell in a row definition controls the sign of the amounts in a row. To reverse the sign of a row, or if the normal balance of an account is a credit, enter a C in the Normal Balance cell for that row. Management Reporter for Microsoft Dynamics ERP reverses the sign on all credit balance accounts in that row. When Management Reporter converts these accounts, it removes the debit/credit characteristic from all amounts, which makes totaling straightforward. For example, to calculate net income, you subtract expenses from income.
Share
Report
All responses (
Answers (
12,931
