Re: LONG - Question on dealing w/ numerics

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: ddurst(at)larubber(dot)com, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: LONG - Question on dealing w/ numerics
Date: 2003-01-29 02:54:11
Message-ID: web-2526955@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rodger Donaldson 2003-01-29 03:13:36 Re: CSV import
Previous Message Josh Berkus 2003-01-29 02:50:54 Re: LONG - Question on dealing w/ numerics