Linking a Check from PM30300 to PM30200 1

[adhlssu07]

Hello,

I am working on using SQL in GP10 to pull the following information for all of the invoices on a particular check:

Invoice Number (docnumbr?)
Outstanding Amount (?)
Net Paid Amount (APFRMAPLYAMT?)
Discount Taken (APFRMDISCTAKEN)
Net Check Amount (?)

I also need information off of the check header. I have found most of this data on the "Apply To History" table (PM30300), but I have a feeling that I will need to join on the invoice header record from PM30200 (and possibly PM20000 as well). I'm trying to figure out where the join points are and which columns are best to look at for each of these pieces of data.

Thanks in advance for any help you can provide.

 

[VictoriaYudin]

Take a look at this view:

http://victoriayudin.com/2008/10/22/sql-view-ap-apply-in-gp/.

I think it has most of the information you need and you can just add on to it as needed.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[adhlssu07]

Victoria,

Thanks so much! Your blog has been hugely useful, and I looked at this post and didn't think it did what I wanted... I'm taking a closer look.

 

[VictoriaYudin]

Let me know if you need help adding the fields you need to it.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com