Buchungsjournal: SQL-Fehler bei anderen Knöpfen als "Alle"

[f.ellenberger@…]

Wählt man in Buchungsjournal einen anderen Knopf als "Alle", bekommt man einen
SQL-Fehler.

Output:
Fehler!
SELECT
ac.oid AS acoid, g.id, 'gl' AS type, FALSE AS invoice, g.reference, ac.taxkey,
c.link,
g.description, ac.transdate, ac.source, ac.trans_id,
ac.amount, c.accno, g.notes, t.chart_id, ac.oid

FROM gl g, acc_trans ac , chart c
LEFT JOIN tax t ON (t.chart_id = c.id)
WHERE 1 = 1 AND gl.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id
IN
(SELECT id FROM chart c2 WHERE c2.category = ?))
AND (ac.chart_id = c.id)
AND (g.id = ac.trans_id)

UNION

SELECT ac.oid AS acoid, a.id, 'ar' AS type, a.invoice, a.invnumber, ac.taxkey,
c.link,
ct.name, ac.transdate, ac.source, ac.trans_id,
ac.amount, c.accno, a.notes, t.chart_id, ac.oid

FROM ar a, acc_trans ac , customer ct, chart c
LEFT JOIN tax t ON (t.chart_id=c.id)
WHERE 1 = 1 AND ar.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id
IN
(SELECT id FROM chart c2 WHERE c2.category = ?))
AND (ac.chart_id = c.id)
AND (a.customer_id = ct.id)
AND (a.id = ac.trans_id)

UNION

SELECT ac.oid AS acoid, a.id, 'ap' AS type, a.invoice, a.invnumber, ac.taxkey,
c.link,
ct.name, ac.transdate, ac.source, ac.trans_id,
ac.amount, c.accno, a.notes, t.chart_id, ac.oid

FROM ap a, acc_trans ac , vendor ct, chart c
LEFT JOIN tax t ON (t.chart_id=c.id)
WHERE 1 = 1 AND ap.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id
IN
(SELECT id FROM chart c2 WHERE c2.category = ?))
AND (ac.chart_id = c.id)
AND (a.vendor_id = ct.id)
AND (a.id = ac.trans_id)

ORDER BY transdate, transdate, trans_id, acoid, taxkey DESC (A, A, A)
ERROR: invalid reference to FROM-clause entry for table "gl"
HINT: Perhaps you meant to reference the table alias "g".

diff -u zu GL.pm

Aliasse im SQL angepasst.

Sieht gefixt aus. Bitte wieder öffnen falls das nicht der Fall ist.