average cost field is empty for inventory item in netsuite

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 'Average Cost' field for an inventory item in NetSuite can be empty due to several reasons. One of the common reasons is that the 'Est. Unit Cost' field is not filled in when making stock adjustments via the Inventory Adjustment feature. When you are increasing the stock level, particularly if the system on-hand stock was zero, you need to enter the cost of each item being added to the quantity on hand in the 'Est. Unit Cost' field. If you entered a negative number in the 'Adjust Qty By' field, you cannot enter anything in this field. The cost of the items being removed from the quantity on hand is calculated. If the 'Est. Unit Cost' field is not filled in, there will be no unit cost attached and therefore the total stock value isn’t increased. This could be why the 'Average Cost' field is empty for the inventory item. Please note that the 'Est. Unit Cost' field might not be visible in some NetSuite reports like the inventory worksheet. You might need to customize the report or use a different report to view this field. Also, it's important to note that the average cost/unit and total inventory value in NetSuite is composed of the FOB price, duty, and freight (landed costs). If you need to recalculate the average cost/unit and inventory value per FOB price, duty landed costs, and freight landed costs separately, you might need to export the raw data and do the calculations outside of NetSuite, such as in Excel or SuiteQL.