Export Accounts Payable Payments to a Text File

In Accounts Payable Payment Processing, you can create a text (.txt) file that contains accounts payable payment information to be processed by a third-party software application.

You choose the format of the text file in Configuration > Accounting > Banks.

You must complete this procedure for each bank code for which you want to create a .txt file. For automatic type payment processing, you choose the bank code on the General tab of the Accounts Payable Payment Processing form when you begin payment processing.

Prerequisites: Complete the tasks in the Accounts Payable Processing Checklist, preview payments on your screen, and assign payment numbers.

To export accounts payable payment data to a .txt file, complete the following steps:

1. On the Payment Printing and Numbering form in AP Payment Processing, click Export to Text on the grid toolbar. If the Export to Text option does not display on the toolbar, click the small, white down-arrow at the right end of the toolbar.
2. On the Download Payments To Text File dialog box, click Create File.
3. On the File Download dialog box, complete one of the following actions:
   • Click Open to view the contents of the .txt file in Microsoft NotePad. Close the file and, on the Download Payments to Text File dialog box, click Create File and then click Save.
   • Click Save to save the file without viewing it first.
4. In the Save in field of the Save as dialog box, enter or navigate to the location in which to save the .txt file. The File name field displays a name (for example, BT_AP_200604_150_Boston.txt) that includes the following components, which you can modify: the Company code (if you use the Multicompany feature), the payment type, the period, the run number, and the bank code.
5. Click Save. Vision saves and closes the .txt file.
6. Close the Download Payments To Text File dialog box.
7. On the toolbar of the Payment Printing and Numbering form, click Print File Copy to print a file copy of the payments.
8. On the toolbar of the Payment Printing and Numbering form, click Post to post the AP payment processing run.