cancel
Showing results for 
Search instead for 
Did you mean: 

How to external bank reconcile using SAP B1 DI API.

Hi,

How to external bank reconcile using DI API Object. I have checked out both object ExternalReconciliationsService and BankStatementsService but there is no solution found.

Please help me.

Thank you in advance.

Finally I found the solution below for manual bank reconciliation.

 SAPbobsCOM.BankPages bnkPage = oCompany.GetBusinessObject(BoObjectTypes.oBankPages);
 bnkPage.AccountCode = item.AcctCode;
 bnkPage.DebitAmount = \\Total Paid Amount (Outgoing JE Doc Total);
 bnkPage.DueDate = DateTime.Now
 bnkPage.DocNumberType = BoBpsDocTypes.bpdt_DocNum;
 bnkPage.PaymentReference = "UTR DATE";
 bnkPage.Reference = "AUTO PAYMENT";
 bnkPage.Add()
 string str = oCompany.GetNewObjectKey();
 int sequence = Convert.ToInt32(str.Split('\t')[1]);
 SAPbobsCOM.ExternalReconciliationsService oReconciliationService = (SAPbobsCOM.ExternalReconciliationsService)oCompany.GetCompanyService().GetBusinessService(SAPbobsCOM.ServiceTypes.ExternalReconciliationsService);

SAPbobsCOM.ExternalReconciliation ExtReconciliation = (SAPbobsCOM.ExternalReconciliation)oReconciliationService.GetDataInterface(SAPbobsCOM.ExternalReconciliationsServiceDataInterfaces.ersExternalReconciliation);

ExtReconciliation.ReconciliationAccountType = SAPbobsCOM.ReconciliationAccountTypeEnum.rat_GLAccount;

SAPbobsCOM.ReconciliationBankStatementLine bstLine = (SAPbobsCOM.ReconciliationBankStatementLine)ExtReconciliation.ReconciliationBankStatementLines.Add();
bstLine.BankStatementAccountCode = item.AcctCode;
bstLine.Sequence = sequence;

 
 // Loop while All Outgoing JE Entry addded in jeLine
 SAPbobsCOM.ReconciliationJournalEntryLine jeLine = (SAPbobsCOM.ReconciliationJournalEntryLine)ExtReconciliation.ReconciliationJournalEntryLines.Add();
                            jeLine.TransactionNumber = \\JE TransID;
                            jeLine.LineNumber = 0;

 oReconciliationService.Reconcile(ExtReconciliation);

Accepted Solutions (0)

Answers (1)

Answers (1)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi srujalpatel,

Refer to the SAP Note 2586911 which mentions the support about Internal Reconciliation in DI API.

Kindly note that only Manual Reconciliation is supported, for both Business Partners and Financials (Journal Entries).

Kind regards,

ANKIT CHAUHAN

SAP Business One Support