Skip to Content
Mar 03, 2022 at 06:11 AM

Detailed Purchase Request Report Not Showing All Rows which are available in that PR


When I Generate Query for "Detailed Purchase Report" then some Transaction Showing All rows which are available in respective PR but some PR Transaction not Showing all Rows in that PR Transaction. Please Suggest Solution.

My Query is given below:

SELECT T0."DocNum", T0."DocType", T0."DocStatus", T0."DocDate", T0."DocDueDate", T0."ReqName", T0."Department",T1."ItemCode", T1."Dscription",T1."LineNum", T1."Quantity" FROM OPRQ T0 INNER JOIN PRQ1 T1 ON T0."DocEntry" = T1."DocEntry"

Please give me some solution to generate proper PR Report.