On Tue, Dec 18, 2007 at 03:34:38PM -0800, Chris Travers wrote:
> Try:
>
> SELECT * from acc_trans WHERE trans_id NOT IN
> (select id from ar UNION select id from ap UNION select id from gl)
> ORDER BY transdate;
(102 rows)
It's actually 3 different transactions, from what I can see:
SELECT coun
On Dec 18, 2007 3:30 PM, The Anarcat <[EMAIL PROTECTED]> wrote:
> We have lived for various periods with transaction reversal NOT enforced
> here, and it probably had impact on the database sanity. I worked with
> Chris Travers to try to reverse some of the obvious damage (that would
> appear in c
We have lived for various periods with transaction reversal NOT enforced
here, and it probably had impact on the database sanity. I worked with
Chris Travers to try to reverse some of the obvious damage (that would
appear in conciliation statements, for example), but I think some
remain.
Could any
