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

Copying closing balance

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 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.