Customized Report under Sales Order

NCP · May 22, 2023, 9:44am

Please check it reference:

Making Custom Reports without coding:
https://docs.erpnext.com/docs/v13/user/manual/en/customize-erpnext/articles/making-custom-reports

https://frappeframework.com/docs/v14/user/en/desk/reports/report-builder

And you can also Make a Query Report:
https://frappeframework.com/docs/v14/user/en/guides/reports-and-printing/how-to-make-query-report

https://frappeframework.com/docs/v14/user/en/desk/reports/query-report

[EDIT]
Please check it.

Query

SELECT
    `tabSales Order`.`name` AS `ID:Link/Sales Order:180`,
    `tabSales Order`.`delivery_date` AS `Delivery Date:Date:120`,
    `tabSales Order`.`customer` AS `Customer:Link/Customer:120`,
    `tabSales Order Item`.`item_code` AS `Item:Link/Item:120`,
    `tabSales Order Item`.`qty` AS `Qty:Float:120`,
    `tabSales Order Item`.`rate` AS `Rate:Currency:120`,
    `tabSales Order Item`.`amount` AS `Amount:Currency:120`,
    `tabSales Order`.`grand_total` AS `Grand Total:Currency:120`
FROM
    `tabSales Order`, `tabSales Order Item`
WHERE
    `tabSales Order Item`.`parent` = `tabSales Order`.`name`
ORDER BY
    `tabSales Order`.`name` ASC

I hope this helps.
Thank You!