output of the quantity of material and the quantity of serial numbers

[Former Member]

Hi everyone,

Currently because the configuration of serial number in my company is no stock validation which leads to the lack of the correspondence between material quantity and serial numbers quantity. For example, in storage location 3000, there are 5 material A, but the quantity of the serial numbers for material A is 4.

Now I want to output the quantity of material and the quantity of serial numbers for each material in each storage location with which to make a report to describe the current situation. How could I finish it without ABAP programming?

Thanks.

Edited by: liyouhua on Apr 1, 2009 12:35 PM

[Former Member]

Hi,

There wont be any mismatching between the Qty in stock and the No.of serial numbers..

THe thing might be ..a part or some of the stock would have not attained the unrestricted type. that is .. a material with a particular serial number would be in project stock or in a stock that is restricted..

You go to MMBE and check for the serial numbers by right clicking on the qty..

and in IQ02 also check for the serial numbers. If you find the difference between MMBE and IQ02, track the history of the serial numbers where you will get the necessay info..(using history pushbutton).

karthick

[Former Member]

Thank you for you reply, but actually the reason that leads to the difference between the invenoty and serial number quantity is the wrong setting of the serial number profile. In OIS2, we set the serial number profile 'no stock validation'.

Now I would like to show the material which has difference between the two sides to show bad the situation is.

Thanks!

[Former Member]

I am not getting properly with the following...

Now I would like to show the material which has difference between the two sides to show bad the situation is.

Please tell me What is your requirement now...

karthick

[Former Member]

Sorry, my mistake.

I mean I want to output the difference on these two sides of each material which will show how bad the current situation is.

The prerequisite of this is that how can I output the quantity of inventory and the quantity of serial numbers separately. That's the key point.