We have EFT vendors in payables module and the bank information is on the address tab under EFT Bank. What Dynamics purchasing file can you query on to get this data on a smartlist for all vendors?
*This post is locked for comments
We have EFT vendors in payables module and the bank information is on the address tab under EFT Bank. What Dynamics purchasing file can you query on to get this data on a smartlist for all vendors?
*This post is locked for comments
This information can be found in the Address Electronic Funds Transfer Master Table SY06000, to best of my knowledge there are no out of bix smartlists linking to this table but if you have (SLB) -Smartlist Builder a smartlist query can be easily created or without it can access thru SQL to query table
Michael Bloom
GP Consultant
mbnet61@hotmail.com
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156