PRINT EFT EDIT REPORT

Use this screen to print a report that contains any ACH file created using the Create EFT File screen. The report includes the vendor's ID, name, bank, and bank account; the total credit amount to the vendor's bank account; the vendor’s voucher number, invoice number, invoice date, invoice amount, discount taken, and amount paid; the vendor's ACH code; a debit record, if one exists; and a total of all credits to all vendors. Information for both live and prenote EFT vendors also prints in this report.

Print this report after creating an ACH file in the Create EFT File screen but before transmitting the file to your bank. If you need to make changes to vendor bank information, do so in the Maintain Vendors screen and then recreate the file. The system automatically overwrites the old file with the new file, providing you use the same file name and path. Posted vouchers are not updated with changes to the vendor ID; if you change the vendor ID in the Maintain Vendors screen, the system will not be able to find vouchers for the new vendor ID when recreating the ACH file, and the vendor will not be paid the correct amount. Do not change the vendor ID before paying posted vouchers.

Note:  When the 820 Transaction Set option in the EDI group box on the Create EFT File screen is selected, the file submitted to the bank will have a different layout than the file created when one of the ACH group box options are selected. The main reason for that is the different structures in which the bank will accept submission of the file. When this scenario takes place, the following fields will not be displayed in the EFT Edit Report:  Pay Vendor, TR CD and Debit Amount.

EFT File Name

Select

Select this pushbutton to choose the filename of the ACH file for which you want to print the report, or enter a file name and path, if necessary. When you select this pushbutton, a standard Windows dialogue box appears, in which you can examine all the files currently existing in your directory structure.

Sort By

Use the options in this group box to specify how the report will be organized.

Pay Vendor Name

Select this radio button to sort the report by vendor name.

Pay Vendor

Select this radio button to sort the report by pay vendor.

Pay Vendor Bank ID

Select this radio button to sort the report by pay vendor bank ID.        

Report Options

Show Addenda Records

Select this checkbox to include addenda records on the Edit Report. This field defaults to unchecked.