Share
ReportI need to display sum of all lines quantities available on Sales order list page
Any help would be appreciated
You’re offline. This is a read only version of the page.
I need to display sum of all lines quantities available on Sales order list page
Any help would be appreciated
Hi, you can refer Amount to create a flowfield field.
For example,
All responses (
Answers (
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
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 ?
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
