Bericht Waren

[wromer@…]

Beim Versuch einen Bericht einer Ware zu erstellen kommt nur bei Auswahl Gekauft
und Verkauft eine Liste, bei allen anderen Wahlmöglichkeiten erscheint folgende
Meldung:
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, '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 lower(p.partnumber) LIKE '%100-0001%' AND p.inventory_accno_id >
0 AND p.obsolete = '0' AND p.id=i.parts_id AND i.qty >= 0
AND o.quotation = '0'
AND o.vendor_id > 0
ORDER BY description
ERROR: relation "i" does not exist

Habe ich versucht nachzuvollziehen, kriege es aber nicht hin.

Das query sieht so aus als ob die Auswahl "Verkaufte Anzahl" daran schuld wäre
(der Filter wird verwendet, aber in das falsche Query eingebunden).

Bitte mehr Informationen geben.

Im aktuellen Release behoben

Wenn man alle Auswahlmöglichkeiten in der Maske belegt, dann tritt der Fehler
erneut auf.

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 > 0) 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,
[...]
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 > 0) 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

wie auch schon #696, gefixt mit neue Backendfunktion