Stammdaten -> Berichte -> Erzeugnisse erzeugt SQL Fehler

[tkasulke@…]

wie #696 und 697 alles anklicken und auf "Weiter" klicken - ausserdem stimmt
da was mit locale->text nicht, da die Überschrift nicht übersetzt wird

SELECT p.id, p.partnumber, i.description, i.serialnumber,
i.qty AS onhand, i.unit, p.bin, i.sellprice,
p.listprice, p.lastcost, p.rop, p.weight,
p.priceupdate, p.image, p.drawing, p.microfiche,
pg.partsgroup,
a.invnumber, a.ordnumber, a.quonumber, i.trans_id,
ct.name, i.deliverydate, 'is' AS module, AS type, 1 As exchangerate
FROM invoice i
JOIN parts p ON (p.id = i.parts_id)
JOIN ar a ON (a.id = i.trans_id)
JOIN customer ct ON (a.customer_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND p.assembly AND (p.obsolete = '0') AND (p.id = i.parts_id) AND
(i.qty >= 0) AND i.assemblyitem = '0' UNION

SELECT p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice,
p.listprice, p.lastcost, p.rop, p.weight,
p.priceupdate, p.image, p.drawing, p.microfiche,
pg.partsgroup,
AS invnumber, o.ordnumber, o.quonumber, oi.trans_id,
ct.name, NULL AS deliverydate,
'oe' AS module, 'sales_order' AS type,
(SELECT buy FROM exchangerate ex
WHERE ex.curr = o.curr AND ex.transdate = o.transdate) AS exchangerate
FROM orderitems oi
JOIN parts p ON (oi.parts_id = p.id)
JOIN oe o ON (oi.trans_id = o.id)
JOIN customer ct ON (o.customer_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND p.assembly AND (p.obsolete = '0') AND (p.id = i.parts_id) AND
(i.qty >= 0) AND o.quotation = '0' AND (o.customer_id > 0) UNION

SELECT
p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice,
p.listprice, p.lastcost, p.rop, p.weight,
p.priceupdate, p.image, p.drawing, p.microfiche,
pg.partsgroup,
AS invnumber, o.ordnumber, o.quonumber, oi.trans_id,
ct.name, NULL AS deliverydate, 'oe' AS module, 'sales_quotation' AS type,
(SELECT buy FROM exchangerate ex
WHERE (ex.curr = o.curr) AND (ex.transdate = o.transdate)) AS exchangerate
FROM orderitems oi
JOIN parts p ON (oi.parts_id = p.id)
JOIN oe o ON (oi.trans_id = o.id)
JOIN customer ct ON (o.customer_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND p.assembly AND (p.obsolete = '0') AND (p.id = i.parts_id) AND
(i.qty >= 0) AND o.quotation = '1'
AND o.customer_id > 0 ORDER BY description
ERROR: relation "i" does not exist

Auch hier, alles wunderbar.

Falsche Übersetzung kam durch falschen Plural von assembly -> assemblys (anstatt
korrekterweise assemblies)