News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Filter trial balance b...

Business Central forum

Suggested answer

Filter trial balance by dimension values

(1) Share

Report

Report

Posted on by TB-21061741-0

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:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 62,823 Super User on at

Like (0)

Report

Filter trial balance by dimension values

Hi, Unfortunately, there is no such field in the standard API and this needs to be customized.

https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2TrialBalance.Page.al

More details:

Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Thanks.

ZHU
Tech_BC_Gokul 247 on at

Like (0)

Report

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

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,781 Super User

#2

Martin Dráb 225,348 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans