Scenario
User would like to see the latest sales price instead of the average unit price on the Items Purchased subtab view.
Applies To
NetSuite 2021.2
Solution
1. On the Item Purchased subtab, click Customise View button.
2. Customizing a view will create a custom view for your item purchased.
a. Edit the title to your preferred name
b. Under Criteria tab, if you choose to only select Invoice as your Type, you must deselect other transaction types, same goes to Accounts field filter.
c. Under Results tab, as you can see below image, Item Rate field corresponds to Sales Price and Maximum summary type should be selected to get the latest sales price.
d. Once done, click Save button.
Results
Note: To export - you must always view this search and export from there.
On Customer File view:
Users can now see the latest sales price.