Integration Faliure Error "Warehouses Setup" window, on "Accounting" tab, choose sales type revenue
Environment :
iVend 6.6
Problem Statement :
We have identified the integration failure issue from iVend to SAP B1 and showing with below error :
System.Exception DI 10000115 In "Warehouses Setup" window, on "Accounting" tab,
choose sales type revenue account [INV1.AcctCode][line 1090] at ReplicationSBOIntegrationWinSer.IntegrationObjects.Base.ARInvoice.CreateARInvoice(DataRow[] objDataRow, DataRow[] objDataRowSurcharges, DataSet ObjDataSetTransactionAttribute, DataSet ObjDataSetTransactionLineAttribute, Decimal passedRoundingAmount, Decimal roundingAmount, Boolean isRolledBack) at ReplicationSBOIntegrationWinSer.IntegrationObjects.Transactions.Replicate(Direction From, Direction To, Int32 DatasetRowID)
at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean Retried)
Symptoms :
Configure Issue
Resolution/Work Around :
We have checked the Account Code in SAP B1 > Chart Of Accounts screen and found that the account type is not as ‘Sales’ instead it is showing with ‘Other’. The Account Code should be a sales type revenue account so we have updated the same and changed it with ‘Sales’. Later we re-tried the record, which got integrated successfully from iVend to SAP B1.
Recommendations /Suggestion :
N/A
Related Articles
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 "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 ...Failed record in SAP to iVend Integration Faliure Monitor for type product (source type 46)
************* Internal Article ************* Error: Failed record in SAP to iVend Integration Faliure Monitor for type product (source type 46) with below error message:SAP DBTech JDBC: [339]: invalid number: [6930] attribute value is not a ...Sales Order Stuck in integration failure log with error The warehouse is not setup as a Retail Store
Problem Statement Sales Order created in SAP Business One is stuck in integration failure log. Error System Exception: The warehouse is not setup as a Retail Store in iVend. Sales order created in SAP Business One “For Store” check box is checked, ...