Skip to Content
1
Apr 25, 2014 at 03:43 PM

Script Logic - Scoping Statement Challenge

34 Views

Dear Friends,

I have a requirement where I need to write a script logic to calculate the net of all Balance Sheet accounts which are under a Hierarchy node (say: BALANCESHEET) and post the reversal to another Account (say: 9999999) which is also located under the hierarchy node: BALANCESHEET

Now the tricky bit is to exlcude the posting account (9999999) when I am reading the Accounts under the hierarchy node: BALANCESHEET.

Anyone knows how to do it ?

Below is my code which only works when the Account: 9999999 is located outside of the hier node: BALANCESHEET

*XDIM_MEMBERSET ACCOUNT = BAS(BALANCESHEET)
*XDIM_MEMBERSET TIME = 2014.APR

*WHEN TIME
*IS 2014.APR
*REC(FACTOR = -1, ACCOUNT=9999999)
*ENDWHEN

The scoping statement I wish that would work is:

*XDIM_MEMBERSET ACCOUNT = BAS(BALANCESHEET), BUT EXCLUDE 9999999

Appreciate any response on this.

Thanks,