I have created the following query:
SELECT SUM(Debit), Project FROM BTF1 WHERE
(Account LIKE '68%' OR Account LIKE '58%') AND
RefDate >= '2017.01.01' AND RefDate <= '2017.06.30' GROUP BY Project
Now I would like to design a graphical interface to collect input (namely the RefDate and the Account).
I tried making the input parametric (i.e. T0.[RefDate]>=[%0]): it does open a window to input data, but I would prefer an input window that executes the query after entering input and clicking a button, without opening the query.
Is it possible to do it in SAP B1?
Thanks a lot for the help.