Richard, These steps are for 10.0, but should work with GP 2010 as well.
How to create one total auto settlement line for the Electronic Funds Transfer (EFT) file in Microsoft Dynamics GP Payables Management
PRODUCT: Microsoft Dynamics GP
VERSION: 10.0
DATE: 11/03/09
ABSTRACT
Explains how to create one total auto-settlement line for the entire EFT file instead of an auto settlement line for each vendor.
INTRODUCTION
This article explains how to create one total auto-settlement line for the EFT file instead of an auto settlement line for each vendor.
MORE INFORMATION
There is an option in EFT to have an auto settlement line for each vendor in the EFT file. However, in some cases banks require one total auto settlement line for all vendors on the EFT file. If this is required, the following steps can be used to set this up in EFT:
1. Click Cards, point to Financial, and then select EFT File Format. Select the desired EFT Format ID or create a new ID in the EFT File Format Maintenance window. (Click Cards, point to Financial, select EFT File Format)
2. If setting up a new EFT Format ID, you will also need to enter a Description, select the Format Type as well as the Format Class for the bank.
3. Mark the Generate Auto-Settlement for Each Detail checkbox – (This will populate the Settlement line from the Line Type Drop down)
4. Unmark the Generate Auto-Settlement for Each Detail checkbox – (This will tell the system that you only want one Auto-Settlement line for the file)
5. Select the Line Type: Settlement
6. Select the Payment Amount Field
7. Change the Maps To value for the line to Calculation
8. Click the Hide/Show button to expand the line
9. Select Total Debit Amount from the Calculation Type dropdown
10. Mark the Checkbox to Remove Decimal Places
11. Enter the Number of Decimal Places – this will be the number of decimal places that you are using.
12. Click Save.
13. Next, click Transactions, point to Purchasing, and then select Generate EFT Files and generate an EFT file. Once the file is generated, you will see one line for a total of all vendors that were included in that EFT file.
