Skip to Content

Consolidated quantity for same material in sale order

Nov 25, 2017 at 03:19 AM


avatar image

Hello Experts,

We have scenario where we need to maintain same material to be repeated in sales order line items. We can enter same material multiple times but my question is how to consolidate the quantities for these materials?

For example:

Item no. Material number Quantity

10 ZZZZZ 3

20 ZZZZZ 5

30 YYYYY 8

40 ZZZZZZ 10

50 YYYYY 10

Quantity for material "ZZZZZ" line items 10,20,40 & 50 to be consolidate all quantities together for this material is 18. Since we are maintaining scale based price if quantity is more than 15 PC's customer will get special prices. If material quantity is not consolidate customer will charge more.

In case if quantity is not consolidated individual line items will charge to the customer and he will not get special price.

Note: We have maintained minimum scale quantity as 15 we can't change the scales since we have other customers to use this.

Also customer don't want to maintain single line item to consolidate the quantities.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Jürgen L
Nov 25, 2017 at 08:17 AM

What is the root cause that a CSR enters the ordered quantity in 2 items of a sales order?

Does your customer eventually have 2 items in his PO, which means he himself is causing the problem as he has not solved the problem to consolidate his order into 1 item.

In case you want assign batches in the sales order and you have 2 batches to fulfill the requested quantity you will always end with 2 sales order items.

10 |10000 characters needed characters left characters exceeded
Fausto Regis de Oliveira Motter Nov 27, 2017 at 01:01 PM


I think (supposing based on your business case) that you are working with sales order as you work with schedule agreement. If this happen to support a customer call, please, check if the best way for you is create a scenario based on a schedule agreement and not a sales order. Or, a sales order with reference to a schedule agreement... could be. Make sense?

Only suggestion for you check. To decide, is relevant follow the colleagues orientation: discover what happened and why this occur (was a isolated case or not).

Best, Fausto Motter

10 |10000 characters needed characters left characters exceeded
Veselina Peykova
Nov 25, 2017 at 10:07 AM

Absolutely agree with Jürgen L that the most important part of finding a good solution is to investigate why you end up in this situation in the first place.

While there are a few cases where having the same material in multiple order items is unavoidable and is not a result of poor training or inefficient communication with the customer, you did not explain the process.

Yes, you may fix the pricing issue easily, but it does not necessarily mean that you have addressed the actual problem.

10 |10000 characters needed characters left characters exceeded
joan mas Nov 25, 2017 at 08:28 AM


define your price condition as a condition group in custo.



10 |10000 characters needed characters left characters exceeded
Sasikanth Chittineni Nov 25, 2017 at 01:01 PM

Hello Jurgen,

You are right, customer has 2 items (Same material) in his PO. Currently we are creating one item by consolidating all the quantities. But customer is not happy with this proposal.



Show 1 Share
10 |10000 characters needed characters left characters exceeded


What is the final solution you have given?

Have you asked the customer that what the is reason for entering same material in different line items in PO ?

It could be a mistake of user also.



G Lakshmipathi
Nov 27, 2017 at 08:05 AM

The simplest solution is to add the quantity in the same line item as and when your client get an amendment from their end customer

10 |10000 characters needed characters left characters exceeded