SAP B1 Query for PR, PQ & PO. Some of PO created without PQ direct Created from PR.

[Former Member]

Hi Expert,

I already created query but Without PQ. PR not displaying in my report.Kindly help for me.

This is my Query.

SELECT T0."DocNum" "PR Number", T1."LineNum", T0."DocDate" "PR Date", T1."ItemCode", T1."Dscription", T1."Project", T1."Quantity" "PRQty",T3."CardCode", T3."DocNum" "PQNumber", T2."Quantity" "PQQty", T5."DocNum" "PO Number", T4."Quantity" "POQty", t4."Price" FROM OPRQ T0 INNER JOIN PRQ1 T1 ON T0."DocEntry" = T1."DocEntry" left outer join PQT1 T2 on T1."DocEntry" = T2."BaseEntry" and T1."LineNum" = T2."BaseLine" left outer join OPQT T3 on T3."DocEntry" = T2."DocEntry" left outer join POR1 T4 on T2."DocEntry" = T4."BaseEntry" and T2."LineNum" = T4."BaseLine" left outer join OPOR T5 on T5."DocEntry" = T4."DocEntry" where T3."CardCode"='SCP' and month(T0."DocDate")=06 and year(T0."DocDate")=2017 order by t0."DocNum", T1."LineNum"