Error message "The bank country/region assigned to the vendor's remit-to address is missing or inactive" when you generate an EFT file for Payables Management in Microsoft Dynamics GP

To resolve this problem, use one of the following methods.


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Method 1

This error message can occur if the checkbook ID that you use has not had a prenote generated. To resolve the problem, follow these steps:

1. On the Cards menu, point to
   Financial, and then click Checkbook.
   
2. In the Checkbook Maintenance window, select the checkbook ID by using the Lookup button in the Checkbook ID field.
3. In the Checkbook Maintenance window, click EFT Bank button.
4. In the Checkbook EFT Bank Maintenance window, click the Payables Options button.
5. In the Checkbook EFT Payables Options window, follow one of the following options:
   
   1. If the Payables Prenote Required check box is selected, go to step 6.
   2. If the Payables Prenote Required check box is not selected, go to Method 2.
6. In the Checkbook EFT Payables Options window, click
   Generate Prenotes.
7. In the Generate EFT Prenotes window, select the checkbook ID in the Checkbook ID field, select the Vendors Only option in the Prenotes For section, select the prenote format ID in the Prenote Format ID field, and then click Process.

Method 2

This error message can occur if you do not have a default remit to address ID populated in the Vendor Maintenance window. To resolve this problem, follow these steps:

1. On the Cards menu, point to
   Purchasing, and then click Vendor.
   
2. In the Vendor Maintenance window, select the vendor ID by using the Lookup button in the Vendor ID field.
3. In the Vendor Maintenance window, click the
   Lookup button in the Remit To field, and then select your remit to address ID that is set up as EFT.
4. Click Save.

Note Beginning in Microsoft Dynamics GP 9.0, a new field was added to the PM Transaction Open File table (PM20000). This field is the VADCDTRO (Vendor Address Code - Remit To) field. Every time that an Electronic Funds Transfer (EFT) invoice is entered into the system, the VADCDTRO field is populated to record the remit-to information for the invoice.

Method 3

This error message can occur if the VADCDTRO (Vendor Address Code – Remit To) field in the PM20000 table for your posted invoices does not match the address ID that you have mapped to EFT. Check the PM20000 (PM_Transaction_Open) table to make sure that the vendor addresses in the VADCDTRO column are the same addresses for the vendors in an earlier version of Microsoft Dynamics GP if you recently upgraded. The VADCDTRO column in the PM20000 table must match the VADCDTRO column in the PM00200 (PM_Vendor_Master) table for each vendor. To resolve this problem, follow these steps:

1. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

   Method 1: For SQL Server 2000

   If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

   Method 2: For SQL Server 2005

   If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

   Method 3: For SQL Server 2008

   If you are using SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
   
2. Run the following script against the company database to update the VADCDTRO field for the records in the PM20000 table.

   UPDATE PM20000 SET VADCDTRO = PM00200.VADCDTRO FROM PM20000 INNER JOIN PM00200 ON PM20000.VENDORID = PM00200.VENDORID

   Note This script will assign the value in the VADCDTRO field for all the posted invoices to be the same as the remit to address ID in the Vendor Maintenance window. This script assumes that the remit to address ID in the Vendor Maintenance window is the address ID that you have mapped to EFT.
   
   Note Or, you can use the following script to update the VADCDTRO field for a specific vendor in the PM20000 transaction table.

   UPDATE PM20000 SET VADCDTRO = 'XXX' WHERE VENDORID = 'YYY'

   Note XXX is a placeholder for the remit-to address code. YYY is a placeholder for the vendor ID.
3. Additionally, if there are records for this vendor in the PM20100 remittance table, make sure that the VADCDTRO column in the PM20100 (PM_Apply_To_OPEN_OPEN_temporary) remittance table matches the VADCDTRO column in the PM00200 table and the PM20000 (PM_Transaction_Open) table. Use the following script against the company database to update the VADCDTRO field for a specific vendor in the PM20100 remittance table.

   Update PM20100 set VADCDTRO='XXX' where VENDORID='YYY' 

   Note XXX is a placeholder for the remit-to address code. YYY is a placeholder for the vendor ID.
4. Test generating the EFT file again. When the VADCDTRO field matches between the PM00200, PM20000 and PM20100 tables for this vendor, you should not receive the error message.