est unit cost empty on inventory adjustment
# ask-stanley-ai
l
est unit cost empty on inventory adjustment
c
AI generated answer (using internal Slack threads):
Based on the conversations, the Estimated Unit Cost (Est. Unit Cost) field in an Inventory Adjustment in NetSuite is used to enter the cost of each item being added to the quantity on hand. 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 stock level is increased, particularly if the system on hand stock was zero, there might not be a unit cost and therefore the total stock value isn’t increased. This is because the system is expected to pick up an average price from NetSuite whether the stock goes up or down. For negative adjustments, you can only change the unit cost on positive adjustments. Negative adjustments use the item's Average Cost. The "avg cost" would only be 0.00 if it was initially added via inventory adjustment at 0.00 or received in on a Purchase Order at 0.00. When creating inventory adjustments and moving the inventory from one lot to another, NetSuite shows the estimated unit cost for up to 8 decimal places. However, the unit cost on the adjustment line is rounded until the cost account status resolves, then it will be the accurate, 8-decimal value. You can get the correct cost from a search/SQL query and use that for your inventory adjustment. ****** 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.83823359
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836286664
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830917418
Please provide your feedback on this answer.
j
Testing