skills.rest
OpenAEC-Foundation
OpenAEC-FoundationOFFICIAL
Explore all skills by this author →
GitHub

frappe-impl-reports

Create ERPNext Script Reports, Query Reports, dashboards, and Number Cards.

163|53|Updated Jan 14, 2026
Search Tags:#permissions#dashboard#sql#filters#report#frappe#erpnext
One-click install
npx skills add https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package --skill frappe-impl-reports
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: frappe-impl-reports
Source: https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package/tree/main/skills/source/impl/frappe-impl-reports
Command: npx skills add https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package --skill frappe-impl-reports

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

ERPNext report builders often encounter misconfigured columns, broken filters, and slow queries that produce empty or incorrect outputs. This Skill provides deterministic patterns and best practices to create Script Reports, Query Reports, dashboards, and Number Cards that behave predictably in production.

Core Features & Use Cases

  • Deterministic reporting templates for Script Reports, Query Reports, Dashboard Charts, and Number Cards.
  • Clear guidance on column definitions, filters, permissions, and performance optimizations to prevent empty results and long runtimes.
  • Use Case: Build a Sales dashboard with accurate filters and responsive charts that stay correct as data grows.

Quick Start

Configure your first report using the included conventions to ensure correct columns, safe filters, and efficient SQL.

Frequently Asked Questions about frappe-impl-reports

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix broken filters and empty outputs in ERPNext reports?▼

To build reliable ERPNext reports, apply deterministic patterns for column definitions, safe filters, and efficient SQL to prevent empty outputs and misconfigured columns in Script and Query Reports.

What is the best way to optimize slow SQL in Frappe Query Reports?▼

The best way to optimize slow SQL in Frappe Query Reports is to enforce performance best practices that prevent long runtimes and ensure queries remain responsive as data grows.

Does this reporting approach work for Frappe v14 and newer versions?▼

Yes, this reporting approach works for Frappe v14 through v16, providing best practices for report composition, permissions, and performance that apply to dashboard charts and Number Cards.

How do I configure dashboard charts and Number Cards in ERPNext without errors?▼

To configure dashboard charts and Number Cards without errors, use deterministic reporting templates that enforce correct column definitions and permissions for accurate, responsive visualizations.

What permissions do I need to set for Frappe Script Reports?▼

Setting permissions for Frappe Script Reports requires following best practices for report composition to ensure safe filters and proper role-based access, preventing unauthorized data exposure.

Related Skills

Explore More Data & Analytics Skills→
Impertio-StudioImpertio-Studio
163

frappe-core-permissions

Implement Frappe permission checks with has_permission hooks and frappe.get_list.

Official
Advanced
marquesfelipmarquesfelip

customer-offboarding

Automate end-to-end customer offboarding workflows for SaaS platforms.

Community
Advanced
anonymousminatianonymousminati

frappe-syntax-print

Design and troubleshoot Frappe print formats and PDF generation workflows.

Community
Advanced
Venkateshvenki404224Venkateshvenki404224
25

frappe-report-generator

Generate SQL-based and Python-based custom reports for Frappe applications.

Community
Intermediate