# get cleared balance
if ($form->{fromdate}) {
$query = qq|SELECT sum(a.amount),
(SELECT DISTINCT c2.category FROM chart c2
# get cleared balance
if ($form->{fromdate}) {
$query = qq|SELECT sum(a.amount),
(SELECT DISTINCT c2.category FROM chart c2
- my %oid = ( 'Pg' => 'ac.oid',
- 'Oracle' => 'ac.rowid');
-
+ my %oid = ('Pg' => 'ac.oid',
+ 'Oracle' => 'ac.rowid');
+
$query = qq|SELECT c.name, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, a.id,
$oid{$myconfig->{dbdriver}} AS oid
$query = qq|SELECT c.name, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, a.id,
$oid{$myconfig->{dbdriver}} AS oid
UNION
SELECT v.name, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, a.id,
UNION
SELECT v.name, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, a.id,
FROM vendor v, acc_trans ac, ap a, chart ch
WHERE v.id = a.vendor_id
-- AND NOT ac.fx_transaction
FROM vendor v, acc_trans ac, ap a, chart ch
WHERE v.id = a.vendor_id
-- AND NOT ac.fx_transaction
UNION
SELECT g.description, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, g.id,
UNION
SELECT g.description, ac.source, ac.transdate, ac.cleared,
ac.fx_transaction, ac.amount, g.id,
FROM gl g, acc_trans ac, chart ch
WHERE g.id = ac.trans_id
-- AND NOT ac.fx_transaction
FROM gl g, acc_trans ac, chart ch
WHERE g.id = ac.trans_id
-- AND NOT ac.fx_transaction