Skip to main content



No record found.

Business Central forum
Suggested answer

Filter trial balance by dimension values

Posted on by 2
Does anyone know if there's a way to add dimension filters to the trial balance in the the d365 business central api?

This is the endpoint I'm referring to:

Get trialBalance - Business Central | Microsoft Learn

I heard something about a global dimension filter, but I haven't found any information on how to use it with the standard api.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,992 Super User on at
    Filter trial balance by dimension values
    Hi, Unfortunately, there is no such field in the standard API and this needs to be customized.
    More details:
    Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs
  • Tech_BC_Gokul Profile Picture
    Tech_BC_Gokul 263 on at
    Filter trial balance by dimension values
    the global dimension are table field names but if you have done the setups in general ledger you can find the field names as in the dimension name pages

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 . . .


André Arnaud de Calavon Profile Picture

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

Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans