Automated AP Payment & Invoice TXT Integration in Sage

By | January 30, 2026
0 Comment

In Sage 300 ERP, custom AP Payment EXE that integrates seamlessly with the standard AP Payment Entry and AP Invoice Entry processes. AP nvoice Entry screen is used to record supplier invoices, capturing details such as vendor, invoice number, amount, tax, and distribution. Once invoices are posted, payments are processed through the AP Payment Entry screen, where users select invoices for payment, assign a
bank code, and post the payment transaction. These standard AP transactions form the foundation of the customization.

Building on this core workflow, the custom EXE extracts data directly from posted AP invoices and AP payments. The Exe provides user-defined filters such as Bank Code and Posting Date, ensuring that only the relevant transactions are selected for export. This allows users to generate output files specific to a particular bank and accounting period, which is essential for real-world banking and reconciliation processes.

New Stuff: – Enhancement in TDS Audit Report for Sage300.

Please refer below screenshot of the user interfaces for the “Automated AP Payment & Invoice TXT Integration in Sage”.

Figure 1 : Bank Integration exe

Once the above parameters are selected, clicking Print will generate the TXT file. The following success message will be displayed.

Figure 2 : Success message


Output:

DFT@IN@78678-09091@INR@6852.850@@20260102@@@@@@@@@@@@@Chloride Systems@@@@Current@1233435355@@@@@@NEFT@HDFC0000339@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@customer_service@chlorideus.com@@@@@@@@@@@@@CITI14@3@CITIBA@@@@@@@@@@@@@@@@@@@@

INV@ .
INV@ .
INV@ .
INV@ .
INV@Invoice Number Inv Date Inv Amt TDS% TDS Ded Net Pay .
INV@INV/94 20260102 4462.07 00.000 0.000 4462.070.
 
Optional Fields:

Also we have added the optional field which can useful for mapping the data which is taken from the payment entry and required for the company specific, the following optional fields are added into the AP Vendor master screen and Common service optional field.

  • (Beneficiary Bank Routing Method) BBRM -A/P Vendor optional field
  • (Account Type) ACCTYPE – A/P Vendor optional field
  • (Beneficiary Acc No) BENACCNO -A/P Vendor optional field
  • IFSC -A/P Vendor optional field
  • (Payment Code) PYCODE -Common service Optional Field

This Exe includes following fields and can be modified according to the requirement.

  1. Bank code
  2. payment code
  3. Debit country
  4. Debit account number
  5. Currency
  6. Payment amount
  7. Posting date
  8. Beneficiary name
  9. Beneficiary account number
  10. Beneficiary account type
  11. Bank routing code
  12. Bank routing method
  13. Account name
  14. Country code
  15. Invoice date
  16. Invoice number
  17. Posting date
  18. Invoice amount 

In this way, the report provides a clear picture of Payment activity, enabling better decision-making and effective monitoring of business growth. We can also customize this report output with required additional fields. 

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, 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 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 GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill 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. 

Related Posts