Inventory Detail Sublist Is Not Equal to Inventory Numbers Sublist

Scenario

Users may sometimes observe that the Inventory Detail tab and Inventory Numbers tab may have different Quantity Available. This may be due to Sales Orders or Work Orders wherein the Inventory Numbers are committed.

Solution

To resolve, users may create a Search for transactions wherein Inventory Numbers are committed to:

1. Navigate to Lists > Search > Saved Searches > New

2. Search Title: Enter Title

3. Click Transaction

4. Click Criteria 

5. Click Standard 

6. Filter:

   Note: For every required field use the drop-down menu to select it, once adjusted click Add.

   • Select Item
   • Select Location
   • Select Posting
   • Description: Set to False
   • Select Quantity Committed
   • Description: Set to Greater than 

7. Click Results

8. Click Columns

9. Field:
   Note: For every required field use the drop-down menu to select it, once adjusted click Add.

   • Select Date
   • Select Type
   • Select Document Number
   • Select Location
   • Select Item
   • Select Quantity
   • Select Quantity Committed
   • Select Transaction Serial/Lot Number
   • Select Transaction Serial/Lot Number Quantity

10. Show Totals: Enter Checkmark

11. Click Save & Run