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