{"id":36794,"date":"2026-01-30T10:03:19","date_gmt":"2026-01-30T10:03:19","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=36794"},"modified":"2026-01-30T10:06:45","modified_gmt":"2026-01-30T10:06:45","slug":"automated-ap-payment-invoice-txt-integration-in-sage","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2026\/01\/30\/automated-ap-payment-invoice-txt-integration-in-sage\/","title":{"rendered":"Automated AP Payment & Invoice TXT Integration in Sage"},"content":{"rendered":"\n

In Sage 300 ERP<\/a><\/u>, <\/strong>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.<\/p>\n\n\n\n

Building on this core workflow, the custom EXE extracts data directly from posted AP invoices and AP payments<\/strong>. The Exe provides user-defined filters such as Bank Code and Posting Date<\/strong>, 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.<\/p>\n\n\n\n

New Stuff: –<\/strong> Enhancement in TDS Audit Report for Sage300.<\/a><\/p>\n\n\n\n

Please refer below screenshot of the user interfaces for the \u201cAutomated AP Payment & Invoice TXT Integration in Sage<\/strong>\u201d.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 1 : Bank Integration exe<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

Once the above parameters are selected, clicking Print<\/strong> will generate the TXT file. The following success message will be displayed.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 2 : Success message<\/center><\/font>\n\n\n\n


Output:<\/strong><\/u><\/em><\/p>\n\n\n\n

DFT@IN@78678-09091@INR@6852.850@@20260102@@@@@@@@@@@@@Chloride Systems@@@@Current@1233435355@@@@@@NEFT@HDFC0000339@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@customer_service@chlorideus.com@@@@@@@@@@@@@CITI14@3@CITIBA@@@@@@@@@@@@@@@@@@@@<\/em><\/p>\n\n\n\n

INV@ <\/em>.
INV@ .<\/em>
INV@ .<\/em>
INV@ .<\/em>
INV@Invoice Number Inv Date Inv Amt TDS% TDS Ded Net Pay .<\/em>
INV@INV\/94 20260102 4462.07 00.000 0.000 4462.070.<\/em>
\u00a0
Optional Fields:<\/strong><\/u><\/em><\/p>\n\n\n\n

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.<\/p>\n\n\n\n