Is there any query to get which record will go next in the Integration queue from iVend to Magneto?
Version:
6.6 with Magento
Query:
Is there any query to get which record will go next in the Integration queue from iVend to Magneto?
Response:
Below is the query that will give the result for the records which will go to Magento in the first to the newest sequence:
Select * from RepIntegrationLog where ApplicationKey='<put the ApplicationKey here>'and Flag=0 and Status =0 order by LogDatetime ASC
Query:
Is there any query to get that how many records are in the Integration queue from iVend to Magneto
Response:
Below is the query that will give the result for the records which are pending to go to Magento:
Select count (*) from RepIntegrationLog where ApplicationKey='<put the ApplicationKey here>'and Flag=0 and Status =0
Note: Below is the query, which can be used to get the ApplicationKey for the Magento
Select * from CfgRegisteredApplication
This KB article concludes here.
Related Articles
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 ...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 ...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): ...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 ...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 ...