pressi
January 28, 2013, 7:26am
1
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;
pressi
January 28, 2013, 9:41am
6
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