2,280
I have a client that would like a report that lists all vendors with active EFT information. What is the best way to get this information? Can this be donw with a Smartlist?
*This post is locked for comments
Use the Sy06000 table which is the Address Electronic Funds Transfer Master table and the PM Vendor Master (PM00200) table to come up with the list. If you don't have smartlist builder use the excel connection to your databases and then use vlookup to your vendor ID.
But if you do build a smartlist, using SmartList Builder, you should make sure that you restrict access to the report because you are now exposing everyone's routing and bank account number.
Can be done using SLB (SmartlistBuilder) Do you know if client is licensed for it?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (