Finance | Project Operations, Human Resources, ...

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

(0) Share

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 (2)

Answers (0)

Suggested answer

kmalone43 894 on at

Like (1)

Report

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

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

Was this reply helpful? Yes No