Announcements
I need to display sum of all lines quantities available on Sales order list page
Any help would be appreciated
The quantity for one spesific item?
That you can find on the item page in the field quantity on sales order.
Or are you talking about another quantity ?
Hi, you can refer Amount to create a flowfield field.
For example,
tableextension 50111 MyExtension extends "Sales Header" { fields { field(50100; Quantities; Decimal) { CalcFormula = Sum("Sales Line".Quantity WHERE("Document Type" = FIELD("Document Type"), "Document No." = FIELD("No."))); Caption = 'Quantities'; Editable = false; FieldClass = FlowField; } } } pageextension 50111 MyExtension extends "Sales Order List" { layout { addafter(Amount) { field(Quantities; Rec.Quantities) { ApplicationArea = All; } } } }
Hope this 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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,050 Super User 2026 Season 1
YUN ZHU 1,351 Super User 2026 Season 1
Grigorios Mavrogeorgis 1,200 Super User 2026 Season 1