We have a number of mudules 1)Product 2)Client 3)Sales order etc.

In Product we have a field called "Commission" a %'age.

In Sales order we have a field called Total amount.

I would like to make a new field in "Sales order", that is a calculation of Total amount * Commission / 100, calculated and stored when record is stored.

Is there a possibility to do so`?

As far as I can understand only fileds in same module can be a part of a formula.

Thanks in advance