Skip to main content

Notifications

Microsoft Dynamics RMS forum

Price Change Log

Posted on by Microsoft Employee

Several of our clients have requested to have some kind of log or history created for any changes made to the item prices. This log should be capable of being printed in a report. Can anyone make this available to me. I understand some sort of trigger is required.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Price Change Log

    That was a recent change in FP2, If remember correctly.   You might have to update.

    This is at the store level.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Price Change Log

    HI ALL,

    IN OUR VERSION ALSO WE HAVE THE TABLE AND WE HAVE CUSTOMIZED THE REPORT. THIS REPORT WORKS FINE WITH 2 BRANCHES. BUT IN OTHER 2 BRANCHES NOTHING SHOWS UP.

    DO WE NEED TO RUN ANY WORKSHEET TO SYNC THE DATA?

    THANKS & REGARDS,

    UPENDRA NATH M.

  • NickZnavor Profile Picture
    NickZnavor 715 on at
    RE: Price Change Log

    I don't know exactly what version it was implemented in, but I am running version 2.0.2000 of RMS

    It already contains a database table named ItemValueLog

    I have already built a report that uses this table to show price changes, including the old and new price, and date it was changed

    This table only tracks the standard "Price" for the Item. Is that what you need, or do you need it to track

    changes to sale prices, quantity discount,etc?

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Price Change Log

    Thanks for your response. Would you be interested in providing a quotation to complete this project?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Price Change Log

    you would need to add a table to the RMS database to hold the information.  Then you need to setup a   on update trigger   that then populated the table you added when a item is updated.  

    Then you would need to create a report that pulls information from the table that you added.  

    On a hard to easy scale of 1 to 10,  this is probably a 7.  Not impossible but MAKE A BACKUP first.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans