Hi
What is wrong with this query.
SELECT T0.DocNum as 'Order No' , T0.DocDate as 'Date', T0.CardName as 'Vendor Name',T0.DocTotal as 'Invoice Total (Rs.)',T1.DocNum as Invoice No. ,T1.Docdate as Invoice Date,T1.U_Tr_Name
from ORDR T0 Left Join OINV T1 on T0.DocEntry = T1.DocEntry
WHERE T0.DocDate BETWEEN '[%0]' AND '[%1]'
Thanks