Skip to Content
0
Former Member
May 28, 2015 at 08:04 PM

CALC_DUMMY_ORG replacement

21 Views

Hi guys,

Second issue for the day...

This old logic from 7.5 MS has the very useful CALC_DUMMY_ORG in it. I have tried a couple of ideas, but I can't replicate this in NW at all.

*SELECT(%BANK_TYPE%,"distinct [ID]","ACCOUNTL","[RATETYPE]='BC_END'")

*XDIM_MEMBERSET DATASRCL = BC

*XDIM_MEMBERSET ACCTDETAIL = F_CLO

*XDIM_MEMBERSET ACCOUNTL = %BANK_TYPE%

*CALC_DUMMY_ORG ACCOUNTL = PARENTH1

*WHEN GET(ACCOUNTL=# + ACCOUNTL.PARENTH1)

*IS < 0

*REC(FACTOR=-1,DATASRCL = "REALLOCATIONS")

*REC(FACTOR=1,DATASRCL="REALLOCATIONS",ACCOUNTL="40001")

*ENDWHEN

The purpose of this script is to evaluate the total of each group of bank accounts (they are separated into parents for each bank "brand": e.g. Barclays, Lloyds, Citibank, etc.)

These accounts are evaluated at a total level, and if the total is less than zero a reversing entry should go into the children accounts, in the REALLOCATIONS AuditID, and the total into the account "40001".

This is my current attempt in NW:

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET AUDITIDC = BC

*XDIM_MEMBERSET FLOW = F_CLO

*XDIM_MEMBERSET ACCOUNTC = %BANK_TYPE%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*WHEN ??????

*IS ??????

*REC(EXPRESSION = %VALUE%<0 ? %VALUE%*-1 :0, AUDITIDC = "REALLOCATIONS")

*REC(EXPRESSION = %VALUE%<0 ? %VALUE% :0, AUDITIDC = "REALLOCATIONS", ACCOUNTC = "40001")

*ENDWHEN

I would like to keep this dynamic, so I have tried a few ideas, including replacing the items in bold with a tuple instead, but this would have to be hard-coded, as .Property("<value") doesn't work.

Any suggestions?? I could suggest that this be done in a BaDI, but this would have to be sent out to someone else as I don't know enough about it.

If I can keep it in script that would be ideal.

Thanks very much,

Jason