We have relatively simple pricing criteria, but implementing these in Sage is far from simple.

Special customer prices are a pain, we have to set these up in each individual product record, not in the customer record. This is counterintuitive.

An easier way would be to,

1. Allow each customer to have more than one customer price list.
2. Set up the pricing criteria at the price list level, not on each individual product,
   1. Products we apply a cost plus price to could just be added to a cost plus price list which marks up the cost price by x% rounded up to y pence
   2. Products we apply a discount from sales price to could just be added to the approproiate price list
   3. Product should, as now be able to be added to multiple price lists, as we may have different criteria for differnet groups of customers

Eg

If we have some products, say "widget", "thingummy" and "wotsit" and customers MegaCorp, CornerShop, MissNice and MrNasty we could do something like this.

Add products "widget" and "thingummy" to price lists markupalittle and markupalot.

Add product "wotsit" to discountalittle and discountalot

All 4 customers buy all 4 products. We want MegaCorp and MrNasty to pay more than CornerShop and MissNice, so we would allocate the price lists as

MegaCorp and MrNasty use markupalot and discountalittle.

CornerShop and MissNice use markupalittle and discountalot.

If we then get 2 new products, we just allocate them to the price lists and the sales prices for each customer are calculated automatically. If we get a new customer, we just allocate them to the appropriate price lists. If MrNasty's attitude improves, we just change the price lists allocated to him.

When costs change, we just update the cost price and new customer prices are generated automatically.

The current system sort of does this, but it's very cumbersome and timeconsuming to set up or make changes.