A price list lets you set customer-specific prices for products. You can link a price list directly to customers or to a customer contract. Whether a price list is used depends on its status, validity period, links and the service's pricing settings.
Manage price lists in the browser version. Field service management must be enabled for your account. You need permission to create and edit price lists. Adding and removing customer links also requires permission to edit the customers concerned. Changing a contract link requires permission to edit the relevant contracts.
Creating a price list
- Open Price Lists in the Customers group in the side menu, then select Create new price list at the top of the page.
- Enter a unique Name for the price list and, if needed, Additional info. The name can contain up to 256 characters. Choose a name that makes the intended use and validity period easy to identify.
- Select a Status. The default status for a new price list is Active. Select Inactive if you do not want the price list to be included in customer-specific price lookups.
- Set the Start time and End time. Despite their names, these fields contain dates. Both are required, and the end date cannot be before the start date.
- Select Create new price list on the form. After saving, the price list's edit view opens so you can add products and links.
To open an existing price list, click its name in the price list directory. Change its name, status, additional information and validity period on the Basic info tab, then confirm the changes with the form's Save button.
Adding products and prices
- Open the price list's Products tab and select Link products.
- Select products using the plus icons in the dialog's Select column. Clicking the check mark next to a selected product deselects it.
- Confirm your selections with the dialog's Save button. This saves the product selections separately from the price list's basic information.
- Edit the added product's price in its cell in the Price-list based price column. When you finish editing the cell, the price change is sent for saving immediately. Check the success notification.
When you link a product, a missing price list price is filled in with the product's current selling price in the product directory. If there is no selling price, the price is saved as zero. This is a copy made at the time of saving: subsequent changes to the selling price in the product directory do not change the price already saved in the price list.
Price-list based price is the price list's own value. The Sell price and Buy price shown on the same row come from the product directory. Editing the price list's price cell does not change them. Enter a price list price of zero or more; a change that leaves the cell empty is not accepted. The price list price is saved to two decimal places.
When you open Link products again, your previous product selections are included. Deselecting a previously linked product and saving the selections removes the product and its price list price from the price list. The product remains in the product directory. You can also remove an individual product row using its trash icon on the Products tab and confirming the removal.
Updating multiple prices through calculations and viewing the change history are covered in How do I update price list prices and check the history?
Linking customers
- Open the price list's Customers tab and select Link customers.
- Select customers using the plus icons in the dialog's Select column. Also check the customers selected previously.
- Select Save in the dialog. Customer links are saved at this stage separately from the price list's basic information.
Deselecting a previously linked customer and saving the selections also unlinks the customer from the price list. You can also unlink a customer using the row's trash icon on the Customers tab and confirming the removal. The customer is not deleted from the customer directory.
Simply adding a product to a price list does not link customers to it. Removing a customer link does not remove any direct contract link the price list may have: the customer on the contract may still receive the price through the contract.
Active price lists linked directly to a customer may have overlapping validity periods if they do not contain the same products. Having the same product for the same customer during overlapping periods prevents saving. A shared start or end date also counts as an overlap. This check applies when saving basic information as well as product and customer links.
A price list through a contract
You can also create a price list directly for a saved customer contract:
- Open Contracts in the Customers group in the side menu, open the contract, then open its Customer price lists tab.
- Open the Directly linked to this contract subtab and select Create new price list. You need permission to create price lists and edit the contract.
- Fill in the price list's basic information and validity period, then select Create new price list on the form. The price list is automatically linked to the open contract.
- Add products and their prices on the Products tab of the price list that opens.
You can create multiple price lists directly linked to the same contract. However, the validity periods of active price lists for the same contract cannot overlap, even if they contain different products or are still empty. A shared start or end date also counts as an overlap. For example, a price list valid from 1 January to 31 December can be followed by a new price list starting on 1 January of the following year, but not on the previous price list's end date of 31 December.
You can also select Create new price list on the contract's Linked through customer subtab. In this case, the price list is automatically linked to the customer on the contract rather than directly to the contract. This link requires permission to edit the customer. A price list linked directly to a customer can also serve that customer without the contract concerned.
To link an existing price list directly to a contract, use the Link to contract button on the price list's Contracts tab. Select the contract and confirm by saving in the dialog. A price list can have one direct contract link, although a contract can have multiple price lists. Selecting a new contract replaces the price list's previous direct contract link and requires permission to edit both the previous and the new contract.
The list on the price list's Contracts tab may contain both the directly linked contract and contracts belonging to the price list's customers. The trash action on a contract row clears the price list's direct contract link; it does not delete the contract or the price list's customer links. A contract linked through a customer may therefore remain in the list. A contract appearing in this list does not by itself prove that it is directly linked: check the contract's Directly linked to this contract subtab.
Status, validity and price selection
The Inactive status preserves the price list's products, prices and links, but the price list is not used in customer-specific price lookups. Its dates may overlap with other price lists. When you change its status to Active, overlaps are checked again. An active price list saved for a future period is included in price lookups only according to its own validity period. Expiry does not delete the price list or its links.
Price lookups use the current date in your account's time zone. Both the start and end dates are included in the validity period. A price list directly linked to a contract can provide a price for the customer on the contract without a separate customer link when the price list is active and valid and the contract has the status Waiting for start date, Active or Waiting for end date. A price list for a contract waiting for its start date can therefore also come into use based on the price list's own validity period. Prices are not retrieved through contracts with the status Ended, Archived or Deleted from system.
When a customer-specific selling price is calculated for a product on an offer, task or service request in the browser version, the product is first looked up in active, valid price lists linked directly to the customer. If the product is not found there, it is looked up in contract price lists that meet the conditions. A price list linked directly to the customer therefore takes priority for each product. If the product is found in multiple contract price lists, the price from the price list created first is used. This can happen, for example, when the customer has multiple contracts.
The price list price is not necessarily the final selling price. In the browser version, Settings → Offers → Offer Pricing contains the Sales Price Calculation Waterfall setting. The calculation uses the first rule that produces a price greater than zero. The default order is Base Selling Price (Product), Customer-Specific Price, Product Price with Customer Discount % and Product Price with Customer Profit Settings. With the default order, a positive base selling price for the product therefore takes precedence over the price list. If the price list is intended to take priority, check the position of the Customer-Specific Price rule.
A zero price in a price list does not make the product free through this selling price calculation. If the product is found at a zero price in a price list linked directly to the customer, the calculation moves on to the next pricing rule rather than to a contract price list for the same product. If no rule produces a positive price, the calculation uses a positive net price and the Default Sales Margin (%) setting when the margin is below 100%. The default margin is 20%, so a net price of €80 gives €80 / (1 − 0.20) = €100. If these conditions are not met, the result is zero. The calculated selling unit price is rounded to two decimal places.
For example, if the product's price is €80 in a price list linked directly to the customer and €90 in a contract price list, the customer-specific price rule produces €80. However, if an earlier rule produces a positive price, that earlier result is used. A custom unit price entered separately on a task or service request overrides the calculation when custom pricing is allowed. If the job has multiple customers, this product price calculation uses the job's first customer.
The selling price and product cost are different values. In the separate product cost calculation order, the Customer price table rule retrieves a price only from an active, valid price list linked directly to the customer. It does not look up a contract price list, and the cost calculation can also accept a zero price. Do not infer which selling price was selected solely from the cost total.
Products recorded on a task on Android and iOS are saved to the same job. When a task or service request is marked as done, the server calculates and saves the products' cost and sales information according to the rules in effect at that time. Later changes to the price list do not by themselves update this completion information already saved. Also check the price used in the job details.
The contract's own billing rows must be checked separately: linking a price list does not replace the need to maintain them. See contract billing and price changes.
Checking saves and results
Save in the price list's basic information, Save in the product and customer selection dialogs, editing a price cell, and confirming a contract link each save their own changes. Selecting Cancel on the form or closing it does not undo links or price cell changes that have already been saved successfully. Save changes to the basic information separately and wait for each action's success notification.
Reopen the price list from the price list directory. Check the status and dates on the Basic info tab, the products and price list prices on the Products tab, and the direct customer links on the Customers tab. If you use a direct contract link, also check the contract and its Directly linked to this contract subtab.
If the price is not being used, check that the product is in the price list, the customer or contract link, the validity period, the price list's status, the contract's status and the selling price calculation order. Also check for a custom unit price and which customer the job uses. If saving produces an overlap error, check the other active price lists for the same customer or the same directly linked contract.
Deleting a price list
Delete a price list using the row's trash icon in the price list directory and confirm the deletion. You need permission to delete price lists. A price list cannot be deleted if its directly linked contract has the status Waiting for start date, Active or Waiting for end date. This also applies to a price list with the status Inactive.
Deleting a price list also deletes its product rows, price list prices and customer links, but does not delete the products, customers or contract from their directories. If you want to keep the price list's information and links for later use, change its status to Inactive instead of deleting it.