Hi,
I am trying to get quantity * new weight into custom field Extended Weight. I am using below code. But When I update quantity into one field, it's updating into all line item. Where I am wrong. Please help me solve it.
pageextension 50102 SalesOrderLinesPage extends "Sales Order Subform"
{
layout
{
addafter(Quantity)
{
field("Net Weight"; "Net Weight")
{
ApplicationArea = all;
TableRelation = Item."Net Weight" where("No." = field("No."));
Editable = false;
}
field("Extended Weight"; ExtWght)
{
ApplicationArea = all;
Caption = 'Ext. Weight';
Editable = false;
}
}
modify(Quantity)
{
trigger OnAfterValidate()
begin
UpdateTotalQty();
SalesLine."Extended Weight" := ExtWght;
Message('%1 ExtWght', ExtWght);
Message('%1 SalesLine."Extended Weight"', SalesLine."Extended Weight");
CurrPage.Update();
end;
}
}procedure UpdateTotalQty()
begin
SalesLine.CopyFilters(rec);
ExtWght := Quantity * "Net Weight";
end;
trigger OnAfterGetCurrRecord()
begin
SalesLine.CopyFilters(rec);
ExtWght := Quantity * "Net Weight";
end;
var
SalesLine: record "Sales Line";
ExtWght: Decimal;
}
