Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 52F3E47711A for ; Tue, 28 Jan 2003 23:00:18 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id DDCE74770A9 for ; Tue, 28 Jan 2003 21:51:20 -0500 (EST) Received: from [216.135.165.74] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2) with HTTP id 2526641; Tue, 28 Jan 2003 18:50:54 -0800 From: "Josh Berkus" Subject: Re: LONG - Question on dealing w/ numerics To: ddurst@larubber.com, X-Mailer: CommuniGate Pro Web Mailer v.4.0.2 Date: Tue, 28 Jan 2003 18:50:54 -0800 Message-ID: In-Reply-To: <34281.216.86.192.34.1043801682.squirrel@www.la-rubber.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/454 X-Sequence-Number: 11319 David, > I have a function that is to create a Accounting JOURNAL entry. > The strange thing is the function works for simple entries such as: > Here is the function and I can't seem to figure out what is LOGICALLY > wrong and would produce these results. I'm not sure the problem is with the function. I think the problem is with your program logic, as the funciton just inserts a *single* journal line and updates the balance. How do you insert the 4 entries required by a full double-entry transfer as you described? Also, how about posting a schema? -Josh