Anyone know a way to track vendor purchase price changes over time? Have someone who records this manually in Excel each time they have a price increase from a vendor on an item. Seems like there would be a better way!

@Justin B I have not tried this but the changes should be tracked in system notes so if you 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 w/o having to track in Excel.

Thanks for your input! I think you're right as the Purchase Price field goes, but in this case purchase prices are being set specific to a vendor on the item record (Purchasing/Inventory > Vendors) since many items have multiple different vendors w/ different purchase prices. And I haven't been able to get Vendor Purchase Price field with a system notes join or system notes search.

I am not sure about past pricing but you can easily snapshot a saved search of current by vend/prod into a new custom record and then use analytics to slice and dice over time periods

@redfishdev what do you mean by “easily snapshot a saved search”? Like just export it out periodically and save it off for analytics in excel or something?

what I mean is add a scheduled script or workflow or something that triggers a script to call a saved search and then take the result set and dump to a custom record that hold historic data. this is denormalizing data. in essence 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. the harder part in NS is showing the price at a certain month when price was X in Jan and Y in Mar because Feb was skipped. That is why I said the new analytics can help or if you want to make you world really easy just export all changes on event to AWS and show real charts in Quick sights

@redfishdev that sounds like a cool idea. I've never been able to accomplish storing Saved Search results in a custom record via a WF. This must take a Custom WFA or scheduled script like you mentioned. I'd be interested to know if you were sucessful in doing this using a WF and no scripting at all.

Could you search on previous PO for the items by vendors. Would only find price changes if you placed a PO at a given price. (As an aside price changes are hitting across the world)