Any other ideas?
Thanks, Adam
----------
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@emerald.iea.com
> 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?