how can i force netsuite to recalculate the average cost

AI generated answer (using internal Slack threads):

To force NetSuite to recalculate the average cost, you can use the Adjust Inventory Worksheet. Here are the steps: 1. Navigate to Transactions > Inventory > Adjust Inventory Worksheet. 2. Select your date at the top, then select your item from the list. 3. Set the quantity to the same as the on-hand quantity (so you don't adjust the quantity) but then set the value to the new value you want. This will set the average cost for that item to that amount on the day you have selected at the top. Another method is to do an inventory adjustment that brings the total on hand to zero, and then do an inventory adjustment in 2 calendar days later to bring it at the correct amount. This method ensures that the inventory has to sit at 0 for a calendar day for NetSuite to completely adjust inventory. Please note that these methods may not work for lot numbered items. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******