exchange 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 starting Day 1 to change the exchange rate setup 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):

Based on the conversations, it appears that the exchange rate in NetSuite is driven by the transaction date and not the current date. However, this behavior can be influenced by various factors such as scripts, workflows, and the currency update time set in your NetSuite account. If you want to change the exchange rate logic, you might need to consider these factors. For instance, if you have scripts or workflows that are changing the exchange rate, you might need to modify them to achieve your desired behavior. Also, the currency update time in your NetSuite account can affect the exchange rate. If the update time is set in the middle of the day, you could be using the previous day's rates for transactions. The default update time is 3 AM server time. As for your specific question about changing the exchange rate setup 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 not explicitly mentioned in the conversations. However, given that the exchange rate is driven by the transaction date, it might be possible to achieve this by adjusting the transaction dates accordingly. Please note that these are interpretations based on the provided conversations and may not fully address your specific situation. You might need to experiment with different settings in your NetSuite account or consult with a NetSuite professional to find the best solution for your needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******