Manual and Auto Payment Process

By | February 27, 2024

Recently, we have created an Addon Bank Approval Integration that allows users to reconcile their bank statements directly through the bank. Our Addon is tailored to seamlessly integrate with ADCB Bank’s reconciliation process in Sage 300 ERP, giving users the ability to reconcile payment transactions manually or automatically, making the reconciliation process more efficient.

New Stuff: E-Invoice Filing From OE/AR transaction Screen

In Sage 300 ERP, When you enter a transaction in the Payment Entry screen, there is no automatic process to create the reconciliation of that payment. Users are required to manually reconcile the payment entry. As a result, we have created a procedure in which users are able to automatically reconcile the payment entry.

In Bank Approval Integration, we have provided two Transaction Processing approaches for the Payment’s reconciliation Process:

1. Manual Payment Process
2. Auto payment Process

1. Manual Payment Process:

Manual Payment Process is a Transaction screen in this Addon which allows the user to process payments which are Posted. Miscellaneous Payments, Prepayments, and Apply Document types will not be included or available for processing. To display the data in the Grid, users are required to choose the criteria shown in the screenshot that includes below filters.

  • From and To Payment Date
  • From and To Vendor Code
  • From and To Payment Number
Figure 1: Manual Payment Process Screen

Once the criteria are selected, users need to click on the GO (>>) button. After that, users have the option to mark the payments that need to be processed or choose to select all payments by clicking on the “Select All” button.

Once the user clicks the Process button, the Text files will be uploaded to the Bank’s SFTP server and will be further processed by the Bank for the data authenticity. If the data is processed successfully on the Bank server, it will then be marked as Success in Status Inquiry screen of Bank Approval Integration Addon in Sage 300 ERP. If an error occurs, it will be indicated as “Process is completed, please check the error log”. The user can also review the Error Logs and other files located in the application path.

Transaction Status Inquiry Screen:

The payment status and other details will be available on the Transaction Inquiry screen which will help in identifying the status of the Payments processed through the Manual/Automatic Payment Process screen.

Figure 2:Transaction status Inquiry screen

Furthermore, the payment number that corresponds will be automatically reconciled in the Bank Reconcile statement screen of the Standard Bank module (Refer below screenshot) and report of Remittance Advice will be generated and sent via email to the vendor linked to the payment entry.

Figure 3:Reconcile Statements Screen

Auto payment Process:

To automate the above Payment process, a scheduler will be deployed and configured in the task manager as necessary. This will enable the automatic processing of Posted Payment Entries that are created in the AP payment screen. The subsequent process will be the same as manual payment processing. All posted payments will be processed according to the time interval set in the Task scheduler.

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.