Script logic retained earning account

[Former Member]

Hello BPC Guru's,

I have created a script logic in order to move the PL amounts to the retained earning account based on BPC440 document(NW).

While using EVSND to input data on the relevant accounts, I am getting the following error:

Error running default logic()

MDX statement error: The argument IIF([/CPMB/G6D5B0K PARENTH1].CURRENTMEMBER.PROPERTIEDIMLIST1)=L1_V,[/CPMB/G6DMWOV PARENTH1].[Balance].

Enclosed the script logic which is called in the default logic.

Does anyone know what the error means??

Tnx,

N

script_logic_retained_earning_account.txt.zip

[former_member186338 · Accepted solution]

Hi,

First, don't use *XDIM_MEMBERSET in default.lgf - read here:

The first part of script will be:

*WHEN ACCOUNT.GROUP

*IS PL

*WHEN FLOW

*IS Balance

*WHEN INTERCO

*IS ThirdParty

//Don't need to overwrite destination if no change!

*REC(ACCOUNT=PL999,FLOW=CIS) //All PL accounts will accumulate on PL999 with FLOW=CIS

*REC(ACCOUNT=PL999) //All PL accounts will accumulate on PL999

*ENDWHEN

*ENDWHEN

*ENDWHEN

Can you explain the business logic of this code:

[FLOW].[#F_VAR]=IIF([ACCOUNT].CURRENTMEMBER.PROPERTIES(DIMLIST1)=L1_V,[FLOW].[Balance]

*COMMIT

[FLOW].[#F_ERR]=IIF([ACCOUNT].CURRENTMEMBER.PROPERTIES(DIMLIST1)=L1_E,[FLOW].[Balance]

*COMMIT

It's better to replace this code with WHEN/ENDWHEN

Vadim

[former_member186338 · Accepted solution]

P.S. May be something like:

*WHEN ACCOUNT.DIMLIST1

*IS L1_V

*WHEN FLOW

*IS Balance

*WHEN INTERCO

*IS ThirdParty

*REC(EXPRESSION=%VALUE%,FLOW=F_VAR)

*ENDWHEN

*ENDWHEN

*ENDWHEN

...

[former_member186338 · Accepted solution]

P.P.S. And if you look on the examples in 440, then there are some syntax issues:

[FLOW].[#F_VAR]=IIF([ACCOUNT].CURRENTMEMBER.PROPERTIES("DIMLIST1")="L1_V",[FLOW].[Balance],0)

[Former Member · Accepted solution]

Hi Vadim,

Thank you, the " " did the trick!

N