Hi, the invoice number is not used as a database key, you can even enter the number like you want it....(even multipke entries...).
But you are right, the numbers should be running numbers and therefore only if posted assigned... . I think it might be easier to rather use the ID field on table INVOICE with an own sequence just for the invoices for that purpose and then rename the existing "invoice number" to "our reference" or something else.... Regards Rainer > -----Original Message----- > From: Steven D'Aprano [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 2:42 AM > To: [EMAIL PROTECTED] > Subject: Re: [SL] Automatic incrementing of unposted PO's and Invoices > > > 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]/ ------------------------------------------------------- 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]/
