They key here is that we need all items in inventory to have a value when they print on the valuation report. Can we do an Import/Export or some bulk transaction process to move Cost to Average Cost where Average Cost = 0?

Thank you, but nothing is "purchased' by these locations. Inventory is transferred there from warehouse to warehouse. How would the average cost then be determined?

We did find out that if a SKU did not have a location then the average cost would not show up on reports. All SKUs have been updated with locations now. This does not help with SKUs that do not have an average cost This SKU has not been built and it has not been purchased What we need to know is how do we get Netsuite to…

When the Inventory was imported, there were quantities on hand, as well as an item cost.. In the items I am referring to on the inventory valuation report, there are quantities but no value because the average cost is blank.

This is the detail Level, XWhse is the CLASS Below is the Summary Level which does not include the information I need When I export to Excel, Below, the number appear in the summary, but they are wrong as discussed in my origial Question What I al looking for is Total revenue of all Xwhse products, Quantity sold, and the…