[Emerald] Invoicing Problem

Greg Hastings ( (no email) )
Thu, 21 Oct 1999 09:40:58 -0700

This morning I discovered one customer whose account expired without Emerald
ever generating a renewal invoice. I can find nothing unusual about the
setup on this account. But for some reason Auto Batch/Create does not
generate an invoice. I can manually generate an invoice using the menu
selection Master/Invoice Next Term.

All of the expire dates, billed through dates, etc are correct. All settings
that I can see are the same as most other accounts.

When I started looking at the data in the Invoices and Payments tables, I
discovered 2 surprising things.

1) The Invoices table records do not appear to contain any information which
relates to payments made on that invoice or unpaid balance due on that
2) Although the Payments table records have an InvoiceID field, none of the
records in that table have anything recorded in the InvoiceID field. How are
payments tied to invoices?

So, how in the world is Emerald determining which invoices are paid, and
which are not?

And does anyone have any suggestions as to what might be causing a
MasterRecord to not get an invoice generated automatically.

Greg Hastings

For more information about this list (including removal) go to: