You’re offline. This is a read only version of the page.
3,255
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
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.
Share
Report
All responses (
Answers (
