Integration failure : Item Cost not found for one or more items.

Problem Statement:

Item Cost not found for one or more items.

Version:

iVend 6.5 Update 6 with SAPB1 9.2 , iVend 6.6 with SAPB1

Check Points:

Item cost may not exist in warehouse for which transaction is integrating with SAPB1.

User may find warehouse code by expanding transaction into iVend integration Failure log screen

1. Check if item cost is defined for the concerned Product in SAP B1

Inventory -> Item master data -> Inventory data -> Item cost (Check if item cost is defined for that product or not)

SQL Query : in SAP DB : select AvgPrice,* from oitw where itemcode=''

If it does, then retry the event in iVend integration failure log. If not then proceed with below steps.

2. Update cost of this item in SAP

Inventory -> Inventory -> Transactions -> Inventory Revaluation

3. Restart the Integration service

4. Retry the failed record

Problem Statement

Goods Return against GRPO transaction stucked in Integration Failure from iVend to SAP with the following error message however cost was defined in SAP.

System.Exception: DI:10001287 - Item cost not found for one or more items

atReplicationSBOIntegrationWinSer.IntegrationObjects.GoodsReturn.Replicate(Direction From, Direction To, Int32 DatasetRowID)

at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean Retried)

Resolution/Work

The Goods Return transaction was generated against a GRPO where the item price was recorded as 0 so it will also show same message in SAP "Item cost not found for one or more items"

As a workaround, we recommend creating the Goods Return manually in SAP after stopping the integration service. This should be performed during a support session so that the inventory impact from SAP to iVend can be safely ignored, and to avoid further Goods Return integration failures related to the error “Item cost not found for one or more items

Recommendations /Suggestion