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

Applies to: Dynamics GP 2010

Symptoms


When you generate an Electronic Funds Transfer (EFT) file for Payables Management in Microsoft Dynamics GP after you upgrade from an earlier version, you receive the following error message:
The bank country/region assigned to the vendor's remit-to address is missing or inactive. Assign the bank country/region to the address or activate the format.

Cause


This error message can occur for the following reasons:
  • The checkbook ID that you use does not have a prenote generated. See Method 1 to resolve.
  • The vendor does not have a default remit-to address ID populated in the Vendor Maintenance window. This remit-to address ID is referred to as the VADCDTRO field. See Method 2 to resolve.
  • The VADCDTRO (Vendor Address Code – Remit To) field does not match the VADCDTRO that is used for this vendor in the PM00200 (PM _Vendor_Master) or PM20100 (PM_Apply_to_OPEN_OPEN_temporary tables. See Method 3 to resolve.

Resolution


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.

References


For more information about the EFT setup for Payables Management, see "Chapter 2: EFT setup for Payables Management" in the Microsoft Dynamics GP Electronic Banking manual. To do this, visit the following Microsoft Web site: For more information and troubleshooting tips to generate the EFT file for Payables Management in Microsoft Dynamics GP 10.0, click the following article number to view the article in the Microsoft Knowledge Base:
945955 Guidelines to follow when you generate EFT files or EFT prenote files in Electronic Funds Transfer for Payables Management in Microsoft Dynamics GP 10.0