i have create the simple query report with filter but the filter doent carry any values. it show s blank. the date range is working but company not showing values SELECT si.item_code AS ‘Item Code’, si.item_name AS ‘Item Name’, si.qty AS ‘Quantity’, si.net_amount AS ‘Net Value’, s.customer A…

Hi @Rajkumudu_Rk , Please check it. SELECT si.item_code AS 'Item Code', si.item_name AS 'Item Name', si.qty AS 'Quantity', si.net_amount AS 'Net Value', s.customer AS 'Customer', s.company AS 'Company' FROM `tabSales Invoice` s, `tabSales Invoice Item` si WHERE …

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace Community Chat (new!)

Frappe Forum

Query report for filters

ERPNext

NCP March 13, 2024, 9:00am 2

Hi @Rajkumudu_Rk,

Please check the post.

Thank You!