[Tom Repetti]

I need to write a report that gives me the vendor information and GL distributions for certain checks.  I am having difficulty in finding the tables/fields that link these 3 sources together. 

And if it matters, I will need to run this report for transactions spanning 3 years, so there might be more tables storing the data.

Thanks

——————————
Tom Repetti
Comport
Ramsey NJ
——————————

[Kelly Hobart]

A good place to start is by visiting the screen with the bulk of the information you are looking for and then using table finder to determine the sql tables included.

——————————
Kelly Hobart
Business Data Analyst
Mount Pleasant Waterworks
Mount Pleasant SC
——————————
——————————————-

[Victoria Yudin]

Hi Tom,

I have SQL code on my blog to help with this. Here is the main page for Payables code:
Payables SQL Views

From what you wrote, I think you’re looking for Payment Apply Detail and GL distributions, but I wanted you to see the entire list.

——————————
Victoria Yudin
Microsoft Dynamics GP MVP 2005-2017
Flexible Solutions, Inc.
http://www.GPReportsViewer.com
http://victoriayudin.com
——————————
——————————————-

[Tom Repetti]

Thanks all and thanks Victoria.  The script worked for what I needed.

——————————
Tom Repetti
Comport
Ramsey NJ
——————————
——————————————-

[Leslie Vail]

Victoria is a Rock Star!

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-