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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Sales Order Screen Show Subtotals

(0) ShareShare
ReportReport
Posted on by 3,301

Hi All

Is there a way to show subtotals on Sales Order, Sales Line Subpage. Either based on standard fields like item category or based on a custom field (or even comment start and end) I know we can do this in RDLC layout but on the screen itself is it possible?

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi

    We had a similar setup (development) but after a while we opt out and decided to use Action in page that generate summery on screen for review (on for sure report to print). These are what we have learned.  

    1) We used Factbox and the reason was it had less impact on performance and more room. But we tested fields in page but it was not ideal. 

    2) We used Custom Field and needed to keep the options minimum. Since in the page or in the factbox we needed to define them to show sub-total. Anytime we need to add a new "value" to custom field it was a development to add that value to factbox for total purposes. Hence, we need to deal with lots of limitation. 

    3) It impacted BC performance (SaaS) because of all calculation. 

    The short answer is yes it is possible but need some pre-evaluation. 

  • Suggested answer
    Dallefeld Profile Picture
    233 User Group Leader on at

    I would love to see this on many screens in BC. I had a client write this on several screen in NAV and it's super helpful.

  • Suggested answer
    YUN ZHU Profile Picture
    100,850 Super User 2026 Season 1 on at

    I'm in favor of MahGah's practice of displaying this data in Factbox, as this will not affect performance when you don't display Factbox.

    Also, you can integrate Power BI reports in Factbox for more information.

    pastedimage1649638706229v1.png

    Hope this info also helps.

    Thanks.

    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,961 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,211 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,141

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans