logic to carry closing bal from Actual to Budget

[Former Member]

Hi all

i need a piece of script logic

which copies closing Bal of one category(last month) as opening Bal to another category (only for Jan month)

for ex:

Act (dec month) copy bud (janmonth)

1000 1000

thanks all

[Former Member · Accepted solution]

Hi Satish,

You can use *rec statement to copy from previous Dec to current Jan.

Lets take an example,

*WHEN TIME
*IS 2009.DEC
   *WHEN CATEGORY
   *IS ACTUAL
      *REC(EXPRESSION = %VALUE%, CATEGORY = BUDGET, TIME = 2010.JAN)
   *ENDWHEN
*ENDWHEN

*COMMIT

Hope this helps.

[Former Member]

thanks

[Former Member]

Hey there,

try this:

*RUNALLOCATION

*FACTOR = 1

*DIM TIME WHAT=2009.DEC; WHERE=2010.JAN

*DIM YOURDIMENSION WHAT=ACT; WHERE=BUD

*DIM ...

*ENDALLOCATION

You may need to include your other dimensions as well!

Hope, this helps a bit

Karsten