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 br, Janno 28.02.2011 10:44, "Jesey" kirjutas: > Is there a way to rebuild the "bank" table based on AP and AR invoices? _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger ________________________________________ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1435/3472 - Release Date: 02/27/11 _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
