function getExchangeRate(baseCurrency, sourceCurrency) {
try {
let exchangeRate = 0;
let currencyrateSearchObj = search.create({
type: search.Type.CURRENCY_RATE,
filters:
[
["basecurrency", "anyof", baseCurrency],
"AND",
["transactioncurrency", "anyof", sourceCurrency]
],
columns:
[
search.createColumn({ name: 'internalid', sort: search.Sort.DESC }),
search.createColumn({ name: 'effectivedate', sort: search.Sort.DESC }),
search.createColumn({
name: "exchangerate",
label: "Exchange Rate",
}),
]
});
currencyrateSearchObj.run().each(function (result) {
exchangeRate = result.getValue({
name: "exchangerate",
label: "Exchange Rate"
});
return false;
});
log.debug('exchangeRate',exchangeRate);
return exchangeRate;
}
catch (e) {
log.error("Error @ getExchangeRate", e);
return null;
}
}