import average cost

AI generated answer (using internal Slack threads):

In NetSuite, the Average Costing method is indeed weighted. It is calculated by taking the ending quantity and balance by item and then dividing them. This can lead to significant impacts when you have negative inventory. 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 dollar than 400. To view the average cost of an item at a certain date, you can use the Inventory Valuation Report. This report will give you the total quantity and total value of any item as of some date. The total value divided by the total pieces would give you the average cost. If you're trying to fix the Average Cost for some items, you need to consider all inventory transactions including Inventory Worksheets, Inventory Adjustments, and Inventory Transfers. Inventory Transfers should use the From Location's Average Cost. If the From Location's Average Cost is $0, it will use the $0 amount, which can affect the overall Average Cost calculation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******