List page with sum and grouping

(0) Share

Report

Posted on by Samantha73

2,975

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

All responses (1)

Answers (0)

Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: List page with sum and grouping

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.