Find insufficient quantity in Integration failures logs iVend to SAPB1
Environment:
iVend Version 6.6
Problem Statement:
There may be various integration failures logs from iVend to SAPB1 ,failed due to insufficient quantity in SAPB1.
Symptoms:
Not Applicable
Resolution/Work Around:
The Below Query will result the rows which have less qty in SAP for the Stuck Stock Transfers
WITH STOCKTransfer AS
(
SELECT E.Id AS ItemCode, C.Id AS WhsCode, SUM(D.Quantity) AS [QtyToMove]
FROM InvStockTransfer A
INNER JOIN RepIntegrationLog B ON A.StockTransferKey = B.SourceKey
INNER JOIN InvWarehouse C ON A.FromWarehouseKey = C.WarehouseKey
INNER JOIN InvStockTransferDetail D ON A.StockTransferKey = D.StockTransferKey
INNER JOIN InvProduct E ON D.ProductKey = E.ProductKey
WHERE B.Status = 1 AND B.SourceType = 53
GROUP BY E.Id , C.Id
)
SELECT A.ItemCode, A.WhsCode, A.QtyToMove , OITW.OnHand [SAP QTY], A.QtyToMove - OITW.OnHand AS [Variance]
FROM STOCKTransfer A
LEFT OUTER JOIN SHB_PRD ..OITW AS OITW ON A.ItemCode = OITW.ItemCode collate SQL_Latin1_General_CP850_CI_AS
AND A.WhsCode = OITW.WhsCode collate SQL_Latin1_General_CP850_CI_AS
WHERE A.QtyToMove > OITW.OnHand
The Below Query will result the rows which have less qty in SAP for the Stuck Invoices
WITH Invoice AS
(
SELECT E.Id AS ItemCode, C.Id AS WhsCode, SUM(D.Quantity) AS [QtyToMove]
FROM TrxTransaction A
INNER JOIN RepIntegrationLog B ON A.TransactionKey = B.SourceKey
INNER JOIN TrxTransactionSaleItem D ON A.TransactionKey = D.TransactionKey
INNER JOIN InvWarehouse C ON D.WarehouseKey = C.WarehouseKey
INNER JOIN InvProduct E ON D.ProductKey = E.ProductKey
WHERE B.Status = 1 AND B.SourceType = 143
GROUP BY E.Id , C.Id
)
SELECT A.ItemCode, A.WhsCode, A.QtyToMove , OITW.OnHand [SAP QTY], A.QtyToMove - OITW.OnHand AS [Variance]
FROM Invoice A
LEFT OUTER JOIN Colio ..OITW AS OITW ON A.ItemCode = OITW.ItemCode collate SQL_Latin1_General_CP850_CI_AS
AND A.WhsCode = OITW.WhsCode collate SQL_Latin1_General_CP850_CI_AS
WHERE A.QtyToMove > OITW.OnHand
Recommendations /Suggestion:
Not Applicable
Related Articles
Where we can find the error logs for Integration Service
Version: Not version-specific Query Where we can find the error logs for Integration Service (a component of iVend, which syncs data between ERP and iVend Enterprise). Answer Sometimes it happens, Integration service returns an error while starting ...iVend Stock transfer insufficient quantity in intransit
Problem Statement: At the time of stock transfer customer was facing insufficient quantity in intransit - but the stock at intransit was showing sufficient on View InventoryEnvironment: 6.5 Update 6 integrated with SAP 9.2. Symptoms: User was not ...Good Receipt data fetch for Error Insufficient quantity for item with batch on Integration Monitor
**********Internal Purpose to CXS Support************** Environment : iVend 6.6 With SAPB1 Problem Statement : Stock transfer and Sale transaction events stucked on Integration Failure Monitor with error message “Insufficient quantity for item with ...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 ...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 ...