Skip to Content
0
Former Member
Sep 16, 2011 at 08:56 PM

Issue with Script Logic

23 Views

Hi,

I have maintained a script whrein i want to copy the closing balance of one month to the opening balance of the next month. My script goes like this

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ENTITY=%ENTITY_SET%

*WHEN P_ACCT2.ACCTYPE

*IS AST, EXP

*WHEN FLOW

*IS F_999

*REC(FACTOR=1,FLOW=F_100,TIME=TIME.NEXT)

*ENDWHEN

*IS LEQ, INC

*WHEN FLOW

*IS F_999

*REC(FACTOR=-1,FLOW=F_100,TIME=TIME.NEXT)

*ENDWHEN

*ENDWHEN

*COMMIT

The script works fine if F_999 is not a calculated member. However in the Flow dimension if i maintain a formula for F_999 then the script doesnot run as desired however the calculation for F_999 takes place in the Input Schedule but no carry forward takes place.

Please advice.

Thanks in advance,

Appu

*ENDRUN_PROGRAM

Edited by: Appu Del on Sep 17, 2011 2:26 AM