How to Convert Revenue Display from Negative to Positive in Dynamic Budgets Article

How to Convert Revenue Display from Negative to Positive in Dynamic Budgets Article

The following setting in Manage Company Databases  determines whether revenue Account Numbers will display as negative or as positive values.

To change the display from negative to positive values:

1) Click the Positive Values radio button and then click "Save Definitions";
2) Run the necessary SQL script to update the database: please see Converting from Negative to Positive Revenue Format ; and
3) Check the "Native Total" box for all Define Row Formats .



    • Related Articles

    • Converting From Negative to Positive Revenue Format Article

      When converting from a Negative to Positive Revenue Format on Manage Company Databases  and you have several years of data where revenues were recorded as negative values, please run the below script. Also, please see How to Convert Revenue Display ...
    • 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 ...
    • Manage Budgets Article

          Tutorial Link Purpose: To provide tools to manage budgets such as budget list, budget creation, delete/purge budget, lock budgets/acct #s, link actual GP data & display setup, display budgetids, forecast setup, create historical avg for spreads. ...
    • Account-Debit or Credit Setup (Typical Balance)? Article

      To review the Typical Balance (debit or credit) for an account go to the Export Budget to GP screen: 1) Select the CompanyDB and BudgetID you wish to review; and 2) Click on Search. 3) All accounts will display including the nature of the Typical ...
    • Define Row Formats Article

      This tool is used to total and subtotal data into user defined formats. After changes are made, please Save. Please note that Expand/Reduce Column Width functionality is available. A) To Add a New Format We will first review the process and then ...