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. For more information, see Defining a Mass Update.

Warning:

This action cannot be undone.

To update purchase prices:

1. Go to Lists > Mass Update > Mass Updates.

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. In the Criteria subtab:

   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. Select a value.

   5. Click Set.

6. To choose how to display search results, click the Results subtab.

7. To review your changes before submitting them, click Preview.

8. Click Save.

Related Topics

Setting Up Item Pricing

Using Multiple Pricing

Using Quantity Pricing

Creating Pricing Groups

Updating Item Prices

Swapping Prices Between Price Levels

Creating Item Coupons

Generating Price Lists

Item Pricing

General Notices