cancel
Showing results for 
Search instead for 
Did you mean: 

Run Allocation: Percentage logic

former_member211812
Participant
0 Kudos

We have a requirement where business want to have allocation on GL as well as Cost centre base.

Let me explain you the current allocation process:

1)Enter Transaction data on Operating expense sheet.

For example :

ACCOUNT COST_CENTRE AMOUNT

A CC_001 1000

B CC_002 2000

2)Enter Allocation %

For Example:

COST_CENTRE Allocation %

CC_003 30%

CC_004 30%

CC_005 40%

3)Run Allocation Logic :

*XDIM_MEMBERSET VERSION=%VERSION_SET%
*XDIM_MEMBERSET COST_CENTER=%COST_CENTER_SET%
*XDIM_MEMBERSET LEDGER=%LEDGER_SET%
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET P_ACCOUNT=BAS(A_12)

//POOL ALL OPERATING COSTS

*WHEN COST_CENTER
*IS %COST_CENTER_SET%
*REC(FACTOR = 1,COMPANY_CODE="CO_NONE",COST_CENTER="CC_NONE",FUNCTIONAL_AREA="FA_NONE",PROFIT_CENTER="PC_NONE",SEGMENT="SEG_NONE",LINE_OF_BUSINESS="LOB_NONE", RISK_LOCATION="RL_NONE",RISK_REGION="RR_NONE",CLAIM_YEAR="CY_NONE",AUDIT_TRAIL="AT_BPC_CC_ALLOC")
*ENDWHEN

//ALLOCATE OPERATING COSTS TO COST CENTERS
*XDIM_MEMBERSET VERSION=%VERSION_SET%
*XDIM_MEMBERSET LEDGER=%LEDGER_SET%
*XDIM_MEMBERSET TIME=%TIME_SET%

*RUNALLOCATION
*FACTOR = USING
*DIM_NONAGGR P_ACCOUNT WHAT=BAS(A_12);WHERE=<<<;USING=S_ALLOC
*DIM COMPANY_CODE WHAT=CO_NONE;WHERE=>>>;
*DIM COST_CENTER WHAT=CC_NONE;WHERE=>>>;
*DIM PROFIT_CENTER WHAT=PC_NONE;WHERE=>>>;
//*DIM FUNCTIONAL_AREA WHAT=FA_NONE;WHERE=>>>;
*DIM SEGMENT WHAT=SEG_NONE;WHERE=>>>;
//*DIM LINE_OF_BUSINESS WHAT=LOB_NONE;WHERE=>>>;
*DIM RISK_LOCATION WHAT=RL_NONE;WHERE=>>>;
*DIM RISK_REGION WHAT=RR_NONE;WHERE=>>>;
*DIM CLAIM_YEAR WHAT=CY_NONE;WHERE=>>>;
*DIM LINE_OF_BUSINESS WHAT=LOB_NONE;WHERE=>>>;
*DIM AUDIT_TRAIL WHAT=AT_BPC_CC_ALLOC;WHERE=<<<;USING=AT_BPC_INPUT
*ENDALLOCATION

4)Result :

It will allocate the amounts on both A and B at the same % mentioned in COST_CENTER allocation % sheet.

For Example:

ACCOUNT COST_CENTRE AMOUNT

A CC_003 300

A CC_004 300

A CC_005 400

B CC_003 600

B CC_004 600

B CC_005 800

New requirement:

Now business wants to apply different % for different Accounts for allocation process.

1)Enter Transaction data on Operating expense sheet.

For example :

ACCOUNT COST_CENTRE AMOUNT

A CC_001 1000

B CC_002 2000

2)Enter Allocation %

For Example:

ACCOUNT COST_CENTRE Allocation %

A CC_003 30%

A CC_004 30%

A CC_005 40%

B CC_003 10%

B CC_004 60%

B CC_005 30%

3)Run Allocation Logic. (Which needs to be change)

4)Result :-

It will allocate the amounts on both A and B at the different % mentioned in COST_CENTER allocation % sheet.

For Example:

ACCOUNT COST_CENTRE AMOUNT

A CC_003 300

A CC_004 300

A CC_005 400

B CC_003 200

B CC_004 1200

B CC_005 600

Issues :

I am not able to understand what should be the changes I need to apply in RUN ALLOCATION script logic to be able to meet the requirements.

Thanks in advance.

View Entire Topic
0 Kudos

Hi Floks,

I tried changing this script by giving the account as user selection below is my code, But still no luck can anyone help me.?

*WHEN COST_CENTER
*IS %COST_CENTER_SET%
*REC(FACTOR = 1,COMPANY_CODE="CO_NONE",COST_CENTER="CC_NONE",FUNCTIONAL_AREA="FA_NONE",PROFIT_CENTER="PC_NONE",SEGMENT="SEG_NONE",LINE_OF_BUSINESS="LOB_NONE", RISK_LOCATION="RL_NONE",RISK_REGION="RR_NONE",CLAIM_YEAR="CY_NONE",AUDIT_TRAIL="AT_BPC_CC_ALLOC")
*ENDWHEN
*COMMIT
//ALLOCATE OPERATING COSTS TO COST CENTERS
*XDIM_MEMBERSET VERSION=%VERSION_SET%
*XDIM_MEMBERSET LEDGER=%LEDGER_SET%
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET P_ACCOUNT=%P_ACCOUNT_SET%
//Run Allocation
*RUNALLOCATION
*FACTOR = USING
*DIM P_ACCOUNT WHAT=%P_ACCOUNT_SET%;WHERE=<<<; USING=S_ALLOC //Line added
*DIM COMPANY_CODE WHAT=CO_NONE;WHERE=>>>;
*DIM COST_CENTER WHAT=CC_NONE;WHERE=>>>;
*DIM PROFIT_CENTER WHAT=PC_NONE;WHERE=>>>;
*DIM SEGMENT WHAT=SEG_NONE;WHERE=>>>;
*DIM RISK_LOCATION WHAT=RL_NONE;WHERE=>>>;
*DIM RISK_REGION WHAT=RR_NONE;WHERE=>>>;
*DIM CLAIM_YEAR WHAT=CY_NONE;WHERE=>>>;
*DIM LINE_OF_BUSINESS WHAT=LOB_NONE;WHERE=>>>;
*DIM AUDIT_TRAIL WHAT=AT_BPC_CC_ALLOC;WHERE=<<<;USING=AT_BPC_INPUT
*ENDALLOCATION

Regards,

Toufq

former_member186338
Active Contributor
0 Kudos

Sorry, but if you don't want to read help and correct the syntax errors - I am unable to help.