Calculate balance sheet values using BegBalance
Summary
Add BegBalance to the current period change using ruleContent
Our client has asked to load balance sheet into PBCS. We are loading the periodic change and beginning balance. I'd like to have a rule calculate the balances. Calc manager is objecting to the use of @CurrMbr. What is the alternative? Note: We are not using Financials.
FIX ("FY16","Actual", "Final", "vLoad",@DESCENDANTS("Net Balance Sheet", 0 ),@DESCENDANTS("PCG",0 ), @DESCENDANTS("Store", 0) ,@DESCENDANTS("Department", 0),@DESCENDANTS("FE",0))
"BegBalance"=@MDSHIFT("YearTotal", -1, "Years",);
@CURRMBR("Period")
(IF(@ISMBR("TP1"))
@CURRMBR("Period") + "BegBalance";
ELSEIF ("TP2":"TP13")
1