Is there a query I could use to set a price level at 10% off each items price? I would rather not have to go into each items properties to set it. Thanks for any help. Craig
- posted
17 years ago
setting price levels
Loading thread data ...
- Vote on answer
- posted
17 years ago
I do not know a query for that, but if you do not have too many items, or have them well distributed in to categories or departments, you could run a Worksheet Style 305: Change Item Prices (Level Pricing), and then filter for your criteria. If it is all items, I would just go by Category, generate and then set a formula.
Jocelyn
"Craig" wrote:
- Vote on answer
- posted
17 years ago
- Vote on answer
- posted
17 years ago
The worksheet wizard can generate price levels for existing items based on a formula such as 10% off. If you would like this calculated automatically during new item adds, consider our Master Master add-in. You can define formulas for ABC levels and upper/lower bound prices. These formulas can include division, multiplication, +/-, % or dollars, plus rounding. Examples: Price A is 10% off Retail Price B is Retail minus $10 Price C is Cost + 10% Round prices to nearest .95. You can also change costs and recalculate prices in mass to members of a matrix.
Contact your RMS reseller for information or visit our website to download a 30 day trial of Power Ops. Power Ops is included in Matrix Master and RMS Toolkit.
Greg Digital Retail Solutions
formatting link