Converting From Negative to Positive Revenue Format Article

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 from Negative to Positive In Dynamic Budgets .





Update Assumptions Set

P00=-P00,

P01=-P01,

P02=-P02,

P03=-P03,

P04=-P04,

P05=-P05,

P06=-P06,

P07=-P07,

P08=-P08,

P09=-P09,

P10=-P10,

P11=-P11,

P12=-P12

where actnum like '4%'.


Also watch out for the following for Allocation by Accounts -  Fixed or Variable:


If net expected typical balance of the destination allocation accounts for Expenses=negative Revenues=positive alter view vw_AssumptionsMonthlySummary as


SELECT CompanyDB, BUDGETID, Assumption, Year, ACTINDX, ACTNUM, ACTDESCR, ORGUNIT, OBJECT, CASE (TYPICALBAL) WHEN 0 THEN - S_P00 ELSE S_P00 END AS S_P00, CASE (TYPICALBAL) WHEN 0 THEN - S_P01 ELSE S_P01 END AS S_P01, CASE (TYPICALBAL) WHEN 0 THEN - S_P02 ELSE S_P02 END AS S_P02, CASE (TYPICALBAL) WHEN 0 THEN - S_P03 ELSE S_P03 END AS S_P03, CASE (TYPICALBAL) WHEN 0 THEN - S_P04 ELSE S_P04 END AS S_P04, CASE (TYPICALBAL) WHEN 0 THEN - S_P05 ELSE S_P05 END AS S_P05, CASE (TYPICALBAL) WHEN 0 THEN - S_P06 ELSE S_P06 END AS S_P06, CASE (TYPICALBAL) WHEN 0 THEN - S_P07 ELSE S_P07 END AS S_P07, CASE (TYPICALBAL) WHEN 0 THEN - S_P08 ELSE S_P08 END AS S_P08, CASE (TYPICALBAL) WHEN 0 THEN - S_P09 ELSE S_P09 END AS S_P09, CASE (TYPICALBAL) WHEN 0 THEN - S_P10 ELSE S_P10 END AS S_P10, CASE (TYPICALBAL) WHEN 0 THEN - S_P11 ELSE S_P11 END AS S_P11, CASE (TYPICALBAL) WHEN 0 THEN - S_P12 ELSE S_P12 END AS S_P12, CASE (TYPICALBAL) WHEN 0 THEN - (S_P00 + S_P01 + S_P02 + S_P03 + S_P04 + S_P05 + S_P06 + S_P07 + S_P08 + S_P09 + S_P10 + S_P11 + S_P12) ELSE (S_P00 + S_P01 + S_P02 + S_P03 + S_P04 + S_P05 + S_P06 + S_P07 + S_P08 + S_P09 + S_P10 + S_P11 + S_P12) END AS Total,SortOrder, SEG1, SEG2, SEG3, SEG4, SEG5, SEG6, SEG7, SEG8, SEG9, SEG10, TYPICALBAL, OBJECT_ROLLUP, META1, META2, META3, META4, META5, OBJSORTORDER, ACCTCATEG, RESTRICTED, ORG_ROLLUP, CONTRAALLOC, InLookups, InReports FROM dbo.vw_AssumptionsMonthlySumFeedRound -


If net expected typical balance of the destination allocation accounts for Expenses=Positive Revenues=negative alter view vw_AssumptionsMonthlySummary as


SELECT CompanyDB, BUDGETID, Assumption, Year, ACTINDX, ACTNUM, ACTDESCR, ORGUNIT, OBJECT, CASE (TYPICALBAL) WHEN 0 THEN S_P00 ELSE -S_P00 END AS S_P00, CASE (TYPICALBAL) WHEN 0 THEN S_P01 ELSE -S_P01 END AS S_P01, CASE (TYPICALBAL) WHEN 0 THEN S_P02 ELSE -S_P02 END AS S_P02, CASE (TYPICALBAL) WHEN 0 THEN S_P03 ELSE -S_P03 END AS S_P03, CASE (TYPICALBAL) WHEN 0 THEN S_P04 ELSE -S_P04 END AS S_P04, CASE (TYPICALBAL) WHEN 0 THEN S_P05 ELSE -S_P05 END AS S_P05, CASE (TYPICALBAL) WHEN 0 THEN S_P06 ELSE -S_P06 END AS S_P06, CASE (TYPICALBAL) WHEN 0 THEN S_P07 ELSE -S_P07 END AS S_P07, CASE (TYPICALBAL) WHEN 0 THEN S_P08 ELSE -S_P08 END AS S_P08, CASE (TYPICALBAL) WHEN 0 THEN S_P09 ELSE -S_P09 END AS S_P09, CASE (TYPICALBAL) WHEN 0 THEN S_P10 ELSE -S_P10 END AS S_P10, CASE (TYPICALBAL) WHEN 0 THEN S_P11 ELSE -S_P11 END AS S_P11, CASE (TYPICALBAL) WHEN 0 THEN S_P12 ELSE -S_P12 END AS S_P12, CASE (TYPICALBAL) WHEN 0 THEN (S_P00 + S_P01 + S_P02 + S_P03 + S_P04 + S_P05 + S_P06 + S_P07 + S_P08 + S_P09 + S_P10 + S_P11 + S_P12) ELSE -(S_P00 + S_P01 + S_P02 + S_P03 + S_P04 + S_P05 + S_P06 + S_P07 + S_P08 + S_P09 + S_P10 + S_P11 + S_P12) END AS Total,SortOrder, SEG1, SEG2, SEG3, SEG4, SEG5, SEG6, SEG7, SEG8, SEG9, SEG10, TYPICALBAL, OBJECT_ROLLUP, META1, META2, META3, META4, META5, OBJSORTORDER, ACCTCATEG, RESTRICTED, ORG_ROLLUP, CONTRAALLOC, InLookups, InReports FROM dbo.vw_AssumptionsMonthlySumFeedRound


    • Related Articles

    • 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 ...

    • Row Format (Grid Formats) Article

      Row Formats enable administrators to provide subtotaling rows to enhance the presentation of both data entry and reporting screens in Dynamic Budgets.  A single report can be generated and on-the-fly- can be toggled between different Row Formats to ...

    • 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 ...

    • How Do I Update an Account that Reports as a Negative But Has a Debit Balance in GP (or Visa Versa)? Article

      When reporting in Dynamic Budgets it is expected that accounts with debit balances in Great Plains Accounting Software (ERP) will report as positive balances in Dynamic Budgets, and that accounts with credit balances in the ERP will reports as ...

    • 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 ...