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
*REC(FACTOR = -1, ACCOUNT=9999999)
The scoping statement I wish that would work is:
*XDIM_MEMBERSET ACCOUNT = BAS(BALANCESHEET), BUT EXCLUDE 9999999
Appreciate any response on this.