How often is avg cost calculated and are existing transactions updated?

AI generated answer (using internal Slack threads):

The average cost in NetSuite is calculated based on the transactions in the system. It is a weighted average, meaning that if new transactions are added, the average cost will be recalculated. This is why the numbers might change if the consolidated exchange rates calculator is run on different days. The average cost is stored on the item record. However, this is the current calculation and does not reflect historical calculations. The historical calculation is not stored in a specific location that can be accessed via a report or search. In terms of existing transactions, they are not updated when the average cost is recalculated. However, they do influence the calculation of the average cost. For example, if there is a transaction with a date that is different from the others, it can skew the average cost calculation, as seen in the example where a transaction with a date of 3/1 instead of 3/31 caused discrepancies in the average cost. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******