Skip to Content
0
J S
May 23, 2020 at 06:29 AM

Purchase Query

138 Views

Hi

I have below query . I want to add 1 more column Qty Received so far. When i click on DocNum then it should show all GRPO against this P.O.

SELECT M.DocNum AS 'AP Inv. #', M.DocDate , M.CardName as 'Vendor Name',M.NumAtCard as 'Bill No. & Dt.',L.ItemCode, L.Dscription,L.LineTotal,
M.DocTotal as 'Total (Rs.)'
FROM OPCH M LEFT OUTER JOIN PCH1 L on L.DocEntry=M.DocEntry
  

Thanks