YASSER
08/26/2025, 10:50 PMCeligo AI
08/26/2025, 10:50 PMAI generated answer (using internal Slack threads):The average cost in NetSuite is calculated systematically and is triggered after a transaction entry. This is defined in the Inventory Costing Preferences which can be found in Set Up > Accounting > Inventory Costing Preferences. If you have ticked the 'Use Item Cost as Transfer Cost' on the Transfer Order (TO), the average cost should be calculated after the transaction entry. If you need to override the item average cost, you can do so by adjusting your inventory balance. You can take your balance down to zero and then re-enter it with the corrected cost. For example, if you have 10 items at $1.50 each in the system now, you can do an Inventory Adjustment for -10 to clear the balance. Then, do an Inventory Adjustment for +10 at the corrected price. Please note that inventory transactions on the same day may be ordered differently depending on the costing rules. If you have an average cost that is way off, you can recalculate it by editing and changing the entered price on the Items Purchase Order bills and saving other related records. You can also use the Adjust Inventory Worksheet to update the Cost of an item. This can be found in Transactions > Inventory > Adjust Inventory Worksheet. Select your date at the top, then select your item from the list. 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. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
08/26/2025, 10:50 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821069956
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814221442
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814190328
Celigo AI
08/26/2025, 10:50 PM