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
Is there any way to do that?
Thanks a lot :)
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;
}
You can start from here
You can loop through all orders and assign the Amount a Sum variable and display the message at the end.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (