PRINT EFT EDIT REPORT
Use this screen to print a report that contains any ACH file created via the Create EFT File screen.
The report includes the following information:
-
Vendor's ID, name, bank, and bank account
-
Total credit amount to the vendor's bank account
-
Vendor’s voucher number, invoice number, invoice date, invoice amount, discount taken, and amount paid
-
Vendor's ACH code
-
Debit record, if one exists
-
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 on 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 via the Manage Vendors screen and then recreate the file. Costpoint 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 on the Manage Vendors screen, Costpoint 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.
When you select the 820 Transaction Set option in the EDI group box on the Create EFT File screen, the file submitted to the bank will have a different layout than the file created when one of the ACH group box options is selected. The main reason for this is the different structures in which the bank will accept submission of the file. When this scenario takes place, the following fields do not display on the EFT Edit Report: Pay Vendor, TR CD, and Debit Amount.
See Electronic Funds Transfer (EFT) for related information.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Options
EFT File Name
Alt File Location
Enter, or click 
to select, an alternate file location. The alternate file location is defined on the Manage Alternate File Locations screen, where a URL Folder is attached. This is where the created file will be stored.
Select File Name
Enter, or click to select, the filename of the ACH file for which you want to print the report. This is the filename from the Create EFT File screen.
Report Options
Show Addenda Records
Select this check box to include addenda records on the report. The addenda records are the details for the invoices you are paying; they include invoice numbers, invoice dates, invoice amounts, and the discount taken.
-
If you select this check box, some voucher details from the individual vouchers that make up the payment included in the EFT file display, although there will not be as much detail as that which displays on a check stub or payment advice.
-
If you do not select this check box, then the EFT file contains only the payment information for the total payment, and does not include any individual voucher details.
The addenda record information comes from the Open Accounts Payable (OPEN_AP) table, from the vouchers selected to be paid on the EFT. Some banks permit addenda records and can handle them, while some banks do not accept them.
Sort By
1st Sort
From the drop-down list, select a setting by which to sort the data on the report:
-
Pay Vendor Name — Select this setting to sort by pay vendor name.
-
Pay Vendor ID — Select this setting to sort by pay vendor ID.
-
Pay Vendor Bank — Select this setting to sort by pay vendor bank ID.