Price Change Log

Posted by Errol Leu - CCS Guyana on July 26, 2005, 3:36 pm

Please log in for more thread options

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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=027042b7-bc9f-4910-8999-1bfac4f4e5ff&dg=microsoft.public.pos

Posted by Antonio Mazzeo on July 27, 2005, 9:20 am

Please log in for more thread options

scritto nel messaggio

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

You can use a trigger system to put into a CUSTOM TABLE all price changes ..

antonio

Posted by Errol Leu - CCS Guyana on July 27, 2005, 5:06 am

Please log in for more thread options

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?

"Antonio Mazzeo" wrote:

> scritto nel messaggio

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

> You can use a trigger system to put into a CUSTOM TABLE all price changes ..

> antonio

Posted by Antonio Mazzeo on July 28, 2005, 9:13 am

Please log in for more thread options

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

Posted by Errol Leu - CCS Guyana on July 28, 2005, 5:32 am

Please log in for more thread options

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?

"Antonio Mazzeo" wrote:

> 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