Reports in Physical Inventory

The following reports are available in physical inventory for work scheduling, performing the physical inventory, and correcting errors.

To call the reports, on the SAP Easy Access screen, choose Start of the navigation path Extended Warehouse Management Next navigation step Physical Inventory Periodic Processing End of the navigation path .

Features

Report for Work Scheduling

Determine and Set Prices from ERP

You can use this report to download product prices from the ERP system in Extended Warehouse Management (EWM). The system takes into account these prices during the tolerance checks when you post physical inventory documents in EWM and when you post differences to the ERP system.

Note Note

The report does not always reflect the current prices from the ERP system. Instead, it represents a snapshot of the prices at the time when the report is executed.

End of the note.

Recommendation

We recommend that you execute the report in accordance with the frequency of changes to your product master data. In other words, if your product master data changes frequently, you should also execute the report more frequently.

End of the recommendation.

If you use split-valuated products without batches in ERP, you must execute the report to download the valuation types from the ERP system first. The valuation types are handled as batches in EWM.

Note Note

To avoid stock inconsistencies between EWM and ERP, you must run the report before the first goods movement of a split-valuated product without batches in EWM or before new valuation types are created in ERP.

End of the note.

Operational Reports

Create Physical Inventory Document and Create Physical Inventory Document (Cycle Counting)

You can use these reports to create physical inventory documents in the background. If you have to count a large number of products, for example, you can have the system create the physical inventory documents overnight and you can then start to process them in the morning.

Print Physical Inventory Count Document

You can use this report to schedule the printing of physical inventory count documents as a background job. For example, you can print all the physical inventory count documents for a number of physical inventory documents that you created previously in the warehouse management monitor. Otherwise, you can schedule the printing as a background job to run overnight.

Post Differences to the ERP System

You can use this report to schedule the posting of differences to the ERP system as a background job. As is the case for the Difference Analyzer, you can post differences at cumulative level and detailed level.

Note Note

The system performs the tolerance check with the user settings for the user who starts the report. If required, create a separate user.

End of the note.

Recommendation

We recommend that you use this report to post small differences.

End of the recommendation.

Check Product for Complete Count

You can use this report to perform a completeness check in the background. For more information, see Physical Inventory Progress.

Upload Storage Bins and Count Data and Download Storage Bins and Stock Data

These reports represent an interface to external systems via which you can upload and download storage bin data and stock data.

For uploading, you have the following options:

You upload the storage bin data for which you want to carry out a physical inventory. You carry out the physical inventory in EWM.

You carry out the physical inventory in an external system and then upload the results to EWM.

Note Note

For the sample-based physical inventory, you download the storage bin and stock data. You then determine the sample in an external system. You then carry out the sample-based physical inventory in EWM.

End of the note.

Recommendation

Save the data in the format csv.

End of the recommendation.

Check Reports (Checking Errors)

Stock Comparison ERP

You can use this report to identify and correct inconsistencies between EWM and the ERP system. Since you perform inventory management for a specific storage bin in EWM unlike in the ERP system where you perform inventory management for a specific storage location, the system always assumes that the stocks in EWM are correct. The system also assumes that you have to correct the stocks in the ERP system where necessary.

Adjust Serial Numbers at Warehouse Number Level

For serial number requirement B (Serial Number Requirement at Warehouse Number Level), the system saves the serial numbers in a global table. When you post differences in the Difference Analyzer that might have occurred in various processes, the system does not automatically delete the serial numbers from this table. We therefore recommend that from time to time you reconcile the data in this table with the serial numbers recorded in the physical inventory. This report suggests serial numbers for deletion that have not been recorded by physical inventory documents in the period in question. You can then delete these serial numbers.