Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Price level history in Dynamics GP2015

Posted on by Microsoft Employee

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

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Price level history in Dynamics GP2015

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Price level history in Dynamics GP2015

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans