Discount on Article - Multiple Line Items

[aqarif]

Hello everyone,

We are offering full-pallet discount on article ABC123 and therefore a customer A placing an order for instance of 25 pcs of article ABC123 (that is equivalent to full-pallet quantity of 25 pcs per pallet), then we shall give the customer A lower price per article. Similarly, a customer B placing an order of for instance 30 pcs of an article ABC123 (that is equivalent to one full-pallet quantity and 5 extra pcs) shall get lower price for first 25 pcs and normal price for 5 pcs.

This works well so far as we have introduced a special condition type that takes into account the PAL scale unit and apply the discount on articles.

However, now the situation is that we have to take into account the total number of pcs asked by the customer for a certain article in a sales order and apply the full-pallet discount on total quantity. For instance, if a customer A has placed a total order of 55 pcs of an article ABC123 in an order, then the system should give for 50 pcs lower price (as they are 2 full-pallets keeping in mind 25 pcs per pallet) and 5 pcs of normal price.

This seems simple if we just put total 55 pcs as one line-item in the sales order and it would work well. However these 55 pcs are asked not as whole 55 pcs but as 10 pcs this month, 20 pcs second month, and 25 pcs in the third month (55 pcs in total but in three installments - but we have to give the full-pallet discount for first 50 pcs). For this we have to add three line-items in the sales order for the same article with different quantities and delivery dates. Our current logic then does not work as it only puts the full-pallet discount on current line-item of an article.

Can somebody explain how to achieve this correctly?

Thanks in advance.

A Arif

[aqarif · Accepted solution]

Hi,

I have found the solution and let me share in case somebody else would come across something similar. The trick was to, instead of maintaining several line-items for each quantity and delivery for similar article, maintain the article's quantities and delivery dates on schedule-lines level. In this way, one can apply the pallet-level-discount using the logic explained earlier. The system shall calculate the discount correctly on total quantity ordered for a certain article and shall also take into account the quantities and delivery dates.

I hope this helps.

Best regards...

[Lakshmipathi]

You can consider the discount condition type as header condition and can have the required access sequence. If you have not come across how to treat header condition as item condition, have a look at this blog. Of course, as already suggested, you can consider Pallet discount for this

[sreemohan]

Hi Arif,

I think the best would be to use the condition type KP02 for Pallet discount. This would accumulate the item quantities of the individual items and then calculates the discount for complete pallets only.

Thanks and regards

Sreemohan

[aqarif]

Thanks Sreemohan.

I didn't use KP02 but got the hint from this condition type and adjusted my custom-condition-type accordingly.

Kind regards

[sreemohan]

Good to know, and I am happy that I hinted you in the right direction. May I ask you what was the adjustment to your custom condition type?

[aqarif]

Hi Sreemohan,

I think I was a bit too quick to draw conclusion... the problem is only partially resolved...

I checked the flag Group-Condition and now it takes into account multiple line-items. However, it applies the discount on all items even if the items don't fulfill the requirement of full-pallet. The full-pallet quantity is not being taken into account and the system takes new condition type and applies the discount on every PC.

I think I have to do something in the pricing procedure by putting the correct code for BasType... but so far it does not work as it should be...

any further ideas are welcome.

[sreemohan]

Hi Arif,

You could perhaps take a look at the condition base formula 22. You could also check if the materials has a conversion factor to pallets.

Thanks and regards

Sreemohan

[aqarif]

Hi Sreemohan,

I have already applied base formula 22, but that works only in situation when only full-pallet is involved. But it does not take into account total cumulative order quantity. For example:

5 pcs per pallet

Order is as follows:

Article ABC123 10 PCs (full-pallet discount is applied) - perfect

Article ABC123 3 PCs (no pallet discount is applied) - problem

Article ABC123 2 PCs (no pallet discount is applied) - problem

3+2 = 5 pcs in total which is again a full-pallet and the discount should be applied on both of these articles partially. They are mentioned as separate line-items. It is required to be put in this way as sometimes the same article has different delivery date, but we want to give the customer a discount based on full-pallet order quantity.

Conversion factors are already in place... no issue there.

Please advise.

Thanks.

[sreemohan]

You could take a look at SAP note 114619. Also, you can make a test with condition type KP00 or KP02, which ever suits the need, and check if it works well for the requirement. If it does , then you can make a comparison with the custom condition type.

[aqarif]

Hi Sreemohan,

I have looked at the SAP note and of course also looked at KP00 and KP02. I think they would work only in scenario where weput the total quantity as one whole in the line-item and not as several quantities as line-items. My requirement is to apply the pallet-discount on total number of quantity ordered in a sales order for a certain article. Like for article123 where we have 5 pcs per pallet:

10 pcs in 1st week of October

3 pcs in 2nd week of October

5 pcs in 3rd week of October

2 pcs in 4th week of October

10+3+5+2 = 20 pcs in total (which is equivalent to 4 pallets), so a total of 4 x pallet-discount should be given on the sales order.

Kind regards and Thanks.

[sreemohan]

in this case why don’t you think of creating a new custom condition base formula by copying 22, to calculate the discounts on whole pallet quantities by summing up the individual quantities.

[aqarif]

I think that could be the way and I was already working on that.

[sreemohan]

In this case you could close this thread by selecting the correct answer,or if you have an answer of your own, then you could also post it as the correct answer.