Charges c
InvoiceItems ii
Invoices i
Payments p
MasterAccounts ma
ma.customerid = i.customerid
i.invoiceid = ii.invoiceid
ii.paymentid = p.paymentid
ii.itemid = c.itemid
The next Renewal invoice created for an MBR with a previously created
Charge, will have that charge linked to it (assuming it wasn't already
linked with an older invoice).
Josh
>-----Original Message-----
>From: Dale E. Reed Jr. [mailto:daler@iea-software.com]
>Sent: Wednesday, May 19, 1999 9:24 AM
>To: emerald@iea-software.com
>Subject: Re: [Emerald] Dumb Question
>
>
>John Roman wrote:
>>
>> How can I get Emerald to print out a current list of all customers
>and
>> their monthly charge with out it having to be when the bill is due.
>> I need to match up some records and would like to be able to print out
>> all customers and the charges associated with them
>
>Do you want a list of their current due, or what their monthly charges
>are? Do you want the charges in summary or detail form?
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>