Inventory Adjustment Report
The Inventory Adjustment Report is used to see which kinds of adjustments have been made to the inventory amount of products within one or more outlets.
- To run this report, go to Report Center > Inventory Reports > Inventory Adjustment Report
- To open the report criteria screen, double-click Inventory Adjustment Report or select the report and click Run Report, as per Fig.1
Fig.1 - Running the Inventory Adjustment Report
Enter report criteria below to get desired results, as per Fig.2.
Fig.2 - Report Criteria for the Inventory Adjustment Report
|Outlets||Displays all the outlets in Adaco.
Select All: option allows all of the outlets to be selected in one click.
|Date Range Options||Select Start and End Dates: generates the report showing the changes made within the selected time frame.
Date Range by Period: generates the report showing all the changes made within the selected period.
|From Date||When Select Start and End Dates is enabled, this drop down field will allow a calendar date to be selected as the beginning date.|
|To Date||When Select Start and End Dates is enabled, this drop down field will allow a calendar date to be selected as the ending date.|
|Display Options||(Select All): generates the report with all the options available.
Manual Adjustment: generates the report with only inventory modifications made by users or interim inventories.
Receiving Adjustment DIFF: generates the report with only the difference modification made to a purchase order in a closed period.
Receiving Adjustment CHG: generates the report with only the charge modification made to a purchase order in a closed period.
Automatic Adjustment: generates the report with only inventory modifications made when month end inventory is closed.
When the Inventory Adjustment report is generated, the result should look similar to Fig.3.
Fig.3 - Inventory Adjustment Report results
|Eff Date||Displays the day the modification was made.|
|Product||The Adaco number for the product.|
|Description||The name of the product.|
|Adj. Qty||The inventory amount to which the product was modified.|
|Unit||The inventory unit.|
|Unit Cost||The inventory cost.|
The combined inventory cost.
|Comments||Either the system will fill in the comment with Month End Inventory or the specific interim inventory period or, if a manual adjustment, a required field the user must fill in before saving.|
|Retail Attributes||Displays the assigned retail features if the product is a retail product, located in Property > Products > Retail.|
|Purchase Information||Displays the text put in the Purchase Info field on the Product Master, located in Property > Products.|
|Outlet||The Adaco number and name of the outlet.|
|Outlet Total||Adj. Qty: the sum of all the inventory amount modifications.
Total Cost: the sum of all the combined inventory costs of the products.