7.3.1. Discount Schema (Price List)

In order to be able to automatically generate price list versions you first need to define "Price List" type discount schemas, which will determine the calculation rules used to generate new price list versions based on other versions. The Discount Schema window, located in the Product Setup -> Price List Setup menu, is used to manage discount schemas. The following fields are available:

  • Name, Description - are used to identify the discount schema within the system;

  • Discount Type = "Pricelist";

  • Valid From - the date starting when the schema will be valid;

The Renumber button is used to renumber the sequences in the "Price List Line" tab. This used to obtain empty spaces between numbering sequences. If the process is run successfully, the number of updated entries will be displayed in the window.

In the Price List Line tab you can enter price calculation rules and sequence information for the discount schema. The following fields are available:

  • Sequence - indicates the order in which the prices will be calculated. Therefore, this is very important for the price structure. Default values will be multiples of 10 to facilitate subsequent adjustments. The calculated prices in the subsequent sequences will overwrite those calculated in the first sequences;

In the Reference section, you can enter the conversion information and select the products for which this price rule will apply:

  • Conversion Type - select a conversion type, used to generate price lists in a different currency;

  • Conversion Date - select the date used for currency conversion;

  • Vendor, Product Category, Product and Attribute (1,2,3) fields are used to select the articles for which this price list line is applicable. When you create a base price list, for the first sequence, it is recommended that you leave these fields empty. This will ensure that prices will be created for every single product. The following sequences can be used to define prices for certain vendors, product categories, products or products with specific attributes.

Example: let us assume we have the products A,B and C, each costing 100,00. For the sequence 10, we apply a 20% discount to all products (therefore the new calculated price is 80,00). For sequence 20, define a 25% discount for product B. Therefore, after calculating the price list, the prices will be as such: product A: 80,00, product B :75,00 and product C: 80,00. Notice that the second sequence does not apply the discount to the price obtained after applying the discount in the first sequence, rather to the price that was originally defined.

In the Amount section, enter the price calculation rules for each price type:

For every price type (Standard, Limit and List prices) fill in the corresponding fields:

  • Price base - indicate which price should be used for price calculation: Fixed Price, List Price, Standard Price or Limit Price. If you select the Fixed Price, you can enter a fixt value for the new price;

  • Price Surcharge Amount - indicates the increment added to the price before multiplication;

  • Price Discount% - indicate the discount percentages that will be subtracted from the base prices;

  • Min Margin, Max Margin - indicate a minimum and maximum margin for each of the base prices. The margin is calculated by subtracting the original limit price from the newly calculated price. If the calculated price is not between the minimum and maximum margins, then you need to adjust it so that it falls in this range. If this field is equal to 0,00, then the margin will not be taken into account and the field will be ignored;

  • Rounding - indicate the rounding method (if applicable) that is used to obtain the final prices in the price list.

In the Exclusions tab you can enter a product or a product category for which the discount schema line will not be applied.