How to Use Custom Parameter on Query Manager

With Query Manager on SAP Business One, not just a select syntax, you can also use a selection criteria, and added to your custom query. Here is a simple query sample with a date criteria parameter. With a [Date From] – [Date To] on OINV Table declare @FromDate date declare @ToDate date set @FromDate = ‘2019-01-01’ set @ToDate  =’2019-01-31’ SELECT * FROM OINV WHERE DocDate >= @FromDate AND DocDate <= @ToDate So, you need to change that query, to be like query below: /*SELECT * FROM OINV TO*/ declare @FromDate date declare @ToDate date /* WHERE */ set @FromDate =