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 using single package..
For example Copy 2011.JAN -> 2012.JAN , 2012.JAN -> 2013.JAN ,2013.JAN -> 2014.JAN and for further for 7 years.
Following is my logic
*FOR %COUNTER% = 0,12,24,36,48,60,72,84
*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% +12),%TIME_SET%),CATEGORY=%CATEGORY_SET%)
*ENDWHEN
*COMMIT
*NEXT
I am getting TMVL error. How to ensure that result of past year(Jan) is posted to next year(Jan) when %counter% is used. Is my code needs to be modifed.
Appreciate inputs.