Skip to main content
Version: 7.2

Customer price list

Introduction

Access : Sales → Configuration → Price lists or Partner price lists

Customer price List: is used to reference customer-specific prices. There are exclusive price rates for certain customers, and there are common price rates for different types of customers.

Price list targets contracts with negotiated rates or discount periods. Simple discounts are partially managed by price-lists. In AOS, simple discounts can be triggered by quantities in a sale order.

If you want to manage more complex pricing and discounts, you can go much further with the price list functionality.

The price list concept is common to both the Sales Module and the Purchases Module.

The documentation below explains how price lists work in the Sales module, however the price lists work in the same way in the Purchases module.

How to configure a price list

  1. Give the price list a title (for example, "123 Services customer price list" for a particular customer). It’s equally possible to create a global price list for several customers (e.g. "France customer price list" for French customers).

  2. Price lists have application start dates / application end dates. If these fields have been left blank, the price list will be applicable at any given moment, and can be used continuously.

On the other hand, if the dates have been specified, the list will only apply for a certain period of time.

Dates can be useful when negotiating rates with a customer for a specific period of time, or for setting up promotional periods.

  1. The checkbox "Non-negotiable price list": if this box is checked, it will be impossible to make additional discounts on rates that have already been negotiated. It will be impossible to modify discounts at sale quotation / sale order level.

  2. Tick box "Hide discount on prints ": when creating a sale quotation and adding a price list, the discounts will be hidden on the printout of the sale quotation and the sale order form.

  3. Tick box "Active". This box is ticked by default when a price list is created. It is important to leave it ticked. Why is this important? The "Active" box specifies that the price list will be automatically used for sale orders that can trigger it (i.e. the price list will be taken into account).

  4. General discount %: a general discount will be applied with this price list to all products/services. For example, if the general discount is at 5%, the 5% discount will be applied systematically to all products.

  5. "Price list content" table allows for applying more specific discounts to certain products or categories.

  6. Comments : leave comments in this section.

  7. Historized price lists: once a price list has been created, historize (i.e. "archive") it by clicking on the "Historize price list" button (this button appears once the price list, the partner price list and the partner file attached to it have been created).

As a result, the prices in a historized price list will no longer be applicable, but this feature helps to view previously applied prices.

  1. Partner price lists: displays the partner price lists which use a particular price list.

  2. To add a new Price List Line, click +New in the Price List Content table on the Price List form.

1.1. The price list form. 1) Title 2) Application start date & Application end date 3) Non-negotiable price list 4) “Hide discount on prints” checkbox 5) “Active” checkbox 6) General discount (%) 7) Price list content 8) Comments section 9) Historized price lists table and the button “Historized price list” 10) Partner price lists.
1.1. The price list form. 1) Title 2) Application start date & Application end date 3) Non-negotiable price list 4) “Hide discount on prints” checkbox 5) “Active” checkbox 6) General discount (%) 7) Price list content 8) Comments section 9) Historized price lists table and the button “Historized price list” 10) Partner price lists.

Price list line

Add a new Price List Line by clicking +New in the Price List Content table on the form. A new window will open, the Price list line.

  1. Select a product or a product category. A category includes several products at several prices.

  2. Define the calculation method for a product.

In the "Discount/Additional/Replace" field, define whether it’s a Discount, an Additional price or a Replace. In certain situations, select an "Addition" in order to increase the catalogue prices.

info

When selecting a product instead of a category, it becomes possible to select "Replace" in the "Discount/Additional/Replace" field. Selecting "Replace" will replace the pre-configured price on the product file. In other words, this choice replace one price with another.

  1. In the "Fixed amount%" field, select from "No discount" / "In %" / "Fixed".

When selectiong a fixed amount, the discount will be a fixed amount of company's currency (for example, the fixed discount is 10, which means that the discount will be €10).

Selecting a % amount means that the discount will be calculated as a percentage.

  1. In the "Quantity minimum" field, enter the minimum quantities to be purchased. Selling a certain quantity of a product to a customer will trigger discounts or price replacements.
note

Order quantities can trigger discounts. For example, if the customer buys 20 items of a product, the price will drop from €60 to €50.

  1. Once the price list has been configured, create a price list for partners.
1.1. Add a new Price List Line by clicking +New in the Price List Contents table on the form.
1.1. Add a new Price List Line by clicking +New in the Price List Contents table on the form.
1.2. Clicking on +New on the Price List Contents table will open a new window, the Price list line. Fill in the fields in order to configure a price list line. Select a product or a service. Note that it's possible to change the price by selecting Discount / Additional / Replace in the dedicated field. If a discount is selected, decide whether it's a fixed amount or an amount in %. It's also possible to enter the discounted amount and indicate what quantity will trigger the application of the discount
1.2. Clicking on +New on the Price List Contents table will open a new window, the Price list line. Fill in the fields in order to configure a price list line. Select a product or a service. Note that it's possible to change the price by selecting Discount / Additional / Replace in the dedicated field. If a discount is selected, decide whether it's a fixed amount or an amount in %. It's also possible to enter the discounted amount and indicate what quantity will trigger the application of the discount

Partner price list

Access : Sales → Configuration → Partner price lists

  1. First, create a price list in the Price list menu or directly from Partner price lists.

