Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sherrod Croom]

Is there a way to list my vendors that have been set up to receive EFT payment?

——————————
Sherrod Croom
Lykes Bros. Inc
Tampa FL
——————————

[Bert Green]

Sherrod,

The EFT information is in table SY06000 in the company database.

As far as I know there is nothing out of the box that would get you this information, but you could build a SmartList and tie it together with table PM00200 by the Vendor ID. You could get more than one listing if an EFT is setup on more than one address id.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Leah Nolan]

Start with something like below.  Then you can add fields from SY06000 once you see which vendors are set up.
**********************************************************
SELECT V.VENDORID AS VendorID,
V.VENDNAME AS Vendor,
V.VADCDTRO AS RemitTo,
CASE E.INACTIVE
WHEN NULL THEN ‘N’
WHEN 0 THEN ‘Y’
ELSE ‘N’
END AS EFT
FROM PM00200 V
LEFT JOIN SY06000 E
ON V.VENDORID = E.VENDORID
**********************************************************

——————————
Leah Nolan
IT Business Systems Analyst
Fallbrook Technologies, Inc
Cedar Park TX
——————————
——————————————-