Skip to main content
Business Central forum
Answered

New action to Sum all amounts filtered on Sales Order List page

editSubscribe (0) ShareShare
ReportReport
Posted on by 160

Hi mates! :)

I need your help, I created a button on Sales Order List that count all the records (it's ok) and now, I need another one that sum all the amounts of the filtered records.

Something like:

Order 1 -> 20

Order 2 -> 40

Order 4 -> 10

Pressing button (action) and --> Total Amount: 70

pastedimage1646663234924v1.png

Is there any way to do that?

Thanks a lot :)

  • JMartin Profile Picture
    JMartin 160 on at
    RE: New action to Sum all amounts filtered on Sales Order List page

    Thanks Lars!

    That worked :D

  • Verified answer
    RE: New action to Sum all amounts filtered on Sales Order List page

    Hello, just an example below. It is wrong at least on one point that it is totalling Amount, not Amount (LCY), so it will total $, £, etc alike. But I hope it gives you some ideas where to start:

    pageextension 50101 OrderTotals extends "Sales Order List"

    {

       layout

       {

           // Add changes to page layout here

       }

       actions

       {

           addfirst("F&unctions")

           {

               action(GetTotal)

               {

                   ApplicationArea = all;

                   Caption = 'Get Total';

                   trigger OnAction()

                   var

                       SalesHeader: Record "Sales Header";

                       Total: Decimal;

                   begin

                       Total := 0;

                       SalesHeader.copy(Rec);

                       if SalesHeader.FindSet() then

                           repeat

                               total := total + SalesHeader.Amount;

                           until SalesHeader.Next() = 0;

                       Message(Format(Total));

                   end;

               }

           }

           // Add changes to page actions here

       }

       var

           myInt: Integer;

    }

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 45,235 Super User on at
    RE: New action to Sum all amounts filtered on Sales Order List page

    You can start from here

    docs.microsoft.com/.../devenv-dev-overview

  • JMartin Profile Picture
    JMartin 160 on at
    RE: New action to Sum all amounts filtered on Sales Order List page

    Hi Mohana :)

    How can I do that?

    Thanks! :)

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 45,235 Super User on at
    RE: New action to Sum all amounts filtered on Sales Order List page

    You can loop through all orders and assign the Amount a Sum variable and display the message at the end.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans