web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Select Checks - not fi...
Microsoft Dynamics GP (Archived)

Select Checks - not finding a vendor for EFT payment

(0) ShareShare
ReportReport
Posted on by Community Member

We have a vendor that I can't get the Select Checks window to select any invoices to pay when the checkbook is an EFT checkbook.  The Select Check window works for other EFT vendors.

I can run the Select Checks window with the Payment Method of "Check" and pointing to a Checkbook that is a "Check" and the Select Checks finds the invoices to pay for that vendor.  But if I have the Payment Method be "EFT" and use an EFT Checkbook, then the Select Checks window doesn't find the invoices to pay.

Select Checks finds EFT payments for other vendors.  I've compared the SY06000 and PM00200 tables between the vendor that works and the one that doesn't.  I'm not finding any differences.  I've looked at this KB article.  https://support.microsoft.com/en-us/kb/945955

Does anyone have any suggestions on what to try?  Thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Select Checks - not finding a vendor for EFT payment

    I finally figured this out.  The article I referenced included this:

    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 the earlier version. The VADCDTRO column in the PM20000 table must match the VADCDTRO column in the PM00200 (PM_Vendor_Master) table for each vendor.

    The vendor giving me problems had 2 rows on PM20000.  The rows had different values in VADCDTRO.  I updated them to match the remit to address, and it fixed the problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans