Stock Transfer error "Item not found product-' ' , warehouse-

Stock Transfer error "Item not found product-' ' , warehouse-

Problem Statement: 

While making Stock Transfer receipt on receiving store MC, user get the error

“Item not found product -      Warehouse -  “

 

Version : 

iVend 6.5 Update 6

Check Points:

1. Check if Sending warehouse/Receiving warehouse contains correct mapping with In-transit warehouse or not

Go to iVend Enterprise MC->Administration -> Retail Configuration -> warehouse

 select InTransitWarehouseKey,* from InvWarehouse

2. Open the Receiving Store MC where user try to receive the stock transfer shipment, to check if product is mapped with warehouse or not.

 

Go to Receiving Store MC-> OperationàInventory -> Product -> Search the product for which user get the error -> View ->View   

select WarehouseKey,InStockQuantity,AvailableQuantity,* from InvInventoryItem where ProductKey='enter ProductKey'

3. If it is not , there is need to check   product availability  on  the Enterprise MC

Go to Enterprise MC -> Operation-> Inventory-> Product -> Search the product for which user get the error -> View ->View inventory à Check for In-transit warehouse

SQL Query/table same as step 2

4. If it is not , there is need to check   product’s availability    on  the Sending Store MC

Go to Sending Store MC -> Operation -> Inventory -> Product -> Search the product for which user get the error -> View -> View inventory à Check for Intransit warehouse

SQL Query/Table same as step 2

5. If it is not in iVend HO MC /Sending Store MC/ Receiving Store MC, then need to check the same from SAPB1

Go to SAPB1 -> Inventory-> Item Master data -> Search Product -> Inventory Data

select * from oitw where ItemCode='enter itemcode'

6. If it exist in SAPB1 , user may update Locked field -> click Update -> Unlock Field -> Click update

select Locked,* from oitw where ItemCode='enter itemcode '

7. With this process, SAPB1 will generate the integration events for this specific warehouse( missed in iVend ) and with Replication events, it will update the Product availability for specific warehouse.