How to modify Purchase History view on Vendor Record

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the modification of the Purchase History view on the Vendor Record in NetSuite is not straightforward. Vendor-specific purchase prices are not tracked in system notes like sales prices are. Here are a few suggestions from the conversations: 1. You could create a saved search and add in the system notes: purchase price field to the criteria and then add the old value and new value to your results columns (and the date). This should give you a running list without having to track in Excel. However, this method might not work if purchase prices are being set specific to a vendor on the item record. 2. Another approach could be to create a custom sublist attached to the record and script to store changed values. This method might be more complicated than using a spreadsheet. 3. You could also create a saved search of purchase transactions showing when the price is last used/first used. 4. Another suggestion was to add a scheduled script or workflow that triggers a script to call a saved search and then take the result set and dump it to a custom record that holds historic data. This is denormalizing data. Your new custom record would have SnapShot data rows like Vendor / Date / Item / Price. You could then trend it in analytics / charts or show dates of progression. Remember, these are suggestions based on the conversations and might not be the perfect solution for your specific situation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******