cancel
Showing results for 
Search instead for 
Did you mean: 

Any mechanism to match input and output serial numbers in a production Order

syed_aleem3
Explorer
0 Kudos

Hi Forum,

Background:

Let the input item be A and five of them serialized in stock are : A0001, A0002, A0003, A0004 and A0005

Let the output item to be produced be Z  if two are produced then  : Z0001, Z0002

Assume manual issue as it is serial item.

A production order takes a BOM with serialized items (can be 1 or many items ) and creates a serialized output item (single item). The planned quantity of production order could be 1 or many. In our example BOM1 takes single item.

For example BOM1  has single input item A.

Production Order planned is for 2 (output).

Issue of production order requires two input items from BOM1 (as we are producing two output items). Let's provide the two serialized input items as A0003 and A0001.

The Receipt/Completion of production order will ask for serial number.  Let's provide the two as Z0001 and Z0002.

Here is the problem:

==============

How do we know which serialized input item belongs to which serialized output item? There is no mechanism to control the user to record which input serial went into which output serial.

We want to be able to trace back in case of failure which component has gone into which produced item.

Any suggestions how to accomplish this? If user defined tables is a solution where and how should it be linked?

Thank you all.

Cheers!

Syed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Syed,

Have you tried query report to trace?

Thanks,

Gordon

syed_aleem3
Explorer
0 Kudos

Managed to find a partial solution and mainly revolves around  table OSRN.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Syed,

You can use transaction COIB or do the same transaction through confirmation CO11N (first you must maintain single screen entry of confirmation in OPK0, use area 860 serial number assignment)

Later you can track which SN component is used on SN FG on IB52 and IH20.

Good luck,

Arman Lie

syed_aleem3
Explorer
0 Kudos

Hi Arman, thanks for responding.  It sure seems like you can do it easily in SAP ERP.

However, I am talking about SAP B1 - Business One, a newer product from SAP to address the business needs of small to medium scale industries.