The Silverdale Enhance JSON Import/Export with Analytic Names feature solves a critical usability challenge in exporting analytic data. In standard Odoo behavior, analytic account distributions (used in journal items, invoices, order lines, etc.) are stored in JSON format and, when exported, display technical database IDs. This format is difficult to interpret, often requiring manual cross-referencing with a separate list of analytic account names.
This feature enhances the export process by automatically converting those internal IDs into user-friendly analytic account names, greatly improving clarity and saving time during data analysis.
What It Does
- Updates the export logic for fields that store analytic distributions in JSON.
- Replaces internal IDs (analytic_account_id) with analytic account names in the exported output.
- Applies to any export from models like:
- Journal Items
- Invoice Lines
- Sales Order Lines
- Purchase Order Lines
User Steps
- Navigate to Accounting > Journal Items (or any other model using analytic distributions).
- Click on Favorites > Export and select a custom export template that includes the field for Analytic Distribution.
- In the exported file:
- Previously: You would see entries like {"3": 50.0, "7": 50.0} (where 3 and 7 are database IDs).
- Now: You will see entries like {"Marketing": 50.0, "Consulting": 50.0}.
Benefits
- Improved readability of exported data for accounting and business users.
- No need to manually match IDs with account names, reducing time and risk of error.
- Supports better decision-making by presenting clear analytic allocation data.
- Compatible with standard Odoo export workflows and templates.
This feature is particularly useful for companies that use analytic accounting with multiple departments, projects, or cost centers and regularly export financial data for reporting or review. With this enhancement, your exported reports are cleaner, clearer, and ready to use—without extra data manipulation.
Enhance JSON Export With Analytic Names