Settlement line calculates incorrectly in the Electronic Funds Transfer file for Payables Management
This article provides a resolution for the issue that the Settlement line in the Electronic Funds Transfer (EFT) file only shows the amount of the last invoice.
Applies to: Microsoft Dynamics GP
Original KB number: 2026313
The Settlement line in the EFT file only shows the amount of the last invoice, instead of calculating the correct total amount of the whole file. This is when you have only one settlement line in the EFT file that should display the sum of the whole file.
The calculation method for the payment amount field in the settlement line needs to be changed from a Data Field to a Calculation.
Modify the calculation method in the Settlement line by following these steps:
On the Cards menu, point to Financial and select EFT File Format.
Enter the EFT Format ID that needs to be modified.
First, select the Import/Export button, and save a copy of the existing format to a location of your choice in case you would need to refer back the original setup for any reason.
In the EFT File Format Maintenance window, select the Line Type of Settlement.
For the payment line, select Calculation in the Maps To column.
Then select the Show Details button to expand the line.
Set the Calculation Type to Total Debit Amount.
If necessary, select the checkbox for Remove Decimal Places.
Enter 2 for the Decimal Places.
Test the file to make sure the total is correct. (The Settlement line typically starts with 627 in the EFT file.)
When the file is correct, select Import/Export again and overwrite the old copy of the file with the new file. It is recommended to keep a copy of the correct file in case you would need to import it back in again for any reason.
This section explains how to populate the Settlement line with the default settings, and have only one Settlement line for the whole file:
- In the EFT file format, mark the Generate Auto-Settlement for Each Detail checkbox to populate the Settlement line with the default settings.
- Save the EFT file format.
- Then reopen the EFT file format and unmark the Generate Auto-Settlement for Each Detail, and select Save when prompted Settlement details exist for this format. Do you want to save or delete the details? Then select OK on the next message. This will retain the mapping for the Settlement line and result in one settlement line for the whole file, that would include a sum total for the whole file. Then follow the steps in the Resolution section to change the Settlement line from a Data Field to a Calculation so it totals correctly.