Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Last Purchase Price
To retrieve the last purchase price in NetSuite, you can create a Saved Search with a formula field. Here's a detailed guide on how to accomplish this:
- Create a Saved Search:
- Navigate to Lists > Search > Saved Searches > New.
- Select the appropriate record type (e.g., Item) as the search type.
- Define filters to narrow down the search results if needed. For example, you might filter by item type or vendor.
- Add Columns:
- Include columns such as Item Name, Last Purchase Date, Last Purchase Price, and any other relevant fields you want to display in the search results.
- To add columns, click on the "Add" button, then select the desired fields from the available options.
0