Integration error "Invalid UoM; specify a purchase or sales UoM from ITM3 [ITM9.UomEntry][line: 1]"

****** Internal Article ************

Problem Statement

Failed Integration records from iVend to SAP Source type 46 (product), error

"System.Exception: DI:1470000147 - Invalid UoM; specify a purchase or sales UoM from ITM3 [ITM9.UomEntry][line: 1] en

ReplicationSBOIntegrationWinSer.IntegrationObjects.Item.Replicate(Direction From, Direction To, Int32 DatasetRowID)en ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean&) Retried "and for Sourcetype 59 (UPCTranslation) also error:

"System.Exception: DI:1470000147 - Invalid UoM; specify a purchase or sales UoM from ITM3 [ITM9.UomEntry][line: 1]en

ReplicationSBOIntegrationWinSer.IntegrationObjects.UPCTranslation90.Replicate(Direction From, Direction To, Int32 DatasetRowID)en ReplicationSBOIntegrationWinSer.IntegrationObjects.UPCTranslation.Replicate(Direction From, Direction To, Int32 DatasetRowID)

en ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean& Retried)"

Below is the screenshot of the errors:

​

Cause

UOM showing at GUI was correct however the data in the relevant tables were not in sync. 

We analyzed that UOM for this failed item was showing in SAP UI Item master data screen as Lets say "Box" under the UoM Code however when we checked SAP table it was linked with UOM code Lets say "Pair" in table OUOM and ITM9 hence causing the issue.

Example:

ItemCode 'A' has UomCode assigned 'Box'

Select * from OITM where ItemCode = 'A'

Select * from ITM3 where ItemCode = 'A' --Pick UomEntry from here

Select * from ITM9 where ItemCode = 'A' --Pick UomEntry from here, Lets say UomEntry =2

Select * from OUOM where UomEntry = '2' --Result UomCode = 'Pair' which is different from actual UomCode 'Box' of this ItemCode A hence causing the issue.

Resolution

Link the product with correct UOM in SAP then retry all related failed records in Integration failure monitor to resolve the issue.

• Related Articles

• Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"

  Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...

• Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"

  *****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...

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

• Integration error DI:Item number is missing; specify an item number [POR1.ItemCode][line: 1]"

  Product Version 6.5 Update 6 Problem Statement Purchase order stuck on Integration Failure Monitor with error message from iVend to SAP “System.Exception: DI:Item number is missing; specify an item number [POR1.ItemCode][line: 1]” Proposed Solution ...

• iVend to SAP Intgartion Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO

  Environment :  Ivend 6.6 Problem statement : iVend to SAP SAP B1 Integration Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO Symptoms: Sale Transactions is not integrating from ivend to SAP B1. Below ...