Use this screen to print a list of the records the system 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, and a grand total for the entire amount of the transfer to the bank/bank account. It can be limited 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 checkbox selected, there must be a bank account listed, and the ACH code must be "None."
|
|
Note: Vendors to whom you are making the first electronic payment will be included in this report, but the transfer amount will be 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 in the Vendor User Flow screen (Accounting\Maintain\Vendors). Subsequent payments to the vendor will be made electronically. |
The EFT Pre-Transfer Edit Report consists of three blocks that can be used as follows:
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
Run and review this report before creating the EFT file. Retain the report as an audit trail.
|
|
Note: This report uses dynamic worktables. Because these tables are user-specific and will be 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 are logged in under different user names. |
Verify that you are printing the report for the correct bank abbreviation.
To verify this, look at the Cash Account Description field in the Edit Voucher Payment Status screen (Accounting\Process\Pay).
Once you know the cash account description, go to the Cash Accounts screen (Accounting\Maintain\Accounts), 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.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously-saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen.
When you save your record, all the selections you made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously-defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use this block to select bank account abbreviations to include in the report. Only active EFT pay vendor/address combinations assigned to these bank account abbreviations will 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.
Bank Abbreviation *
Enter the range, or select a range from the drop-down box.
Range options include "All," "One," "Range," "From Beginning," and "To End."
Because the EFT file can be created for only one bank account abbreviation at a time, the default Range Option is "One."
Enter, or use Lookup to select, the beginning bank account abbreviation you want to include.
If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter or use Lookup to select the ending bank account abbreviation you want to include.
If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
Use this drop-down box to sort the transfers within each bank account abbreviation by Pay Vendor ID or by Pay Vendor Name.
For both options, subtotals are calculated based on a vendor/address combination.
2nd Sort *
This sort option is the system default.
Make this selection to view transfers by vendor ID for each bank and bank account.
Make this selection to sort the report by pay vendor name within each bank and bank account.
This screen accesses the OPEN_AP (Open AP) table.
* A red asterisk denotes a required field.
