You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FCCS Add Backs Calculation in FCCS1_0

Hi,

What's the best pratice for automating Net income Addbacks using FCCS_10 and a specific cashflow adjustment data souce as target ?

example:


FIX ("Entity Currency")
/*Step 1: run BOTTOMUP on the single FIX-ed target block using sparse as anchor*/
FIX ("FCCS_Periodic", @RELATIVE("TOT_Depr", 0), @RELATIVE("Total Custom 1", 0), @RELATIVE("Total Custom 2", 0), "CASHFLOW ADJ", @LIST("Depreciation AddBack","FCCS_Mvmts_NetIncome")
"FCCS_Entity Input" (
@CALCMODE(BOTTOMUP);
IF (NOT @ISMBR("FY23"))
IF (@ISLEV("Entity", 0))
"Depreciation AddBack" = #Missing;
"FCCS_Mvmts_NetIncome" = #Missing;
ENDIF
ENDIF
)
ENDFIX
SET HYBRIDBSOINCALCSCRIPT FULL;
SET IGNORECONSTANTS TRUE;
/*Step 2: Sucessive Addition -- Calculate add back/reclass on CASHFLOW*/
FIX ("FCCS_Periodic", @RELATIVE("TOT_Depr", 0), @RELATIVE("Total Custom 1", 0), @RELATIVE("Total Custom 2", 0), "CASHFLOW ADJ", @LIST("Depreciation AddBack","FCCS_Mvmts_NetIncome")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!