is there a way to set price a,b,c by percent of cost?

I would like to have my prices set by percentage of my cost or regular sales price. for instanace price = is $40.00 then price a = 90% of price = $36.00. can some one help me figure out how to do this.

Thank You

Victor

Reply to
Victor
Loading thread data ...

Victor,

I did something like this it was kind of crude and it used an update and insert trigger along with sub1, 2 and 3. Basically whenever an item was created or update the trigger would fire and take the value placed in sub 1 and multiplied that by the price to get price a, then did the same for sub2 and price b and sub3 and price c.

The only real draw backs are that it uses up subs 1, 2 and 3 for price factors and that you have to specify each value for each item in each sub description.

Rob

Reply to
Rob

You can do this in RMS using querry. (take a backup first) Update item Set PriceA = 0.9*Price

Save the querry and you can run it daily. Contact us if you have any questions.

Best regards,

Mihir

Diviasoft, Inc

732-791-2894 snipped-for-privacy@diviasoft.com
formatting link
Reply to
Mihir Shah

You can do this in using the inventory wizard. It won't automatically detect price changes and adjust the price levels to match, but if you run through the wizard on a daily or weekly basis you can keep them pretty well synced up.

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.