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 transactions selected for reconciliation [??????? 3821 3] at ReplicationSBOIntegrationWinSer.IntegrationObjects.IncomingPayment.CreateIncomingPayment(DataSet objDataSetTransaction, DataSet objDataSetTransactionSurcharge, DataSet objDataSetPayment, DataSet objDataSetARPayment, Boolean ZeroPayment, Boolean ApplyLayawayOnSale, Boolean IsMultiCurrency, String CurrencyCode)
Symptoms:
NA
Resolution/Work Around:
Advise customer/Partner to add payment in SAP screen. SAP will also throw the same error.
Customer/Partner can get details of all transaction from Integration Failure Monitor by expand transaction.
The error is not related to iVend, this is related to SAP Business One.
Below is the SAP forum link
https://answers.sap.com/questions/9531213/reconciliation-date-must-be-on-or-after-the-last-p.html
It should be noted that the iVend integration service uses SAPB1 DI API to post such transactions so issues related to this should be consulted with SAP Partner.
Recommendations /Suggestion:
NA
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 ...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 ...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 ...