Hi ..
Please check the below code for flowing filed value from Item Table to Item Ledger entry table. i may made some changes in your coding, am using flow field to flow data from Item table to Item ledger entry table, and also please check you Item card page new field mapping, the should be Filed caption and second should be the Field Name(from Item Table).
1. Item Table
--------------------
tableextension 50101 MyNewItemTable extends Item
{
fields
{
field(50000; QtyAvailabe; Decimal)
{
Caption = 'Qty. Availabe';
}
}
var
myInt: Integer;
}
2. Item Page
----------------
pageextension 50101 MyItemPageExt extends "Item Card"
{
layout
{
addafter("Qty. on Purch. Order")
{
field(QtyAvail; QtyAvailabe)
{
Editable = false;
Caption = 'Quantity Availabe';
ApplicationArea = All;
}
}
}
trigger OnAfterGetRecord()
var
myInt: Integer;
begin
QtyAvailabe := Inventory - "Qty. on Sales Order";
Modify(true);
end;
var
}
3. Item Ledger Entry Table
-----------------------------
tableextension 50102 MyILETableExt extends "Item Ledger Entry"
{
fields
{
// Add changes to table fields here\
field(50000; QtyAvail; Decimal)
{
FieldClass = FlowField;
CalcFormula = sum (Item.QtyAvailabe where("No." = field("Item No.")));
Caption = 'Quantity Available';
}
}
var
myInt: Integer;
}
4. Item Ledger Entries Page
-------------------------------
pageextension 50102 MyILEPageExt extends "Item Ledger Entries"
{
layout
{
addafter("Remaining Quantity")
{
field(QtyAvail; QtyAvail)
{
ApplicationArea = All;
}
}
}
var
myInt: Integer;
}
OutPut:-
Item Card
-------------------------
Item Ledger Entry
---------------------------
