Use Cost Estimate for Negative Inventory
# ask-stanley-ai
y
Use Cost Estimate for Negative Inventory
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that the use of cost estimates for negative inventory in NetSuite is a complex issue. When dealing with negative inventory, one of the common methods mentioned is the use of Inventory Adjustments (IA). This can be done by adjusting the inventory negatively, which will come out at its current average cost. This should theoretically bring the current value/cost to zero if you take out the total inventory quantity at a location. After this, when you adjust it back in, you can specify the new cost. It is recommended to do the move-out IA first and separately (and on a different posting date) than the move-back-in IA, to keep things clean. However, it's important to note that depending on your system settings, the average cost on the item record is not necessarily updated immediately after saving transactions. You should check your inventory costing preferences page. In the case of adjusting underwater stock for inventory items, it seems that the average cost for the item is not corrected even after performing IAs to offset negative inventory. This could be due to the fact that these items are not being purchased but are still used as a component of kit packages to calculate cost based on their average cost. In such cases, it might be necessary to adjust the inventory positively to offset the negative inventory. However, this does not seem to change the item's average cost. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841318071
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835015357
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828382492
Please provide your feedback on this answer.