web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... List page with sum and...

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

Suggested Answer

List page with sum and grouping

(0) Share

Report

Report

Posted on by Samantha73

3,315

Hi All

I'm trying to create a list page based on the warehouse entries table that sum up the quantity on hand and group by item, bin and lot. I know how to do this is a Query object but how can I do this in a list page? Haven't found nay examples from the base App.

Thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

The most BC like way would be to add fact boxes showing bin content and lots for every items number.

If you want to show it in a two dimensional list page i think you will have to loop through all the items, and for every items you loop through all the bins holding that item and every lot. containing that item. Then you populate those data into a new table and use that table as the source data item for your list page.

Some lines of codes, but completely doable.

But i like to do as much as possible the "BC way" and then i think the fact boxes are the way to go at least if it is only for displaying the data.

A different scenario if it is for reporting. Then maybe you should build a custom api and present the data in Excel or Power BI.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,216 Super User 2026 Season 1

#2

YUN ZHU 1,471 Super User 2026 Season 1

#3

AndrewThomas81 1,369

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans