can I import the last purchase price or fix the av...
# ask-stanley-ai
l
can I import the last purchase price or fix the average cost
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that you can indeed adjust the average cost of an item in NetSuite. Here are the steps: 1. Use the Adjust Inventory Worksheet to update the Cost of an item. You can find this under Transactions > Inventory > Adjust Inventory Worksheet. 2. Select your date at the top, then select your item from the list. 3. Set the quantity to the same as the on-hand quantity (so you don't adjust the quantity) but then set the value to the new value you want and it will set the average cost for that item to that amount on the day you have selected at the top. Another method mentioned is to manipulate the item's PO bills by editing and changing the entered price, then saving other related records too. This might trigger a re-calculation of the average cost for items. However, please be aware of the costing rules in NetSuite. Inventory transactions on the same day may be ordered differently depending on the costing rules. If the system doesn't treat the positive inventory adjustment as the later transaction, you might have to do the transactions on different days. ****** 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.822954297
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815449774
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814812601
Please provide your feedback on this answer.