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