Notifications
Announcements
No record found.
hello team,
is there is a way where i can get a list of the supplier who get paid by cheque and does not have banking info setup in the system ?
Thank you
*This post is locked for comments
Couldn't you do this with a smart list?
Hi Ebram-
You should be able to do this with SmartList Designer or SmartList Builder. It would be a left outer join between the PM Vendor Master table (PM00200) and the Address Electronic Funds Transfer Master table (SY06000).
I have a SQL view if you'd like too.
Hope this helps.
Thanks.
-Joe
Click on the reports tab on this site and you will all the useful sql views create by Victoria Yudin. Perhaps you can start by modifying some of them.
victoriayudin.com/.../
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
