Received: from bering.webline.dk (83.adsl0.kh.worldonline.dk [213.237.10.83]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBLJGS634159 for ; Thu, 21 Dec 2000 14:16:28 -0500 (EST) (envelope-from kar@webline.dk) Received: from localhost (localhost [[UNIX: localhost]]) by bering.webline.dk (8.10.2/8.10.2/SuSE Linux 8.10.0-0.3) id eBLJHIw26224 for pgsql-sql@postgresql.org; Thu, 21 Dec 2000 20:17:18 +0100 From: Kaare Rasmussen Date: Thu, 21 Dec 2000 20:17:18 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="us-ascii" To: PostgreSQL-SQL References: <200012211750.eBLHohP12000@linda.lfix.co.uk> <20001221130833.C5263@thune.mrc-home.org> In-Reply-To: <20001221130833.C5263@thune.mrc-home.org> Subject: Re: Invoice number MIME-Version: 1.0 Message-Id: <00122120171802.26171@bering> Content-Transfer-Encoding: 8bit X-Archive-Number: 200012/256 X-Sequence-Number: 593 > What do you do on the following scenario: I don't enter ! > Client 1 is placing an order, gets invoice #1. Wrong! He gets an order number > Client 1 changes mind and cancels order. Invoice #1 is not used. Invoice > #2 is. > Client 3 comes along. Do they use invoice #1, out of order, or invoice #3? If Invoice 1 is cancelled for some reason, it is still an invoice. The right thing is to produce a credit note to balance off the cancelled invoice. For smaller quantities, I believe it is OK just to file the cancelled invoice with a clear note that it's been cancelled. But I have a feeling my accountant doesn't agree :-) -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Email: kar@webline.dk 2000 Frederiksberg Lørdag 11.00-17.00 Web: www.suse.dk