Revenues and Expenses Don't Net-Reports are Summing Absolute Values Article

Revenues and Expenses Don't Net-Reports are Summing Absolute Values Article

If your revenues and expense are summing absolute values instead of netting out, there are 2 places to check 





Typical Fixes: (Assuming you wish to display and enter CR balance accounts (aka Revenues) as positive values)

  1. Check Define Row formats and make sure all rows, in all formats, have Native Total check marked
    This tells the application to roll up the sum of all native balances for your accounts.


         



Once corrected your report should look similar to the screenshot below:  

  • (Sub totals for Revenue (CR balance Groupings) will show as Positive Values
  • Sub totals for Expense (DR balance groupings) will show as Negative Values)


           


        2) If the Native Totals were already check marked in Define Row Formats, then the Company Settings for Revenue formatting may need to be adjusted

    • In System Management \ Manage Companies \ Segment Definitions tab
    • If Display Revenues As (and any other CR balance Accounts) is set to Negative, change the choice to Positive Values.
    • Click the Save Company only button
    • Be sure to Close and Reopen whichever Data Entry or Report screens you had open
    • and then re-perform your search and the subtotals should be corrected.



      • Related Articles

      • Custom Reports Article

           Tutorial Link Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. The report is structured to the user's needs. Reports with a customized Column Format as defined in Define Custom ...

      • Refresh Spread Method Source Values Article

        The Simple Spread Methods provides the option to spread a budget over months in the budget year using as the spread basis Actual data from Great Plains Accounting (ERP) software.  Should the selected Actual spread year remain open for posting, ...

      • Custom Reports Tutorial

        PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. Other Related Tutorials & Page Links:* Step by ...

      • Define Custom Reports-Actual, Variance, Comments Tutorial

        PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Prerequisite Steps: Make use of the reporting tags 1-10 in manage objects, orgunits and master chart of accounts. This helps with the display of desired accounts ...

      • Change in Display of Revenue Values Tutorial

        PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Note: Please contact Dynamic Budgets before changing the display of revenue.  We need to determine the assumptions, allocations, and fixed calc entries. We may ...