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

(1) Share

Report

Posted on by Netjacker2097

256

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;

Categories:

Development

Reports and Business Intelligence

Inventory and warehouse management

Purchasing

All responses (4)

Answers (1)

Verified answer

YUN ZHU 69,202 Super User 2024 Season 2 on at

Like (1)

Report

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

Hi, hope the following helps.

Thanks.

ZHU
Netjacker2097 256 on at

Like (0)

Report

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

@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;
Netjacker2097 256 on at

Like (1)

Report

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

Thanks, will try it now.

M
Suggested answer

Tech_BC_Gokul 267 on at

Like (2)

Report

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

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