You’re offline. This is a read only version of the page.
Announcements
When I try to Print Checks, it generates an error that there is an Error in the batch. No errors are listed in Computer Checks Edit List.
When I go to Edit Check Batch and try to select one of the transactions, I get the following error:
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.
Looking in the Vendor Cards, both vendors in batch are active. both have Country Code USA and Remit To address PRIMARY.
Click Address (Vendor Address Maintenance), Address ID PRIMARY has Country Code USA.
Click EFT Bank (Vendor EFT Bank Maintenance), Bank Country/Region is United Stats and Currency ID US $
Back on Vendor Maintenance, click Options (Vendor Maintenance Options), Currency ID is US $
Click on Checkbook ID (Checkbook Maintenance), Curency ID is US $
Click on EFT Bank (Checkbook EFT Bank Maintenance), Bank Country/Region is United States and Country code is USA.
For some batches in the Print Payables Checks window, the menu options are Print and Clear. These do not generate errors. Batches that are generating batch error and bank Country/Region errors have Process and Clear options when they are opened in Print Payables Checks.
*This post is locked for comments
Hi,
I had a heck of a time trying to get the above link to actually display the KB article. Just in case anyone else also has this problem, I'm posting its contents below. Sometimes these old links go bad and we lose an answer.
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
Article ID: 944441 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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.
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: a.If the Payables Prenote Required check box is selected, go to step 6.
b.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.
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:
mbs.microsoft.com/.../ElectronicBanking.pdf
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
Took me a while to find this the first time it happened (and I'm still not sure why). It took me about three hours the second time...
http://wazirabad4.rssing.com/browser.php?indx=3945929&item=394
Basically I think it might be a timing thing - possibly if the invoice is entered & posted, then the vendor is switched from check to ACH, then paid, I think the PM20000 table gets "confused". But the SQL script to update the VADCDTRO works like a charm.
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
