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 >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
