| From: | Craig Bennett <craig(at)amajuba(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Gregory Stark <stark(at)enterprisedb(dot)com>, justin <justin(at)emproshunts(dot)com>, hitz(at)jamhitz(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Chart of Accounts |
| Date: | 2008-10-14 00:02:04 |
| Message-ID: | 48F3E17C.3080700@amajuba.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> If you want to take a particular system out to extra digits, it's
> probably good to record the rounding error as a separate component of
> the transaction (that is, if you want everything to balance out
> perfectly).
>
>
I think you have two different problems here. On the one hand you have
rounding errors which are material when aggregated on the other hand
most sales transactions (for example) will come to a dollar and cents
figure. If you have two accounts with different precision then I think
from an accounting perspective you need to say something like this when
posting between the two:
DR My 2 Decimal Precision Account 2.00
DR Accumulated Rounding (4 Decimal) 0.0010
CR Original 4 Decimal Account 2.0010
Then at period end you can including your rounding account and
everything will balance.
Craig
| From | Date | Subject | |
|---|---|---|---|
| Next Message | justin | 2008-10-14 00:26:20 | Re: Chart of Accounts |
| Previous Message | Greg Smith | 2008-10-13 21:21:27 | Re: [GENERAL] Drupal and PostgreSQL - performance issues? |