Hello Paul, I can deal with stock and COGS but check what happened:
Banking Account (Table) 03/06/2009 INV151 GFL Mining Services Limited 31,920.00 121,182.19 Balance Sheet (03/06/2009): Cheque Account 121,182.19 ..... world is beautiful :) Banking Account (Table) 04/06/2009 S058 Salary - Moses April 09 1,594.01 117,768.65 05/06/2009 2171 P & I Hose and Industrial Supplies 700.05 117,068.60 Balance sheet (05/06/2009): Cheque Account 64,276.91 ....... rude awakening, does not balance eversince and the balance difference grows :( On my bank statement I have a transaction: 04/06/2009 Electrim Control Systems cc -52,791.69 66,570.97 Half a year ago (before I started to be to clever) the bank statement, the Bank Account (Table) and the Balance sheet were in sync to the cent. Now, I can not find the invoice which was deleted? in my AP listings. The payment processed on the deleted? invoice is still processed on the balance sheet but omitted In the Banking Account. There were few like that. I thought that if I delete something it is automatically, properly posted. Any comments... best regards "Jersey" ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paul Tammes Sent: 28 February 2011 02:27 PM To: SQL-Ledger Users Subject: [SQL-Ledger] Re: Corruption of Banking Table.... 1) I fear you might have changed both COGS and inventory as well! Deleting AP invoices from stock items will most likely result in 100% margin on sales for sold items. 2) Did you check to see if the "new" a/p sevice invoices are outstanding (reconciliaion or payment from bank account might well be deleted as well!) If so, deduct outstanding invoices from bankstatement and see if that fixes things.. HtH Pau;l 2011/2/28 Janno Lamus <[email protected]> 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 ________________________________________ 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
