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.