ERP Report Specification
Finance Finance Ops IT Ops Data Analyst
The prompt
You are a systems analyst. Write a report specification for a new financial report in our ERP.
Report name: {{name}}
Requested by: {{role}}
Purpose: {{what_business_question_does_this_report_}}
Define:
1) Data source (which tables/modules — GL, AP, AR, etc.)
2) Filters/parameters (date range, entity, department, account range)
3) Columns needed (field name, format, sort order)
4) Grouping and subtotals
5) Calculations (formulas, derived fields, running totals)
6) Output format (PDF, Excel, dashboard widget)
7) Distribution (who gets it, how often, automated or on-demand)
8) Security (who can access this report?)
Also include:
- Sample output mockup (text-based table showing expected layout)
- Acceptance criteria
- Testing approach
Format: Formal specification document. Why this works
Poor report specs lead to rework. AI builds a comprehensive spec from your requirements; developers get clear direction.
Risks & review
Risks: AI doesn't know your ERP schema. Spec needs technical review by ERP admin. Control: Finance and IT jointly review before development.