Skip to Content
avatar image
Former Member

BPC 10.1 NW : Allocation script logic approach

I have a simple allocation requirement but somehow I am getting stuck.

I need to allocate data from all GL accounts where property allocate is Y to one account GL90001, and this should be allocated from cost center CC_1001 to all base members of CC_CORP. I have created dummy cost center members against each of the base member of CC_CORP and the hierarchy for that is CC_COPR_R.

*XDIM_MEMBERSET CATEGORY = Budget

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = E1000

*XDIM_MEMBERSET U_PCTR = PC_1000

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET FLOW = F_999

*XDIM_MEMBERSET TIME = %TIME_SET%

//*XDIM_MEMBERSET P_ACCT = ALLOC_RATIO

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM P_ACCT WHAT=[ALLOCATE]="Y";WHERE = GL90001;USING=[ALLOCATE]="Y"

*DIM COSTCENTER WHAT = CC_1001;WHERE=BAS(CC_CORP);USING=BAS(CC_CORP_R)

*ENDALLOCATION

This works fine when I maintain the ratio for the account which is getting allocated but when I try to do it for a specific ratio account (ALLOC_RATIO), this allocation doesn’t work. I would like to maintain ratio for only one account member and refer that for all allocations.

Can you help me in understanding what am I doing incorrect here.

Thanks

-SM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 08, 2015 at 08:45 AM

    Hi Swati,

    Not clear - you are using *FACTOR = USING/TOTAL but TOTAL is not defined...


    What was the script with ALLOC_RATIO?


    *FACTOR = USING

    *DIM P_ACCT WHAT=[ALLOCATE]="Y";WHERE = GL90001;USING=ALLOC_RATIO ???


    Provide UJKT log!


    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 08:42 AM

    Hello Swati,

    Could you post the UJKT script result. Also does your member ALLOC_RATIO has property "Y"?

    Regards

    Bhagyesh Ravange

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 06:02 PM

    Thanks for replying. I have some strange system behavior. Today the same code works fine.

    I have USING/TOTAL as factor and when I have USING=[ALLOCATE]='Y', it takes the ratio maintained on same GL account (not on ALLOC_RATIO)

    and when i use USING = ALLOC_RATIO, it is allocating based on ratio maintained on ALLOC_RATIO account member.

    This is expected behavior but somehow I was not able to get it to work earlier.


    I will update the thread if I face this issue again in further testing replication of logic for different allocation cycles.


    Thanks.

    -SM

    Add comment
    10|10000 characters needed characters exceeded