web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Suggested answer
    kmalone43 Profile Picture
    894 on at

    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

  • CG-Fisk Profile Picture
    on at

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

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans