Dear All,
As i am trying to create a report using Query report Where i can get the day settlement per day branch wise.
I tried To get the reference of GL Entry But i couldn’t add the date filter in the js file as the directory is not showing in the accounts report.
I tried with this query
select
account AS “Account:Link/Account:150”,
tabGL Entry
.posting_date
as “Date:Date:150”,
sum(debit)As “Debit:Currency:120”,
sum(credit) AS “Credit:Currency:120”,
(sum(debit) - sum(credit)) as “Net:Currency:120”
from tabGL Entry
group by account
kindly help me in that.