SQL-Fehler Berichte Erzeugnisse mit "Verkaufte Anzahl"

[mike.constabel@…]

r4111

Stammdaten -> Berichte -> Erzeugnisse:

Nur das Häkchen "Verkaufte Anzahl" setzen, dann weiter:

SELECT DISTINCT p.id, pfac.factor AS price_factor, p.partnumber, ioi.description, p.onhand, p.sellprice, ioi.unit, (SELECT SUM(a_lc.qty * p_lc.lastcost / COALESCE(pfac_lc.factor, 1))
FROM assembly a_lc
LEFT JOIN parts p_lc ON (a_lc.parts_id = p_lc.id)
LEFT JOIN price_factors pfac_lc ON (p_lc.price_factor_id = pfac_lc.id)
WHERE (a_lc.id = p.id)) AS lastcost, SUM(ioi.qty) AS soldtotal FROM parts p LEFT JOIN partsgroup pg ON (pg.id = p.partsgroup_id) LEFT JOIN (
SELECT parts_id, description, serialnumber, trans_id, unit, sellprice, qty, assemblyitem, 'invoice' AS ioi FROM invoice UNION
SELECT parts_id, description, serialnumber, trans_id, unit, sellprice, qty, FALSE AS assemblyitem, 'orderitems' AS ioi FROM orderitems
) AS ioi ON ioi.parts_id = p.id LEFT JOIN price_factors pfac ON (pfac.id = p.price_factor_id) WHERE (1=1) AND ( p.assembly) AND (NOT p.obsolete) AND (ioi.qty >= 0) GROUP BY p.id, pfac.factor, p.partnumber, ioi.description, p.onhand, p.sellprice, ioi.unit, (SELECT SUM(a_lc.qty * p_lc.lastcost / COALESCE(pfac_lc.factor, 1))
FROM assembly a_lc
LEFT JOIN parts p_lc ON (a_lc.parts_id = p_lc.id)
LEFT JOIN price_factors pfac_lc ON (p_lc.price_factor_id = pfac_lc.id)
WHERE (a_lc.id = p.id)) AS lastcost ORDER BY description ASC
FEHLER: Syntaxfehler bei »AS«
LINE 12: WHERE (a_lc.id = p.id)) AS lastcost ORDER BY descri...

Fix in -r4118