You can review a list of all of the adjustments that have been made to inventory through any screen.
The Inventory Adjustment List displays inventory changes from the following:
Purchases, based on vendor bills
Sales, based on customer invoices
Adjustments, based on entries made in the Inventory Adjustment screen
Changes, based on entries in the Update Inventory screen
Beginning inventory information, based on the Beginning Inventory figures you entered when you set up the item on the Setup Products screen.
From this screen, you can review information about all changes to inventory, and open the original product setup screen or inventory change record of specific inventory items for editing, deletion, or further review.
To review the Inventory Adjustment List:
1. Select Adjustments from the Inventory menu to open the Inventory Adjustment screen.
2. Click the List button to open the Inventory Adjustment List.
The Inventory Adjustment List displays a table containing all of the inventory changes for each item you have defined.
Note: The list displays changes to all items, regardless of whether the item has been designated as an inventory item on the Setup Products screen.
3. (Optional) Use the fields in the Search Criteria panel to narrow the list to display specific items. You can select a specific product from the Product drop-down list or a specific period from the Period drop-down list, and click View.
If you do not filter the list, the table displays all of the entered adjustments and changes for all of the products you have defined.
4. (Optional) Click any column heading to sort the table in ascending order by that column, and click again to sort in descending order.
5. Review the information in the table.
The table displays the following information for each adjustment:
§ Item: The name of the item adjusted. Click the item name to review the original product setup screen.
§ Date: The date of the adjustment. Click the date to open the original invoice or bill.
Note: This link is not available for changes made through the Inventory Adjustment or Update Inventory screens.
§ Reference and Description: Identifying entries from the Inventory Adjustment screen.
§ Type: Specifies the source of the inventory change. Entries in this column indicate whether the change was the result of a Sales Invoice, a Vendor Bill (including the beginning inventory set on the Product Setup screen), or Purchase Adjustments that include entries made on the Inventory Adjustment and Update Inventory screens.
§ Item Quantity: Indicates the quantity of the change - the number purchased, sold, or adjusted.
§ Unit Price: Displays the price of the item, based on the inventory method (FIFO or LIFO) you specified in the Inventory Preferences screen.
§ Used or Reduced:
6. Click Excel to export the information in the Inventory Adjustment List to an Excel spreadsheet for review or further analysis.
You are prompted to open or save an Excel file containing the information from the Inventory Adjustment List.
7. Click Add to return to the Inventory Adjustment screen to create a new inventory adjustment.