External Bank Recon DI API Error "No matching records found (ODBC -2028) [الرسالة 131-183]"

[saintneo007]

Hi,
Any suggestion regarding this, I'm having this error "No matching records found (ODBC -2028) [الرسالة 131-183]". Thanks.

This is the code below.

BSLine1 = oExReconciliation.ReconciliationBankStatementLines.Add()
BSLine1.BankStatementAccountCode = "111020100"
BSLine1.Sequence = 66

JELine1 = oExReconciliation.ReconciliationJournalEntryLines.Add()
JELine1.TransactionNumber = 35
JELine1.LineNumber = 0

oExReconService.Reconcile(oExReconciliation)

[guruprasath424 · Accepted solution]

You need to add the Account Type

oExReconciliation.ReconciliationAccountType = ReconciliationAccountTypeEnum.rat_GLAccount;

[saintneo007 · Accepted solution]

Hi,

Thank you so much. Can I ask another question, is this the correct field for filtering unreconciled entry JDT1.ExtrMatch or there is another proper checking with OJDT or any other table. Thank you.