i have these requirement, please propose ur idea for helping me..
price of material is determined based on fuel rate and exchange rate. first of all, cust has made an agreement about Bo (fuel rate in aggrement) and Co (exchange rate in agreement). Ci = average exchange rate in one month. Bi = average fuel price (based on purchase order).
formula : (Bo/Co)(Bi/Ci)
my query is can we do that? and in what field we can store Bo, Co, Ci, Bi in sales order?
i really appreciate your idea.