Skip to Content
-1

Sales order stock delivery tracking for relevant production order.

Hello All,

I have the following issue, we follow MTO scenario here. Say i have a sales order 1001 for 3 EA qty. I have maintained maximum lot size 1. So after MRP run i'll get 3 planned orders which i will convert to 3 production orders say 1201,1202,1203 and i will also confirm and update stock 3 EA in inventory. Now Sales person did delivery of 1 qty to customer, so now remaining 2 qty in stock.

I want to know, that 1 EA stock from which production order was issued to customer and stock of which production orders are available. Any way to trace it?

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Nov 16, 2017 at 02:23 PM

    I guess you will definitly need either batch management (each piece equals one batch number) or serial numbers for each piece. Then you would definitly know which piece exactly (produced from which production order) was deliverd to the customer. Otherwise you will have some kind on "anonymous" stock within the MTO stock, where the pieces of the different production orders get mixed up. How should the system know without any trace to prodcution order like batch number or serialnumber?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 05:22 AM

    MB51

    Add comment
    10|10000 characters needed characters exceeded

    • Hello SPRO,

      In MB51 for that sales order and 601 movement type and material document,i added Order column which is blank for this combination. And further even if you see for orders 1000291,1000292 they have sales order link inside. But its not showing here in MB51,as you can see its blank. But in COOIS report i can see the sales order relevant to production orders.

      sd.jpg (30.4 kB)
  • Nov 15, 2017 at 06:18 AM

    I believe production order will have the corresponding sale order reference. Is that not happening in your case?

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      Yes in production order sales order reference is available. But the issue is after delivery of stock, i want to trace the delivered stock belongs to which production order. In MB51 for that sales order and 601 movement type and material document,i added Order column which is blank for this combination. And further even if you see for orders 1000291,1000292 they have sales order link inside. But its not showing here in MB51,as you can see its blank.

      sd.jpg (30.4 kB)
  • Nov 15, 2017 at 07:36 AM

    If the movement type is 601E, then, you should be able to see the order reference in MB51

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 08:17 AM

    Hi ,

    i think it is only possible if you dont have Batch management , if we go by GR we can get SO no and production order no but we can not trace the material of which GR no is delivered.

    Thanks & REgards,

    Mahesh,

    Add comment
    10|10000 characters needed characters exceeded

    • Again, there is no magic in SAP, no matter what client believes. You can use batch management and that would give you full traceability. If you don't want to use batch management (or Z equivalent to batch management, which wouldn't make a lot of sense IMHO) then you can only have limited traceability. E.g. if you have 1 sales order, then 3 production orders and 1 delivery and all the serial numbers (and without serial numbers this is just plain mission impossible) are assigned to one delivery then you won't be able to tell which one of the 3 production orders the item came from. To do so, you'd have to somehow enforce strict 1:1 relationship all over the document flow.

      Of course, there are also options like physically attaching the employee DNA to the product but that's outside of the SAP scope.