In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution. Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values. However, in financial reporting, there are times when the natural format does not suit the format of your reports, so it is necessary to reverse the sign.
Applies to: The Sage Intelligence Financial Report Designer
As an example, in an Income Statement, Revenue is naturally a credit account, and so it will be seen as a negative amount after the Sage Intelligence formula is dragged in for the row and its arguments configured. This will also impact any other formulas in the layout that depend on it, like Variance and Gross Profit.
It, therefore, makes sense to reverse the sign of the Sage Intelligence formulas in the row. For this, all you have to do is the following:
The results will now be negated. In other words, the credit balances will be shown as positive values, making the layout easier to interpret and other formulas more natural to calculate.
United Solutions provides unmatched software solutions and support for clients in the construction, real estate industries. We enable our clients to operate at peak efficiency and maximize their profits.Read More
Subscribe to Our eNewsletter