How Do I Access Detailed Pricing Changes from Item System Notes?
I'm not sure when it happened, but I just recently noticed that NetSuite now records ALL Item Price changes in the Item System Notes using a field named "Pricing"
[LIST]
[*]Provides a "View" link to the entire list of prices PRIOR to the change
[*]Provides a "View" link to the entire list of prices AFTER the change[/LIST]This is definitely a great step forward in recording price changes. Previously there was no indication that a price in a Price Level had changed.
Here's what we really need to know:
[LIST=1]
[*]Only those Price Levels that have changed
[*]The OLD price
[*]The NEW price[/LIST]Unfortunately the VIEW links provide the ENTIRE list of Price Levels that have a price entered, regardless of whether or not the price changed.
How do we identify (via Saved Search or Script) only those prices which have changed?
The VIEW link seems to refer to a "PriceHistory" table. It would be tremendous if NetSuite would expose this "PriceHistory" table to Saved Searches and Scripts. Then we could probably generate just about any type of Price Change Report we need.
For reference, here's a example URL to the Item Prices AFTER the change:
https://system.netsuite.com/app/common/item/itempricelisthistory.nl?searchid=-39&[COLOR=blue]InvtItemPriceHistory_ITEM=4809&InvtItemPriceHistory_ITEMtype=ANYOF&InvtItemPriceHistory_VERSIONfrom=-1&InvtItemPriceHistory_VERSIONtype=EQUAL&l=T[/COLOR]
Can anyone suggest a way via Script we can pull the actual list of prices that are shown by the VIEW link? If we could do that, then we could via script ID just those prices which actually changed, and produce a nice report. NetSuite, it is probably too late for any changes to 2011.1, but I think it would benefit, many, if not all, of your customers to provide full access (Saved Search and Script) to the Item Price History in the 2011.2 release. Thanks for your consideration of this request.