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
