Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A393547683C
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 23:02:47 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id 51E244778E6
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 21:54:40 -0500 (EST)
Received: from [216.135.165.74] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2)
	with HTTP id 2526955; Tue, 28 Jan 2003 18:54:11 -0800
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: LONG - Question on dealing w/ numerics
To: ddurst@larubber.com, <pgsql-sql@postgresql.org>
X-Mailer: CommuniGate Pro Web Mailer v.4.0.2
Date: Tue, 28 Jan 2003 18:54:11 -0800
Message-ID: <web-2526955@davinci.ethosmedia.com>
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/455
X-Sequence-Number: 11320

David,
 
> Cash - Debit  100
> A/R  - Credit 100
> Cash - Credit 100
> A/R  - Debit  100
> (Which should have a net affect of 0 on both accounts)
> 
> But here is the resulting balance on accounts,
> 
> Cash Debit  Balance 200
> A/R  Credit Balance 200

Here may your problem, and it's in the schema:  is "A/R" and account or
is "A/R Credit" an account?   You're being unclear in your e-mail,
which makes me suspect that you're being vague in your code as well.

If I'm totally off the mark, then please post the four calls to your
function that produced the above mis-balance, and I can easily spot the
problem for you.

-Josh