Re: Reports

Dale E. Reed Jr. ( (no email) )
Tue, 23 Dec 1997 11:20:55 -0800

Richard Sensale wrote:
>
> Do you now what table and field stores the flag for if an invoice has been
> paid or not?

There isn't such a field. In 2.2 and lower, whether an invoice is paid or
not is determined by whether it has any invoice items that haven't been
paid. This is determined by looking at the InvoiceItems table, PaymentID
field and seeing if its null.

Off the top of my head its like:

Select InvoiceID