On Mon, Jul 15, 2002 at 04:19:31PM -0600, Dieter Simader wrote: > Numbers increase as soon as you bring up the invoice or order form. > > If you change your mind and don't want to finish an invoice put a NPN item > without a price on it and post it. Next time you write an invoice, bring > up this blank invoice and edit it. > > This keeps your numbers in sequence.
Unless you are a multi-user environment, or if you forget to bring up the blank invoice. Internal invoice ID numbers (which increase as soon as you call up the invoice form) should be seperate from the human-readable invoice number, which should always been sequential. If there are unused internal IDs, no-one cares. But accountants and office managers get very cranky when there are missing invoice numbers. And not just because they are anally-retentive. If invoice 456712 is missing, is it because you've lost the paperwork? Because somebody has raised an invoice, then deleted it from the system? Because someone has hacked the database? Is it an accident or fraud? Or just because the computer hasn't used that specific number? The point is, there is a reason why invoices are traditionally numbered sequentially, and it has very little to do with using the invoice number as a database key. -- Steven D'Aprano Cybersource Pty Ltd, ACN 053 904 082 Level 9, 140 Queen St, Melbourne VIC 3000 Tel: +61 3 9642 5997 Fax: +61 3 96425998 Web: http://www.cyber.com.au ------------------------------------------------------- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim _______________________________________________________ (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
