Tables

(0) Share

Report

Posted on by JFo

I have been asked to query our Dynamics GP database for some information. I am starting with the table PM30200 and filtering on a specific vendorID. The client also wants account numbers and the line item detail. I do not know what table to join to my query to return this information. Please help. Please do not suggest using the GP client as this is not an option. I must do the querying in Microsoft SQL Management Studio (long story).

*This post is locked for comments

All responses (6)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Tables

Most welcome,

Please never hesitate to share any further inquiries.
JFo 95 on at

Like (0)

Report

RE: Tables

Thank you for your excellent and timely suggestions. I was able to get the information I needed.
Suggested answer

sandipdjadhav 18,265 on at

Like (0)

Report

RE: Tables

This may help you. It has GL level transactions details - victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions

Thanks

Sandip
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Tables

I recommend checking the "Payable SQL Views" on Ms. Victoria Yudin website. Check several reports on the following link;

Payable SQL View

Your feedback is highly appreciated.

Hope this helps,
JFo 95 on at

Like (0)

Report

RE: Tables

I am trying to get a list of transactions for a specific vendor. The list should include the date, amount, account code charged and any comments on the transactions.
sandipdjadhav 18,265 on at

Like (0)

Report

RE: Tables

Explain problem briefly, What you trying to achieve.

Thanks

Sandip