Project

General

Profile

Fehler #34

Bei Lieferanten Lieferungen anzeigen geht nicht

Added by Werner Hahn almost 10 years ago. Updated almost 10 years ago.

Status:
Erledigt
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
02/05/2015
Due date:
% Done:

0%

Estimated time:

Description

Es kommt folgende Meldung {"error":"SELECT
s.shiptoname,
i.qty * -1 AS qty,
ap.id,
ap.transdate,
ap.invnumber,
ap.ordnumber,
i.description,
i.unit,
i.sellprice,
oe.id AS oe_id,
invoice
FROM ap

LEFT JOIN shipto s
ON (ap.id = s.trans_id)

LEFT JOIN invoice i
ON ap.id = i.trans_id

LEFT JOIN parts p
ON p.id = i.parts_id

LEFT JOIN oe
ON (oe.ordnumber = ap.ordnumber AND NOT ap.ordnumber = ''
AND oe_vendor_id IS NOT NULL )

WHERE 1=1 AND ap.vendor_id = ?
ORDER BY ap.transdate DESC LIMIT 15 (1397)
ERROR: column \"oe_vendor_id\" does not exist
LINE 26: AND oe_vendor_id IS NOT NULL )
^"}

History

#1

Updated by G. Richardson almost 10 years ago

  • Status changed from Neu to Erledigt

Behoben in Commit 3e0483ee5d

Also available in: Atom PDF