Physical Inventory Reports
You can use a number of reports to help you during the process of performing a physical inventory and to analyze and report the results of physical inventory adjustment transactions.
Physical Inventory Tag Listing
This report lists all the default and blank tags that you generated and all the dynamic tags that you entered. The report shows the tag number, item, revision, subinventory, locator, lot, and serial number for each tag used in your physical inventory. You can use this report as the document you give to the employees performing the counts. You can also use this report as a complete count history after all counts have been completed.
Physical Inventory Counts Report
This report shows information on the tags you enter for a physical inventory, including the item, item controls, count location, count quantity, and count value.
Physical Inventory Missing Tag Listing
This report lists the tags that are missing from a user-specified range of tag numbers. The report also shows what information was printed on the tag, if any, to aid in the search. Oracle Inventory considers as missing those tags for which you have not entered counts. Void tags are not considered to be missing. Use this report before initiating physical adjustments to verify that you have accounted for all tags generated by the system. Otherwise, if you have not entered a count for a tag and approvals are not required, Oracle Inventory adjusts your on-hand balances down to zero quantity.
Physical Inventory Adjustments Report
This report shows all adjustments against unique combinations of item, revision, subinventory, locator, lot, and serial number for a user-specified physical inventory. You can run this report before processing your adjustments to get a preview of your adjustment quantities and values. You can then determine whether you are ready to process all final adjustments or whether you need to recount certain locations. This report is also automatically generated after the successful completion of the adjustment program as a record of what was actually adjusted.
Physical Inventory Accuracy Analysis
You can run the Physical Inventory Accuracy Analysis report many times during your physical inventory. If you run it after you take a snapshot of your on-hand balances, this report shows the system on-hand quantity and value for each item included in your physical inventory. If you run this report after entering your tag counts, it shows the actual count quantities and values, as well as the adjustment quantity, value and error percentage for each count you entered. You can also use this report as a historical accuracy analysis tool.
Physical Inventory Summary Report
This report provides a summary of your physical inventory adjustments by subinventory. You can see, in your functional currency, the system on-hand value, the actual count value, and the resulting adjustment value, as well as the number of tags and adjustments performed for each subinventory. You can also use this report as a management tool to monitor the accuracy of your inventory as it also includes the error percentage of your original system on-hand quantities and values.
Physical Inventory Trend Report
This report compares past physical inventories so that you can see whether record accuracy has improved over time. It provides a summary of physical inventory adjustment values, by date and subinventory, as well as the number of tags and adjustments each subinventory required. You can view subtotals for each physical inventory as well as a grand total of all your physical inventory adjustments over time.
