Copy Calculated Field Value to another Decimal column just as a value.

(1) Share

Report

Posted on by Netjacker2097

286

Hi,

Using Item Table as sample, As your aware, Inventory is a calculated flow field. if i was to create another Field inside the items table and wanting to transfer the value from Inventory to the new field.

understanding that each timewe go to the page, it will need to update. this can be handled on the events. How do i transfer the value across?

i thought it was this but i get nother back.:

    local procedure UpdateInvST(ItemNo: Code[20])
    var
        Item: Record Item;
    begin
        if Item.Get(ItemNo) then begin
            Item.CalcFields(Inventory);
            Item.InvST := Item.Inventory;
            Item.Modify();
        end;
    end;

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Dynamics_Decoded_Gokul 478 on at

Like (2)

Report
Copy link

Link copied!

Hi

You can try this method instead of field use a variable in Page

In Page OnAfterGetRecord

if Item.Get(ItemNo) then begin

InvST:= 0;

Item.CalcFields(Inventory);

InvST:= Item.Inventory;

end;

This variable need to initalzed global.

Thanks
Gokulnath

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (1)

Report
Copy link

Link copied!

Thanks, will try it now.

M

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report
Copy link

Link copied!

@Tech_BC_Gokul, i have tried below still not taking the value from inventory to InvST:

trigger OnAfterGetRecord()

begin

if Rec.Get(Rec."No.") then begin

InvST := 0;

Rec.CalcFields(Inventory);

InvST := Rec.Inventory;

end;

end;

var

InvST: Decimal;

Was this reply helpful? Yes No
Verified answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following helps.

Thanks.

ZHU

Was this reply helpful? Yes No