WM cycle counting

[Former Member]

Hi All,

In SAP, are there any standard Cycle Count reports? Reports that summarize what's been counted, listing details of variances, value of inventory variances,

accuracy ratings etc...

Also, is there a standard transaction that would display excess or inactive material at the pick level? Is there a transaction that could be used to move excess

or inactive material at the pick level.

Advance thanks

SATYA

[former_member1245242 · Accepted solution]

Hi

for your 1st requirement, MIBC, LX22, MI20 helps.

Rgds

Ramesh

[Former Member · Accepted solution]

Thank You,

But I want any standard reports available for BIN level

[Former Member]

Hello Satya,

Using transcation MIDO you can get list of physical inventory overview.

Transcation MI24 can be used for getting the list of all pysical inventory document.

You can use LX25 to get the inventory status for a combination of warehouse number, storage type and inventory period.

With LX25 you will get information on following points

Total number of bins

Inv. executed during selection peri

Inventory active

Inventory planned

No inventory executed

LX22 transcation will give you warehosue managed physical inventory overview.

Br,

Tushar

[Former Member]

Hi Tushar Patankar /Sashidhar/Ramesh,

Thanks for your replies. Actually my client wants the consolated report at bin level stock. Please tell is thereany standard reports?

If not please tell what are the SAP tables to be checked.

Thanks to all

SATYA

[Former Member]

Did you see check if LX03 was useful to you for Bin level stock report?

[Former Member]

Hello Satya,

You can get the details at bin level in LX25 transcation.

Go to LX25. Enter the warehouse number and storage type and inventory period dates and execute the report.

Now place the cursor on total numbet of bins and press tab choose details.This will give you overall picture of physical inventory at bon level.

Also by placing the cursor on inventory plan, you will get all the bins which are due for inventory durin mentioned inventory planned period in selection criteria.

BR,

Tushar

[Former Member]

There is no such standard report to show inactive materials.

Materials at any point in time should be lying in any of the storage types. So, you can periodically create Transfer orders in LT01 with Movement type 999 to transfer excess materials from one storage type to another