Incentives Calculation for Customer

[Former Member]

Dear SAP Expert,

• My Client are appointed based on security deposit as a Dealer or Distributor.

For Example,

Every Quarter in a year , My client Calculate Incentive for customer  as follows

• Security Deposit Amount            : Rs. 500000
• Sales Transaction                      1st  Month : Rs. 250000

                                            2nd Month : Rs.350000

                                            3nd Month : Rs.400000

        Total Transaction for Sales Quarters : Rs.1000000

• Slab Rate : Less than  <  1.5 times  -  10%

      1.5 Times  > 3.0 times    - 20%         

                        3.0 Times > More than    - 30%

     -> How to find out  Slab Rate?

                                    (Total Transaction for Sales Quarters/Security Deposit Amount)

                                    (1000000/500000)

                                    = 2 Times ( So it is satisfy 2^nd slab rate percentage : 20%)

• Incentives amount for customer

                = (( Slab Rate % * Security Deposit Amount)/365) * No of Days Quarter

                = ((20% * 500000)/365)*91

                = 24932

How can we map in SAP or is there any provision like this scenario , If any one Know please revert back

[Lakshmipathi]

There is a separate package for this (Incentive and Commission Management).  Execute the text in brackets in Google so that you will find lot of documents on this topic.  You need to implement this.  Else, develop a zee table where you can have fields you need to fetch the report and develop the report accordingly.

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi,

One things, After getting incentive amounts, it should be treated three ways

1) it should be issues as credit note.

2) It should be added in Secuirty deposit amount.

3) customer requesting for incentive amount, then it should be sent to customer.

How can we map in SAP or is there any provision like this scenario