is it possible to get an location average cost for an item, without making an item receipt or an inventory adjustment? for a brand new item

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the location average cost for an item in NetSuite is not directly accessible or scriptable. It is a dynamic value that changes as inventory moves or landed costs get added. However, it is possible to capture the location average cost at the time of creation of the item receipt using a User Event (UE) script with the event set to Create only. This would capture the cost at that specific moment in time. For adjusting the average cost of an item, it is typically done via inventory adjustments. If you adjust the inventory negatively, it will come out at its current average cost. If you take out the total inventory quantity at a location, in theory, that should bring the current value/cost to zero. When you adjust it back in, you can specify the new cost. It is recommended to do the move-out inventory adjustment first and separately (and on a different posting date) than the move-back-in inventory adjustment, to keep things clean. Another method to adjust the average cost is to take your balance down to zero and then re-entering with the corrected cost. This can be done through inventory adjustments. However, you need to check the costing rules to make sure it will treat the positive inventory adjustment as the "last" transaction. Inventory transactions on the same day may be ordered differently depending on the costing rules. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******