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
That was a recent change in FP2, If remember correctly. You might have to update.
This is at the store level.
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.
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
Thanks for your response. Would you be interested in providing a quotation to complete this project?
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.
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... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154