Hi, is there a way to convert the rate from from t...
# general
l
Hi, is there a way to convert the rate from from the transaction in one currency to another, both ways, without the need to add the price in both price level? Like this: Currency 1 Price Level A QTY 0 = 10 Currency 2 (System Currency) Price Level A QTY 0 = (Empty/Null) It should convert based on the Exchange Rate. (Currency1.PriceLevelA * ExchangeRate.CurrencyRate)
m
You can create a script to automatically update the price level in Currency 2 based on the price level in Currency 1 and the current exchange rate. Or Create a custom field on the item record for your converted price, and create a workflow that updates this field whenever the item price or exchange rate changes. Use a formula to calculate the converted price based on the original price and the exchange rate.
l
We are currently doing/using something like that, its a script that takes about 6-9 hours to complete cause of the amount of sku (about 86k). Now we are trying updating the Rate directly when the line item is added, based on the currency (Exchange Rate) of the Transaction.