When creating a new Partner price list, there is a possibility to either select from existing price lists, or create a new one.

  1. Then, apply this price list on a Customer file.

In order to do this, open a Customer file → click on the Customer tab → select a price list in the Sale price list field.

Partner price lists are used for grouping together several price lists. These partner price lists that can be applied to partners files.

note

In AOS the term “partner” indicates a third party. It could mean any third party, whether it’s a Supplier or a Customer. The term "partner" is applied in further documentation.

The next steps are :

  1. Open Partner price lists. On the Price Lists table, either create a new price list for a partner by clicking on +New, or select from existing Price lists configured beforehand in Price lists.

  2. On the partner price list, it’s possible to attach several price lists to a partner (or several partners if the price list is shared). This functionality therefore allows several price lists to be grouped together.

  3. “Exclusive" checkbox: if this box is ticked, the price list will be exclusive for a selected partner. In other words, once this partner price list has been attached to a partner file, it cannot be used for another partner.

The price list applied to a selected partner with an active "Exclusive" check box will equally disappear from available price list selection

Uncheck the box if you wish to use this price list for other partners.

  1. On the "Partner Price List" file, if there is a need to consult an associated Partner file, follow these steps :
  • open a Customer file ;

  • click on the Customer tab;

  • in this tab, select a partner price list in the "Sales price list" field.

  1. Save the changes.
caution

Remember to apply a partner price list to the customer file since the configured partner price list is not automatically applied.

1.1. The Partner Price List form. 1) Fill in the label; 2) Tick the “Exclusive” box if necessary 3-4) On the Price lists table, add price lists by clicking on “Select” or configure a new price list by clicking on +New. 5) In the Partners section, partners attached to a Partner price lists will be displayed.
1.1. The Partner Price List form. 1) Fill in the label; 2) Tick the “Exclusive” box if necessary 3-4) On the Price lists table, add price lists by clicking on “Select” or configure a new price list by clicking on +New. 5) In the Partners section, partners attached to a Partner price lists will be displayed.
1.2. On the partner price list form, click “Select” to add an existing price list to the Price lists table. A new page will open. There, select one or more price lists.
1.2. On the partner price list form, click “Select” to add an existing price list to the Price lists table. A new page will open. There, select one or more price lists.
1.4. Once you have added a price list on a customer file, the partner attached to this list will be displayed on the Partners table.
1.4. Once you have added a price list on a customer file, the partner attached to this list will be displayed on the Partners table.
1.5. How to apply a list to a partner ? On the customer file, click on the Customer tab. In the “Sales price lists” field select a sales price list.
1.5. How to apply a list to a partner ? On the customer file, click on the Customer tab. In the “Sales price lists” field select a sales price list.

Sale quotation and price lists

Access : Sales → Sale quotations → New

How to create a sale quotation for a customer with a partner price list?

caution

Check first if price lists / partner price lists were created beforehand.

Also, be sure to attach a price list to a customer file. Open a customer file, then click on the Customer tab and select a price list in the dedicated field.

  1. Open a Sale quotation. In the "Customer" field, select the customer.

As the list has already been attached to the customer file, it will automatically appear in the "Price list" field on the sale quotation file.

However, if several price lists are attached to the Partner price list file, it will be possible to select from several lists when creating a sale quotation.

1.1. Open a Sale quotation file. Select a customer in the “Customer” field. If this customer file is attached to a price list, the fields relating to the price list will be filled in automatically.
1.1. Open a Sale quotation file. Select a customer in the “Customer” field. If this customer file is attached to a price list, the fields relating to the price list will be filled in automatically.
  1. As a result, the prices indicated on the price list will be applied directly.

  2. Add new products to the "Detail lines" table by clicking on "New".

  3. On the Sales Order Line tab, select the product in the "Product" field. If this product or service is part of the price list, the price and discounts linked to this item will be automatically taken into account.

  4. Complete the sale quotation configuration as required and click on the "Finalize" button.

1.2. Click +New in the Detail lines table to add a Sales Order Line for a product / service. The “Sales Order Line” window will open.
1.2. Click +New in the Detail lines table to add a Sales Order Line for a product / service. The “Sales Order Line” window will open.
1.3. On the Sales Order Line window, select a product or a service. If this product is part of the price list, the price and discounts applied on this list will be automatically filled in on the corresponding fields of Sales Order Line.
1.3. On the Sales Order Line window, select a product or a service. If this product is part of the price list, the price and discounts applied on this list will be automatically filled in on the corresponding fields of Sales Order Line.

Historize Price List

  1. Open a Price list. On the Price list file, click on the "Historize price list" button (i.e. archive this price list).

  2. Once the existing list has been historized, it becomes possible to modify prices on the same file in order to create a new version.

  3. If there is a need to consult the historized list and to view the old prices, click on the record in the "Historized price lists" table.

1.1. On the Price list file, click on the ”Historize price list” button to archive this price list. The historicised record remains visible in the ”Historized price lists” table. Consult it to view the old prices. A new price list can be created then from the same record.
1.1. On the Price list file, click on the ”Historize price list” button to archive this price list. The historicised record remains visible in the ”Historized price lists” table. Consult it to view the old prices. A new price list can be created then from the same record.