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.