Re: [SL] Re-generating Year End For Prior Years

[Armaghan S. <sa...@le...>]

On Thu, Feb 12, 2009 at 7:06 PM, Rich Shepard <rsh...@ap...> wrote:
> On Thu, 12 Feb 2009, Armaghan Saqib wrote:
>> Duplication in chart can be confirmed using the following query.
>>
>>                SELECT id, 'chart' AS table, COUNT(*) AS count
>>                FROM chart
>>                GROUP BY 1,2
>>                HAVING COUNT(*) > 1
>
> Armaghan,
>
>   The above script returns 0 rows. Where do I learn what function is
> provided by the chart table?

'chart' table is used for the chart of accounts.

1. Could you confirm that year end transactions are not duplicated in
the database (acc_trans). You could search for these by using query
like:

SELECT * FROM acc_trans WHERE trans_id = closing_entry_id;

closing_entry_id can be found on "general ledger-reports". click the
'ID' checkbox before clicking the continue button.

2. Also make sure there is no duplicate account number.  Following
query should help.

                SELECT accno, COUNT(*) AS count
                FROM chart
                GROUP BY 1
                HAVING COUNT(*) > 1

Regards
-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--