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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Opening balances in Trial balance

(0) ShareShare
ReportReport
Posted on by 427

Why opening balances and closing balances option are not available in D365 summary trial balance report.

It is the basic requirement of every client.

I have the same question (0)
  • Suggested answer
    Vaishnavi J Profile Picture
    3,062 on at

    Hi,

    Microsoft have created the column layout in Summary Trial Balance Report for displaying the opening balance and closing balance of each account by default.

    There is no option in the request page to show the data in report based on Opening and Closing option.

    Below is the link for more information.

    docs.microsoft.com/.../trial-balance-financial-reports

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Hi Vaishnavi Joshi I am asking about trial balance in Business central.
    and in my version no filters are available.

    pastedimage1645203959076v1.png

  • Suggested answer
    Vaishnavi J Profile Picture
    3,062 on at

    Hi ,

    Just to confirm you want to have Opening and closing balances of the account in trial balance report?

    if yes then there is separate report for that which is "Trial Balance Detail/Summary"

    if you want as option/filter for opening and closing balance in "Trial Balance Report " there is no standard option/filter available in request page of Trial balance report.

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Yes I need opening and closing .

    Only trial and detailed trial are available.

    pastedimage1645206799039v1.png

    pastedimage1645206854504v2.png

  • Suggested answer
    Vaishnavi J Profile Picture
    3,062 on at

    Hi ,

    Are you a super user or can you check that you have permission to access this Report  ID- 10021- Trial balance Summary/Detail.

    Also let me know what version and localization is your business central 

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Yes Super User.

    pastedimage1645213991388v1.png

  • Suggested answer
    Vaishnavi J Profile Picture
    3,062 on at

    Can you create a test permission sets and then in that permission sets add the report and its id? Refer the below screenshot.

    and assign this test permission sets to yourself and try if u are able to see summary trial balance report 

    pastedimage1645167556910v1.png

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Hi,

    Report Id also not available in permission set,

    May be this functionality not available in our region.

    pastedimage1645214920727v1.png

  • Suggested answer
    Vaishnavi J Profile Picture
    3,062 on at

    Exactly

    You don't have this report in your localization as of now.

    if you want the opening and closing balance in your trial balance report you can go for customization as of now.

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans