MODULES / FINANCE
Excel Report Designer
Save personal Excel column layouts for registered ASKERP reports.
Overview
| Module id | ask_excel_report_designer |
|---|---|
| Version | 1.0.0 |
| Who uses it | Anyone who uses the screens listed below. |
| Installed | On demand, from Settings → Modules. Anything it needs is installed with it. |
Where to find it
| Reports / Tools | Excel report designer |
|---|
The menu entries appear once the module is installed and your role allows them.
How it links to other modules
- Needs: Accounting
- Works better with: Invoicing, Vendor Bills, Inventory, Stock Ledger Report, Payment Analysis, Customer Recovery Summary, Aging Recovery Letters, Daily Accounting Books
- Needed by: no other module
A module that is needed cannot be turned off while the module that needs it is on.
Details
Excel Report Designer
Optional adaptation of D:/Odoo18/sparkosol/addons.odoo18/excel_report_designer. Install Excel Report Designer in Settings → Modules. Open any permitted report and choose Design Excel, or use Reports → Excel report designer.
Choose columns and their order from the selected ASKERP report, then save a private layout for your own account. XLSX output uses that report's current filters, rows, money precision and source data. Layouts are company and user isolated. Owners can update or remove their layouts; disabling the addon hides and refuses designer and custom export actions while preserving layouts for reinstall.
Only columns declared by the registered report are accepted. Export checks the full source report's control rows before omitting columns, so hiding a check column cannot bypass a mismatch block. Custom exports use the usual report permissions, module gates and report-export audit event.
This is intentionally not an arbitrary model/field query builder. The Odoo source can select arbitrary ORM models and includes executable server-action choices; ASKERP exposes neither capability. It also does not add formulas, SQL filters, shared/public layouts or PDF layout editing. No accounting or source documents are changed.
Migrations 0107_excel_report_layouts.sql and 0108_excel_layout_user_rls.sql store ordered column keys under company RLS and an authenticated-user policy. Validation: npx vitest run addons/ask_excel_report_designer lib/modules.test.ts lib/nav.test.ts server/reports/registry.test.ts.