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
My logic appears as follows, which is part of bigger other logic...
*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
Can some one suggest what I am missing in the recording logic, so that current year'Jan' closing balance is posted to next year'Jan' opening balance
It need to be calculated for one after another year in loop and it part of major other calculation.