How can i create a record in each FA journal for each asset with the asqusition value of the assets

I have taken one data item that is fixed assest and i wrote code on after trigger even thougth the values was not coming.

FADeprBook.RESET;

FADeprBook.CALCFIELDS(FADeprBook.“Acquisition Cost”);

FADeprBook.SETCURRENTKEY(FADeprBook.“FA No.”);

FADeprBook.SETRANGE(FADeprBook.“FA No.”,“Fixed Asset”.“No.”);

IF FADeprBook.FINDFIRST THEN

MESSAGE(’%1’,FADeprBook.“Acquisition Cost”);

it was displaying zeros there.please help me

Hi,

Are you trying to insert the record or you just want to display it in Report ?

Didn you try

FADeprBook.RESET;

FADeprBook.SETCURRENTKEY(FADeprBook.“FA No.”);

FADeprBook.SETRANGE(FADeprBook.“FA No.”,“Fixed Asset”.“No.”);

IF FADeprBook.FINDFIRST THEN BEGIN

FADeprBook.CALCFIELDS(FADeprBook.“Acquisition Cost”);

MESSAGE(’%1’,FADeprBook.“Acquisition Cost”);

END;

This should work… FADeprBook.RESET; FADeprBook.SETCURRENTKEY(“FA No.”); FADeprBook.SETRANGE(FADeprBook.“FA No.”,“No.”); IF FADeprBook.FINDFIRST THEN BEGIN FADeprBook.CALCFIELDS(FADeprBook.“Acquisition Cost”); MESSAGE(’%1’,FADeprBook.“Acquisition Cost”); END;

FADeprBook.RESET;

FADeprBook.SETCURRENTKEY(“FA No.”);

FADeprBook.SETRANGE(FADeprBook.“FA No.”,“No.”);

IF FADeprBook.FINDFIRST THEN BEGIN

FADeprBook.CALCFIELDS(FADeprBook.“Acquisition Cost”);

MESSAGE(’%1’,FADeprBook.“Acquisition Cost”);

END;

thanks now values was coming after that i have written the code to insert the values

FAJour.RESET;
FAJour.SETRANGE(FAJour.“Journal Template Name”,‘Assest’);
FAJour.SETRANGE( FAJour.“Journal Batch Name” ,‘Default’);
FAJour.INIT;
FAJour.validate(FAJour.“Journal Template Name”,‘Assest’);
FAJour.validate( FAJour.“Journal Batch Name” ,‘Default’);
if not FAJour.FINDLAST then
FAJour.“Line No.”:=Line+10000
else
FAJour.“Line No.”:=FAJour.“Line No.”+10000;
FAJour.INSERT