Re: [Emerald] Adding other tables to receipt.rpt

Daniel Wood ( dgwood@iwvisp.com )
Mon, 22 Nov 1999 10:21:26 -0800

>> When I add another table, like invoices, to the receipt.rpt it
>> seems to work from Crystal Report but when I use it in Emerald
>> all the fields are blank.
>
>Support forwards (what I will assume to be your receipt report)
>and the catch is that you can NOT link Payments.InvoiceID to
>Invoices.InvoiceID. The reason is that Payments.InvoiceID is
>NOT filled until the next invoice for the customer. So if you
>make a payment and try to immediately print a receipt, it would
>be blank, because there is not match. What you want to link on
>would be the InvoiceItems.PaymentID and then invoices to
>invoiceitems. However, thats not a guranteed link, either.

Yes I found that out. I linked MasterAccount.CustomerID to
Payments.CustomerID then Payments.PaymentID to InvoiceItem.
PaymentID. Then I linked Invoiceitems.InvoiceID to Invoice.
InvoiceID. This seems to work ok.

Thank You
Dan
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>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