Account entry records keeping in AX as normalized tables. Accounting departments always use trial balance report with dimensions. Report date range can be between 6 months and 1 year.  A new summarized ledger report table can be designed with a denormalized table. That table can be fed from General journal account entry documents.