web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

GL Trial Balance with All Dimensions

(0) ShareShare
ReportReport
Posted on by 1,114

Is there a solution available in Business Central to generate a Trial balance with all dimensions similar to Dynamics GP or SL.  Our client will want something like the following where the sub-account are the BC dimensions.  Such a presentation is integral in both SL and GP.  Clients transitioning need to be able to view accounts in the same manner.  Is there such an option available?  Please advise.  Thank you.

pastedimage1674234139940v1.png

JG

I have the same question (0)
  • Suggested answer
    CU11121527-0 Profile Picture
    4 on at

    Hello,

    I don't think there is a report that looks like that out of the box. You may have to take an existing report and customize it. However, try these reports out of the box and see if it works for you.

    pastedimage1674243645673v1.png

  • Tom_ikapa Profile Picture
    56 on at

    There is also the Finance...Chart of Accounts menu option. This has the life to date values, but you could filter that to show the period that you are looking for.

  • Suggested answer
    DF-19061705-0 Profile Picture
    5 on at
    Hi,
     
    Open the General Ledger Entries window.  There are columns for the Dimensions - add the ones you need. 
     
    Use the "Open In Excel" command to export the data to Excel.  Concatenate the account code and the dimension values.
     
    Not pretty, but it worked!
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 572 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 331 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 330 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans