Example: ICE for balance sheet template in Planning Business Modeler

The following example shows a code snippet from the ICE for Balance Sheet template.

SCOPE ICMETHOD(#Full#,#Holding#, #Equity#);
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
<<[Account].[All Members].[Related Party LT Payables]>> += PCON_1 * CURRENTTUPLE;
END SCOPE;
END SCOPE

The following example shows how this segment might be changed into a usable rule. Note that the example substitutes specific account members for the replacement string values.

SCOPE ICMETHOD(#Full#,#Holding#);
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
[Account].[All Members].[202500] += PCON_1 * CURRENTTUPLE;
/* replace Related Party LT Payables placeholder */
END SCOPE;
END SCOPE

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×