Specify Normal Balance cell in a row definition
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.
Totaled and calculated rows typically are not affected by a C code. The exception is that the XCR print control in the column definition reverses the sign of any row that contains a C in the Normal Balance column. This formatting is especially important when you want to show all unfavorable variances as negative amounts. If a totaled or calculated number displays the wrong sign, place a C in the Normal Balance cell for the row to reverse the sign. For more information about the column definition Print Control, see the “Add a print control code” section in Add special formatting options.