Stammdaten -> Berichte -> Diestleistungen erzeugt SQL Fehler

[tkasulke@…]

wie in #696 alles anklicken und auf "Weiter" erzeugt:

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, 'ir' AS module, AS type, 1 AS exchangerate
FROM invoice i
JOIN parts p ON (p.id = i.parts_id)
JOIN ap a ON (a.id = i.trans_id)
JOIN vendor ct ON (a.vendor_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND (p.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') AND
(p.obsolete = '0') AND (p.id = i.parts_id) AND (i.qty >= 0) AND i.assemblyitem =
'0' UNION

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.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') 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.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') 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 * -1 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, 'purchase_order' AS type,
(SELECT sell 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 vendor ct ON (o.vendor_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND (p.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') AND
(p.obsolete = '0') AND (p.id = i.parts_id) AND (i.qty >= 0) AND o.quotation =
'0' AND (o.vendor_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.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') AND
(p.obsolete = '0') AND (p.id = i.parts_id) AND (i.qty >= 0) AND o.quotation = '1'
AND o.customer_id > 0 UNION

SELECT p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
oi.qty * -1 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, 'request_quotation' AS type,
(SELECT sell 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 vendor ct ON (o.vendor_id = ct.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE 1 = 1 AND (p.inventory_accno_id IS NULL) AND NOT (p.assembly = '1') AND
(p.obsolete = '0') AND (p.id = i.parts_id) AND (i.qty >= 0) AND o.quotation = '1'
AND o.vendor_id > 0 ORDER BY description
ERROR: relation "i" does not exist

Ebenfalls gefixt. Wie auch 696.