Skip to Content
0
Former Member
Jul 29, 2009 at 11:23 PM

Invoices with multiple payments

114 Views

Hi Experts-

I would like to create a query that returns all A/R invoices with more than one incoming payment applied.

I started with:

select t0.docentry from rct2 t0 group by t0.docentry having count(t0.docentry) > 1

But I don't think that is quite correct.

Thanks!

Lang