Upfront Discount based on cumulative sales

Logistics : SD and its sub-modules (Inquires, Quotes, Order Entry, SIS, Sales Contacts, Dist. & Billing)

Moderators: Snowy, thx4allthefish, mike_ac, Lost Identity

Post Reply
subodhd
Posts: 268
Joined: Thu Apr 28, 2005 7:33 am
Location: Sydney

Upfront Discount based on cumulative sales

Post by subodhd » Thu Apr 04, 2019 1:14 pm

Need to check if there is any way of calculating percentage discount in sales order , only if the historical invoiced sales qty has reached a certain threshold as agreed with the customer during the contract duration of one year.
Eg if the contract with a customer was for say 1000 qty for the whole year , until such time we have already sold a threshold qty if say 300, we would not apply the discount of 10%.
So for the first few sales orders from that customer - if the cumulative order qty was say 250, all these orders would not get any discount. But the moment an order comes in that makes the cumulative order qty for that customer to go over 300, that order will get 10% discount.
The order qty needs to be cumulated for all materials ordered from the customer .
Material M1 qty may be 10, Material M2 May be 20 and so on , the cumulative qty becomes 30. The cumulative needs to occur for all line items for all materials for all sales orders for that customer .
We are on ECC6.

We done want to use rebates as it involves accruals / settlement / credit memos and so on. Customer wants upfront discount at the time of invoicing. Hence the question.
Thanks

SD

subodhd
Posts: 268
Joined: Thu Apr 28, 2005 7:33 am
Location: Sydney

Re: Upfront Discount based on cumulative sales

Post by subodhd » Thu Apr 04, 2019 1:20 pm

Correcting some typo mistakes here-

Need to check if there is any way of calculating percentage discount in sales order , only if the historical invoiced sales qty has reached a certain threshold as agreed with the customer during the contract duration of one year.
Eg if the contract with a customer was for say 1000 qty for the whole year , until such time we have already sold a threshold qty of say 300, we would not apply the discount of 10%.
So for the first few sales orders from that customer - if the cumulative invoiced sales qty was say 250, all these orders would not get any discount. But the moment an order comes which will make the cumulative sales qty for that customer to go over 300, that order will get 10% discount.
The order qty needs to be cumulated for all materials ordered from the customer .
Material M1 qty may be 10, Material M2 May be 20 and so on , the cumulative qty becomes 30. The cumulation needs to occur for all line items for all materials for all sales orders for that customer .
We are on ECC6.

We don’t want to use rebates as it involves accruals / settlement / credit memos and so on. Customer wants upfront discount at the time of invoicing. Hence the question.
Thanks

SD

Post Reply