FX rates used in NetSuite to record sales and COS, we understand that these are driven by the rates set at the creation of the source sales order and purchase order. Is it possible to change the exchange rate on a certain date in the system so that revenue postings convert at the rate as of the billing date and COS convert at the rate as of the goods issued/invoiced date?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** In NetSuite, the exchange rate used for transactions is typically determined by the transaction date. If you change the transaction date, the system should automatically adjust the exchange rate accordingly, assuming a rate exists for that date. However, this behavior can be influenced by other factors such as workflows and scripts. If you're seeing the same exchange rate for different transaction dates, it could be due to the lack of default exchange rates for those specific dates. Also, make sure your currency rates are set to automatically update in NetSuite. Regarding your question about changing the exchange rate on a certain date in the system so that revenue postings convert at the rate as of the billing date and COS convert at the rate as of the goods issued/invoiced date, it's important to note that the exchange rate on transactions like Sales Orders and Item Fulfillments is typically locked in at the time of creation and cannot be changed afterwards. However, it seems that the exchange rate on the Item Fulfillment does follow the rate set on the Sales Order. So, if you manually set a custom rate on the Sales Order, the Item Fulfillment should use the same rate. As for permissions, if the Currency Permission is set to VIEW, users won't have the right to change the exchange rate for the currency. If you need users to be able to adjust the exchange rate on the Sales Order, you might need to set the Currency Permission to EDIT, but this also provides access to the currency records themselves, which may not be ideal. Please note that these are general observations based on the provided conversations and may not apply to all situations or account configurations in NetSuite.