-----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
