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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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