Employee Discounts

Dec 18, 2005 4 Replies

I give our staff a discount on everything in the store (basically cost price plus a tad). All the staff have accounts. When we started out (only 2 staff) it was easy but now with 35 staff its taking an increasing amount of time to do these discounts. I could just set the discount in their accounts to eg.25% but the problem is the items in our store range from low margin to high margin eg. some lines the GP% would be 5 but on others 50-60%. Is there anyway that I can give them items on their account at cost plus 5%?



Cheers


Thanks for the reply David, that sounds exactly what we want to do. How can I set C price to run automatically in SQL based on the cost?

Cheers

"David" wrote:

jetspeed,

Do a search on the ng for 'Trigger' and MSDN for SQL Triggers.

Rob

You can also do this in the Inventory Wizard if you aren't familiar with SQL...

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required