Converting price

KarinTauber

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?

Sai_Bharadwaj_Venati

hi, have you used lookup formula? ⇒ IF SKU Currency = USD then 1 else FX01.exchange rate[lookup:sku currency]

KarinTauber

Sai, thanks for the reply

Yes, I have

Dikshant

@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.

KarinTauber

@

KarinTauber

@Dikshant

Thanks, I found the issue though.

the lookup wasn't a list.

Thanks! 😊