automatically update pricing levels

Having to run an Inventory Wizard to change prices just to update my Price C (used as the employee purchase price) is annoying. Is there any way around that so that the price will automatically update as the cost changes (i.e. goes up)? Should I be using an entirely different method of pricing things for employees?

TIA. ______________________________________________________

Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!

124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com

formatting link
Featuring free bike advocacy and safety materials!

Reply to
OlyBikes
Loading thread data ...

Reply to
convoluted

That option was a good suggestion, but I don't think it fits with my employee purchase policy. If a store had a policy where employees get X% off retail price, that'd work, but my policy differs. Employees get items for cost (zero markup). Thus, with varying markup based ON cost, a flat rule like 40% off retail price doesn't work.

I thank you for trying though.

Reply to
Larry Leveen

Thanks for your response.

I do not understand how running a query (which I've never done) is any faster/more convenient than using the price change wizard built into Manager.

Can you explain?

Reply to
Larry Leveen

You can save the query to be able to use it every time instead of having to go through the steps in the wizard every time. It still doesn't do what you want accomplished which is having the price update automatically when the cost increases. This could be done using a trigger but I would advise against it since you could very easily forget what triggers you have installed and eventually cause a train wreck if you get careless. Also if MS updates the tables you would lose all your custom triggers. My method is to run the inventory wizard once a month to catch any price increases. Craig

Reply to
Craig

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.