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

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

INTERNAL DOCUMENT

Problem Statement:  

Item Cost not found for one or more items.


Version: 

iVend 6.5 Update 6 with SAPB1 9.2  

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


    • Related Articles

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

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

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

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