Consolidated quantity for same material in sale order

[Former Member]

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.

[JL23]

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.

[former_member330246]

Sasikanth,

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

[Lakshmipathi]

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

[Former Member]

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.

Regards,

Sasikanth

[former_member183501]

Hi,

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.

Regards

Kamlesh

[VeselinaPeykova]

Absolutely agree with jrgen.lins 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.

[Former Member]

Hi,

define your price condition as a condition group in custo.

Regards

JM