SELECT OCRD.CardCode AS 'Supplier Code', OCRD.CardName AS 'Supplier Name', OITM.ItemCode AS 'Item Code', OITM.ItemName AS ' Item Description',
OPOR.DocNum AS 'P.O. No', POR1.Quantity AS 'PO Qty', OPOR.DocDueDate AS 'Due Date', OPDN.DocDate AS 'Reciept Date',
PDN1.Quantity AS 'Receipt Qty', PDN1.Quantity - POR1.Quantity AS 'Balance Qty', OPOR.DocTotal AS 'PO Value'
FROM OPDN INNER JOIN
PDN1 ON OPDN.DocEntry = PDN1.DocEntry INNER JOIN
OITM INNER JOIN
POR1 ON OITM.ItemCode = POR1.ItemCode INNER JOIN
OCRD INNER JOIN
OPOR ON OCRD.CardCode = OPOR.CardCode ON POR1.DocEntry = OPOR.DocEntry ON OPDN.CardCode = OCRD.CardCode AND
PDN1.ItemCode = POR1.ItemCode
WHERE (OCRD.CardType = 'S') AND (OPDN.InvntSttus = 'O') and OPOR.DocDueDate between '[% FROM ]' and '[%TO]' ORDER BY OPOR.DocDueDate
I want to pass from date and to date as parameter in the above query.The above query gives error.What correction should ne done ?
Edited by: Dilip Kumbhar on Jan 15, 2008 9:38 AM
Edited by: Dilip Kumbhar on Jan 15, 2008 9:39 AM