Sales Order Screen Show Subtotals

(0) Share

Report

Posted on by Samantha73

3,255

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)

All responses (3)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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.

Hope this info also helps.

Thanks.

ZHU

Was this reply helpful? Yes No