Inventory reports

This table shows the report name and description:

Report Description
Activity By Pallet Lists the pallet ID, product, date, activity type, lot number, the quantity before and after the activity, and the employee ID. Lists the old and new status codes of a specific pallet ID or all pallet IDs in a date range.
Calculate Pending ABC Utility Enables you to make changes to the ABC Classification and see the effects of those changes before applying the changes.
Detailed Transactions You can sort this report by product or location and date range. You can print the report for a specific employee or all employees, and include a specific zone or all zones. Any line that contains the product number includes both description lines of the product.
Empty Locations Shows empty locations and primary products when applicable.
Inventory Detail By Location Shows inventory in the locations that match the criteria entered on the report parameters window. Shows the location, pallet, product number, description, lot or serial number, total quantity, aisle, and zone.
Inventory Detail By Stock Number Shows available and unavailable inventory by stock number for a range of product numbers and a specific status code. Can include serial numbers. The report can be sorted by product number or stock status.
Item Availability/Demand Shows on hand, reserved, and demand quantities of a selected product or all products in the warehouse or for a particular zone.
Item History By Item Shows transaction history for a product. Shows the product number and description, and the date the transaction occurred. Shows the status, starting balance, adjustments, receipts, returns, shipments, on hand quantity, calculated on-hand quantity and difference are included on the report.
Item History Summary Shows status, date, start balance, receipts, returns, adjustments, shipments, ending balance, totals.
Item Records Missing Data Shows locations for products that are missing cross-references, primary locations, and default warehouse zone.
Item: Kit Items Shows kit product, description, kit quantity, available quantity, open quantity, quantity for order.
Item: Serial Items Provides detailed information about serialized products. The Inventory By Location Report and Inventory By Stock Number Report also include detail for serial products.
Items (Non-Stock) You can generate this report by product or location. The product, transaction type, zone, and class are displayed.
Items in Multiple Locations Helps you determine if products can be consolidated. Shows products that are in multiple bins in the warehouse. Can include a range of products, for a specific zone, and include primary pick locations. Output is sorted by product, bin, and pallet.
Non-Stock Item Inventory Helps you monitor the nonstocks that are in your warehouse for potential action or consolidation. Lists nonstock products, location, pallet, status, and quantity that are in the warehouse. You can sort this report by product totals or inventory by location.
Over Demand Items Lists the orders with products that were not in stock. The on-hand and reserved quantities are also listed.
Pending Order Lines Shows orders that have been released but have not been dropped. Includes the carrier, service, self ship, product and description, primary pick location, quantity.
Pending Put-Away Activity Lists the inventory in dock or department stage-out locations that are ready to be put away.
Pending Replenishment By Item Shows movement activities and product data that is cross-referenced by company number, warehouse number, and product number. If an individual pending movement is urgent, then an X is printed at the beginning of the line.

Run this report before orders are dropped to ensure adequate quantities are in a location. Shows product number and description, lot, to locations and from locations, quantity, case quantity, number of cases, remaining units.

Physical Inventory Summary Includes the warehouse zone, total number of locations that are counted/uncounted, total inventory records that are counted/uncounted, and warehouse zone accuracy percentage.
Physical Transactions Includes the product number, location, lot number, quantity before and after.
Physical Inventory Valuation Sorts products by Product Warehouse Product Setup cost type. Includes options to print bin locations per product and include total cost. You can specify a cut-off value.
Physical Inventory Variances You can enter a location, a partial product number, zone, and aisle to view the qualifying variances on the report. Both negative and positive values are displayed. You can use the Recount column to keep track of which products must be recounted.
Physical Uncounted Inventory During a physical inventory count, you can run this report for uncounted inventory by stock status, both, available, and unavailable. You can sort by product or location. You can print the report to a text printer or manually import the flat file into a spreadsheet.
Physical UnCounted Locations Includes products by warehouse zone or aisle that have not been counted. You can sort the report by zone or aisle, or location.
Primary Pick Locations By Item Shows product, description, location, pick type, case quantity, pallet quantity, max/min, replenishment unit, replenishment quantity, calculated replenishment.
Primary Pick Locations by Location Primary locations that contain non-primary products.
Quantity Discrepancy Report You can run this report by product or location. Lists the quantity discrepancies by transaction type, expected quantity, actual quantity, and bin location.
Zero Quantity Inventory Helps you locate inventory and receiving errors. Shows location, pallet, product, lot, and quantity for locations containing zero or negative quantities. When a partial product or location number is entered on the report parameter window, all records that begin with those characters are included.