skills.rest
nathanabay
nathanabayCOMMUNITY
Explore all skills by this author →
GitHub

frappe-impl-reports

Design and deploy ERPNext reports, dashboards, and charts with SQL and Python.

Updated Aug 23, 2026
Search Tags:#SQL#dashboard#Python#JavaScript#report#ERPNext
One-click install
npx skills add https://github.com/nathanabay/epc_bespo --skill frappe-impl-reports-nathanabay
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: frappe-impl-reports
Source: https://github.com/nathanabay/epc_bespo/tree/main/skills-frappe/impl/frappe-impl-reports
Command: npx skills add https://github.com/nathanabay/epc_bespo --skill frappe-impl-reports-nathanabay

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the creation of various reports in ERPNext, preventing output errors, broken filters, and inefficient SQL queries that hamper large dataset analysis.

Core Features & Use Cases

  • Report Types: Supports Script Reports, Query Reports, Dashboard Charts, and Number Cards tailored for ERPNext data.
  • Construction Guidance: Provides detailed instructions on file structure, code implementation, and visualization techniques for report building.
  • Use Case: A developer needs to generate a sales dashboard with charts and filterable tables; this Skill offers step-by-step guidance to facilitate development and deployment.

Quick Start

Use the frappe-impl-reports skill to understand how to create a query report for sales orders.

Frequently Asked Questions about frappe-impl-reports

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

FAQPage Schema
How do I create a query report in ERPNext for sales orders?▼

Building ERPNext reports requires knowledge of Python and JavaScript coding standards to handle report scripting and chart integration. You need this technical foundation to properly implement file structures, optimize SQL queries, and deploy structured dashboards without output errors or broken filters.

What types of dashboards and visualizations can I build for ERPNext data?▼

You can build Dashboard Charts and Number Cards tailored for ERPNext data. These report types enable you to generate visual sales dashboards by integrating charts and filterable tables through structured report scripting and visualization techniques.

How do I optimize SQL queries in ERPNext reports to handle large datasets?▼

To optimize SQL queries in ERPNext reports for large datasets, you must follow structured report scripting guidelines that prevent output errors and inefficient data fetching. This involves writing clean SQL within Query Reports to ensure smooth analysis performance.

Why does my ERPNext report show broken filters and output errors?▼

ERPNext reports show broken filters and output errors due to improper file structure and unoptimized SQL queries. Following structured report construction guidance ensures correct code implementation and prevents these issues during large dataset analysis.

Related Skills

Explore More Software Engineering Skills→
superyngosuperyngo

dev-prompt

Merge general clean code principles with language-specific rules for Python, Rust, and JavaScript/TypeScript.

Community
Intermediate
delta-and-betadelta-and-beta

analyst-data-export

Export Braze data from dashboard CSVs and Export API responses into analyzable datasets.

Community
Advanced
PatternsDevPatternsDev
235

react-server-components

Server-render React components to reduce client-side JavaScript in Next.js App Router.

Official
Intermediate
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-analytics-reporter

Analyze data, build statistical models, and generate business intelligence reports.

Community
Advanced