Need to get the latest price for an item but the conversion should be from a particular past date
Hi,
we are working on Quoting and Advance Pricing.
we have setup a Multi Currency enabled price list.
Now the issue is - we have a case where in the quote is created on for example todays date with X item at $10 and conversion from USD to Rs is say 60.
So Item price is Rs.600
But the negotiation process took time and it took 10 days.
After 10 10 days, the price of X item is $12 and the conversion rate is say 70. so the latest price of the Item is Rs.840.
Now, we want the price to be $12 but the conversion rate should be 60. So as per our requirement the price should be Rs.720.