Introduction to Bank Approval Integration Addon in Sage300 ERP

By | February 23, 2024

A Bank reconciliation statement consolidates a company’s banking and business accounts, aligning its bank account with its financial records. This statement comprises a detailed record of all deposits, withdrawals, and other financial transactions conducted with the bank within a specific timeframe.

New Stuff: IC Transaction Statistics

Sage 300 ERP is a vital software system that offers a range of addon modules including 3-way PO matching, Audit documents, Document Numbering, and more. We have recently developed an Addon that provides features to reconcile the Bank statements directly through the bank. Our addon has been specifically designed to integrate with ADCB Bank’s reconciliation process within Sage 300 ERP. Users will have the capability to reconcile payment transactions both manually and automatically, streamlining the reconciliation process effectively. In summary, the working process involves exporting posted AP Payments from Sage 300 ERP in the bank’s designated file format (CSV/Excel/XML). These files are then uploaded to the bank’s SFTP server, where they are processed by the bank’s systems for approval or rejection of the transactions. This Addon will consist of following Screens:

Bank Approval setup
ADCB Bank Approval Module

A. Setup

  • Options
  • Upgrade

B. Transaction Processing

  • Manual Payment Process

C. Status Enquiry

  • Transaction Enquiry

The system offers two options for processing payments: manual and automatic through a scheduler. In the manual process, users input transactions manually, selecting those that require approval by the bank. Conversely, in the automatic process, all posted payments are handled by the scheduler to obtain approvals from the bank. Our addon ensures that these entries are automatically reconciled in the Bank module as well.

We plan to publish additional blogs detailing the functionalities, configurations, and operations of this addon module. These resources aim to provide users with a deeper understanding of the process, facilitating quicker operations and automating the reconciliation process within Sage 300 ERP.

About Us:-

Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customization, data migration, system integration’s, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and MagentoeCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integration’s using Data and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.