:

Price Change Log

Several of our clients has 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.
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.
formatting link

Reply to
Errol Leu - CCS Guyana
Thanks for your response. I am not familiar with trigger systems. Can you assist me by giving me a sample of what the trigger should look like?
Reply to
Errol Leu - CCS Guyana
"Errol Leu - CCS Guyana" ha scritto nel messaggio news: snipped-for-privacy@microsoft.com...
You can use a trigger system to put into a CUSTOM TABLE all price changes ..
antonio
Reply to
Antonio Mazzeo
That would be really nice. Yes, I would like to have the cost, price, a,b,c,msrp, saleprice, and also discounts logged. How do you get a hard copy. Is a text file created for printing?
Reply to
Errol Leu - CCS Guyana
I have a bit of time only this weekend.. Saturday. Do you need to log all prices? (cost, price, a,b,c,msrp, saleprice) and also discounts?
Antonio
Reply to
Antonio Mazzeo
"Errol Leu - CCS Guyana" ha scritto nel messaggio news: snipped-for-privacy@microsoft.com...
You can download the trigger from
formatting link
or
formatting link

I'm in office, but again I have no time for release a rms-active report
bye antonio
Reply to
Antonio Mazzeo
I would really like to use this log. When I try to run it as an SQL statement (correct) it does not work. Please tell me how to get this work. Should be available to all. Thanks for your hard work
Reply to
Roxanne

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.