biuan SAP® BUSINESS ONE SDK
SQL Banking / Reconciliation History
API External Reconciliations Service

Description

The ExternalReconciliationsService service enables you to add, look up, and cancel external reconciliations.

Source table: OMTH.

Object Model

ExternalReconciliationsService
GetReconciliation (ExternalReconciliation)
ReconciliationJournalEntryLinesReconciliationJournalEntryLine
ReconciliationBankStatementLinesReconciliationBankStatementLine
GetReconciliationList (ExternalReconciliationsParamsCollection)ExternalReconciliationParams

Remarks

To perform external reconciliations, choose Banking --> Bank Statements and External Reconciliations --> Reconciliation. In the External Reconciliation ? Selection Criteria window, select either the Manual or Automatic radio button, specify the selection criteria, and choose the Reconcile button.

Example

C#
//Get business service. SAPbobsCOM.CompanyService oCompanyService = Cmpy.GetCompanyService(); SAPbobsCOM.ExternalReconciliationsService ExtReconSvc = (SAPbobsCOM.ExternalReconciliationsService)oCompanyService.GetBusinessService (SAPbobsCOM.ServiceTypes.ExternalReconciliationsService); SAPbobsCOM.ExternalReconciliation ExtReconciliation = (SAPbobsCOM.ExternalReconciliation)ExtReconSvc.GetDataInterface(SAPbobsCOM.ExternalReconciliationsServiceDataInterfaces.ersExternalReconciliations); ExtReconciliation.ReconciliationAccountType = SAPbobsCOM.ReconciliationAccountTypeEnum.rat_BusinessPartner; // default is GL Account //Reconcile object. SAPbobsCOM. ReconciliationJournalEntryLine jeLine1 = (SAPbobsCOM. ReconciliationJournalEntryLine)ExtReconciliation.ReconciliationJournalEntryLines.Add(); jeLine1.TransactionNumber = "1"; jeLine1.LineNumber = 1; SAPbobsCOM.ReconciliationJournalEntryLine jeLine2 = (SAPbobsCOM. ReconciliationJournalEntryLine)ExtReconciliation.ReconciliationJournalEntryLines.Add(); jeLine2.TransactionNumber = "2"; jeLine2.LineNumber = 2; SAPbobsCOM.ReconciliationBankStatementLine bstLine1 = (SAPbobsCOM. ReconciliationBankStatementLine)ExtReconciliation. ReconciliationBankStatementLines.Add(); bstLine1.BankStatementAccountCode = "C1"; bstLine1.Sequence = 1; SAPbobsCOM. ReconciliationBankStatementLine bstLine2 = (SAPbobsCOM. ReconciliationBankStatementLine)ExtReconciliation. ReconciliationBankStatementLines.Add(); bstLine2.BankStatementAccountCode = " C1"; bstLine2.Sequence = 2; ExtReconSvc.Reconcile(ExtReconciliation); //Get object. SAPbobsCOM.ExternalReconciliationParams ExtReconParam = (SAPbobsCOM.ExternalReconciliationParams)ExtReconSvc.GetDataInterface(SAPbobsCOM.ExternalReconciliationsServiceDataInterfaces.ersExternalReconciliationParams); ExtReconParam.AccountCode = "100012"; ExtReconParam.ReconciliationNo = "2"; ExtReconciliation = ExtReconSvc.GetReconciliation(ExtReconParam); //Get Reconcile List. SAPbobsCOM.ExternalReconciliationsParamsCollection ExtReconsParamsCollection = (SAPbobsCOM. ExternalReconciliationsParamsCollection)ExtReconSvc.GetDataInterface(SAPbobsCOM.ExternalReconciliationsServiceDataInterfaces.ersExternalReconciliationsParamsCollection); SAPbobsCOM.ExternalReconciliationFilterParams ExtReconFilteredParams = (SAPbobsCOM.ExternalReconciliationFilterParams)ExtReconSvc.GetDataInterface(SAPbobsCOM.ExternalReconciliationsServiceDataInterfaces.ersExternalReconciliationFilterParams); ExtReconFilteredParams.ReconciliationAccountType = SAPbobsCOM.ReconciliationAccountTypeEnum.rat_GLAccount;//"G/L Account" ExtReconFilteredParams.AccountCodeFrom = "11200000-01-001-01"; ExtReconFilteredParams.AccountCodeTo = "12400000-01-001-01"; ExtReconFilteredParams.ReconciliationDateFrom = "05/03/11"; ExtReconFilteredParams.ReconciliationDateTo = "06/03/11"; ExtReconFilteredParams.ReconciliationNoFrom = 1; ExtReconFilteredParams.ReconciliationNoTo = 2; ExtReconsParamsCollection = ExtReconSvc.GetReconciliationList(ExtReconFilteredParams); //Cancel reconciliations. foreach (SAPbobsCOM.ExternalReconciliationParams ExtReconParam in ExtReconsParamsCollection) { ExtReconSvc.CancelReconciliation(ExtReconParam); }

See Also

SAP® B1 DI-API C# definition

public class ExternalReconciliationsServiceClass : IExternalReconciliationsService, ExternalReconciliationsService { public extern ExternalReconciliationsServiceClass(); public virtual extern void CancelReconciliation( ExternalReconciliationParams pIExternalReconciliationParams); public virtual extern object GetDataInterface( ExternalReconciliationsServiceDataInterfaces enumMSDI); public virtual extern object GetDataInterfaceFromXMLFile( string bstrFileName); public virtual extern object GetDataInterfaceFromXMLString( string bstrXMLString); public virtual extern ExternalReconciliation GetReconciliation( ExternalReconciliationParams pIExternalReconciliationParams); public virtual extern ExternalReconciliationsParamsCollection GetReconciliationList( ExternalReconciliationFilterParams pIExternalReconciliationFilterParams); public virtual extern void Reconcile( ExternalReconciliation pIExternalReconciliation); }

Related information


External Reconciliations Service Data Interfaces ExternalReconciliationsServiceDataInterfaces Enumeration
ExternalReconciliationsService data interfaces.
   Parent: External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH

External Reconciliation ExternalReconciliation Object· Table: OMTH
Represents external reconciliation, which is the comparison of open transactions within SAP Business One with an external account statement. Source table: OMTH.
   Parent: External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH

External Reconciliation Filter Params ExternalReconciliationFilterParams Object
Specifies the selection criteria for viewing, canceling, or re-creating previous external reconciliations created for business partners or G/L accounts.
   Parent: External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH

External Reconciliations Params Collection ExternalReconciliationsParamsCollection Collection
A collection of ExternalReconciliationParams objects.
   Parent: External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH


SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates