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.