/
SalesOrderList.al
41 lines (40 loc) · 1.21 KB
/
SalesOrderList.al
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
tableextension 50119 SalesHeaderExt extends "Sales Header"
{
fields
{
field(50100; "Total Quantity"; Decimal)
{
Caption = 'Total Quantity';
DecimalPlaces = 0 : 5;
CalcFormula = sum("Sales Line".Quantity where("Document Type" = field("Document Type"),
"Document No." = field("No.")));
Editable = false;
FieldClass = FlowField;
}
field(50101; "Number Of Lines"; Integer)
{
Caption = 'Number Of Lines';
CalcFormula = count("Sales Line" where("Document Type" = field("Document Type"),
"Document No." = field("No.")));
Editable = false;
FieldClass = FlowField;
}
}
}
pageextension 50119 SalesOrderListExt extends "Sales Order List"
{
layout
{
addafter(Amount)
{
field("Total Quantity"; Rec."Total Quantity")
{
ApplicationArea = All;
}
field("Number Of Lines"; Rec."Number Of Lines")
{
ApplicationArea = All;
}
}
}
}