web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Page List - Add totals to a list from a header table

(0) ShareShare
ReportReport
Posted on by

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)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,284 Super User 2025 Season 2 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans