Converting price
I have a module called FX01 Currency Rates. It has 6 Currencies and their rates for 2024, monthly.
I have another Module called REV04 Sales Volume Budget. where by customer and SKU there's an input for volume and price. The price is by SKU currency. The SKU currency is brought in a line item. I want to have a rate line item where it does the following;if the SKU currency is USD then bring 1 (that is the base currency therefore USD is always 1) if it is not USD then refer to the FX01 Currency Rates module and bring the corresponding rate
I have tried multiple options, but none of them would pull the data
what am I missing?
Answers
-
hi, have you used lookup formula? ⇒ IF SKU Currency = USD then 1 else FX01.exchange rate[lookup:sku currency]
V.Sai Bharadwaj
0 -
Sai, thanks for the reply
Yes, I have
0 -
@KarinTauber - Can you share the screenshot of FX01 module ? I think that module might have a different dimension or have rates on yearly level ? If that is the case then we need to lookup based on that as well.
0 -
@
0 -
0