Totals on financial statement for variances are incorrect

The totals on financial statement for variances are incorrectly showing negative and positive signs for favorable/unfavorable figures.  Variance columns only look to see if there is an increase or decrease.  They do not recognize settings within the Visual Chart Organizers that "Show debit balance as" positive or negative.
This issue is resulting from the VCO having revenue accounts mixed in expense sections.  The revenues and expenses must be separate to report on  favorable/unfavorable figures consistently.

1.  Open the VCO used on the report.
2.  Change the VCO to Design view.
3.  Remove all Headers and Account Detail sections under expenses that filter on revenue accounts.  Save and close the VCO.

* Can also remove the Variance selection from the Column, and instead use mathematical function to subtract the two columns

Environment

 7.82.104, patch 18

Was this article helpful?