Skip to content
ERPNext Data Model
Esc
↑↓navigate↵open⌘Jpreview
On this page

Reports

All 184 ERPNext reports — Script, Query and Report Builder — with type, module, reference DocType, roles and disabled state.

184 fixtures in **/report/<name>/<name>.json: 165 Script Report, 13 Query Report, 6 Report Builder. One is disabled: 1. “Ref DocType” links to this site’s entity pages where the report’s ref_doctype is one of the 448 documented entities; where it names a real ERPNext DocType outside that set, or a name absent from the pinned ERPNext source entirely, the cell says so instead of guessing at a link.

sorted alphabetically by Report

Report Type Module Ref DocType Roles Disabled
Account Balance Script Report Accounts Bank Account — No
Accounts Payable Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Accounts Payable Summary Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Accounts Receivable Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Accounts Receivable Summary Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Address And Contacts Script Report Selling Address (not in ERPNext source) Accounts User, Maintenance User, Purchase User, Sales User No
Asset Activity Report Builder Assets Asset Activity Accounts User, Quality Manager, System Manager No
Asset Depreciation Ledger Script Report Accounts Asset Accounts User No
Asset Depreciations and Balances Script Report Accounts Asset Accounts User No
Asset Maintenance Report Builder Assets Asset Maintenance System Manager No
Available Batch Report Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Available Serial No Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Available Stock for Packing Items Script Report Selling Product Bundle Sales User, Stock Manager, Stock User No
BOM Explorer Script Report Manufacturing BOM Manufacturing Manager, Manufacturing User No
BOM Operations Time Script Report Manufacturing BOM Manufacturing Manager, Manufacturing User No
BOM Search Script Report Stock BOM Manufacturing Manager, Manufacturing User No
BOM Stock Analysis Script Report Manufacturing BOM Manufacturing Manager, Manufacturing User No
BOM Variance Report Script Report Manufacturing Stock Entry Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Balance Sheet Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Bank Clearance Summary Script Report Accounts Journal Entry Accounts Manager, Accounts User, Auditor No
Bank Reconciliation Statement Script Report Accounts Journal Entry Accounts Manager, Accounts User, Auditor No
Batch Item Expiry Status Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Batch-Wise Balance History Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Billed Items To Be Received Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User, Stock User No
Budget Variance Report Script Report Accounts Cost Center Accounts Manager, Accounts User, Auditor, Purchase User, Sales User No
COGS By Item Group Script Report Stock GL Entry Accounts Manager, Accounts User, Auditor No
Calculated Discount Mismatch Script Report Accounts Version (not in ERPNext source) Accounts Manager, Accounts User, Administrator, System Manager No
Campaign Efficiency Script Report CRM Lead Sales Manager, Sales User, System Manager No
Cash Flow Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Cheques and Deposits Incorrectly cleared Script Report Accounts Payment Entry Accounts Manager, Accounts User No
Completed Work Orders Query Report Manufacturing Work Order Manufacturing User, Stock User No
Consolidated Financial Statement Script Report Accounts Account Accounts Manager, Accounts User, Auditor, Purchase User, Sales User No
Consolidated Trial Balance Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Cost of Poor Quality Report Script Report Manufacturing Job Card Manufacturing Manager, Manufacturing User, System Manager No
Custom Financial Statement Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Customer Acquisition and Loyalty Script Report Selling Customer Accounts Manager, Accounts User, Sales Manager, Sales Master Manager, Sales User, Stock Manager, Stock User No
Customer Credit Balance Script Report Selling Customer Accounts Manager, Accounts User, Sales Manager, Sales Master Manager, Sales User, Stock Manager, Stock User No
Customer Ledger Summary Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Customer-wise Item Price Script Report Selling Customer Accounts Manager, Accounts User, Sales Manager, Sales Master Manager, Sales User, Stock Manager, Stock User No
Customers Without Any Sales Transactions Query Report Selling Sales Invoice Sales Manager, Sales User, System Manager No
Daily Timesheet Summary Script Report Projects Timesheet Accounts User, HR User, Manufacturing User, Projects User No
Deferred Revenue and Expense Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Delayed Item Report Script Report Stock Delivery Note Accounts User, Maintenance User, Sales User, Stock Manager, Stock User No
Delayed Order Report Script Report Stock Delivery Note Accounts User, Maintenance User, Sales User, Stock Manager, Stock User No
Delayed Tasks Summary Script Report Projects Task Projects Manager, Projects User No
Delivered Items To Be Billed Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Delivery Note Trends Script Report Stock Delivery Note Accounts User, Sales User, Stock Manager, Stock User No
Dimension-wise Accounts Balance Report Script Report Accounts GL Entry — No
Downtime Analysis Script Report Manufacturing Downtime Entry Manufacturing Manager, Manufacturing User, System Manager No
Electronic Invoice Register Script Report Regional Sales Invoice — Yes
Exponential Smoothing Forecasting Script Report Manufacturing Sales Order Manufacturing Manager, Manufacturing User, Sales Manager, Sales User, Stock Manager, Stock User No
FIFO Queue vs Qty After Transaction Comparison Script Report Stock Stock Ledger Entry Administrator No
Financial Ratios Script Report Accounts Account Accounts Manager, Accounts User, Auditor, Purchase User, Sales User No
First Response Time for Issues Script Report Support Issue Support Team No
First Response Time for Opportunity Script Report CRM Opportunity Sales Manager, Sales User No
Fixed Asset Register Script Report Assets Asset Accounts User, Quality Manager No
General Ledger Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
General and Payment Ledger Comparison Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Gross Profit Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Gross and Net Profit Report Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
IRS 1099 Script Report Regional Supplier Accounts Manager, System Manager No
Inactive Customers Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Inactive Sales Items Script Report Accounts Sales Invoice Accounts Manager, Accounts User, Auditor No
Incorrect Balance Qty After Transaction Script Report Stock Stock Ledger Entry Purchase User, Stock Manager, Stock User No
Incorrect Serial No Valuation Script Report Stock Stock Ledger Entry Accounts Manager, Accounts User, Stock Manager, Stock User No
Incorrect Serial and Batch Bundle Script Report Stock Serial and Batch Bundle Delivery Manager, Delivery User, Maintenance User, Manufacturing Manager, Manufacturing User, Purchase Manager, Purchase User, Stock Manager, Stock User, System Manager No
Incorrect Stock Value Report Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Invalid Ledger Entries Script Report Accounts GL Entry — No
Issue Analytics Script Report Support Issue Support Team No
Issue Summary Script Report Support Issue Support Team No
Issued Items Against Work Order Query Report Manufacturing Work Order Manufacturing User, Stock User No
Item Balance (Simple) Query Report Stock Bin Purchase User, Sales User, Stock User No
Item Price Stock Script Report Stock Item Accounts User, Item Manager, Maintenance User, Manufacturing User, Purchase User, Sales User, Stock Manager, Stock User No
Item Prices Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Item Shortage Report Script Report Stock Bin Purchase User, Sales User, Stock User No
Item Variant Details Script Report Stock Item Accounts User, Item Manager, Maintenance User, Manufacturing User, Purchase User, Sales User, Stock Manager, Stock User No
Item Where Used Script Report Stock Item Item Manager, Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Item Wise Consumption Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Item-wise Price List Rate Report Builder Stock Item Price Purchase Master Manager, Sales Master Manager No
Item-wise Purchase History Script Report Buying Purchase Order Purchase Manager, Purchase User, Stock User No
Item-wise Purchase Register Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Item-wise Sales History Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Item-wise Sales Register Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Items To Be Requested Query Report Stock Material Request Purchase Manager, Purchase User, Stock Manager, Stock User No
Itemwise Recommended Reorder Level Script Report Stock Item Accounts User, Item Manager, Maintenance User, Manufacturing User, Purchase User, Sales User, Stock Manager, Stock User No
Job Card Summary Script Report Manufacturing Job Card Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Landed Cost Report Script Report Stock Landed Cost Voucher Purchase Manager, Purchase User, Stock Manager, Stock User No
Lead Conversion Time Script Report CRM Communication (not in ERPNext source) Sales Manager, Sales User No
Lead Details Script Report CRM Lead Sales Manager, Sales User, System Manager No
Lead Owner Efficiency Script Report CRM Lead Sales Manager, Sales User, System Manager No
Lost Opportunity Script Report CRM Opportunity Sales Manager, Sales User No
Lost Quotations Script Report Selling Quotation Sales Manager, Sales User No
Maintenance Schedules Query Report Maintenance Maintenance Schedule — No
Material Requests for which Supplier Quotations are not created Query Report Stock Material Request Purchase Manager, Purchase User, Stock Manager, Stock User No
Material Requirements Planning Report Script Report Manufacturing Master Production Schedule Manufacturing Manager, Manufacturing User, Purchase Manager, Purchase User, Stock Manager, Stock User, System Manager No
Negative Batch Report Script Report Stock Serial and Batch Bundle Delivery Manager, Delivery User, Manufacturing Manager, Manufacturing User, Purchase Manager, Purchase User, Stock Manager, Stock User, System Manager No
Open Work Orders Query Report Manufacturing Work Order Manufacturing User, Stock User No
Opportunity Summary by Sales Stage Script Report CRM Opportunity Sales Manager, Sales User No
POS Register Script Report Accounts POS Invoice Accounts Manager, Accounts User No
Payment Ledger Script Report Accounts Payment Ledger Entry Accounts Manager, Accounts User, Auditor No
Payment Period Based On Invoice Date Script Report Accounts Journal Entry Accounts Manager, Accounts User, Auditor No
Payment Terms Status for Sales Order Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Pending SO Items For Purchase Request Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Process Loss Report Script Report Manufacturing Work Order Manufacturing User No
Procurement Tracker Script Report Buying Purchase Order Purchase Manager, Purchase User No
Product Bundle Balance Script Report Stock Stock Ledger Entry Stock User No
Production Analytics Script Report Manufacturing Work Order Manufacturing User, Stock User No
Production Plan Summary Script Report Manufacturing Production Plan Manufacturing User No
Production Planning Report Script Report Manufacturing Work Order Manufacturing Manager, Manufacturing User, Stock User No
Profit and Loss Statement Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Profitability Analysis Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Project Summary Script Report Projects Project Projects Manager, Projects User No
Project wise Stock Tracking Script Report Projects Project Projects Manager, Projects User No
Prospects Engaged But Not Converted Script Report CRM Lead Sales Manager, Sales User, System Manager No
Purchase Analytics Script Report Buying Purchase Order Purchase Manager, Purchase User No
Purchase Invoice Trends Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Purchase Order Analysis Script Report Buying Purchase Order Purchase Manager, Purchase User, Stock User, Supplier No
Purchase Order Trends Script Report Buying Purchase Order Purchase Manager, Purchase User, Stock User No
Purchase Receipt Trends Script Report Stock Purchase Receipt Accounts User, Purchase User, Stock Manager, Stock User No
Purchase Register Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Quality Inspection Summary Script Report Manufacturing Quality Inspection Quality Manager, Stock Manager, Stock User No
Quotation Trends Script Report Selling Quotation Maintenance Manager, Maintenance User, Sales Manager, Sales User No
Received Items To Be Billed Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Requested Items To Be Transferred Query Report Stock Stock Entry Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Requested Items to Order and Receive Script Report Buying Material Request Purchase Manager, Purchase User, Stock Manager, Stock User No
Reserved Stock Script Report Stock Stock Reservation Entry System Manager No
Review Query Report Quality Management Quality Action Quality Manager, System Manager No
Sales Analytics Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Stock User No
Sales Invoice Trends Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Sales Order Analysis Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Order Trends Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Partner Commission Summary Script Report Selling Sales Order Maintenance User, Sales Manager No
Sales Partner Target Variance based on Item Group Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Partner Transaction Summary Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Partners Commission Query Report Accounts Sales Invoice Accounts Manager, Accounts User No
Sales Payment Summary Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Sales Person Commission Summary Script Report Selling Sales Order Maintenance User, Sales Manager No
Sales Person Target Variance Based On Item Group Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Person-wise Transaction Summary Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Sales Pipeline Analytics Script Report CRM Opportunity Sales Manager, Sales User No
Sales Register Script Report Accounts Sales Invoice Accounts Manager, Accounts User No
Serial No Ledger Script Report Stock Stock Ledger Entry Purchase User, Sales User, Stock User No
Serial No Service Contract Expiry Report Builder Stock Serial No Item Manager, Stock Manager, Stock User No
Serial No Status Report Builder Stock Serial No Item Manager, Stock Manager, Stock User No
Serial No Warranty Expiry Report Builder Stock Serial No Item Manager, Stock Manager, Stock User No
Serial No and Batch Traceability Script Report Stock Serial and Batch Bundle Delivery Manager, Delivery User, Manufacturing Manager, Manufacturing User, Purchase Manager, Purchase User, Stock Manager, Stock User, System Manager No
Serial and Batch Summary Script Report Stock Serial and Batch Bundle Maintenance User, Purchase User, Sales User, Stock User, System Manager No
Share Balance Script Report Accounts Share Transfer System Manager No
Share Ledger Script Report Accounts Share Transfer Administrator, System Manager No
Stock Ageing Script Report Stock Item Accounts User, Item Manager, Maintenance User, Manufacturing User, Purchase User, Sales User, Stock Manager, Stock User No
Stock Analytics Script Report Stock Stock Entry Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Stock Balance Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Stock Ledger Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Stock Ledger Invariant Check Script Report Stock Stock Ledger Entry System Manager No
Stock Ledger Variance Script Report Stock Stock Ledger Entry — No
Stock Projected Qty Script Report Stock Item Accounts User, Item Manager, Maintenance User, Manufacturing User, Purchase User, Sales User, Stock Manager, Stock User No
Stock Qty vs Batch Qty Script Report Stock Item Item Manager No
Stock Qty vs Serial No Count Script Report Stock Item Stock Manager, Stock User No
Stock and Account Value Comparison Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Subcontract Order Summary Script Report Buying Subcontracting Order Purchase Manager, Purchase User, Stock User No
Subcontracted Item To Be Received Script Report Buying Subcontracting Order Purchase Manager, Purchase User, Stock User No
Subcontracted Raw Materials To Be Transferred Script Report Buying Subcontracting Order Purchase Manager, Purchase User, Stock User No
Supplier Ledger Summary Script Report Accounts Purchase Invoice Accounts Manager, Accounts User No
Supplier Quotation Comparison Script Report Buying Supplier Quotation Manufacturing Manager, Purchase Manager, Purchase User, Stock User No
Support Hour Distribution Script Report Support Issue Support Team, System Manager No
TDS Computation Summary Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Tax Withholding Details Script Report Accounts Purchase Invoice Accounts Manager, Accounts User, Auditor, Purchase User No
Territory Target Variance Based On Item Group Script Report Selling Sales Order Accounts User, Maintenance User, Sales Manager, Sales User, Stock User No
Territory-wise Sales Script Report Selling Opportunity Sales Manager, Sales User No
Timesheet Billing Summary Script Report Projects Timesheet Accounts User, Employee, Employee Self Service, HR User, Manufacturing User, Projects User No
Total Stock Summary Script Report Stock Stock Entry Manufacturing Manager, Manufacturing User, Stock Manager, Stock User No
Trial Balance Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Trial Balance (Simple) Query Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Trial Balance for Party Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
UAE VAT 201 Script Report Regional GL Entry — No
VAT Audit Report Script Report Regional GL Entry — No
Voucher-wise Balance Script Report Accounts GL Entry Accounts Manager, Accounts User, Auditor No
Warehouse Wise Stock Balance Script Report Stock Stock Ledger Entry Accounts Manager, Stock User No
Warehouse wise Item Balance Age and Value Script Report Stock Stock Ledger Entry Accounts Manager, Sales User, Stock Manager, Stock User No
Work Order Consumed Materials Script Report Manufacturing Work Order Manufacturing User, Stock User No
Work Order Stock Report Script Report Manufacturing Work Order Manufacturing User, Stock User No
Work Order Summary Script Report Manufacturing Work Order Manufacturing Manager, Manufacturing User, Stock User No
Work Orders in Progress Query Report Manufacturing Work Order Manufacturing User, Stock User No
YouTube Interactions Script Report Utilities Video (excluded ERPNext) All, System Manager No

Report Center

A separate, much smaller fixture: erpnext/report_center/accounting.json is the only Report Center record ERPNext v16.29.0 ships, listing 4 reports.

Report
Sales Register
Item-wise Sales Register
Purchase Register
Item-wise Purchase Register

It carries "sidebar": "Accounting", which matches the Accounting desktop-icon folder (see Navigation) rather than any Workspace Sidebar fixture. The field’s target type and render behaviour are unverified here — Frappe, which defines Report Center, isn’t part of this checkout.

Was this page helpful?