Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

GL Trial Balance with All Dimensions

Posted on by 1,355

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

  • Suggested answer
    DF-19061705-0 Profile Picture
    DF-19061705-0 3 on at
    GL Trial Balance with All Dimensions
    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!
     
     
     
     
  • Tom_ikapa Profile Picture
    Tom_ikapa 52 on at
    RE: GL Trial Balance with All Dimensions

    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
    WhatWhyHow Profile Picture
    WhatWhyHow 150 on at
    RE: GL Trial Balance with All Dimensions

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans