Hello, :))).... may you be eternally blessed for mentioning Trial Balance... I found an invoice there with deposit and partial payments... one of them was missing... I reposted this one and everything clicked into order...
Many Thanks :) "Jersey" P.S. Many thanks to everyone for assisting one dumb a^%$ :))) > Yeaaa… weekend…. I probably have to restore the system to the last point > which does not show corruption… no problem, but: Not quite sure how you want to do this - other then making a backup file and deleting part of it. ***** I have backups going 3 years back :)... call it impulsive compulsive :) ***** > WHAT HAPPENED TO THE INVOICE WHICH "HALF" EXISTS (check below)? ☺ ... That’s > what I would like to know :). There is nothing like a "half existing" invoice! If the invoice has been entered you should be able to select it from the Trial Balance report. If some data should be missing you'll see this. Be careful with reposting invoices if they are for stock items. Also, it is not a good idea to play God and to repair database tables with an external tool UNLESS you really understand the database structure! Think at least 3 times before doing this. It can be the direct way into a major mess! ****** I did not try it because of what you said... I do not understand 100% how the data base works :) ****** In any case take a backup before making any changes, repair. What I tried to tell you is: (1) get your bank and cash accounts right - ensuring that all transactions are posted (2) make sure that all goods receipts and goods issues are posted (3) you may have to recalculate your COGS Hope this helps, Bernd On Mon, 28 Feb 2011 16:40:27 +0200 "\"Jesey\"" <[email protected]> wrote: > Hello Bernd, > > Yeaaa… weekend…. I probably have to restore the system to the last point > which does not show corruption… no problem, but: > > WHAT HAPPENED TO THE INVOICE WHICH "HALF" EXISTS (check below)? ☺ ... That’s > what I would like to know :). > > Anyway, I am going to restore it to ledger123 re-enter data and give it a try. > > Thnx > "Jersey" > > ________________________________________ > From: [email protected] > [mailto:[email protected]] On Behalf Of Bernd Plagge > Sent: 28 February 2011 03:56 PM > To: SQL-Ledger Users > Subject: [SQL-Ledger] Re: Corruption of Banking Table.... > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > > what you need is a quiet weekend - or maybe more. > > Then you take your paper copies and check one by one that invoices and goods > receipt, goods posted are showing properly. > > Take your bank statements and look for the point in time your accounts are > not syncing any more. > For each incoming and outgoing statement you > - may have an order > - need to have an invoice (purchase, sales) or a accounting statement > - if you have goods you also have to get your stock figures right (but I > think there is a program available > which will repost your goods receipts and issues one by one) > BUT you need to have ALL purchases and sales in the system > > Think about it: The system calculates the moving average costs of your > products and COGS. If you just delete some goods receipts or issues the whole > thing will fall apart. > > Hope this helps, > Bernd > > > On Mon, 28 Feb 2011 15:16:27 +0200 > "\"Jesey\"" <[email protected]> wrote: > > > 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 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > > iEYEARECAAYFAk1rqW0ACgkQpYU8M8PbPV4/lwCgpNaVBncQ9bUn8WmrJWshNTQl > WXgAoKllE/L//YaFYRHpcazBXMje7Lbw > =ynbR > -----END PGP SIGNATURE----- > _______________________________________________ > 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAk1ruBgACgkQpYU8M8PbPV4VXgCfbsv543wJrDITaJtE/3zooSQ2 X50An1MH0x48sLz7A9hIgLk67AKblso/ =7Kb8 -----END PGP SIGNATURE----- _______________________________________________ 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/3473 - Release Date: 02/28/11 _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
