Hello all,
Having had no reply to my message from back in August (below), I have
done some more digging today (our annual accounts are due shortly,
which focuses the mind) and found where the discrepancy lies.
In acc_trans there are two entries which should not be there, viz:
select * from acc_trans where trans_id = 20922;
trans_id | chart_id | transdate | source | cleared | fx_transaction | project_
id | memo | invoice_id | amount | entry_id
----------+----------+------------+--------+---------+----------------+---------
---+------+------------+--------+----------
20922 | 10474 | 2008-02-25 | | f | f |
| | 19621 | -10 | 19828
20922 | 10016 | 2008-02-25 | | f | f |
| | | 10 | 19829
When querying the invoice table for id 19621, no rows are returned,
so transaction 20922 is a ghost/orphan/zombie or however you want to
call it. As there is another similar transaction on the same date for
the same amount, the presumption is that this was introduced by fat
fingers or other PEBKAC.
I think that by simply removing these two rows from acc_trans my trial
balance will once again be correct. Is there any danger in doing this
(obviously I have backups and could just reinstate these 2 rows at a
later date if required)?
Pete
On Fri, Aug 13, 2010 at 04:48:08PM +0100, Pete Houston wrote:
> Hello all,
>
> I have spotted a weird inconsistency in the trial balance vs the account
> detail which I cannot logically explain. When viewing the trial balance
> for a particular period, the credit column for Accounts Payable is x.
> However, when clicking through on the Accounts Payable account number to
> get the breakdown over that period, the credit column total is now
> x minus 10 (and the finishing balance is also down by 10).
>
> Now, this is causing a problem as the balance sheet for today is wrong
> as it seems to have the extra 10 pounds (like the trial balance has)
> which should not be there.
>
> So, assuming that the account breakdown for Accounts Payable has the
> correct figure (and I'm satisfied that this is the case), how can I go
> about finding and removing the spurious extra 10 pounds as reported in
> the trial balance and the balance sheet?
>
> Thanks,
>
> Pete
--
Openstrike - improving business through open source
http://www.openstrike.co.uk/ or call 01722 770036 / 07092 020107
Attachment:
pgpgjlfK9J2hs.pgp
Description: PGP signature