This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have an average cost that is way off? How can I recalculate it. Is there a way to debug it?

As I know, you need to manipulate from Items PO bills by editing and changing the entered price then save other related records too. I don't know Is there any other way to re-calculate average cost for Items by triggering.

Is there a saved search to show my the average cost per transaction so I can debug it. I have an item that is 2000 lb um and Netsuite for some reason is multiplying the average cost by a factor of 2000. All my transactions look fine (Correct amount per um) .

You can use the Adjust Inventory Worksheet to update the Cost of an item.
Transactions &gt; Inventory &gt; 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 qty) 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

<@U01MA5829D1> - go to setup&gt;accounting&gt;costing preferences

and see often your costing runs. Your avg. cost is updated