Skip to Content
0
Former Member
Jan 15, 2012 at 05:45 PM

Balance carry in script logic

30 Views

Time counter loop

I need to copy the 'Jan' closing balance from Account A to copied Account B of the following year'Jan'.

This I need to do it for 7 years planning values by user defined 50 profit centers

I am using time counter in the beginning...like following

*FOR %COUNTER% = 0,12,24,36,48,60

*XDIM_MEMBERSET TIME =TMVL(%COUNTER%,%TIME_SET%)

*XDIM_MEMBERSET RPTCURRENCY= LC

*XDIM_MEMBERSET CATEGORY= %CATEGORY_SET%

*WHEN ACCOUNT

*IS ACCOUNT'1'

*REC(ACCOUNT='ACCOUNT '2', TIME=TMVL(%COUNTER%,%TIME_SET%),CATEGORY=%CATEGORY_SET%)

*ENDWHEN

*COMMIT

*NEXT

It is not posting to following year. Can some one suggest what I am missing in the recording logic.

It need to be calculated for one after another year in loop and it part of major other calculation.