web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Price Change Log
Microsoft Dynamics RMS (Archived)

Price Change Log

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member 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.

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

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

  • 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 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.

  • Suggested answer
    Community Member Profile Picture
    Community Member 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans