Skip to Content
0
Former Member
Jul 23, 2014 at 01:53 PM

Balance Sheet postings

18 Views

Hi Experts,

I am trying to post a calulations to the balance sheet via script logic.

The first part of the logic is working fine and produces the desired result however the second part of the logic (lookup) do not produce a value

// THIS LOGIC WILL CALCULATE THE ADVANCE TICKET SALES INPUT

*XDIM_MEMBERSET TIME = 2014.12

*XDIM_MEMBERSET CATEGORY=Budget
*XDIM_MEMBERSET ACCOUNT=AC_2016100
*FOR %M%=%TIME_SET%

*WHEN CATEGORY
*IS *
*REC(EXPRESSION=([ACCOUNT].[AC_2016100]/[ACCOUNT].[AC_60501]*365), TIME=TMVL(1,%M%), ACCOUNT=AC_2016100_INP)
*ENDWHEN
*NEXT
*COMMIT

//==================================================================================================

*LOOKUP FINANCE
*DIM INP:ACCOUNT=AC_2016100_INP
*DIM TIME =2015.01
*DIM CATEGORY = Budget

*ENDLOOKUP

*XDIM_MEMBERSET TIME = 2015.01
*XDIM_MEMBERSET CATEGORY=Budget
*XDIM_MEMBERSET ACCOUNT=AC_2016100

*WHEN CATEGORY
*IS *
*REC(EXPRESSION=([ACCOUNT].[AC_60501]*LOOKUP(INP)/365), ACCOUNT=AC_2016100)
*ENDWHEN

The second part should post the balance into the following time period, which it is not doing at present and is there a away that this could be done dynamically i.e. for all future time periods

Thanks in advance