Announcements
No record found.
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
Can be done using SLB (SmartlistBuilder) Do you know if client is licensed for it?
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.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Shravan Attelli 1
