I need script report or query report for lead transaction

[NCP]

@satyamsathya978

i need deal query report also like above

You have to learn and develop it yourself.

Reference:

Create scripts report error

Hi @Zeeshan_Naeem, I think You should check the documentation of the server script report and also check the video. Query Report for please check it. [Reports II - Query Report] Script Report for please check it. [Reports III - Script Report] I hope this helps. Thank You!

Stock report issue

Please try it. Use the Bin doctype for get the stock qty. SELECT a.item_code AS "Item:Link/Item:120", a.item_name AS "Item Name::150", a.item_group AS "Item Group:Link/Item Group:120", a.description AS "Description::150", b.warehouse AS "Warehouse:Link/Warehouse:120", b.actual_qty AS "Balance Qty:Float:140", w.company AS "Company:Link/Company:120" FROM `tabItem` a LEFT JOIN `tabBin` b ON a.item_code = b.item_code LEFT JOIN `tabWarehouse` w ON b.warehouse = w.…

I need "from date" and "to date" filter in query report

Please apply the query: SELECT ta.employee AS "Employee:Link/Employee:200", COUNT(CASE WHEN ta.status = 'Present' THEN 1 END) AS "Total Present:Int:200", COUNT(CASE WHEN ta.status = 'Absent' THEN 1 END) AS "Total Absent:Int:200", COUNT(CASE WHEN ta.late_entry = 1 THEN 1 END) AS "Total Late Entry:Int:200", COUNT(CASE WHEN ta.early_exit = 1 THEN 1 END) AS "Total Early Exit:Int:200", SUM(TIMESTAMPDIFF(HOUR, ta.in_time, ta.out_time)) AS "Total Working Hours:Float:200" FROM …

Query report for filters

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 si.parent = s.name AND s.posting_date BETWEEN %(from_date)s AND %(to_date)s AND s.company = %(company)s; Thank You!

Query Report - ORDER BY after UNION Two Tables

Hi @umarless, Please try it. SELECT * FROM ( SELECT name as "Voucher No.:Data:250", loan_date as "Voucher Date:Date:150", loan_amount as "Amount:Currency:150" FROM `tabFlexi Loan` WHERE employee = %(employee)s AND docstatus = 1 UNION SELECT name as "Voucher No.:Data:250", payroll_date as "Voucher Date:Date:150", amount * -1 as "Amount:Currency:150" FROM `tabAdditional Salary` WHERE employee = %(employee…

Adding Filters in Query Report

Hi @DME_Apaulsoftware, Please check this. [image] Output: When you select MR ID then will be show data. [image] Sample code: SELECT `tabMaterial Request`.`name` as `MR:Link/Material Request:180`, `tabMaterial Request`.`transaction_date` as `Transaction Date:Date:120`, `tabMaterial Request`.`status` as `Status:Data:100` FROM `tabMaterial Request` WHERE `tabMaterial Request`.`name` = %(name)s AND `tabMaterial Request`.docstatus = 1 T…