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 Extended Warehouse Management ® Physical Inventory ® Periodic Processing.

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.

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.

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.

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.

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

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

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.

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.

Save the data in the format csv.

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.