News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Filter Totals

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

Suggested answer

Filter Totals

(2) Share

Report

Report

Posted on by JE-20081519-0

601

Hi:

In such screens as the Customer List, what is "filter totals" used for?

Thanks!

John

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Suresh Kulla 44,565 on at

Like (0)

Report

Filter Totals

Those are flowfilters on the table, which are used for the calculation of some flowfields so based on the filters you specify those field calculations will change.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-flowfields-and-flowfilters
Suggested answer

JAngle 63 on at

Like (0)

Report

Filter Totals

Filter totals apply to fields called flowfields. On the customer table balance is a good example. It is a calculated field and it has a drilldown to the customer ledger entries. Within customer ledger entries you have posting date. So the date filter you see on the customer list will manipulate the posting date on the related table, which again in this case is the customer ledger entries. These types of filters and flowfields appear throughout the system. On the item table the inventory field is another good example. For an even better explanation check out the docs: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfilter-overview

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,479 Super User 2025 Season 1

#2

Martin Dráb 231,295 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans