Adding new field which will contain multiplication values of other two fields

Dear All,

I want to add a new field in invoice journal.

Path: Accounts payable-> Inquiry->Journals-> Invoice Journal.

In Invoice Journal screen, the currency field contains USD or EURO(suppose).

i want to add new field ‘totalamount’ which will calculate the multiplication of currency and invoice amount only for USD(USD * exchange value= EURO ) values and wants to see value only in EURO .

Exchange rate is already there in exchange rate field.

My question is in which method and where i should write the logic.




You should add your logic your table modifiedfield method so if you modify your invoice amount it will be calculated automatically. If your table doesn’t have this method, just create it, you can see a lot of tables in AOT that have this method.

Hope it helps