SAP Business One
Integration Failed records from SAP to iVend "Input string was not in a correct format"
***************** Internal Article ***************** Problem Statement Integration Failed records (Customer type, update events) from SAP to iVend. Below is the error coming: System.FormatException: Input string was not in the correct format. at ...
How to break consolidation into inidividual transaction.
Environment: iVend Version 6.6 with SAPB1 9.2 Problem Statement: How to break consolidation into individual transaction. Symptoms: Not Applicable Resolution/Work Around: Follow the below steps. 1. Take the SAP database backup 2. Stop the Replication ...
Events are not triggering from SAP to iVend in Integration monitor
Issue Events are not triggering from SAP to iVend in the Integration monitor. Investigation When the events are not triggering from SAP to iVend then we should always check two things: 1. iVend transaction notification stored procedure ...
DI: Discount amount is greater than Balance Due (Integration failure from iVend to SAP)
Product Version 6.5 Update 6 Problem Statement Failed record in Integration Failure monitor from iVend to SAP error says: “DI: Discount amount is greater than Balance Due.” Proposed Solution/Workaround One of the known issues for this error was about ...
iVend Addon Wrong digital signature of AddOn Citixsys AddOn uninstaller
Product Version 6.5 Update 6 integrated with Sap B1 Problem Statement At the time of registering the Addon in SAP its showing below message “ Wrong digital signature of AddOn Citixsys AddOn uninstaller” after upgrade. Proposed Solution Wrong digital ...
ERP Integration Stock transfer stucked System.Runtime.InteropServices.COMException (0xFFFFFC17)
Product Version 6.6 integrated with Sap B1 Problem Statement Stock transfer stucked on Integration Failure Monitor from iVend to SAP with error message “System.Runtime.InteropServices.COMException (0xFFFFFC17): Exception from HRESULT: 0xFFFFFC17’ ...
Price update events (source type 1003) from SAP to iVend getting failed in Integration Monitor
********************************Internal to CitiXsys****************************************** Product Version 6.5 Update 6 Issue Price update events (source type 1003) from SAP to iVend getting failed with error below: System FormatException: Index ...
While installing iVend Addon Message showing 'database structure has been modified'
Product Version iVend 6.6 Patch 2 Problem Statement While installing iVend Addon Message showing ‘database structure has been modified’ Proposed Solution While login with iVend addon and starts installing then gives a message that ‘database structure ...
Sale completed at POS does not show all items in AR Invoice in SAP
Query A Sale was completed at iVend POS with 2 items (In one transaction) but when Checked in SAP, only one item available in SAP A/R invoice. Cause Need to verify the nature POS transaction. The transaction might consist of one or more items with ...
ERP Good Receipt Integration error System.Exception:DI:Quantity falls into negative inventory
Product Version iVend 6.5 Update 5 with SAPB1 Problem Statement Good receipt add stucked on Integration Failure Monitor with error message “System.Exception:DI:Quantity falls into negative inventory [WTR1.ItemCode][line: 2]” Proposed Solution ...
Require an item to be marked as Kit in iVend when it is created from SAP.
Query Require an item to be marked as Kit in iVend when it is created from SAP. Solution For that you need to create bill of material for the product in SAP. When a BOM (Bill of material) is created in SAP where it's type is Production and "Retail ...
Steps to pulls SAP data /Table from SAP HANA Database to iVend SQL SERVER
*************************************************************************************************************************** This article is only for internal use. ...
Error in SAP while updating serial item
Product version 6.6 with SAP B1 9.3 Problem statement On updating a serial item in SAP B1 customer got the error: Cannot modify the serial number. Refer below screenshot. Proposed solution Fix is already provided by the development team in latest ...
"System.Exception: DI:10000104 - enter posting date that is equal to or earlier than system date"
Problem Statement Record stuck on Integration Failure with Error Message "System.Exception: DI:10000104 - In "Posting Date" field, enter posting date that is equal to or earlier than system date" Cause These errors occur when future posting is not ...
Getting error "DI: No matching record found" in integration failure monitor.
Problem Statement Record stuck in integration failure monitor having the error DI: No Matching Records Found”. Possible Cause with Resolution Some of the possible causes with resolution are listed below: Cause 1-Related item does not exist in SAP or ...
System.Runtime.InteropServices.COM Exception from HRESULT: 0xFFFFFC17 Stock transfer
Problem Statement Unable to integrate the Stock transfer from iVend to SAP B1. In the integrationMonitor it show error as “System.Runtime.InteropServices.COMException (0xFFFFFC17): Exception from HRESULT: 0xFFFFFC17” Proposed Solution/Workaround We ...
While updating record in SAP it don't integrate to iVend nor do they appear in Integration Monitor
Problem Statement While updating anything in SAP, the events do not integrate to iVend HO and also don't appear in the Integration Monitor. However, it's working fine from Enterprise to SAP. Product Version 6.5 Update 6 Proposed Solution There might ...
Integration Error System.Exception: DI:10000492- Tax account is missing
Product Version: 6.5 Update6 Problem Statement: - INC0012338 Transaction Consolidation record Stuck on Integration Failure Monitor with below error message from iVend to SAP. System.Exception: DI:10000492- Tax account is missing (‘VN’) Proposed ...
Integration Error -4) UoM Group Can not be Changed
Product version: iVend 6.6 with SAP B1 9.2 Problem statement :- While updating the price from SAPB1 Product Master Screen ,it displayed the error message (-4) UoM Group Can not be Changed Proposed solution: Altered the stored procedure ...
Needs to re-initializate an iVend HO from SAP
Problem Statement Needs to re-initializate an iVend HO from SAP Product Version 6.6 Proposed Solution Uninitialize the SAP B1 using sql statement and clear all the table data after that iVend can be re initialized. Steps to be Performed : 1. Take a ...
Integration not working from SAP to iVend
Version: iVend 6.5 Update 6 for this case (However not version specific). Issue: Integration events neither appeared in Integration monitor nor updating the corresponding records in iVend at HO. However, it is working fine from iVend Enterprise to ...
Integration Error Change tracking is not enabled on table
Problem Statement Integration was not working from iVend to SAP and Vice-Versa. It shows status Not processed. On Integration Event viewer we found below error “System.Exception: System.Data.SqlClient.SqlException (0x80131904): Change tracking is not ...
Getting error "Gift Certificate A/C is not mapped in SBO" in integration failure monitor.
Issue: Records are stuck in the integration failure monitor having error “Gift Certificate A/C is not mapped in SBO” as shown below: iVend Version: iVend Retail 6.6 Cause: This issue occurs when “Gift certificate Income A/c” is not mapped in the ...
Object (-5002): 10000047 – Date deviates from permissible range
Problem Statement: Getting an error "Object (-5002): 10000047 – Date deviates from the permissible range" in the iVend integration monitor. Cause This error generally occurs on A/R Invoice and A/P Invoice documents, and the most common reason for the ...
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired
Problem Statement Getting an error message "System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." in the iVend integration failure ...
System.Exception: DI:Under/Overpayment account is missing
Problem: Getting an error message “System.Exception: DI:Under/Overpayment account is missing” in the iVend integration monitor. Cause: The error “System.Exception: DI:Under/Overpayment account is missing” occurs when the G/L Account Determination for ...
iVend API not allowing to create Product Id with length greater than 20 characters
Problem Statement iVend API not allowing to create Product Id with length greater than 20 characters(Method -SaveProduct & SaveProductList) Details While calling iVend API method SaveProduct and SaveProductList, and passing ProductId with length ...
SAP Integration Error Reconciliation date must be on or after the last posting date for transaction
Environment: iVend 6.6 integrated With SAP B1 Problem Statement: AR Payment stuck on Integration Failure Monitor from iVend To SAP Business one with below Message “System.Exception DI Reconciliation date must be on or after the last posting date for ...
Integration event counts : In Process , Processed , Failure
Environment : iVend 6.6 7989 with SAP B1 9.2 Queries : There are below queries ,used to find the In process, Processed & Failure from iVend to SAPB1. A) Summary Select 'Processing Records' Status,COUNT(*) 'Events Count' from RepIntegrationLog(nolock) ...