Chart of Accounts, Dimensions, and Account Structures
M3's financial reporting starts with the chart of accounts in CRS630 and the seven accounting dimensions (division, accounting identity 1-7). Dimension structures in CRS632 define how transactions are categorized for reporting—by cost center, project, product group, region, and custom dimensions. Well-designed dimension structures enable drill-down analysis without requiring chart of accounts changes, while poorly designed structures create reporting dead ends that require expensive restructuring.
- Design chart of accounts in CRS630 with 7-10 digit account numbers using hierarchical grouping for roll-up reporting
- Configure accounting dimensions in CRS632: AIT1 (cost center), AIT2 (project), AIT3 (product), AIT4-7 (custom)
- Set up account dimension rules in CRS635 to enforce valid dimension combinations and prevent posting errors
- Use CRS640 to define reporting structures that group accounts into P&L categories and balance sheet classifications
- Implement intercompany elimination accounts in CRS630 for consolidated financial reporting across M3 companies
GLS200 Report Writer and Budget Configuration
GLS200 is M3's built-in financial report writer that produces formatted financial statements from GL data. Report templates define row layout (accounts or account groups), column layout (periods, budget comparison, variance), and calculation rules (subtotals, ratios, percentages). Budget structures in BUS100 support top-down and bottom-up budgeting with version control, enabling actual-vs-budget variance analysis directly in GLS200 reports.
- Create GLS200 report templates with row definitions from CRS640 account structures for consistent P&L formatting
- Configure column definitions for period comparisons: current month, YTD, prior year, and budget columns
- Set up BUS100 budget versions with annual, quarterly, and monthly granularity for variance analysis
- Enable GLS200 drill-down capability: report row → account detail → individual voucher for audit trail
- Schedule automated report generation via GLS200 batch jobs for month-end distribution to management
Multi-Company Consolidation and Period-End Closing
Organizations running multiple M3 companies require consolidated financial reporting. M3's consolidation process in GLS840 collects balances from subsidiary companies, applies currency translation, eliminates intercompany transactions, and produces consolidated financial statements. Period-end closing in GLS900 ensures all transactions are posted, allocations are executed, and the period is locked before reporting.
Netray AI agents can automate close checklists and validate cross-company eliminations.
- Configure GLS840 consolidation rules: source company mapping, currency translation method (current rate, temporal, functional)
- Set up intercompany elimination rules in GLS845 for automatic removal of intercompany AR/AP and revenue/cost
- Implement GLS900 period-end close checklist: allocation runs, revaluation, accruals, depreciation, and reconciliation
- Enable GLS910 year-end closing with retained earnings transfer and opening balance generation
- Use Netray AI agents to validate period-end close completeness and flag anomalous GL entries before sign-off
Try it here, free
ERP Report Rationalization Checklist
A step by step checklist to find, review, merge and retire ERP reports without breaking anyone's month end.
Modernize your M3 financial reporting with AI-powered automation—schedule a Netray consultation.