Sales order stock delivery tracking for relevant production order.

[jeffrey_pepito]

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.

[cw78]

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

[maheshkumar_komatineni]

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,

[jeffrey_pepito]

Hello Mahesh,

We don't have Batch here. And yeah there are ways to trace the production order and sales order after Goods receipt. But my issue is different. After PGI in sales order, the stock is reduced. I need to trace the stock which was delivered to customer belongs to which production order.

[Jelena]

There is no "PGI in sales order", PGI is done in the delivery. Several people already replied that stock can be traced down to specific production order with the batch management. What other answers are expected?

Of course, you can just ask the warehouse personnel to put the stock physically in a different box and label it with PO #. But SAP won't know anything about this.

Just thinking logically: where could such data be stored? Very much confused by the expectations here, sorry.

[jeffrey_pepito]

Hello Jelena,

Thanks for your consideration and reply. Yeah i know PGI is done through VL01N outbound delivery,i just meant generically sales. Why our client put forth this requirement is because, in some cases there will be customer return of goods due to bad quality or some defects. So in such cases management need to trace back to the production order number against the delivered sales order number & stock and then which employee performed that particular operation and also which quality personnel approved that particular stock. Then they'll deduct certain amount from their salary as per management's terms and policies. That's why they ask for tracing.

[Jelena]

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.

[Lakshmipathi]

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

[jeffrey_pepito]

Hello,

Order reference you mean production order right? If yes,then wondering why its not displaying here in the 4th column.

[Lakshmipathi]

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

[jeffrey_pepito]

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.

[former_member184701]

MB51

[jeffrey_pepito]

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.