Re: [Emerald] Payments.InvoiceID

Dale E. Reed Jr. ( (no email) )
Sun, 13 Jun 1999 20:28:04 -0500

Josh Hillman wrote:
> Is there a way to replace all of the Payments.InvoiceID NULLs (from previous
> payments made with Emerald 2.1) with the correct InvoiceID associated with
> the payments as referenced in InvoiceItems?

Thats not what its designed for. The Payments.InvoiceID should show
the Invoice that the payment is shown to the customer as received.
For example, you might have Invoice 2, which is paid by payment 5.
Then next round the customer gets Invoice 12. Emerald checks for
Payments with a NULL InvoiceID and puts the new invoiceID (12) on
that. The Sub Report InvoiceP shows those payments.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.