Skip to Content
0
J S
Jul 14, 2020 at 06:44 AM

Multiple Location

47 Views

Hi

IN below query i want to that List of Locations from Olct should be displayed for Selection. User should be able to select more than 1 Location. Also with Date From & Date To option.

SELECT M.DocEntry, M.DocNum AS 'AR Inv. #', M.DocDate as 'Date', M.CardName as 'Customer Name'
FROM OINV M LEFT OUTER JOIN INV1 L on L.DocEntry=M.DocEntry
LEFT OUTER JOIN INV4 T on T.DocEntry=L.DocEntry and L.LineNum=T.LineNum
LEFT OUTER JOIN INV5 J ON M.DocEntry = J.AbsEntry
LEFT OUTER JOIN INV3 Q ON M.DocEntry = Q.DocEntry
LEFT JOIN CRD1 A on M.CardCode=A.CardCode and M.PayToCode=A.Address and A.AdresType='S'
WHERE (M.DocDate >= '[%0]' AND M.DocDate <= '[%1]')

Thanks