📝 Adding Notes to Financial Report Lines 📊
An AL extension adds line-level notes to financial reports (Account Schedules) in Business Central, allowing users to document explanations directly within reports instead of maintaining separate documentation. Notes appear in the definition page, matrix overview, printed reports with synchronized numbering, and Excel exports.
post Gerardo Rentería Blog
"Some users in monthly closing meetings always had to keep additional separate documentation to explain things."
Key points
- Two new fields added to Account Schedule lines: Has Notes (calculated) and Note Text with edit dialog
- FactBox in Account Schedule Overview shows notes for selected lines with direct edit actions
- Reports include superscript indices in descriptions and a synchronized NOTES TO FINANCIAL STATEMENTS section
- Excel export includes a bold Notes column with all line notes and preserved formatting
- Solution supports CFO/controller presentations, auditor documentation, and analyst variance comments
Quotes
- “Some users in monthly closing meetings always had to keep additional separate documentation to explain things.” (Identifies the core problem this extension solves: keeping explanations separate from financial reports.)
- “The idea is to keep notes within the financial report, carrying its own context without external documentation.” (Summarizes the extension’s goal of making financial reports self-contained with embedded explanatory context.)
- “Edit Note actions allow editing notes without leaving the matrix.” (Demonstrates improved user experience by enabling direct note editing within the report overview interface.)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- page “Acc. Schedule Names”
- page 490 “Acc. Schedule Overview”
- table 85 “Acc. Schedule Line”
- page “GDRGAccScheduleNoteFactBox”
- page “GDRGEditNoteDialog”
- report “GDRGExportAccSchedToExcel”
Not found in BC28-30: page “Acc. Schedule Names”, page “GDRGAccScheduleNoteFactBox”, page “GDRGEditNoteDialog”, report “GDRGExportAccSchedToExcel”.
Context
- Features: Line-level notes on Account Schedules, Note Text field with drill-down editing, Has Notes calculated field, FactBox for note visibility, Synchronized superscript numbering in reports, Notes to Financial Statements section, Excel export with Notes column, RDLC layout customization
Source: Gerardo Renteria, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.