currency exchange rate table can be used on workflow ( workflow action script ) or script

AI generated answer (using internal Slack threads):

Yes, you can use the currency exchange rate table in a workflow action script or a SuiteScript. However, it's important to note that you cannot directly use the exchange rate in a formula on a Set Field Value action in a workflow. You would need to create a custom script to retrieve the exchange rate first. For example, if you want to convert the rate from one currency to another, you can create a script to automatically update the price level in the second currency based on the price level in the first currency and the current exchange rate. Alternatively, you can 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. If you want to add a new currency exchange rate using a SuiteScript, it's not directly supported to create individual exchange rate records. However, you can trigger a CSV import task using the N/task module. You would need to create an exchange rate saved CSV import, put the file in the file cabinet, and then have a script run on schedule to read the file from the file cabinet and trigger the CSV import task using the N/task module. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******