[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
1.5 test for unbalanced acc_trans
- Subject: 1.5 test for unbalanced acc_trans
- From: herman vierendeels <..hidden..>
- Date: Mon, 10 Feb 2014 12:46:55 +0100
Hello,
If following is a good test for unbalanced transactions,
could we add it to setup- and upgrade-scripts?
select *|(or only relevant data) from acc_trans where trans_id in
( select trans_id from acc_trans group by trans_id having sum(amount) <> 0 );
Best wishes,
Herman