ManEx KB

PO Query - Open PO Dock Receiving Report

Below is the SQL Query for the Open Purchase Order Dock Receiving Report

SELECT Podock.Ponum, SupInfo.Supname, Poitems.Itemno, Podock.Qty_rec, Podock.Date, Podock.Porecpkno, Podock.Receiverno, ;

Pomain.Conum,Poitems.PartMfgr,Poitems.Mfgr_pt_no, ;

IIF(EMPTY(Poitems.Uniq_key),SPACE(10),Poitems.Uniq_key) AS Uniq_key, ;

IIF(EMPTY(Poitems.Uniq_key),Poitems.Part_no,Inventor.Part_no) AS Part_no, ;

IIF(EMPTY(Poitems.Uniq_key),Poitems.Revision,Inventor.Revision) AS Revision, ;

IIF(EMPTY(Poitems.Uniq_key),Poitems.Part_class,Inventor.Part_class) AS Part_class, ;

IIF(EMPTY(Poitems.Uniq_key),Poitems.Part_type,Inventor.Part_type) AS Part_type, ;

IIF(EMPTY(Poitems.Uniq_key),Poitems.Descript,Inventor.Descript) AS Descript ;

FROM Manex!Podock, Manex!Pomain, Manex!Supinfo, ;

Manex!Poitems LEFT OUTER JOIN Manex!Inventor ;

ON Poitems.Uniq_key = Inventor.Uniq;

WHERE Pomain.UniqSupno = Supinfo.UniqSupno ;

AND Poitems.Ponum = Pomain.Ponum ;

AND Podock.Uniqlnno = Poitems.Uniqlnno ;

AND Podock.ponum = Poitems.Ponum ;

AND EMPTY(Podock.CompDate) ;

INTO CURSOR ZPoDockOp