"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.