Select Checks - not finding a vendor for EFT payment

(0) Share

Report

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)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No