why the average cost for item per location is greater than Est. Unit Cost

AI generated answer (using internal Slack threads):

The average cost for an item per location might be greater than the Estimated Unit Cost due to several factors. Firstly, the average cost is a dynamic value that changes as inventory moves or when landed costs get added. This means that every time an item is received, sold, or transferred, the average cost is recalculated. The calculation is effectively done by taking the ending quantity and balance by item and then dividing them. This is a weighted average calculation. For example, if you receive 300 units at $1 and then receive 1 at $400, your average cost is going to be significantly closer to $1 than $400. Secondly, the average cost can also be affected by the inventory costing preferences set up in your NetSuite account. For instance, if the 'Use Item Cost as Transfer Cost' option is ticked on the Transfer Order (TO), the cost of the item at the time of transfer will be used, which could potentially increase the average cost. Lastly, the average cost can be significantly impacted when you have negative inventory. This can lead to unexpected results in the average cost calculation. Please note that the location average cost is not directly accessible via SuiteScript and might only be available for searches. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******