Query Report error..?

ERPNext Reports
1

Hi,
Now I Am create a new query report to filter the data for one month…Already i am wrote query but its has some error…I want To filter the data by Posting date…

select
`tabSales Invoice`.`employee_name` as "Employee Name:Read Only:100",
`tabSales Invoice`.`posting_date` as "Date:Date:100",
`tabSales Invoice Item`.`qty` as "Quantity:Float:100",
`tabSales Invoice Item`.`rate` as "Rate:Currency:100",
`tabSales Invoice Item`.`amount` as "Amount:Currency:100",
`tabInput Filter`.`transcation` as "Transcation:Data:100",
from
`tabSales Invoice`, `tabSales Invoice Item`,  `tabInput Filter`
where
`tabSales Invoice Item`.parent = `tabSales Invoice`.name
 and `tabSales Invoice`.`docstatus` = "1"
and  `tabSales Invoice`.`posting_date`  between  `tabInput Filter`.`from date`  and `tabInput Filter`.`to date`
group by `tabSales Invoice`.'employee_name'
2

@Mohamed_Sajid Can you post the error?

3

Thanks i am solve that error…

4

@Mohamed_Sajid

I appreciate, if you can post the solution here as it will help others to follow if they find the same issue.

Regards
Ruchin Sharma

5

Its Correct Query…i am mistake in syntax…

select
`tabSales Invoice`.`employee_name` as "Employee Name:Read Only:100",
sum(`tabSales Invoice Item`.`qty`) as "Quantity:Float:100",
sum(`tabSales Invoice Item`.`amount`) as "Amount:Currency:100",
`tabInput Filter`.`transaction` as "Transaction:Data:250"
from
`tabSales Invoice`, `tabSales Invoice Item`, `tabInput Filter`
where
`tabSales Invoice Item`.parent = `tabSales Invoice`.name
 and `tabSales Invoice`.`docstatus` = "1"
 and `tabInput Filter`.`docstatus` = "1"
 and  `tabSales Invoice`.`posting_date`  between  `tabInput Filter`.`from_date`  and `tabInput Filter`.`to_date`
group by `tabSales Invoice`.`employee_name`
1 Like