Skip to Content
0
Former Member
Jan 16, 2012 at 02:44 PM

TMVL counter error

38 Views

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.