Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Show sales order amount total on sales order form

(1) ShareShare
ReportReport
Posted on by 24
When adding the column /Total amount/ to the sales form, only zeros display for each order. How can I get the order total amounts to show on this form?
//
  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    Show sales order amount total on sales order form
    Using the new capabilities of grids is nice indeed, but net amount is in the currency selected on the line, isn't is? Therefore just putting net amounts together, regardless of currency, will give you a meaningless result if all lines don't share the same currency.
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,836 Super User 2024 Season 2 on at
    Show sales order amount total on sales order form
    Hy Jack,
    i can not provide a complete solution for your request as the totals are not saved to a table and the total value is not a column that could be added with the standard to the sale order list form.
     
    As a compromise you can do this one for open Sales Order (and even all Orders). You need to have "saved views" activated in the features.
     
    Open the Sales and marketing/Sales Orders/"Open sales order lines" list page.
    Here you can add the column "Net amount"
    On the "Sales Order" column right click and select "Group by this column"
    On the "net amount" column right click and select "View column totals" as "Sum"
    Save the view as a personal view and distribute to user or security group if this is good for your requirement.
     
     
    May be the "net amounts" are not finally correct because of charges or discounts on line or header level.
     
    Additional you can adjust some filters for the "open sales order line" form on the "advanced filter and sort" form.
    Just adopt you selection for the Line status and order type you want to see on the list form.
     
    E.g. filter for all order types and all order status looks like this:
     
     
    When you have confirmed the filter save this as a "personalized view" with a fitting name, and even if you want to be this the standard view for the "Open sales order line" form select "Pin as a default".
     
    Now every time you select "Open Sales Order lines" menu item this form will be opend and display all sales order lines (not even open lines) and the sales order lines grouped by Sales order and summed by net amount.
    Isn't that fantastic?
    I think it is good, but for now it is not complete as we can not collapse or expand all grouped sales Orders, this has to be done by each sales order. 
     
     
    You can also add some sorting criteria as you want to see to newest SO on the top.
     
    Hope this helps.
     
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
     
     
     
  • Ramit Paul Profile Picture
    Ramit Paul 22,302 Most Valuable Professional on at
    Show sales order amount total on sales order form
    Hi,
     
    We have done this customization as Andre suggested, please note since this is a calculation runtime, we faced a slight slowness while opening up the SO form, however that was manageable, may be for low volume of data..
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at
    Show sales order amount total on sales order form
    Hi Jack,
     
    SalesTotals are not stored in the sales order table. They are online calculated when you open the Sales totals form. In case you want to have the column, you would need to go for a customization. Also, you might expect challenges on keeping the totals up to date and performance.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans