howto recalculate Est. Extended Cost

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. ****** The Est. Extended Cost is a snapshot value of the item’s Cost Estimate Type which is taken upon the creation of the Sales Order transaction. The Est. Extended Cost may not be updated in the Sales Order even if there are new Purchase Orders for the item with Cost Estimate Type = Last Purchase Price. To recalculate the Est. Extended Cost, you would need to adjust the Cost Estimate Type. If the "cost estimate type" is set to "Average", then any sales order that comes in for that product will take the "average cost" at that exact moment in time for the sales order and will never change. However, it's important to note that changing the Est. Extended Cost doesn't affect the real COGS (Cost of Goods Sold). It's primarily used for reporting and for easily knowing what the payouts are. Any accounting adjustments are typically done with a contra account at the end of the month. If you need to adjust the Est. Extended Cost at the time of the sale, you could consider creating a new column and putting your calculation there. This wouldn't affect your COGS but it would show you the amount you are looking to see. For more detailed information, you can refer to this NetSuite SuiteAnswers article: https://suiteanswers.custhelp.com/app/answers/detail/a_id/69579/loc/en_US