Skip to Content
0
Apr 27, 2014 at 12:52 PM

How to calculate commission on discounted and non discounted sales in Pricing

309 Views

Hi,

In our company we have a scenario, where in Franchise sells the product at actual price and also at a discounted price.

When they sell at the actual price, then they get a full commission (Ex: 3 cents/unit sold). When they sell at the discounted price, then they get less commission (Ex: 2 cents/unit sold).

But Franchise is paid initially full commission for all the units. Later when the units are sold Franchise sends the sales information which will have units that are sold at discounted price.

For example Franchise is paid full commission for 1000 units @0.03= $30

But Franchise sold 300 units at discounted price.

So the commission on these 300 units@0.02 = $ 6

Commission on remaining 700 units@0.03 =$21

So the total commission payable = $27

Net due from Franchise = 30 – 27 =$ 3.

Now the question is how to capture this scenario in SAP pricing.

Client would like to maintain the commission rates in the form of condition records.

The challenge here is the quantity differs for total sales and discounted sales which are captured as single line item. (1000 units in the above example)

Thanks to guide if someone had similar requirements.