web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

kmalone43 894 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CG-Fisk on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 509 Super User 2026 Season 1

#2

Giorgio Bonacorsi 375

#3

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans