55
How to retrieve all vendors list from table dbo.Vendor including the three/four letter company id ( dbo.Company.CpnyId ) ?
Basically i cannot find any joining coloumn to get all vendors for a given company id.
*This post is locked for comments
Another idea is to join vendors.vendid with APHist.vendid and filter for current year and APHist.ytdpurch>0.
The result is a record for each company each vendor was paid from.
Vendors are not company specific. Depending on what you need the info for - you could link to APDoc on vendid and see which cpnyid has apdoc records for the vendor or possibly if your users are company specific you could look at the crtd_user for the vendors.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (