Hi All,
Can you please provide table information about Price level history for items.
if any create/update/delete price levels the table hold the information.
thanks,
srinivasulun
*This post is locked for comments
Hi All,
Can you please provide table information about Price level history for items.
if any create/update/delete price levels the table hold the information.
thanks,
srinivasulun
*This post is locked for comments
As Richard mentioned, Dynamics GP out of box doesn't offer Price Level history.
There are 3rd party products like Rockton Auditor which offer this functionality rocktonsoftware.com/.../auditor
Other option is to write a customization in Dexterity or a SQL table trigger on the table you want to audit. Both solutions involve the creation of a new table for storing the Price Level history.
The IV40800 table will contain the price levels and the table IV00108 will contain the prices per item at those levels. However, there is nothing that tracks the historical values. So will not find anything that says in 2010 these were the price levels and then in 2012 these were the price levels.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156