Function to get Exchange rate using SuiteScript

 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;
            }
        }

Leave a comment

Your email address will not be published. Required fields are marked *