Settlement Line calculates incorrectly in the Electronic Funds Transfer (EFT) file for Payables Management in Microsoft Dynamics GP

Modify the calculation method in the Settlement line by following these steps:

1.  On the Cards menu, point to Financial and click onEFT File Format.

2.  Enter the EFT Format ID that needs to be modified.

3.  First, click on 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.

4.  In the EFT File Format Maintenance window, select the Line Type of Settlement.

5.  For the payment line, select Calculation in the Maps To column.

6. Then click the Show Details button to expand the line.

7.  Set the Calculation Type to Total Debit Amount.

8.  If required, click the checkbox for Remove Decimal Places.

9.   Enter 2 for the Decimal Places.

10.  Click Save.

11.  Test the file to make sure the total is correct.  (The Settlement line typically starts with '627' in the EFT file.)

      NOTE:  When the file is correct, click 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.