Query for purchase Register

LINKING OF PURCHASE ORDER TO CREDIT NOTE TABLES

SELECT *

FROM POR1 T1

LEFT OUTER JOIN OPOR T2 ON T1.DocEntry = T2.DocEntry

LEFT OUTER JOIN PDN1 T3 ON T2.DocEntry = T3.BaseEntry

AND T1.LineNum = T3.BaseLine

AND T1.ItemCode = T3.ItemCode

LEFT OUTER JOIN OPDN T4 ON T3.DocEntry = T4.DocEntry

LEFT OUTER JOIN RPD1 T5 ON T4.DocEntry = T5.BaseEntry

AND T3.LineNum = T5.BaseLine

AND T3.ItemCode = T5.ItemCode

LEFT OUTER JOIN ORPD T6 ON T5.DocEntry = T6.DocEntry

LEFT OUTER JOIN PCH1 T7 ON T4.DocEntry = T7.BaseEntry

AND T3.LineNum = T7.BaseLine

AND T3.ItemCode = T7.ItemCode

LEFT OUTER JOIN OPCH T8 ON T7.DocEntry = T8.DocEntry

LEFT OUTER JOIN RPC1 T9 ON T8.DocEntry = T9.BaseEntry

AND T7.LineNum = T9.BaseLine

AND T7.ItemCode = T9.ItemCode

LEFT OUTER JOIN ORPC T10 ON T9.DocEntry = T10.DocEntry

Add the required field from the table in the select and check required condition on the where clause…

Hope Helpful