Missing Product Warehouse Mapping in iVend databases

Missing Product Warehouse Mapping in iVend databases

*********** Internal to CitiXsys ***********

Environment: 

iVend 6.4.1.2 with SAPB1 9.2

Problem statement: 

User creates warehouse in SAPB1 and it gets integrated in iVend but Inventory of product was not updated on Enterprise and store.

Symptoms:

User creates warehouse in SAPB1 and it gets integrated in iVend but Inventory of product was not updated on Enterprise and store.

Resolution/Work Around:

There is need to generate the inventory-Warehouse mapping in iVend Enterprise   
Below are the step we require to follow-up to resolve the issue.
1.Query used for insert missing entries on enterprise database.
INSERT into InvInventoryItem
SELECT
CONVERT (VARCHAR(20),row_number() over (order by t1.ProductKey) + 5176000) 'InventoryItemKey',
t1.ProductKey, t1.WarehouseKey,0,0,0,0,0,0,0,0,0,0,0,0,0,0,GETDATE(),
GETDATE(),-1,-1,0,0,0,0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,0,NULL,NULL,
NULL,NULL,NULL,0,0
FROM (SELECT ProductKey, WarehouseKey FROM InvProduct
Cross JOIN InvWarehouse) t1
LEFT JOIN InvInventoryItem t2 ON T1.ProductKey = t2.ProductKey and t1.WarehouseKey = t2.WarehouseKey
where t2.InventoryItemKey is null
order by t1.WarehouseKey, t1.ProductKey
2.Updated inventory by using sap inventory.
3.Query used for  generate replication events for inserted data.
Select
'exec DataNotification @pSourceType=38, @pSourceKey=' + CONVERT(VARCHAR(20),InventoryItemKey) + ',@pBatchKey=' +
CONVERT(VARCHAR(20),row_number() over (order by InventoryItemKey)) + ', @pOperationType=0,@pUserKey=1'
from invinventoryitem where created >= '4-Jan-2019'
and len(InventoryItemKey)=7

Recommendations /Suggestion:

This article is created only for Support team and such activities should be done along  with  product expert.

    • Related Articles

    • Restrict particular users to access warehouse

      Environment : iVend 6.6 with SAPB1 Problem Statement : There is need to restrict particular users to access warehouse & its relevant information in iVend Various Screens. Resolution/Work Around : Whenever you create any warehouse in SAPB1 , it will ...

    • Error while creating a new product group with Business Central

      Environment: iVend 6.6 Patch 7989 Problem Statement: Loyalty plans were created correctly but adding the products involved in the discount does NOT allow us to create a new group of products. Scenario: Client created loyalty plans in iVend system but ...

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

    • Warehouse creation in SAP R3 and its effect in ivend

      Product version: iVend 6.5 update 6 Problem Statement: Stock transfer request only created between warhouses which mapped to stores(Retail) and not General Warhouse. Proposed Solution: NA Steps if any: In SAP R3 , value needs to be passed from ...

    • Missing Retail Tender in SAPB1 Warehouse : Generate Mappings

      This KB is for Internal Purpose Only for CitiXsys Environment: iVend 6.6 with SAPB1 9.2 Problem statement: There are some warehouse in SAPB1 where iVend Addon Screen "Retail Tender" doesn't display the available tenders to be mapped. Symptoms : There ...