On 07/23/11 09:38, Rich Shepard wrote:
On Fri, 22 Jul 2011, Jeff Kaminsky wrote:
I have had a few cases where the beginning balance was not correct.
This is true here, too. I think that I know how to fix the problem and
bring everything current, if that beginning balance is a stored value and
not calculated on the fly each time the reconciliation page is prepped
for
display.
If someone familiar with L123 internals can point me to the table and
column holding that beginning balance, I can change it to the bank's
ending
balance for this month. That should make next month's reconciliation
begin
with the proper beginning balance and fix the problem for me.
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
L123 is not just the DB but also SL's/L123's perl scripting that
interacts with the DB. Going in now and changing the beginning balance
at the DB level ignores future interactions by the perl scripting and is
just more of your "finagling". Why don't you create a proper correction
transaction for the last day of the prior period such that your
beginning balance for the current period matches the bank's records and
be done with it? Use a GL entry or investigate perhaps using Cash -> FX
Adjustment. Armaghan's changes to SL's reconciliation module are, in my
experience to date, solid. I seriously doubt L123 is at fault here.
Regards,
r
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
