Small and medium business | Business Central, N...

How to manage the parameters and available fields in business central report ?

(0) Share

Report

Posted on by Basem Ibrahim

Dear All,

Hope all are doing well.

I'd like to ask you, how I can add some fields for the available fields in Filter: G/L Account in Detailed Trial Balance in Business Central ? For ex, I need to add some of Shortcut Dimensions to use it for filter. So, How I can do that? and, Will it require customizations or not ? and If it will require customization, how I can processes it.

Kind regards,

Thanks

Categories:

Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (0)

Report

How to manage the parameters and available fields in business central report ?

Hi, this needs to be customized, you need to use Report Extension.

https://yzhums.com/10723/

But as HVGEEL mentioned, it might be better to use the Financial Report (Account Schedule) feature.

Also you can try the new In-client Analysis mode, although this has a row limit.

More details: https://yzhums.com/35080/

Hope this helps.

Thanks.

ZHU
Suggested answer

HVGEEL 288 on at

Like (0)

Report

How to manage the parameters and available fields in business central report ?

This will require customization, if having the values available in the Detailed Trial Balance, filtered per dimensionvalue is a hard requirement.

If content has higher priority than form (which should always be the case, imho) there is an easy workaround:

There is standard functionality, doing éxactly that: if you inject the entire CoA into a Financial Report, you can perfectly achieve the very same result.