discrepancy between IM stock and WM Stock

[Former Member]

Hi experts,

We found there is discrepancy between IM stock and WM Stock.Before configuring WM storage types , IM Stocks are not syched. So WM stocks are showing less then IM stocks,. Now i need to synch up the IM stock and WM stock. what we needs to do. Can you please guide us.

Thanks & Regards,

Vamsi

[Former Member]

answered

[Former Member]

OR

have a look at using transaction LX23 (provided you dont use HUM this should help you determine/ analyse and post any differences between IM and WM).

thanks,

A

LX23: Stock Comparison Inventory Management / Warehouse Management

Description

Using this report you can generate an inventory comparison between the IM System (Inventory Management) and the WM System (Warehouse Management).

On the selection screen, you can limit the area for comparison by entering the plant / storage location, plant / warehouse number or only the warehouse number.

In addition to specifying the area, you can also determine the extent of information to be issued. Here you have three options:

1. "With bin inventory"

In addition to generating the corresponding stock figures, you can also have a list of the corresponding WM bin quantities included.

2. "All data on material"

Even if only one difference occurs in one of the listed combinatations of material / batch / special stock indicator / supplier, all material combinations are listed. This can be very helpful when searching for errors.

3. "Clear differences"

If you mark this field, the system will generate a batch input session. By starting the batch input session, the differences to be cleared are removed in the IM system. Negative WM stock figures and stock differences in returns will not be cleared.

If you want to have a batch input file generated for the purpose of clearing the differences, it is important, for consistency reasons, that the materials in the respective warehouse are blocked in order that postings affecting stock figures can be prevented.

CAREFUL: If you generate this session, all the material stocks belonging to the respective warehouse number are blocked completely, that is, for the duration of the program, no postings affecting the stock in the warehouse will be possible!

Prerequisites

The comparison is also possible for warehosue numbers managed on a decentralized basis.

Output

You receive a list with various materials. The list contains the following information, for example:

The first line contains the plant, storage location, warehouse number, material number, total stock in inventory management, total stock in the warehouse, and the difference between the stocks.

The following line contains the first combination of batch / special stock indicator / supplier (or sales document and item number for sales order stock) and stock category (Q,R,S, ), the stock figures in Inventory Management, in Warehouse Management, and the difference.

If a batch input session is to be generated, the list contains a note in the log as to whether or not a session has been generated or behind the pushbutton "non-postable stocks", which materials could not be cleared because of negative stock figures or because they belong to returns stock.

Edited by: WILSAQ on Aug 11, 2009 12:09 AM

[MANIS]

Hi Vamsi

My suggestion is correct the stock through Physical inventory process.

Regards

Manish kumar