Skip to Content
0

BPC script logic not work

Aug 01, 2017 at 01:27 AM

143

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Aug 01, 2017 at 06:46 AM
0
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 01, 2017 at 11:26 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

"Does your BAS(INTERCO) include ThirdParty ID?" - this is not clear from the original post and the topic author did not provide any info about INTERCO dimension hierarchy...

But even if BAS(INTERCO) include ThirdParty ID the script has to produce some value in ThirdParty :)

0
Former Member
Vadim Kalinin

Hi Vadim,

I provided the solution based on general issues I experienced.

As he mentioned "it did not work" I construed it as not working as expected.

Regards,

Amit

0

In the report I see nothing in ThirdParty cell :)

0