Inventory Management: view and adjust inventory

Learn how to check quantity on hand (QOH) and adjust quantity, lot numbers and expiration dates, and average cost using the View Quantity on Hand window and the Adjustment List.

View Quantity on Hand window

Use the View Quantity on Hand window to view QOH, as well as adjust quantity, expiration dates and lot numbers.

Inventory > View Quantity on Hand

Filter and display items

1. Locate inventory item(s) using the location, classification, and Item fields. The Item field searches for either the item ID or description with an embedded ‘search for word’ function.
2. Click Advanced search for additional search criteria including inventory groups or types (MLI only), expiration date range, lot numbers and total cost.
3. Select Only show items with a negative quantity to exclude viewing items with a positive quantity.
4. Sort windows further by:
   • Clicking column headers. An arrow marks the sorted column.
   • Right-click the column header row to select which columns to display.
5. Click on a column heading to drag columns to a the preferred order.

View and adjust items

Select an item and do one of the following:

1. Click Edit QOH to adjust the quantity on hand for the selected item.
2. Click New QOH Adjust to search for an adjust items not displaying in the View Quantity on Hand window.
   • Adjust QOH, expiration date, and/or lot number all in the same window.
   • Items maintaining QOH may not display if they were recently set to track quantity or if the quantity has been at zero for more than 14 days.
3. Click Edit Lot & Exp to adjust only lot numbers and/or expiration dates on items that are tracking that information.
4. Click the Item History tab to review inventory records, such as ordered or received date, quantity and cost
5. Click Item Information tab to view information such as buy/sell ratio and pricing details.
6. Click Stock Locations tab to check the items stock levels at other locations. This tab is only for practices setup with MLI.

Notes:

• Changes may not appear immediately in the View QOH window if the Auto confirm adjustments inventory default is not selected.
• Confirm adjustments at Inventory > Adjustment List to finalize item changes to QOH and/or lot number / expiration date.

Adjust QOH for multiple items

1. Select multiple items in the View Quantity on Hand window:
   • Non-sequential items: Ctrl + click
   • Sequential items: Shift + click
2. Click Edit QOH.
   • Enter quantity change and adjustment reason, then click Next Record.
   • Click Previous record to move back thru the list of items.
   • View items included in the Adjusting # of # records pane.
   • Click Save to commit all changes and return to the View Quantity on Hand window.

Adjustment List window

Use the Adjustment List to:

• View and confirm QOH, lot number/expiration date adjustments.
• Perform single average cost, quantity and lot number/expiration date adjustments.

Inventory > Adjustment List

1. Click New QOH Adjust to find and adjust QOH, lot number or expiration date information
2. Click New Cost Adjust to find and adjust a QOH item’s average cost.
3. Click View to see the adjustment record of the selected row. Cost adjustments will not display.
4. Click Print to access the Inventory Adjustment report.
5. Click Confirm to finalize an unconfirmed adjustment.
6. Click Void to remove an unconfirmed adjustment.

Note: the Adjustment list can be filtered by adjustment status, date range or location (MLI only). Click Advanced search for additional search criteria including inventory groups (MLI only), item search, classification or adjusted by staff.

View Quantity on Hand versus Adjustment List

Use the chart below to determine which tasks can be performed from which window.

Additional information

General

• Internal Stock Use is recommended in cases of expired products, donations, broken or defective items as associated costs are tracked.
• Sort either window using available filters and column headers.
  • Right-click the column header row to adjust column display.
  • Columns can be dragged to the preferred order. The selection will be retained for the logged in user.
• Adjustments are tracked to the logged in user on the Inventory Adjustment report
• Lot/Exp date information can only be edited if the item is set to track that information.
  • These adjustment types are per item; multi-select is not available.
  • To adjust item tracking options:
    • Per item: Lists > Invoice Item > Inventory tab
    • Bulk changes: Tools > Invoice Item Setup > Set Barcodes/Expdate/Lotnbr tab

Item Search

• View Quantity on Hand and Adjustment List windows and Inventory Item list have both basic and advanced search functions. Advanced search functions offer additional fields to find specific inventory items.
• The item field on the View Quantity on Hand and Adjustment List (advanced search) windows will search within the specific window for either the item ID or description and includes a ‘search for word’. Ex: searching ‘AD” will return matches with ‘AD’ in description or ID.
  • The View Quantity on Hand window completes search upon entry of search criteria.
  • The Adjustment List window completes search after entry of search criteria and clicking the Search button.
• Use F2 in an item field or click <icon> to access the Search for Inventory item window’s basic search.
  • Only active items will display.
  • Perform a keyword search by using a preceding % to your search term. Example: %pea will return results such as Venison and Pea, Venison and Green Pea or Duck and Pea.
  • Basic search within Search for Inventory Item window will complete search upon entry of search criteria.
  • Click Advanced search for additional fields to find specific items. The search is completed after entry of search criteria and clicking the Search button.
    
• The search icon can also be accessed from Item History and Stock Locations tabs at bottom of View Quantity on Hand window.
  

Adjustment List

• The past 30 days of adjustments display by default. Adjust the date range as needed.
• Unconfirmed adjustments appear in the window when the Inventory Defaults are not set to auto-confirm adjustments: Controls > Defaults > Practice and Workstation > Inventory.

View Quantity on Hand window

• After editing the lot/expiration details, both the new and old entries will display on the View Quantity on Hand window.
  • The old old lot/expiration date will have a QOH of 0.
  • This and any other 0 qty line will disappear from the list in 14 days. This is based on End of day closing.

Related reports

• Adjustment Report
• Audit Report
• Inventory Cost Report
• Inventory Counts Report
• Inventory on hand reports