How to regenerate the Electronic Funds Transfer file for Payables Management in Microsoft Dynamics GP

Information about the EFT file name

Microsoft Dynamics GP creates the EFT file name based on the following information: 

• The file name in the Payables Domestic Payments field and in the Payables Foreign Payments field in the Checkbook EFT Payables Options window. To the open Checkbook EFT Payables Options window, point to Financial on the Card menu, click Checkbook, click EFT Bank, and then click Payables Options.
• The Checkbook ID.
• The user date.
• The index number for the next EFT file to be generated.

The EFT file name uses the following format: Consider the following scenario. The file name in the Payables Domestic Payments field in the Checkbook EFT Payables Options window is PMT-Domestic. The checkbook ID is CHKBOOK, the user date is 04/15/2007, and the index number is 2. In this scenario, the EFT file name is as follows:

How to void and then reenter each payment to repopulate the CM20203 table and the CM20202 table

Use one of the following methods to void each payment. After you void each payment, run the Select Checks procedure again to generate the EFT file.

Method 1

Use this method only if the payment is fully applied and if the payment is in the history tables. To void the payment, follow these steps:

1. On the Transactions menu, click Purchasing, and then click Void Historical Transactions.
2. In the Void Historical Payables Transactions window, click to select the Void check box for the payment that you want to void.
3. Click Void.
4. When you are prompted to print the posting journals, select the destination, and then click OK.
5. Close the Void Historical Payables Transactions window.

Method 2

Use this method if the following conditions are true:

• The payment is partially applied.
• The payment has the Open status.
  
• The debit documents that the payment is applied to are in the history tables.

To void the payment, follow these steps:

1. Create an additional invoice for the amount that remains to be paid. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Transaction Entry.
   2. 
      In the Payables Transaction Entry window, enter an invoice for the vendor who has the payment that you want to void. Next, enter a value in the Purchases field for the amount that remains to be paid. Leave the Batch ID field blank.
   3. Click Post.
   4. 
      Close the Payables Transaction Entry window, select a destination when you are prompted to print the posting journals, and then click OK.
2. Apply the additional invoice to the payment. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Apply Payables Documents.
   2. In the Vendor ID field, click the vendor who has the additional invoice that you want to apply.
   3. 
      In the Document No. field, click the payment.
   4. 
      Next to the additional invoice that you created, click to select the Apply check box.
   5. Click OK.
3. Void the payment. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Void Historical Transactions.
   2. In the Void Historical Payables Transactions window, click to select the Void check box for the payment that you want to void.
   3. Click Void.
      
   4. When you are prompted to print the posting journals, select the destination, and then click OK.
   5. Close the Void Historical Payables Transactions window.
4. Void the additional invoice that you created in step 1. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Void Open Transactions.
   2. In the Vendor ID field, click the vendor who has the invoice that you want to void.
   3. 
      Click to select the Void check box for the invoice that you want to void.
      
   4. Click Void.
      
   5. When you are prompted to print the posting journals, select the destination, and then click OK.
      
   6. Close the Void Open Payables Transactions window.

Method 3

Use this method if one of the following conditions is true:

• The payment and all the invoices that the payment is applied to have the Open status.
• The payment has the Open status, and the payment has not been applied to any invoices.

To void the payment, follow these steps:

1. Unapply the payment. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Apply Payables Documents.
   2. In the Vendor ID field, click the vendor whose payment you want to unapply.
   3. In the Document No. field, enter the document number of the payment.
   4. Select each invoice to which the payment was applied, and then click Unapply.
      
2. Void the open invoice. To do this, follow these steps:
   1. On the Transactions menu, point to Purchasing, and then click Void Open Transactions.
   2. In the Vendor ID field, click the vendor whose payment you want to void.
   3. 
      Click to select the Void check box for the invoice that you want to void.
      
   4. Click Void.
   5. When you are prompted to print the posting journals, select the destination, and then click OK.
   6. Close the Void Open Payables Transactions window.