"Avaialbe to Sell quantity"is 0 whereas "Available quantity" exist for a particular product.

"Avaialbe to Sell quantity"is 0 whereas "Available quantity" exist for a particular product.

--INTERNAL DOCUMENT----

Product Version:

iVend 6.5 Update 6

Problem Statement  :

In the Inventory View of the Product the Available to Sell Quantity is showing 0, whereas the available quantity exists at a particular store.


Root Cause:

This issue is suspected to occur when the database is tempered by someone. So in such cases, we can find that one entry is missing in the “InvInventoryLocation” table of the HO database.

 Proposed solution: 

We need to update the missing entry in the “InvInventoryLocation” table of the Enterprise database by running the SQL query. And after that the replication events needs to be generated so that the data gets updated on the store as well.

    • Related Articles

    • 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 ...
    • Coupon ID does not exist

      Product version: iVend 6.6 Problem statement: Coupon already available on management console, but in upload, it shows coupon ID does not exist. Proposed Solution/Workaround: Map the Coupon id and Serial number. Steps  - Step to do the coupon upload. ...
    • Error at MC "Not enough quantity available in In-transit warehouse" while receiving Stock Transfer

      For Internal Use Product Version: 6.5 Update 6 Problem statement: An issue occurring where customer has done a Stock transfer in SAP (marked as for store), it has integrated to iVend Enterprise, then replicated down to the store, the transfer is at ...
    • Restrict user to change the product quantity in POS screen.

      Environment: iVend 6.6 Problem statement: Restrict user to change the product quantity in POS screen. Solution/Work Around: As a workaround,in the retail profile , you can check box "change qty" inside the manager override so whenever user changes ...
    • Default quantity at POS with condition

      Environment: iVend 6.6 Problem Statement: Is there a way to configure iVend to automatically set the default QTY per product on selecting the item at POS? For example, if an item name does not start with X-, then the default QTY for that item is 6. ...