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

    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

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