Financial
GL analysis, custom tabular reports, and consolidation
Income Statement
Income Statement: custom GL tabular report with Actual, Budget, and prior-year columns
Define and run custom GL tabular reports (income statements, balance sheets, and multi-level detail), then reconcile group consolidation and export to Cognos.
Business outcomes
- Build and run custom GL tabular reports with up to three detail levels and optional waterfall charts
- Compare Actual, Budget, and prior-year columns side by side
- Explore GL accounts with transaction history and year-on-year views
- Reconcile intercompany balances, manage ConsolStructure, and export GL data to IBM Cognos
Modules in this domain
GL Codes
CacheableFull GL code listing with transaction drill-down, purchase orders, and history. Consolidated group view.
GL Tabular Reports
CacheableDefine and run custom GL tabular reports with up to three detail levels, waterfall charts, scoped permissions, and consolidated pivot exports for group companies.
Consolidation Reporting
Intercompany comparison workspace, ConsolStructure tree, ConsolCode GL mapping, matrix management, reporting periods, period locking, attestation, and PDF/Excel export.
Syspro2Cognos
Export Syspro GL data to IBM Cognos: Actuals, Budgets, and Forecasts with streaming export.