use emerald
select ma.customerid, ma.firstname, ma.lastname, inv.invoiceid,
inv.type, inv.amount
from masteraccounts as ma, invoices as inv
where ma.customerid = inv.customerid
and inv.type <> "Void"
and inv.sentdate between "6/1/00" and "7/1/00"
and not exists (select pa.paymentid from payments as pa
where pa.invoiceid = inv.invoiceid)
go
It's a little rough, but works.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Kelly Wright
Sent: Wednesday, July 05, 2000 6:35 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] Invoices
I was referring to manual invoices created. I know how the service
invoices work. The invoices I create are for one time charges for the
customer. Example - April IPASS Roaming $89.25.
Kelly Wright wrote:
>
> Is there a way for Emerald to show Unpaid invoices? We need to create a
> bunch of invoices for our IPASS service and want to make sure invoices get
> paid.
On the invoices tab select "show unpaid only" (and additionally "show
last only" if you only want to see one per person).
However, the Aging report might be more useful to you to see who owes
you money and from time frame. You can get it from:
ftp://ftp.iea-software.com/Emerald/reports/aging.zip
--Dale E. Reed Jr. Emerald and RadiusNT/X__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart