Adaco: Inventory Adjustment Report – Fourth & HotSchedules Customer Success Portal

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

Report Criteria

Enter report criteria below to get desired results, as per Fig.2.

Fig.2 - Report Criteria for the Inventory Adjustment Report

Fields	Description
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 the average price difference calculations caused by receiving corrections made to purchase orders originally received in a closed period. Receiving Adjustment CHG: generates the report with quantity and/or price change calculations caused by receiving corrections made to purchase orders originally received in a closed period. Automatic Adjustment: generates the report with only inventory modifications made when month end inventory is closed.

Report Results

When the Inventory Adjustment report is generated, the result should look similar to Fig.3.

Fig.3 - Inventory Adjustment Report results

Fields	Description
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.
Total Cost	The combined inventory cost. Calculation: TOTAL COST = ADJ. QTY x UNIT 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.

Related articles