How to adjust cost of inventory only (not adjust q...
# ask-stanley-ai
k
How to adjust cost of inventory only (not adjust qty. of inventory)?
c
AI generated answer (using internal Slack threads):
Based on the conversations, adjusting the cost of inventory without adjusting the quantity can be a bit tricky in NetSuite. Here are some steps you can follow: 1. If you have a 3-day window in history with no inventory transactions, you can bring inventory to 0 on a Friday backdated with an inventory adjustment and then on Monday bring the inventory back up to stock at the correct value. This has to be a full calendar day at 0 on hand for it to work. You'll change the financials in that period, and need to use an appropriate expense account or a holding account for both inventory adjustments. 2. Another way is to do an Inventory Adjustment. If you have 10 widgets at $1.50 a piece in the system now, do an Inv Adjustment for -10 to clear the balance. Then do an Inv Adjustment for +10 at the corrected price. You'll have to check the costing rules to make sure it will treat the positive Inv Adj as the "last" transaction. If it doesn't treat the positive one as the later transaction, you might have to do the transactions on different days. 3. If you are making stock adjustments via Inventory Adjustment and the stock level is increased, particularly if the system on hand stock was zero, you should 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. Please note that these methods might have an impact on your financials, so it's recommended to validate with 1 or 2 items first. ****** 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.838020563
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837432683
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835906684
Please provide your feedback on this answer.