The Inventory Adjustment Report is a tool designed to provide detailed insights into inventory adjustments within a specified date range and location.
To access the Inventory Adjustment Report you will need to navigate to Main Menu > Management > Reports > Inventory Adjustment Reports > View All Inventory Adjustments Report.
Once there you will be presented with the following screen
How to Generate the Inventory Adjustment Report
-
Select Date Range: Specify the start and end dates for the report. This allows you to focus on adjustments made within a specific period.
-
Select Location: Choose the location for which you want to generate the report. This could be a warehouse, store, or any other designated area where inventory is stored.
-
Select Manufacturer (Optional): If you want to filter the report by manufacturer, you can select a specific manufacturer from the dropdown list. This option helps in analyzing adjustments related to products from a particular supplier.
-
Item # (Optional): If you have selected a manufacturer, you can further refine the report by entering the item number associated with the manufacturer's products. This allows for a more granular analysis of inventory adjustments.
Once you have selected your parameters click Submit and the following report will be displayed.
For definitions of each column on the report please see below.
Date: The date on which the inventory adjustment was made.
Time: The time at which the inventory adjustment was recorded.
Manuf: The Manufacturer of the item
Item: The unique identification number assigned to the item being adjusted.
Description: A brief description or name of the item being adjusted.
Finish: The surface treatment or appearance of the item (e.g., polished, matte, glossy).
Fabric: The material composition of the item (e.g., cotton, polyester, leather).
Options: Any additional specifications or variations of the item
QTY Entered: The quantity of the item entered into the system for adjustment.
Location: The specific physical location where the inventory adjustment occurred (e.g., warehouse, store).
QTY (+): The quantity of items added or increased as part of the adjustment (positive adjustment).
Asset Amt(+): The monetary value associated with the items added or increased. This will show both with and without freight
QTY (-): The quantity of items removed or decreased as part of the adjustment (negative adjustment).
Asset Amt(-): The monetary value associated with the items removed or decreased.
User: The user or employee who initiated the inventory adjustment
Authorized by: The individual or authority who approved or authorized the inventory adjustment.