Physical inventory in one warehouse number shared by 3 plants

[Former Member]

Hello

We recently physically moved 2 "spare parts" plants into our production plant which is WM managed. The 2 plants that we moved are now link to the same warehouse number link the production plant. Here is our setup:

Plant     Storage location     Warehouse number

A          1000                         520

B          2000                         520

C          3000                         520

One of the main goal of the moving was to combine the same material of the 3 plants in the same physical bin to save on warehouse space. But in SAP we have 3 differents records ( quants). It was also a prerequisite to keep the 3 plants

Material      Bin               plant   Sloc     quantity

X               10-10-10      A          1000     2

X               10-10-10      B          2000     3

X               10-10-10      C          3000     4

total in the bin: 9

Count with LM50:

material     bin               plant          counted qty

X               10-10-10      A               9

X               10-10-10      B               0

X               10-10-10      C               0

We plan to use LM50 to enter the count with RF device but the counter doesn't know the plant/material quantity: he can only know the total quantity which is 9. So, we plan to enter the total quantity in the first plant/material combinaison and enter 0 for the other plants. Then, we will have to "reclass" the good quantity with LI11N or LI12N in the right plant to avoid useless inventory adjustement ( LI20/LI21 transaction).

Is there another way(s) to to do the physical inventory than this with our warehouse/plant structure?

Thank you

Stephane

[nrameshkumar]

This message was moderated.

[MANIS]

Quant is a combination of (Material / Plant / SLoc/ Batch / St category and Special stock) if any of the characteristic change then system creates a new QUANT, in you case Plant is changing hence you are getting multiple Quant in the same bin (Mixing allowed at storage type level)

With regard to physical inventory there is no other way other then user count the stock physically in the bin and update the system (in this case since mixing is allowed and user is not having the visibility of the stock of multiple plant )  It is good that you want to optimize the warehouse space however by doing this you are creating further complexity in the warehouse as if there is any difference then it is very difficult to decide in which plant you have the difference and where to book that

In my opinion this is more towards operational rather then system. You need to put some physical separator to segregate the stock of multiple plant or remove the mixing (but in this case you will have under utilization of space)

[Former Member]

It's not possible to put separators because we are doing a lot of stock transfer between the 3 plants but the stock is not moving in the bin. Because we don't want the warehouseman to move a material in the same bin just because it has changed from one plant to another.

Thank you for your input

[JL23]

I wonder a bit on the process, maybe it is caused by a very special plant meaning in your design. We have as well shared warehouses between 2 plants, and we do stock transfers too.

But usually then the entire quantity moves if the stock remains in the warehouse, or it is taken immediately for consumption.

But if you keep stock of both plants parallel in your warehouse, then you either need to be able to distinguish this spatial or optical. Spatial would mean moving it to a separate bin, which is understood that you do not want this (I would not want this too) , so you have only a posting change. But a posting change does not necessarily mean that you are not allowed to do something physically. E.g. you could put a label with the owner to the material. This would then help to identify to which plant it belongs and where it has to be counted.