Skip to Content
0
Former Member
Apr 28, 2014 at 07:55 PM

Need to set perameter of from date and to date in query

26 Views

Hi all

Can anyone advise me how can I set parameter to generate my GRN report

I need parameter of from date and to date for below query

SELECT OPDN.DocNum, PDN1.Dscription, PDN1.Quantity, PDN1.UomCode, PDN1.VatSum, OPDN.CardName, OPCH.DocNum AS [AP Inv Doc No],

OPOR.DocNum AS [PO Doc No], OPOR.DocDate, POR1.Quantity AS [PO Qty], OPCH.DocTotal, PDN1.FreeTxt, PDN1.Text

FROM OPOR INNER JOIN

POR1 ON OPOR.DocEntry = POR1.DocEntry RIGHT OUTER JOIN

OPCH INNER JOIN

PCH1 ON OPCH.DocEntry = PCH1.DocEntry RIGHT OUTER JOIN

OPDN INNER JOIN

PDN1 ON OPDN.DocEntry = PDN1.DocEntry ON PCH1.BaseEntry = PDN1.DocEntry AND PCH1.BaseLine = PDN1.LineNum ON

POR1.LineNum = PDN1.BaseLine AND POR1.DocEntry = PDN1.BaseEntry

Thanks

Ricky