Pricing
Price List Schema
Application
> Master Data Management
> Picing
> Price List Schema
Overview
A price list schema is a template used to automatically populate a new version of a price list.
Price List management is not an easy task to handle, mainly in competitive markets where the margins are very tight.
Nowadays, organizations have to deal with a huge variety of products, which have different prices depending on the season and other pricing variables.
Etendo manages prices through three pricing related concepts:
- the Price List
- the Price List Schema
- and the Price List Version
And it allows the creation of:
- General Sales and/or Purchase Price List
- Specific Price Lists for a specific supplier or customer, or a group of them.
- Based on cost Price list based on product cost
The way these concepts work in Etendo is described below:
- Creation of Price List/s:
- A "Default Price List Schema", with no configuration at all, is created by default after creating an organization.
- The "Default Price List Schema" is the schema to be used in the creation of the price lists which are NOT a "Price List Version".
- The Price Lists linked to the "Default Price List Schema" might contain both the net list price and the net unit prices of the products.
To learn more, visit Price List. - The Price list/s created can be linked to the business partners as required.
To learn more, visit Business Partner
- Creation of Price List Schema/s:
- New Price List Schema can be created as a way to configure a set of commercial rules to be applied to existing price lists.
To Learn how, keep reading.
- New Price List Schema can be created as a way to configure a set of commercial rules to be applied to existing price lists.
- Creation of Price List Version/s:
- A new version of an existing Price List is created as a combination of a base price list and a given "Price List Schema".
To learn more, visit Price List. - The Price list/s versions created can be linked to the business partners as required.
To learn more, visit Business Partner.
- A new version of an existing Price List is created as a combination of a base price list and a given "Price List Schema".
Header
Price list schema window supports the creation of as many price list schemas as required with the aim of obtaining an easy management of price lists and price list versions.
As shown in the image below, the creation of a price list schema is as easy as to create it and give it a Name.
The set of price and discount rules which might apply to a set of product categories or specific products must be configured in the "Lines" tab.
Lines
Price list schema lines tab allows defining a set of price rules such as to apply a discount % to the net unit price of a given product category or specific product.
First thing to notice is that, as shown in the image above, "Lines" tab is split into two sections:
- the first section allows the user to:
- Inform Etendo about:
- the "Business Partner" and/or
- the "Product Category" and/or
- the "Product"
to which the price/discount rules to be defined in the next section are going to apply.
- the second section allows the user to:
- configure which price of the existing price list is going to be taken as "Base List Price" in the new price list version. The options available are:
- Net List Price which is the price published in the price list
- Net Unit Price which is the final price used in purchase and sales order/invoice lines
- Fixed Price, as it is possible to configure that for the new price list version, therefore the net list price is equal to a given fixed price.
- Cost, which is the price published in the price list, will be the product cost (costing tab in product window) and a margin.
- Fixed Price or Cost Based combines the previous two options with the following condition:
- If the fixed price is higher than the cost, then the defined fixed price is selected.
- If the fixed price is lower than the cost, then the cost (plus the defined margin) is selected.
- Fixed Price or Cost plus Margin Based combines fixed price and cost options with the following condition:
- If the set fixed List/Unit price is higher than the current cost plus List/unit Price margin, the price list will be created with the fixed price.
- If the set fixed List/Unit price is lower than the current cost plus List/Unit Price margin, then the price list will be created using the cost plus the margin.
- configure which price of the existing price list is going to be taken as "Base Unit Price" in the new price list version. The options available are the same as above:
- Net List Price
- Net Unit Price
- Fixed Price, as it is possible to configure that for the new price list version, the net unit price is equal than a given fixed price
- Cost
- Fixed Price or Cost based
- Fixed Price or Cost plus Margin Based
- configure the discounts if any to apply to the net unit price and/or to the net list price in the fields:
- List Price Discount %
- Unit Price Discount %
- configure the margin on the product cost to apply to the net unit price and/or to the net list price in the fields:
- List Price Margin %
- Unit Price Margin %
Second thing to notice is that the set of price rules and/or discounts could be configured in a "hierarchical" way, that's line by line or applying the last valid price rule (non-hierarchical way).
Info
The Enable Hierarchical Price List preference is available in order to select the desired behavior applying the price list rules.
Let us imagine that the rules which need to be part of a price list schema are:
- to apply a net unit price discount of 5% to the products which belong to a Product Category X.
- to apply a net unit price discount of a 10% to the products which belong to the Product Category Y.
- to apply a net unit price discount of 15% to the Product X that belongs to Product Category X.
The way this works in Etendo is:
- the price list schema must contain 2 lines one per each discount rule to be applied:
- First Line will contain information such as:
- Sequence Number = 10
- Conversion Rate Type = Spot
- Product Category = Product Category X
- Base Net Unit Price = Net Unit Price
- Net Unit Price Discount = 5.00
- Second Line will contain information such as:
- Sequence Number = 20
- Conversion Rate Type = Spot
- Product Category = Product Category Y
- Base Net Unit Price = Net Unit Price
- Net Unit Price Discount = 10.00
- Third Line will contain information such as:
- Sequence Number = 30
- Conversion Rate Type = Spot
- Product Category = Product Category X
- Product = Product X
- Base Net Unit Price = Net Unit Price
- Net Unit Price Discount = 15.00
Using hierarchical behavior:
- unit price discount of 5% is applied to the products which belong to a Product Category X.
- unit price discount of 10% is applied to the products which belong to a Product Category Y.
- unit price discount 15% is applied to Product X, in addition to the 5% discount for belonging to Product Category X.
Using non-hierarchical behavior:
- unit price discount of 5% is applied to the products which belong to a Product Category X, except to Product X.
- unit price discount of 10% is applied to the products which belong to a Product Category Y.
- unit price discount of 15% is applied to Product X.
Price List
Application
> Master Data Management
> Picing
> Price List
Overview
A price list is a listing of prices for different products or services.
Info
It is possible to create as many price list and price list versions as required depending on the organization's needs.
The process of creating a price list is slightly different to the process of creating a price list version.
Price List creation:
- Price List Name and Type (sales or purchase) is detailed in the Price List window header. It is also mandatory to define whether the price includes taxes or not.
- There exists the possibility of Price list based on cost, for this, the price list should be a sales price list.
- The Default Price List Schema with no configuration at all, as well as the valid from date information, must be detailed in the Price List Version tab
- The Unit / List price of each product which must be included in the price list is detailed in the Product Price sub-tab.
- The price list is ready and can be linked to the business partners as required and used.
Price List version creation:
- Price List Name and Type (sales or purchase) is detailed in the Price List window header.
- A Price List Schema which contains the new commercial rules to apply, the valid from date and the Base Price List for which the price list version is created and must be detailed in the Price List Version tab.
- The process Create Price list populates the "Product Price" tab by including:
- every product contained in the original price list
- each product will have a new unit and/or list price, depending on what was configured in the price list schema used.
- The price list version is ready and can be linked to the business partners as required and therefore used.
- Documents will automatically default the most recent version of a price list.
- There is no end date on price list versions, but old versions can be deactivated.
Price List
Price List window allows creating purchase and sales price lists to be assigned to the business partners for its use in purchase and sales transactions such as orders and invoices.
As shown in the image above, a price list or a price list version can be created by just entering below relevant information:
- By selecting the field "Sales Price List" it will be for sales transactions, otherwise it will be a purchase price list.
- Default field allows defining a given price list as the default one to be used in case a business partner does not have a specific price list assigned.
- Price list based on cost, this field is shown if the price list is a Sales Price List. This option allows creating a price list based on the cost price plus a margin.
- the cost price is the one defined in the Costing tab of the product window.
- the margin is defined in the Price List Schema window.
- when the price list is a price list based on cost, the price list schema should be configured with cost and a margin.
- Price includes taxes. This flag is very important and depending on this the behavior of sales and procurement flows will be affected.
- If it is marked, then the price defined is the gross unit price
- If it is not marked, then the price defined is the net unit price
How does this affect the flows?
- When the price list includes taxes, the gross unit price and line gross amount are filled and the net unit price is calculated based on the gross unit price and the corresponding tax rate. What cannot be changed is the gross and, due to this, there might be some rounding issues that the system automatically handles adding or subtracting these differences in the tax amount.
As an example : If price inclusive of tax is originally 135.50 and rate is 4.5 % then the rounded price before tax would be 129.67
The order line would stay:
Quantity: 1 Net Unit Price: 129.67 Line Net Amount: 129.67 Gross Unit Price: 135.50 Line Gross Amount: 135.50
But the total gross amount (calculated by the system) would be 135.51 (tax base amount:129.67 + tax amount:5.84) and what it has to be clear is that the final result must be 135.50 (The customer bought 1 unit whose price is 135.50). This difference is going to be solved adjusting taxes:
The system will adjust the difference by summing or subtracting this difference with the tax that has the highest amount. So, in this example, instead of having a tax line where the amount is €5.84, the amount will be €5.83 (5.84-0.01)
Finally, the total gross amount for the sales order would be 135.50 (129.67+5.83) which is the desired amount.
Due to this (Net amount vs Gross amount), when using prices that include taxes, it is recommended to work with greater precision (price precision) to avoid rounding differences.
- When the price list does not include taxes, the gross unit price and line gross amount fields are not displayed and both fields are not calculated at all in the line of the document. The final gross amount of the document will be the result of the sum of the lines net amounts plus the tax amounts.
- The price list is defined at document level (header) so there cannot be lines where the price includes taxes and others where not. This is clear for orders, but for invoices where orders can be grouped in one just invoice the rule is also applied. One invoice cannot have orders where the price list includes taxes and orders where the price list does not include taxes.
Price List Version
There could be as many versions of an existing price list as required, versions which can be valid for a given time period and which can be defined according to certain commercial rules.
As shown in the image above, there are two types of "Price List Versions":
- generic and original ones linked to the "Default Price List Schema"
- further price list versions (not based on the cost) which requires both:
- a Price List Schema
- and a Base Price List version
- price list versions based on cost require a Price List Schema with Cost configuration in Base list price and Base unit price.
The process button named "Create Price List" must be used only in the case of creating further price list versions as it requires a Base Price List if the price list is not based on cost. If the price list is based on cost, it is mandatory to select the price list schema and optionally the base version.
- if Base version is blank, the application calculates the unit price and list price for all the products (excluding discounts products) plus the margin defined.
- if Base version value is selected, the application calculates the unit price and list price for all the products defined in the base price list as cost plus margin.
Product Price
Product Price tab allows the user to either add or edit products and their prices for a selected price list.
In other words:
- Add products in the case of creating a price list
- Edit products in the case of modifying a price list version:
- as the required products at their new prices are automatically populated by Etendo in this tab while running the process "Create Price List".
Overall, this tab includes two main fields:
- 'the List Price' field, as the price used as a reference in a given price list or price list version. This price can be the result of a discount or any other commercial rule applied by a Price List Schema.
- and the Unit Price field, as the final price used in documents such as orders and invoices. This price can be the result of a discount or any other commercial rule applied by a Price List Schema.
Create All Price Lists
Application
> Master Data Management
> Pricing
> Create All Price Lists
Overview
On daily sales, especially on retail and distribution, price lists are very important. Therefore, Etendo includes plenty of information to manage and update price list versions per business partner.
This functionality includes different price lists, price list versions per each price list and price list schemes. Have a look at these concepts to better understand Create all Price Lists functionality.
Etendo allows hierarchical price list structure and this hierarchy is based on price list schemes.
Functionality
Follow this example about what Create all Price Lists is used for:
Example 1:
Imagine you own a bakery and you sell different bread types to different customers. You may have French bread, rolls, bagels, etc. And for each type you may have different sizes small, medium and extra.
You use a main price list (with a price list version) containing a price per bread when they are medium size. Based on this price list we build 2 other price lists applying a price list schema. For small bread, 5% off and for extra breads 4% more. This way, you will be able to manage price updates easily. Suppose flour price rises 10%, and you want to increase all prices for all breads. You could follow this steps:
- Create a new price list schema increasing the price 10%.
- Create a new version for the main price list, based on the new price list schema.
- Regenerate all price lists based on the main price list automatically. For this third step, you may use the Create All Price Lists feature.
Process
The Create All Price Lists generates all price lists pending from the selected price list. The process checks for all child price lists, and applying the defined price list schema, it generates a new version for each price list.
Discounts and Promotions Window
Application
> Master Data Management
> Picing
> Discounts and Promotions
Overview
Discounts and Promotions is a flexible feature that allows you to automatically adjust prices on order and invoice lines according to configurable business rules. You can define when and how promotions apply using filters (such as Business Partners, Products, Price Lists, and Characteristics), configure the type of discount (percentage, fixed amount, or fixed price), and control promotion availability by day and time. Multiple promotions can be applied in a prioritized cascade. The configuration also supports translating promotion names and tracking applied discounts on processed documents through an optional read-only tab.
Header
Defines the core settings and conditions for applying Discounts and Promotions to orders and invoices.
Fields to note:
Main Section
- Organization: Organization to which the discount or promotion will be available.
- Discount/Promotion Type: Defines the type of rule used to adjust prices. By default, Etendo includes the Price Adjustment type, but it is possible to extend and add custom types according to the organization's needs.
- Name: Internal identifier for the promotion.
- Printed Name: Label shown to end-users and in reports. Defaults to Name if empty.
- Description: Optional short text describing the promotion (up to 255 characters).
- Active: Enables the promotion for use. Inactive records are retained for auditing/reporting.
Filter Options
- Starting Date: Date when the promotion becomes valid.
- Ending Date: Date until the promotion remains valid (inclusive).
- Priority: Order of application when multiple promotions apply. Lower number = higher priority.
- Apply Next Discount/Promotion: If checked, subsequent applicable promotions will also be applied.
-
Filters:
Each of the following fields supports two filtering methods that define how the related records configured in the tabs will be treated during promotion evaluation.These options provide flexibility for defining the scope of a promotion in relation to Business Partners, Products, Price Lists, and Organizations.
- Included BP Categories
- Included BP Set
- Included Business Partners
- Included Product Categories
- Included Products
- Include Price Lists
- Included Organizations
-
Included External Business Partner References
Method Description All excluding defined (Default) The promotion applies to all records except those listed in the corresponding tab. Only those defined The promotion applies only to the records listed in the corresponding tab.
Some filters have different filtering methods, which are described below:
-
Included Characteristics: Defines how product characteristics are filtered to apply the promotion. Three methods are available:
Method Description All Characteristics (Default) The promotion applies regardless of product characteristics. All of the values defined The product must match all defined characteristic for the promotion to apply. Any of the ones defined The product must match any defined characteristic for the promotion to apply. -
Exclude Characteristics: Defines how product characteristics are filtered to exclude the promotion. Two methods are available:
Method Description All of the values defined (Default) The product must match all defined characteristic for the promotion not to apply. Any of the ones defined The product must match any defined characteristic for the promotion not to apply.
Definition
- Discount %: Percentage discount to apply to the price.
- Discount Amount: Fixed amount to subtract from the price.
- Fixed Unit Price: Final price assigned to the product when the promotion is applied.
- Min. Quantity: Minimum quantity required for the promotion to apply.
- Max. Quantity: Maximum quantity eligible for the promotion.
- Is multiple: Discount applies only if quantity is a multiple of a defined value.
- Units per package: This option is displayed only if Is Multiple is enabled. It defines the number of units considered per package.
Availability
This section defines the days and times when the promotion is active. If no availability is configured, the promotion will always be applied.
- All Week: Flag to enable the promotion throughout the entire week.
- Starting Time: Daily start time for the promotion.
- Ending Time: Daily end time for the promotion.
- Monday – Sunday: Flags to enable the promotion on individual days of the week.
- Starting Time: Start time for the specified weekday.
- Ending Time: End time for the specified weekday.
Tabs
- Translation: Allows defining the language, as well as the corresponding translated Name and Printed Name for each language.
- Business Partner Category: Allows inclusion or exclusion of Business Partner Categories from a promotion or discount.
- Business Partner: Allows inclusion or exclusion of specific Business Partners from a promotion or discount.
- Business Partner Set: Enables defining Business Partner Sets that a promotion or discount will apply to.
- Product Category: Allows inclusion or exclusion of Product Categories from a promotion or discount.
- Products: Allows inclusion or exclusion of individual Products from a promotion or discount.
- Price List: Enables selection of Price Lists to include or exclude from a promotion or discount.
- Organization: Allows selecting Organizations to include or exclude from a promotion or discount.
- Charesteristics: Allows selecting Product Charesteristics to include from a promotion or discount.
- Exclude Charesteristics: Allows selecting Product Charesteristics to exclude from a promotion or discount.
- External Business Partner Allows selecting External Business Partner to include or exclude from a promotion or discount.
Buttons
- Add Organizations: Adds Organization records in the Organization tab to include or exclude them from the promotion.
- Add Product Categories: Adds Product Category records in the Product Category tab to include or exclude them from the promotion.
- Add Products: Adds Product records in the Products tab to include or exclude them from the promotion.
How Promotions are Defined?
The process for setting up a promotion is straightforward:
-
Identify the promotion: Use the fields Name and Printed Name to identify the promotion. Printed Name will be shown to the final user, while Name is used internally.
-
Define the active period: Set Starting Date and Ending Date to define when the promotion will be valid.
-
Control promotion priority and cascade: Use Priority to determine the order in which promotions will apply if more than one is valid. Enable Apply Next if you want subsequent promotions to apply after this one.
-
Configure filters: Use the Filter Options section to determine where the promotion applies:
- Select Included method for each filter (Business Partners, Products, Price Lists, Characteristics, and Organizations).
- Define the actual filter values in the corresponding sub-tabs or use the available buttons.
Tip
Filter configuration is key to ensuring the promotion applies only in the intended scenarios.
-
Define discount logic: In the Definition section, configure the discount:
- Discount Amount and/or Discount % to adjust the price.
- Fixed Unit Price to override the final price.
- Min and Max Quantities to apply the promotion only for certain quantities.
Tip
Use Fixed Unit Price for promotions that should force a specific price, and Min/Max Quantities for volume-based promotions.
-
Set promotion availability (optional): In the Availability section, configure when the promotion will be active, ff no availability is configured, the promotion will always be applied:
- Use All Week to apply the promotion every day.
- Optionally, enable individual days (Monday to Sunday) to fine-tune when the promotion is active.
- For each day (or All Week), set Starting Time and Ending Time to define the valid time range.
Tip
Setting availability ensures promotions are correctly applied based on business hours, special days, or time-based marketing strategies.
How Promotions are Applied?
Discount and Promotion rules are automatically applied to sales order lines and sales invoice lines based on the filters you configure. For example, targeting certain Business Partner Categories or specific products during a defined time period.
Etendo calculates the final price in three steps:
- Price List: The base price defined in the product price list.
- Price Standard: The first discount level. This may come from the price list or can be manually adjusted on the line.
- Actual Price: The final price that will appear on the document after applying promotions.
If multiple promotions apply, they will be applied in order of priority. Each new promotion is applied to the price resulting from the previous one (cascade).
Price adjustments are visible immediately when editing the line, you will see the final price before processing the document.
Info
Although the discount is shown instantly, the Discounts and Promotions record is only created once the document is processed. See the Optional Configuration section to learn how to display this information in the document window.
Optional Configuration
The Discounts and Promotions read-only tab can be added to the following windows to display the discounts applied to each price:
- Purchase Order
- Sales Order
- Purchase Invoice
- Sales Invoice
- Sales Quotation
Tip
To display this tab in the mentioned windows, simply check the Active box in the corresponding tab in the windows, tabs and fields window. This action should be performed by a developer, with system administrator role, and using a development template to export the configuration and prevent changes from being lost.
Service Price Rule
Application
> Master Data Management
> Picing
> Service Price Rule
Overview
In this window Price Rules assigned to Price Rule Based services will be configured. Instead of having a fixed price, there will be rules that will determine the price of the Service.
Service Price Rule
Configuration fields:
- Name: Name of the Service Price Rule.
- Description: Description of the Service Price Rule.
- Rule Type: There are two values to select in the dropdown
- Percentage: If selected, a Percentage field will be displayed allowing to set a Percentage. To determine the price of the service, this amount will be applied to the amount of the lines related to the service.
- Percentage: Percentage to be applied.
- After Discounts: If selected, the percentage will be applied after adding the discounts to the ticket.
- Ranges: If selected, a new tab Ranges will be displayed allowing to create different Ranges based on the amount of the related lines.
Ranges
In this tab, different Ranges can be created based on the amount of the related order lines. Configuration fields:
- Amount Up To: If the summed amount of related order lines is equal or less than this amount, the configuration of this range will be taken into account.
- Rule Type: There are two values to select in the dropdown
- Percentage: If selected, a Percentage field will be displayed allowing to set a Percentage. To determine the price of the service, this amount will be applied to the amount of the lines related to the service.
- Percentage: Percentage to be applied.
- After Discounts: If selected, the percentage will be applied after adding the discounts to the ticket.
- Fixed Price: If selected, a field ‘Price List’ will be displayed.
- Price List: Price List from which the price of the service will be obtained.