Manage pricing in Projects
/visma-net-erp/help/project-accounting/manage-pricing-in-projects
section
2026-02-19T17:09:06+01:00
# Manage pricing in Projects
About rate tables
/visma-net-erp/help/project-accounting/manage-pricing-in-projects/about-rate-tables
page
Effective pricing management is crucial for successful project execution.
2026-02-19T17:09:06+01:00
# About rate tables
Effective pricing management is crucial for successful project execution.
In Visma Net, the rate tables feature within the Projects module allows you to balance project revenues and costs efficiently. To achieve desired business outcomes and make the most of your project budget, it is essential to develop a suitable pricing model.
## Rate table
+ You use a rate table to determine a specific value, a rate, for a particular transaction to be processed with the help of allocation rules. The table includes rates for all combinations of factors that might affect the rate, such as particular tasks, account groups, stock items involved, employees participating, etc.
+ You can also create distinct rate sets for individual steps in allocation rules by utilizing various rate types for each step. The rate or value obtained from the rate table for every transaction can be referenced in the allocation rule formulas as **@Rate** and employed as a multiplier, an addend, or a constant.
+ You can create one rate table to be used for all projects or multiple tables to be used for different projects.
+ If you want to define rates of different types, such as expressed as factors (1.2, 1.0, 0.2), defined as amounts (€1000), or defined as hourly rates (€100 per hour), create a separate rate table for each type.
## Rate table configuration
You fully configure a rate table in four stages by using the following windows:
1. [Rate tables (PM204200)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-tables-pm204200/): To create a rate table. Initially, you just create an empty container for a new rate table; later, in another window, you will specify the rates and date ranges.
1. [Rate types (PM204100)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-types-pm204100/): Create rate types by establishing empty containers for them. Think of a rate type as a new dimension within the same table. Commonly, various rates are used for allocating labour costs, revenues, and expenses. At this point, determine the number and types of rate types needed; later, when creating allocation rules, assign different rate types to specific steps of allocation rules, allowing for step-specific rates.
1. [Rate lookup rules (PM205000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-lookup-rules-pm205000/): To create sequences, each of which is a set of factors. Any combination of the following factors can be specified for a sequence: **Project**, **Project task**, **Account group**, **Item**, and **Employee**.
1. [Rate table maintenance (PM206000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-table-maintenance-pm206000/): To actually specify the rates (with their date ranges) for each sequence or for each combination of particular factors. You can define rate codes on the fly to define multiple rates for the same sequence.
## Rate lookup sequences
For rate tables, sequence include multiple factors that may affect the rates.
You
define sequences by using the [Rate lookup rules (PM205000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-lookup-rules-pm205000/) window as follows:
+ A sequence determines the factors that influence the rate, such as projects, project tasks, employees, account groups, or items. For instance, if tasks are a factor, unique rates can be applied to specific tasks or to certain tasks within particular projects when specific employees work on those tasks.
+ The order of numeric identifiers for sequences is crucial, as it determines the sequence in which the system searches for rates. Starting with the first sequence (smallest number), the system compares the factors specified in transactions with those defined by the current sequence. If there is a match, the rate is assigned to the **@Rate** parameter. If not, the system proceeds to the next sequence (by number). If no matching factors are found for the last sequence, the system follows the selected option for that allocation rule step. Options include: **Set @Rate to 1**, **Set @Rate to 0**, **Raise error**, and **Do not allocate**.
A rate table may include different sets of sequences for different rate types.
## Rate codes
A rate code serves as an extra dimension in a rate table, allowing for simpler configuration. By utilizing rate codes, you can decrease the number of sequences needed for each rate table-rate type pair, making it easier to specify all the necessary different rates.
A rate code serves as an extra dimension in a rate table, allowing for simpler configuration. By utilising rate codes, you can decrease the number of sequences needed for each rate table-rate type pair, making it easier to specify all the necessary different rates.
For example, suppose that you want to define a specific rate for each employee working on a
project.
You have two possible ways to create such rates:
+ Create as many sequences with the **Employee** check box selected as there are employees to have a separate rate. In the rate table, enter one rate code for all these sequences. For each sequence, select a particular employee and enter the rate.
+ Create only one sequences with the **Employee** check box selected. In the rate table, for each employee with a specific rate, enter a separate rate code, select the employee, and enter the rate for this employee.
The total number of code-sequence combinations remains the same for both methods. However, using rate codes allows you to reuse the same sequence for defining multiple rates. It is important to note that even when using different rate codes, combinations of specific factors must be unique within a sequence. When searching for rates, the system will search through all rate codes.
## Rate specification
By using the [Rate table maintenance (PM206000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-table-maintenance-pm206000/) window, you can finally fill in
the rate table for each rate type that you are going to use in the allocation rules.
+ Enter the rates along with the date range when they are effective. On the tabs for various factor types (which show up if defined in the rate lookup rules), provide specific factors like projects, tasks, employees, items, or account groups.
+ The rate application condition can be defined using the following rules: When conditions apply to specific projects, items, employees, or account groups, they are connected using OR operators. However, when conditions involve different rate factors, they are connected using AND operators.
Related pages
Tasks
Windows
Configure a rate table
/visma-net-erp/help/project-accounting/manage-pricing-in-projects/configure-a-rate-table
section
In Visma Net, you can implement virtually any pricing model by using rate tables and rate types.
2026-02-19T17:09:06+01:00
# Configure a rate table
In Visma Net, you can implement virtually any pricing model by using rate tables and rate types.
In Visma Net, you can implement virtually any pricing model by using rate tables and rate
types.
For more information about the functionality, see: [About rate tables](/visma-net-erp/help/project-accounting/manage-pricing-in-projects/about-rate-tables/)
## Create a new rate table
1. Go to the [Rate table maintenance (PM206000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-table-maintenance-pm206000/) window.
1. Click .
1. In the **Rate table** column, type the identifier for the new rate table.
1. In the **Description** column, provide a description for this new rate table.
1. Click .
## Create rate types
1. Go to the [Rate types (PM204100)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-types-pm204100/) window.
1. Click .
1. In the **Rate type** column, type the ID for the new rate type. Specify identifiers in accordance with the type of allocation to be performed with this rate type, such as **LABOUR** for labour cost allocations and **BURDEN** for allocating costs.
1. In the **Description** column, provide a description for this new rate table.
1. Click .
## Create sequences
1. Go to the [Rate lookup rules (PM205000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-lookup-rules-pm205000/) window.
1. In the **Rate table** field, select the rate table that you want to configure.
1. In the **Rate type** field, select one of the rate types to be used with this rate table.
1. For each planned sequence, do the following:
1. Click .
1. In the **Sequence** column, type the sequence reference number. You can enter only digits in this field.
> [!NOTE]
> Leave a gap between reference numbers if you want to be able to insert additional sequences if needed without renumbering the existing sequences.
1. In the **Description** column, provide a description for this new sequence.
1. Select which types of factors affect the rate by selecting the check boxes in the respective columns: **Project**, **Project task**, **Account group**, **Inventory**, and **Employee**.
1. Review the reference numbers of sequences and adjust them if needed, keeping in mind that the numbers define the order in which the system will be applying the sequences to find the rate.
1. Click .
1. If you plan to use the rate table with more than one rate type (that is, in more than one allocation step), perform Steps 3 through 6 for each remaining rate type.
## Enter rates
1. Go to the [Rate table maintenance (PM206000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-table-maintenance-pm206000/) window.
1. In the **Rate table** field, select the rate table you are going to fill in.
1. In the **Rate type** field, select the rate type for which you are going to define rates in the selected rate table.
1. In the **Sequence** field, select one of the sequences defined for this rate table and this rate type, which you created by using the [Rate lookup rules (PM205000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-lookup-rules-pm205000/) window, as described in the previous section. For the factors selected for this sequence, the respective tabs appear.
1. In the **Rate code** field, type the new rate code.
1. In the **Description** field, provide a description of the rate code to be used for a new set of factors.
1. On the **Rate** tab, click .
1. In the **Start date** column, select the date when the rate will become (or has become) effective.
1. In the **End date** column, select the date that ends that date range when the rate is effective.
1. In the **Rate** column, enter the rate.
1. On each tab with a factor defined by this sequence, create the list of particular factors for which this rate is applicable as follows:
1. Click .
1. In the first column, select the particular factor of the specified type. (For instance, select an employee if this is the **Employee** tab.
1. Repeat the two previous sub steps until you have selected all the particular factors of the type for which this rate is applicable.
1. Click .
1. If you want to specify a rate for another rate code, repeat Steps 5 through 11.
1. Repeat Steps 4 through 12 until you have specified rates for all of the sequences defined for this rate table and this rate type.
1. Click .
1. If you plan to use the rate table in more than one allocation step, repeat Steps 3 through 14 for another rate type.
Related pages
Concepts
Tasks
Windows
Create rate types
/visma-net-erp/help/project-accounting/manage-pricing-in-projects/create-rate-types
section
2026-02-19T17:09:06+01:00
# Create rate types
1. Go to the [Rate types (PM204100)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-types-pm204100/) window.
1. Click .
1. In the **Rate type** field, enter the identifier for the rate type. This can be a ten-character string of letters and numbers.
1. In the **Description** field, enter a more detailed description of the rate type. This can be a 50-character string of letters and numbers.
1. Click .
To create another rate type, click .
Related pages
Concepts
Tasks
Windows
Create rate lookup rules
/visma-net-erp/help/project-accounting/manage-pricing-in-projects/create-rate-lookup-rules
section
2026-02-19T17:09:06+01:00
# Create rate lookup rules
1. Go to the [Rate lookup rules (PM205000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-lookup-rules-pm205000/) window.
1. In the **Rate table** field, select the rate table you want to specify sequences for.
1. In the **Rate type** field, select the rate type you want to specify sequences for. You define these rate types in the [Rate types (PM204100)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-types-pm204100/) window.
1. For each planned sequence, do the following:
1. Review the reference numbers of sequences and adjust them if needed, keeping in mind that the numbers define the order in which the system will be applying the sequences to find the rate.
1. Click .
1. If you plan to use the rate table with more than one rate type (that is, in more than one allocation step), repeat step 3 - 5 for each rate type.
Related pages
Concepts
Tasks
Windows
Specify rates for rate tables
/visma-net-erp/help/project-accounting/manage-pricing-in-projects/specify-rates-for-rate-tables
section
2026-02-19T17:09:06+01:00
# Specify rates for rate tables
1. Go to the [Rate table maintenance (PM206000)](/visma-net-erp/help/project-accounting/project-accounting-windows/rate-table-maintenance-pm206000/) window.
1. In the **Rate table** field, select the ID of the rate table you want to set rates for.
1. In the **Rate type** field, select the rate type you want to view or maintain rates for.
1. In the **Sequence** field, select the sequence of the rate table for which you want to view or maintain rates.
1. In the **Rate code** field, select the rate code you want to define rates for. In order to create a new rate code, you can enter its identifier in this field.
1. In the **Description** field, enter a description for the rate code.
1. On the **Rate** tab, click .
1. In the **Start date** column, enter the start date of the period when the rate is valid.
1. In the **End date** column, enter the end date of the period when the rate is valid.
1. In the **Rate** column, enter the rate.
1. On each tab with a factor defined by this sequence, create the list of particular factors for which this rate is applicable:
1. In the table toolbar, click .
1. In the first column, select the particular factor of the specified type (for example, select an employee if this is the **Employee** tab).
1. Repeat steps a and b until you have selected all the factors of the type for which this rate is applicable.
1. Click  in the table toolbar.
1. To specify a rate for another rate code, repeat steps 4 - 10.
1. Repeat steps 3 - 11 until you have specified rates for all of the sequences defined for this rate table and this rate type.
1. Click .
1. If you plan to use the rate table in more than one allocation step, repeat steps 1 through 13 for another rate type.
Related pages
Tasks
Windows