Paid Invoices? 1

[Borvik]

OK - here's a quick question.

I'm looking for all invoices (in a certain date range) that have been paid. I'm uncertain as to what would be the best way to determine if an invoice is paid.

I was thinking to do one of the following:

1) Take the Invoice DOCAMNT - PYMTRCVD > 0 (not paid)

OR

2) Search for Invoice number in the RM10101, RM20101, RM30101 tables (DOCNUMBR field). -Add up and compare to DOCAMNT.

OR - Suggest something.

Of the two - if either will work of course - it looks like 1) would be the best choice.

I guess the question is - what is the best way to determine if an invoice has been paid.

 

[TheKnee]

In smart list, sales transaction
you could chose docamount and paiment receive (something like this.

you could precise your query how you whant after that

TheKnee

 

[Borvik]

Ah - but this I am not running the query in Great Plains.

I'm writing my own program to generate a csv file. I need to use SQL.

 

[klewis10367]

Use the Apply to Table..PM30300 and use the APTODCNM and APTODCTYP (=1 for Invoice)

 

[Borvik]

Thanks klewis!

 

[klewis10367]

I didn't look closely enough, the tables I gave you where for Pm not Rm ...use RM20201 or RM30201 if you have moved transaction to history.