Hi Kedalene,
To adhd the Purchase Order Vendor Name to the query, you request to articulation the Purchase Order OPOR array (for header-level details
SELECT
T0.[CreateDate] AS 'GRPO Create Date',
T1.[DocEntry] AS 'GRPO Doc No.',
T0.[DocDate] AS 'GRPO Date',
T0.[DocStatus] AS 'Doc Status',
T0.[U_BLNO] AS 'B/L No.',
T0.[NumAtCard] AS 'DO No.',
T0.[U_CONTREF],
T0.[U_WSLIP],
T0.[U_SUPWSLIP] AS 'Supplier Weighslip No.',
T0.[U_RECWSLIP] AS 'Receiver Weighslip No.',
T0.[CardCode] AS 'Vendor Code',
T0.[CardName] AS 'Vendor Name',
T1.[ItemCode],
T1.[Dscription],
T1.[Quantity] AS 'GRPO Qty',
T0.[U_PO_VW] AS 'Supplier Qty',
T0.[U_OTHERWEIGHT] AS 'Receiver Qty',
T1.[WhsCode],
T1.[BaseDocNum] AS 'PO No.',
T3.[CardName] AS 'PO Vendor Name',
T0.[U_LOGREMARKS] AS 'Logistics Remarks',
T2.[DocDate] AS 'GR Date',
T2.[DocEntry] AS 'GR Doc No.',
T2.[Quantity] AS 'GR Qty'
FROM
OPDN T0
LEFT JOIN
PDN1 T1 ON T0.DocEntry = T1.DocEntry
LEFT JOIN
RPD1 T2 ON T1.DocEntry = T2.BaseEntry AND T1.ItemCode = T2.ItemCode
LEFT JOIN
OPOR T3 ON T1.BaseEntry = T3.DocEntry
WHERE
T0.[CardName] = [%0]
AND T1.[BaseDocNum] = [%1]