Require to make the inventory as Zero for particular store

Require to make the inventory as Zero for particular store

Environment: 

iVend 6.6 with SAP B1 10 

Problem statement: 

Require to make the inventory as Zero for particular store.

Symptoms:

products Inventory show in negative and some are in positive numbers.

Resolution/Work Around: 

There is need to check if SAP B1 and HO for the warehouse, contains same inventory or not. If Yes, then user can create Goods receipt / Goods Issues in SAP B1 for the warehouse so inventory sync will also update the product's quantity in iVend as well. Also customer can use below SQL Queries on iVend MC in Query Builder Screen to fetch details and list of Items.
​
select c.id,c.Description,c.WarehouseKey,a.id,a.Description,a.IsDeleted,b.InStockQuantity,b.AvailableQuantity
from invproduct a(no lock) ,
InvInventoryItem b(no lock) ,
InvWarehouse c(no lock)
where a.productkey=b.productkey
and b.WarehouseKey=c.WarehouseKey
and c.id= 'put warehouse id'
order by c.id,c.Description,c.WarehouseKey,a.id,a.Description

Recommendations /Suggestion:  

Kindly make sure that no one should work on Store/POS machines.


    • Related Articles

    • Sale at POS with Zero Inventory

      Problem: Not able to sell Items with Zero or negative quantity At POS Resolution: iVend has the facility to complete a sale with 0 inventory as well. "Allow Negative Inventory" option need to be enabled at the Enterprise for same, So to assist on ...

    • Addon information was not updated for newly created store

      Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...

    • Inventory Mismatch between Enterprise and store

      Product version: 6.6 Problem statement: INC0012329 Inventory Mismatch between Enterprise and store or skipped transactions from Store to Enterprise due to some issue n Replication. Proposed solution: Suggested customer to deployed the fix as per ...

    • iVend Patch not getting updated at POS

      Environment: iVend 6.6 Patch 7915 Problem Description: Patches in HO and the POS indicates that it has already been updated but in POS it stays in a cycle asking for an update and does not allow it to be done. Scenario: None Solution: 1) At POS the ...

    • View Inventory on POS : Failed on POS machine connected to on-premises Store.

      Problem Statement There is one scenario : Getting an error "Inventory Status updated from enterprise server failed" while clicking on Retrieve from Server button at POS machine however another POS machine ( connected to same stores) doesn't have this ...