Quantity Available on Purchasing/Inventory tab is Less than Inventory Detail tab
Published on
October 24, 2023 at 3:10:01 AM PDT October 24, 2023 at 3:10:01 AM PDTth, October 24, 2023 at 3:10:01 AM PDT
Scenario:
When the quantity available onPurchasing/Inventorytab is less then the quantity available on theInventory Detailtab.
Solution:
The user may create aTransaction Saved Searchto see a list ofItem FulfillmentswithPicked/Packedstatus containing the item with the following steps:
- Go toReports>Saved Search>All Saved Searches>New
- ClickTransaction
- Search Title:EnterTitle
Example:Picked/PackedItem Fulfillment of Item 'A' - Fields:
- SelectType
- Description: is any of Item Fulfillment - SelectStatus
- Description: is any of Item Fulfillment: Picked, Item Fulfillment: Packed - SelectItem
-Description: starts with[Enter Item name] - ClickResults
- ClickColumns
Filter:
Note:For every required filter, use the drop-down menu to select it and once adjusted click Add if needed - SelectDate
- SelectDocument Number
- ClickSave & Run
- Click onViewon eachItem Fulfillment
- Click on theSales Orderlink on theCreated Fromfield
- Check for any Sales Order status that isClosed,if none check theClosedcolumn on the line item level if checked for the item of concern
Quantity available on thePurchasing/Inventorytab is quantity on hand less the committed quantity toSales Orders,while quantity available on theInventory Detailtab is quantity on hand less quantities included inItem FulfillmentsinPickedorPackedstatus.
Hence, the possible scenario for the mismatch is