Skip to Content
0
Former Member
Dec 13, 2006 at 10:15 AM

Incentives calculation

28 Views

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