Hi Jesey
'I deleted some AP invoices which had stock items and replaced them with
new invoices with the same numbers but for “service”'
i belive u can't correct this problem with "magic wand" because ID-s on
database are different from invoice numbers and others numbers shown in SL.
If you are able to understand sql-ledger DB structure is possible
manually write (correct) these ID-s but of my experience is this kind of
work very painful.
The best way now (again of my mind) is take over only chart (+gifi),
customers, vendors and goods. Maybe u can work then.
br, Janno
p.s.
- Wait a little when later timezone guys wakes up -
- Armaghdan, Luke and Rich -
28.02.2011 11:53, "Jesey" kirjutas:
Hello Janno…
Good advice, I tried. The problem is that I deleted some AP invoices which had
stock items and replaced them with new invoices with the same numbers but for
“service”. So I could bring down stock values. It seems to me that some of
those deleted ones are lurking in the twilight zone. The Balance sheet picks
them up as real and the Bank Table does not see them. Whatever I do now
something will be out of balance. My set of accounts started to go sick about 6
months ago and my admin ladies did not complain so…. Lots of work if I want to
restore the healthy ones and redo transactions ☹. Unless someone knows some
trick with SQL ☺.
Best regards
________________________________________
From: [email protected]
[mailto:[email protected]] On Behalf Of Janno Lamus
Sent: 28 February 2011 11:06 AM
To: SQL-Ledger Users
Subject: [SQL-Ledger] Re: Corruption of Banking Table....
hi Jesey,
u can try repost all invoices
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
