Invoice numbers

The key field in the Invoice table is the system-assigned reference number. The system-assigned reference number is different from the invoice number. The system-assigned reference number links transactions to the invoice. For example: Trans.Invoice_Reference_Number = Invoice.Reference_Number

The invoice number, which also is a major key, is assigned only when you run an invoice print procedure (for simple order entry or event registration) or if the operator enters a manual invoice number for a sales transaction.

In many cases, an invoice number may never be assigned, for example, a paid-in-full item, or meeting registrations where the confirmation letters are used in place of official invoice notices.