Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Filter trial balance by dimension values

Posted on by 2
Hello,
 
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.
 
Thanks
Categories:
  • 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
     
    Thanks.
    ZHU
  • Tech_BC_Gokul Profile Picture
    Tech_BC_Gokul 263 on at
    Filter trial balance by dimension values
    Hi 
     
    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
     
    thanks
    gokulnath

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,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans