Updating Item Purchase Prices

NetSuite enables you to update the purchase price on selected items to the price on the most recent purchase of that item. This price reflects the most recent transaction for the item added to inventory. For example, a purchase receipt, inventory transfer, or inventory adjustment. This does not include item returns or assembly unbuilds.

You can update up to 10,000 items with a single mass update.

This action cannot be undone.

To update purchase prices:

1. Go to Lists > Mass Update > Update Prices.
2. Click Items to open the list.
3. Click Update Purchase Price from Most Recent Purchase.
4. Verify or enter a Title of Action for this mass update.The Type field shows the type of record that you are updating.
5. Click the Criteria subtab.
6. Select search criteria for the items you want to update prices for.
   1. Check the Use Expressions box.
   2. Select a Filter method.
   3. In the Mass Update box, in the Account field, select any of or none of.
   4. In the Type & tab for single value box, enter a value, or click the arrow icon () to select one or more values.
   5. Click Done.
   6. Click Set.
7. To choose how to display search results, click the Results subtab.
8. Click Preview to review your changes before submitting them.
9. Click Save.