
Dear Community,
I would like your advice how to best handle the below use case.
What I try to achieve: In a list page feeds from a header kind of table (for example, Warehouse Receipt Header); for each line (1 header) I want to add totals which will be sums or calculation from fields at the line level.
For example, the page Warehouse Receipts is the list of Warehouse Headers; in that page I would like to add fields/columns with the total base quantities, total quantity to receipt, total quantity oustanding, etc.
To be noted: I really want to show these totals within the list; using a pagepart will not fulfil my use case.
Would you please recommend what is the standard ways / most recommended ways to achieve that ?
The fact that we cannot querry the database directly makes it a little counter intuitive at first, so I'm at a loss to understand how to best manage that case.
Thanks for your help and support,
Regards
*This post is locked for comments
I have the same question (0)Why do you want to make it within the list ? You can put it in the page similar to general journal's balance.
If you want it to be inside the list, you need to make the list as temporary table, and insert the record into it. It will be much harder to do that.