Derived price tables

Many suppliers charge a fixed surcharge for another version: tinted glass costs a percentage more than clear glass. With a derived table you only fill in the base. The other table calculates itself.

Deriving a table

1. Open the table that should follow.

   For example tinted glass under CatalogPricingVeranda.

2. Set the Price source to Derived.

   By default a table is set to Own prices: you fill it in yourself.

3. Choose what to derive from.

   Under Derive from you choose the base, for example clear glass. You can only derive from a table with its own prices, of the same product.

4. Enter the surcharge.

   Under Surcharge you enter a percentage, for example 12. A negative percentage is allowed too. With Plus a fixed amount you add an amount to every price, and with Round you round the result, for example to whole euros.

5. Click Save.

   The table now shows the calculated prices, with the table it follows named above it.

To let several versions follow at once, use Derive from…. You choose one base and switch on the types that should follow it.

Good to know

• A derived table also takes the sizes and the VAT setting of its base. That way the surcharge always applies to the same prices.
• A base cannot be derived itself. So you cannot derive tinted glass from a table that is itself derived from clear glass.
• Export as CSV on a derived table gives the calculated prices.
• If the base has no prices yet, the derived table has none either. Fill in the base first.

Editing it yourself after all

If one table differs, click Edit myself. You start from the calculated prices and then adjust them yourself. With Derive from … again you switch it back later.

Who can change this

You need the Prijslijst wijzigen permission (edit the price list). Permission names are shown in Dutch.