PO Vendor Name in GRPO Query

1 month ago 7

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]
Read Entire Article