Skip to Content
avatar image
Former Member

Script not aggregating as expected

I have 3 sections of script that work perfect when you run them individually, they also run perfectly when you run only the first two sections together but when the last one is added I get a totally unexpected result. They all write to the exact same intersection so I would expect them to aggregate correctly.

Any thoughts on why this last section is causing an issue.

Thank you

///////////////////

//// Eliminate COMM REV MNL

/////////////////

*SELECT(%TOTPC31%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC31%

*XDIM_MEMBERSET COMPANYCODE = 7500

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 471000

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

//

//

//

///////////////////

//// Eliminate DIST REV

/////////////////

*SELECT(%TOTPC32%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC32%

*XDIM_MEMBERSET COMPANYCODE = 7100

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592019,592020,592021

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

/////////////////

// Eliminate Admin Allow FIA between SRS and MNL

///////////////

*SELECT(%TOTPC65%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC65%

*XDIM_MEMBERSET COMPANYCODE = 7200

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592023

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 07, 2015 at 02:39 PM

    Hi Nick,

    First of all, please remove absolutely useless COMMIT - the only thing it's doing - just reset scope. The script will be simplified!

    Test in UJKT and post results.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded