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.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required