This sounds more like an error in a much earlier reconciliation, rather
than a fault in the program. Am I wrong? Otherwise I would see in my own
reconciliations which have hundreds of transactions to click off, and
millions of dollars each month would never balance to the penny most of
the time.
Jeff
On 7/22/2011 11:24 AM, Rich Shepard wrote:
On Fri, 22 Jul 2011, Chris Travers wrote:
First, there are other cases where fractional cents may be tracked
(for example sales tax liabilities) but they shouldn't affect bank
deposits or withdrawals.
Chris,
Then the decimal part of the numeric value can be expanded to 3 or 4
digits. I remember when postgres dropped the MONETARY alias to the
NUMERIC
data type, but I used the latter anyway.
What I'd recommend doing first is just transforming the field to an
unbounded numeric type I.e. without parentheses. This represents the
money in PostgreSQL's arbitrary precision math form (internally a string
of 10-bit units, each representing an integer from one to 1000. Why
1000? Because it's more efficient to lose 24 bits per 1024 to
overhead than 6
per 16).
You can do this by (pg 8.1 and above):
ALTER TABLE acc_trans ALTER COLUMN amount TYPE numeric;
That may not fix your problem though.
No, but it's worth doing ... done.
The first question what does SQL-Ledger think your balance should be?
Where? In the trial balance it's correct. When reconciling it's not
correct.
Are there transactions of exactly that amount which were erroneously
committed in the past?
Nope. I have, at most, a couple of dozen checks and debit card
transactions each month. It's easy to match those with the monthly
statement
and reconcile manually before doing so in L123. The manual
reconciliations
always balance. That's why I'm frustrated that the digital version is
off.
If you have old bank statements, you can run successive queries to
try to
determine where and when this problem started.
Long ago.
As I wrote above, manual reconciliation is always correct. The
amounts of
deposit and withdrawal transactions in L123 are correct. But, the
beginning
balance in L123's reconciliation is not and that sets the ending
balance off
so the process continues incorrectly each month. Since the manual
reconciliation is correct, and that amount is shown as the balance in the
checking account the problem is not fatal, but a time consuming PITA each
month.
Thanks,
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
--
Jeff Kaminsky
Sr. Accountant / Logistics
IX Systems
408-943-4100 ext 122
408-943-4101
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
