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

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:


Notes
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)





 
Notes
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



    • Related Articles

    • Getting an error "System.Exception: DI:10001287 - Item cost not found for one or more items"

      Problem: Getting an error “System.Exception: DI:10001287 - Item cost not found for one or more items” during Integration of sale transaction from iVend to SAP Cause: This error occurs when the Item cost is not defined in SBO for one or more items ...

    • SAP Business One - iVend Retail Integration Points

      Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

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

    • Failure Integration Event :Vendor Group not found in iVend

      Environment : iVend 6.6 integrated With SAPB1 Problem Statement : CustomerGroup add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904): String or binary ...

    • Failure Integration Event :CustomerGroup not found in iVend

      Environment : iVend 6.6 integrated With SAPB1 Problem Statement : CustomerGroup add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904): String or binary ...