Generic filters
Exact matches only
Search in title
Search in content

How Can We Help?

< Back
You are here:

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:

  1. Select the Sage Intelligence formula you want to change.
  2. In the formula bar, enter a minus sign after the equals and before the GL portion of the function.
  3. Press Enter to confirm the change.

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.





Previous Sage 300 CRE: How to use the import job cost estimate feature
Next Sage 300 CRE: How to make PJ change request’s, markup, add-on, and taxes grid
Table of Contents
Want Exclusive Sage Construction Software Tips?
Join Our eNewsletter
Get Sage Construction software promotions, events and updates delivered straight to your inbox!
Give it a try, you can unsubscribe anytime.