Skip to Content
avatar image
Former Member

Consolidated quantity for same material in sale order

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

  • 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

    Add comment
    10|10000 characters needed characters exceeded

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2017 at 08:28 AM


    define your price condition as a condition group in custo.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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.



    Add comment
    10|10000 characters needed characters exceeded

    • 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.



  • 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

    Add comment
    10|10000 characters needed characters exceeded