PRINT EFT PRE-TRANSFER EDIT REPORT
Use this screen to print a list of the records Costpoint will include when it creates the electronic funds transfer (EFT) file. This list includes:
-
Summarized voucher information
-
A transfer subtotal for each pay vendor/address combination
-
The total for the entire amount of the transfer to the bank/bank account
You can limit this report's data by bank account abbreviation. The report includes information only for active vendor/address code combinations that receive live electronic payments and includes only selected vouchers in its totals. This means that the vendor must have the EFT Active check box selected on the Addresses subtask of the Manage Vendors screen, there must be a bank account listed, and the ACH code must be None.
Vendors to whom you are making the first electronic payment are included in this report, but the transfer amount is zero. ACH rules require that the first transfer to a vendor be made as a prenote, or test, which includes no currency or a nominal currency amount. After the first successful transfer, you can change the vendor/address combination's ACH code to live status on the EFT Info subtask of the Manage Vendors screen. Subsequent payments to the vendor will be made electronically.
If you print the Print EFT Pre-Transfer Edit Report and there is nothing on it even though you have approved vouchers on Pay status, you should verify that you are printing the report for the correct bank abbreviation. To do so, look at the Cash Account Description field on the Edit Voucher Payment Status screen. Once you know the cash account description, go to the Manage Cash Accounts screen, find the cash account description and the bank abbreviation linked to it. Verify that this is the same bank abbreviation that you are selecting when trying to print the EFT Pre-Transfer Edit Report.
This report uses dynamic worktables. Because these tables are user-specific and are deleted after the process is over and data has been transferred to a permanent table, each user can only run one EFT Pre-Transfer Edit Report using the same user name at one time. Multiple users, however, can run the report simultaneously, as long as they log in under different user names.
See Electronic Funds Transfer (EFT) for related information.
Run and review this report before creating the EFT file. Retain the report as an audit trail.
Screen Contents
This screen has the following elements:
-
Use the Identification block to enter a parameter ID and description.
-
Use the Selection Ranges block to select bank account abbreviations to include in the report.
-
Use the Sort By block to sort the transfers within each bank account abbreviation.
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.
Selection Ranges
Bank Abbreviation
Use this group box to select bank account abbreviations to include in the report. Only pay vendor/address combinations assigned to these bank account abbreviations print on the report. The range of bank account abbreviations you select can also modify which pay vendor/address combinations are included in the report.
Option
Use this drop-down list to select the range of bank abbreviations to be included. Valid options are:
-
All — Select this option to include all available bank abbreviations. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one bank abbreviation and then enter that bank abbreviation in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of bank abbreviations. Enter the beginning bank abbreviation for the range in the Start field and enter the ending bank abbreviation of the range in the End field.
-
From Beginning — Select this option to include a range of bank abbreviations that begins with the first of all the available bank abbreviations and ends with the bank abbreviation that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of bank abbreviations that begins with the specific bank abbreviation that you enter in the Start field and ends with the last of all the available bank abbreviations. The End field is disabled for this option.
Start
Enter, or click 
to select, the starting bank abbreviation for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.
End
Enter, or click to select, the ending bank abbreviation for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.
Sort By
2nd Sort
Use this option to sort the transfers within each bank account abbreviation. Subtotals are calculated based on a vendor/address combination.
-
Pay Vendor — Select this setting to view transfers by vendor ID for each bank and bank account. This is the default.
-
Pay Vendor Name — Select this setting to sort the report by pay vendor name within each bank and bank account.