POS showing zero "Avaialbe to Sell quantity" for an item.

POS showing zero "Avaialbe to Sell quantity" for an item.

Problem:

POS showing zero "Available to Sell quantity" for an item. However, the Available quantity and In-Stock quantity for the same item is greater than zero.


Solution: 

 When POS User mark the checkbox "Reserve Quantity" while creating delivery fulfillment and Layaway with delivery fulfillment then iVend reserved the quantity for fulfillment operation. Might be possible that user reserved the quantity of the problematic item for fulfillment.

One can check the reserved quantity for the item using the below query: -

select ReservedQuantity, * from InvInventoryItem where ProductKey in (select ProductKey from InvProduct where Id = 'product id') and WarehouseKey in (select WarehouseKey from InvWarehouse where Id = 'warehouse id')

Or can check the open Special Order /Layaway transaction using the delivery report.

Open Enterprise Management Console> Reports> Special Order /Layaway Reports >Delivery