I want to create a saved search to show me what items have had changes in average cost. Ideally, output would show: Date Item Old Value of average cost New Value of average cost Internal ID (of posting transaction)

AI generated answer (using internal Slack threads):

To create a saved search that shows changes in the average cost of an item, you would need to utilize system notes and formula fields. However, this might be a complex task as NetSuite does not directly provide a way to track historical changes in average cost. Here's a general approach you could take: 1. Create a custom field on the item record to store the previous average cost. 2. Create a workflow or script that triggers on the change of the average cost field on the item record. This workflow or script would store the old value in the custom field you created in step 1. 3. Create a saved search on the item record. In this search, you would show the item, the custom field (old value), the average cost field (new value), and the internal ID. You could also add a formula field to calculate the percentage change. Please note that this approach would only track changes from the point of implementation forward, and would not capture historical changes prior to implementation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******