Skip to Content
avatar image
Former Member

BPC script logic not work

HI,gays

There is problem I want put all interco to Thiedparty,Here is my logic,but it not work,

*XDIM_MEMBERSET ACCOUNT = 2202000098
*XDIM_MEMBERSET AUDITTRAIL=BAS(AU_0002 )
*XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
*XDIM_MEMBERSET ENTITY=%ENTITY_SET%
*XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
*XDIM_MEMBERSET INTERCO=BAS(INTERCO)
*XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
*XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
*XDIM_MEMBERSET VENDOR=BAS(VENDOR)
*XDIM_MEMBERSET YL01=Y01_NONE
*XDIM_MEMBERSET YL02=Y02_NONE
*XDIM_MEMBERSET YL03=Y03_NONE
*XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


*WHEN ACCOUNT
*IS 2202000098
*REC(FACTOR = 1,INTERCO=ThirdParty)
*ENDWHEN
*COMMIT

Thanks

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 01, 2017 at 06:24 AM

    i updata my logic but still not work

    *XDIM_MEMBERSET ACCOUNT = 2202000098
    *XDIM_MEMBERSET FLOW= F99
    *XDIM_MEMBERSET CATEGORY =V1001
    *XDIM_MEMBERSET TIME = 2016.01
    *XDIM_MEMBERSET INTERCO = BAS(INTERCO)


    *WHEN ACCOUNT
    *IS 2202000098
    *REC(FACTOR = 1,FLOW=F99,INTERCO=ThirdParty)
    *ENDWHEN
    *COMMIT

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 01, 2017 at 06:46 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2017 at 11:26 AM

    Hi,

    Does your BAS(INTERCO) include ThirdParty ID?

    If it does, your current script won't work. You will have to post the entire data on separate audit trail else it would keep on posting wrong data.

    Create additional auditrail ADJ under same parent as AU_0002 and report at parent level.

    Try using following logic then:

    //Clearing data on ADJ audittrail

    *XDIM_MEMBERSET ACCOUNT = 2202000098
    *XDIM_MEMBERSET AUDITTRAIL=ADJ
    *XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
    *XDIM_MEMBERSET ENTITY=%ENTITY_SET%
    *XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
    *XDIM_MEMBERSET FLOW=F99
    *XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
    *XDIM_MEMBERSET INTERCO=BAS(INTERCO)
    *XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
    *XDIM_MEMBERSET RPTCURRENCY=CNY
    *XDIM_MEMBERSET TIME=%TIME_SET%
    *XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
    *XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
    *XDIM_MEMBERSET VENDOR=BAS(VENDOR)
    *XDIM_MEMBERSET YL01=Y01_NONE
    *XDIM_MEMBERSET YL02=Y02_NONE
    *XDIM_MEMBERSET YL03=Y03_NONE
    *XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


    *WHEN ACCOUNT
    *IS 2202000098
    *REC(FACTOR = 0)

    *ENDWHEN

    //Reclassification

    *XDIM_MEMBERSET ACCOUNT = 2202000098
    *XDIM_MEMBERSET AUDITTRAIL=BAS(AU_0002 )
    *XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
    *XDIM_MEMBERSET ENTITY=%ENTITY_SET%
    *XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
    *XDIM_MEMBERSET FLOW=F99
    *XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
    *XDIM_MEMBERSET INTERCO=BAS(INTERCO)
    *XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
    *XDIM_MEMBERSET RPTCURRENCY=CNY
    *XDIM_MEMBERSET TIME=%TIME_SET%
    *XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
    *XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
    *XDIM_MEMBERSET VENDOR=BAS(VENDOR)
    *XDIM_MEMBERSET YL01=Y01_NONE
    *XDIM_MEMBERSET YL02=Y02_NONE
    *XDIM_MEMBERSET YL03=Y03_NONE
    *XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


    *WHEN ACCOUNT
    *IS 2202000098
    *REC(FACTOR = 1, INTERCO=ThirdParty, AUDITTRAIL=ADJ)

    *REC(FACTOR = -1, AUDITTRAIL=ADJ)

    *ENDWHEN

    Add comment
    10|10000 characters needed characters exceeded