cancel
Showing results for 
Search instead for 
Did you mean: 

Incentives calculation

Former Member
0 Kudos

Hi,

Requirement as follows

TARGET

SALE

SALE RETD

NET SALE

%OF ACHIEVEMENT

RATE OF INCENTIVE

Sale is a restricted Keyfigure which is defined as follows

0DOC_CATEG(Sales document category) restricted to Debit memo

0NETVAL_INV(Net value of billing item)(Table VBRP Field NETWR)

Sales returns is another restricted keyfigure defined as follows

0DOC_CATEG(Sales document category) restricted to Creditmemo

0NETVAL_INV(Net value of billing item)

· Net sales = Sale - Sales returns

%Of Achievement = Netsales % Target

Rate of incentive is calculated based upon the following conditions

If 100 % achieved 2.% incentive

I f 80-99.99% achieved 1.% incentive

If over and above 100% achieved 1%incentive

This incentives data is not stored any where so how can I build the formula for this

And I need to write one more formula for the below requirement

Rate of incentive is given based on the % of achievement as well as payments received within 75 days,if payment is not received with 75 days then incentive is not given

Example Basline date is 12/12/06

Due date is 28/01/07

Clearing date is 30/02/07

The customer has to make the payment by 28/01/07 fromthebasline date the days given from baseline date to due date is 1 month 17 days but the customer cleared the payment on 30/02/07 means he took totally 80 days from the baseline date so this customer is not provided with incentive pls suggest how to write formula for this

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Creare two Formula Variables of Type Replacement on Clearing Date(CD) and Base Line Date (BD)

Write is Boolean logic in the Calc Key Figure :

(Netsales % Target =100) ((CD-BD)<= 75)* 2+(Netsales % Target <100) (Netsales % Target>=80) ((CD-BD)<= 75)* 1 +(Netsales % Target >100) ((CD-BD)<= 75)* 1

Former Member
0 Kudos

hi

You have to write a customer exit in the variable to calculate the formula

here

Here first you have to check the collection data to check whether incentive are to be calcuated or not

Then you have to apply the logic

100 % to 2% of achievement as incentive

less than 100 % to 1 % of achievement as incentive

....and so on

Assign points if useful

Regards

N Ganesh

Former Member
0 Kudos

can u provide me the procedure to work with customer exit with logic