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