Skip to Content
0
Former Member
Jun 10, 2010 at 02:57 AM

Pricing - adjustment

15 Views

hei all,

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.

thanks

Best Regard,

Hendry