Dear all,
i am stuck with the al code for doing this issue.
. In the Job planning Lines Page, there are Columns called Qty and Qty to Transfer to Journal. we need to add one column after Qty to Transfer Journal with the total of items already transferred to the journal based on the Qty Column (if the type is Item) and Posted that Jorurnal
Here in the screen shot, the 1st line Total Qty is 100 and we transferred 43 so in total Qty Column Transferred also should come 43. if we transfer the again 10 from the total of 100 Qty then total transfer Column should update 43+10 = 53
once fully transferred then it should be same as Qty column.
pageextension 60201 "Total Qty-Job Planning Lines" extends "Job Planning Lines"
{
layout
{
// Add changes to page layout here
addafter("Qty. to Transfer to Journal")
{
field("Total Tranfer Qty";Rec."Total Tranfer Qty")
{
ApplicationArea = all;
Caption = 'Total Transferred Qty';
Editable= false;
}
}
}
trigger OnAfterGetRecord()
var
QtyTotal : Record "Job Planning Line";
begin
QtyTotal.Reset();
QtyTotal.SetRange("Type", QtyTotal."Type"::Item);
end;
}
