Updating Item Purchase Prices

NetSuite lets you update the purchase price on selected items to match the price from the most recent purchase of that item. This price reflects the most recent transaction where the item was added to inventory, like a purchase receipt, inventory transfer, or inventory adjustment. It doesn't include item returns or assembly unbuilds.

You can update up to 10,000 items in a single mass update. For more information, see Defining a Mass Update.

Warning:

You can't undo this action.

To update purchase prices:

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

  2. To open the list, click Items.

  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 you're 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

General Notices