Share
ReportHi,
I wanted to get sum of qunatity from Sales Lines on sales Order Page. Thus, I created Page Extension.
pageextension 50102 SalesOrderLinesPage extends "Sales Order Subform"
{
layout
{
addlast(Control45)
{
group("")
{
field("Total Quantity"; Quantity)
{
ApplicationArea = Basic, Suite;
/* AutoFormatExpression = "Currency Code";
AutoFormatType = 1; */
/* CaptionClass = DocumentTotals.GetTotalExclVATCaption(Currency.Code); */
Caption = 'Total Quantity';
DrillDown = false;
Editable = false;
ToolTip = 'Total Quantity field.';
trigger OnValidate()
var
TotalQty: Record "Sales Line";
decQty: Integer;
begin
TotalQty.Setrange("Location Code", "Location Code");
TotalQty.CalcSums(TotalQty.Quantity);
decQty := TotalQty.Quantity;
Rec."Quantity" := decQty;
end;
}
}
}
}
actions
{
}
}
I am not getting sum of all line item in Total Quantity field. Please anyone can assist me.
Thank you
All responses (
Answers (
291,269
