Changing condition base value in billing.
In sales order,for certain condition types, when document currency is different from condition currency, system would apply exchange rate. For example if base value is 100USD, then condition value will be 122CAD. ( system would have applied exchange rate of 1.22)
In the billing document system converts the 122CAD to per quantity amount and carries this to base value. for example in sales order if 10 qty costs 100 USD, in biling document the base value is 12.2CAD.
I am wondering why it copies 122 CAD or 12.2 CAD, instead of 100USD.
Now, since both base and document value is in CAD, no exchange rate is applied at the time of billing. If system had copied USD value as such from order, there wuldn't be a probelm.
Our exchange rates are dynamic and hence we want to calculate the exchange rate at billing time. How to proceed?
Thanks in advacne,