News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... What table to join wit...

Finance | Project Operations, Human Resources, ...

Suggested answer

What table to join with the requisition table to add vendor name and ID to Smarlist

(0) Share

Report

Report

Posted on by CG-Fisk

I have been asked to add the vendor's name to the purchase requisition report generated in smartlist. I am having problem with finding a table with a common link that will work. The ones I use are generating double requistion numbers.

Categories:

Microsoft Dynamics GP

All responses Img

All responses (2)

Answers Img

Answers (0)

CG-Fisk on at

Like (0)

Report

RE: What table to join with the requisition table to add vendor name and ID to Smarlist

Thanks, I'll choose that one and see if the requisition number changes per transaction
Suggested answer

kmalone43 880 on at

Like (1)

Report

RE: What table to join with the requisition table to add vendor name and ID to Smarlist

Hi CG-Fisk,

Take a look @ table PM00200, the Vendor Master table which will always only show 1 record per vendor & prevent any potential duplication. Also, just a general FYI & in case you're not familiar w/ the site, I'd recommend checking out https://victoriayudin.com for all things GP SQL related. Very very useful content there!

Hope this helps!

Thanks,

Kyle

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,885 Super User 2024 Season 2

#2

Martin Dráb 230,569 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans