Re: Crystal Reporting of ALL Invoices

Webjogger ( (no email) )
Mon, 23 Mar 1998 11:13:00 -0500

Thanks, Dale, for the suggestion. I tried it, but the invoices I'm missing
still don't appear.

Any other ideas?

Thanks, Adam

> From: Dale E. Reed Jr. <>
> To:
> Subject: Re: Crystal Reporting of ALL Invoices
> Date: Sunday, March 22, 1998 10:20 PM
> Payments should be linked via PaymentID to InvoiceItems, not CustomerID
> to MasterAccounts.
> Dale
Webjogger wrote:
> I just made a Crystal Report (5.0) which is supposed to list every single
> invoice ever generated by Emerald.
> (I'm doing this to have a hard copy record of where my revenue is coming
> from, even if I delete an MBR and all of its associated invoice records).
> The report works well, except some invoices don't appear. These invoices
> appear when I look them up in Emerald, so I know the data is in the
> database somewhere. Some of these invoices are VOIDs, some are open
> (unpaid) renewals, some are open invoices.
> The databases and links included in the report are:
> InvoiceItems Invoices MasterAccounts Payments
> ------------------ ----------- -----------------------
> InvoiceID--------->InvoiceID
> CustomerID----->CustomerID----------------->CustomerID
> There are no selection guidelines which govern the report.
> Does anyone know why some invoices might not be included in the report?