ERPNext Core / Framework
What is Script Report?
- Script Report
- A Script Report in ERPNext is a Python-coded report with full database access, used for complex multi-table reports that cannot be created with the no-code Report Builder.
Building a Script Report
Create a new Report DocType with "Report Type: Script Report". Write the Python "execute()" function that returns columns and data. Use frappe.db.sql() or frappe.get_list() to fetch data. Deploy it as part of a custom Frappe app for version-controlled customisation.
Standard Script Reports
Most advanced ERPNext reports (Stock Ledger, Accounts Receivable Aging, Trial Balance) are Script Reports. You can customise them by forking the standard report in a custom app and overriding the Python file. The Report Builder creates Query Reports rather than Script Reports.
Need help with Script Report?
Infonoxe Technologies specialises in ERPNext implementation and custom software for Indian businesses.
Related Terms
Report Builder
ERPNext's Report Builder is a no-code tool that lets users create custom tabular…
Frappe Framework
Frappe is the open-source full-stack Python web framework on which ERPNext is bu…
Custom Frappe App
A Custom Frappe App is a separate Python package installed alongside ERPNext tha…
Dashboard
ERPNext Dashboards are configurable home-page views showing multiple charts and …
Implement ERPNext for Your Business
Expert ERPNext implementation, customisation, and support for Indian businesses.