Remittance Advice Report in Bank Approval Integration Addon

By | March 28, 2024

In our previous blogs, we discussed about “Manual and Auto Payment Process”. The system offers two options for processing payments: manual and automatic through a scheduler. In the manual process, users input transactions manually, selecting those posted Payment Entry that require approval by the bank. Our Bank Approval Integration Addon ensures that these entries are automatically reconciled in the Bank module as well.

In our Addon, to obtain detailed information of the Invoice entry when entering a transaction in the Payment Entry screen we have developed this report which is a part of our Addon module. This report will acquire the details of both the payment entry and invoice entry which are reconciled in Sage 300 ERP.

New Stuff: – PO Number in AR Aged Trial Balance report

This report will obtain both the Header and Detail data from the AP payment and Invoice entry. The report data will be generated once the payment entry from the bank is approved through the manual payment process screen. Subsequently, the report will also be sent to the specific vendor associated with that payment via email.

The crystal report generated output of the “Remittance Advice Report” report is shown below: –

Remittance Advice Report

This report contains the fields from the AP Invoice and Payment Entry Screen and can be tailored to suit your requirements.

  • Company Address.
  • Supplier Address.
  • Payment Date.
  • Payment Method.
  • Invoice Number.
  • Invoice Date.
  • Currency.
  • Invoice Amount.
  • Paid Amount.

The user can easily access the required data from the AP Invoice and Payment Entry Screen in this manner, which fulfills the objective of this report.

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 customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM,, 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 integrations 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, We will like to hear from you.