The primary function of this form is to categorize inventory items for pricing purposes. It organizes goods into groups based on shared accounting — for example, office supplies, materials, and services that share the same accounting treatment. The values entered in this form are then available in the price list item header in the Product Group field under the Goods – Price List menu.

Press the button or the keyboard shortcut Alt+N to open the form for a new record.

The top toolbar contains a number of buttons whose functions are described in the dedicated section "Program Controls".

Abbreviation

Required field, can contain up to 20 characters. The value must be unique across all records.

The abbreviation (also referred to as a code) is a shortened representation of the group. We recommend choosing an abbreviation that clearly reflects the nature of the group, so that its meaning is immediately apparent.

Name

Required field, can contain up to 255 characters.

This field generally represents the record in overviews, print reports, and selection lists, so it should identify the record in a unique and descriptive way. If you configured foreign languages during the initial setup, you can click the "+" button to fill in the "Name" field in the selected foreign languages.

These language variants of the name are printed on documents when using foreign-language printing. Click the "-" button to close the name fields for foreign languages.

Further data entry is organized across several tabs.

On this tab, you configure offset accounts. These simplify the accounting of stock movements when creating issued invoices, received invoices, cash documents, and goods receipts and issues. The warehouse account is configured in the warehouse list.

You select values using the icons on the right, which redirect you to the Accounting – Chart of Accounts menu.

When selling price list goods, materials, products, and services on invoice or for cash, this option allows you to split accounting within revenues across different analytical accounts.

When creating an invoice in the Sales – Issued Invoices menu (or a cash receipt document), depending on the selected Invoice Type (cash register), the Debit Account (typically 311/211) is saved to the document header on the Accounting and VAT Line tab.

If you fill in the Posting Template field on the Document Specification tab, the remaining accounts (Credit account and VAT accounts) will also be pulled through to the Accounting and VAT Line tab. These accounts are then transferred to the document line item.

If you select Price List Item as the Item Type and then select a Code, the line item posting on the Accounting/Details tab => Credit of base: will be adjusted according to the offset account configured for the group assigned to the selected price list code. At the same time, the Copy value from document header flag will be unchecked.

Example:
In your posting template, you have the template "Revenue from goods sold" => Credit account for receipts 604000. Your revenues from goods are split in the chart of accounts, for example into 604001 Revenue from sold beams, 604002 Revenue from sold battens, 604003 Revenue from sold planks. However, you do not want to manage this split through posting templates. You have three product groups (Beams, Battens, Planks), and in each group you fill in the respective offset account for issued invoices. This ensures that revenue from these product groups is automatically posted to the correct accounts.

When purchasing goods, materials, products, and services from the price list on invoice or for cash, this option allows you to split accounting within revenues across different analytical accounts.

When creating an invoice in the Sales – Received Invoices menu (or a cash receipt document), depending on the selected Invoice Type (cash register), the Debit Account (typically 321/211) is saved to the document header on the Accounting and VAT Line tab.

If you fill in the Posting Template field on the Document Specification tab, the remaining accounts (Credit account and VAT accounts) will also be pulled through to the Accounting and VAT Line tab. These accounts are then transferred to the document line item. If you select Price List Item as the Item Type and then select a Code, the line item posting on the Accounting/Details tab => Debit of base: will be adjusted according to the offset account configured for the group assigned to the selected price list code. At the same time, the Copy value from document header flag will be unchecked.

Example:
In your posting template, you have the template "Goods purchase (method A)" => Debit account for payments 131000. However, you track purchases from one particular supplier separately on account 131001. You do not want to manage this split through posting templates. You therefore create a separate group for that supplier's goods (depending on sales of those goods, there may be more than one group), and fill in the offset account 131001. This ensures that purchases of this product group are automatically posted to the correct account.

The offset account configured here for received invoices and expense cash documents will also be automatically populated as the offset account in the automatically generated goods receipt, provided that "Automatically generate warehouse documents" is enabled in the received invoice type and in the cash register. The warehouse account will be populated from the settings in the warehouse list.

This specifies the offset account used when posting a goods receipt into the warehouse — both when a receipt is created manually and when it is generated automatically upon purchasing price list goods on invoice or for cash. In the latter case, the Automatically generate warehouse documents flag must be checked in the Received Invoice Type and on the Cash Register List form. The warehouse account is configured in the warehouse list.

When manually creating a goods receipt, depending on the selected warehouse, the Posting Template is saved to the receipt header on the Document Specification tab, and subsequently the account from that template is saved to the Offset Account field on the Accounting tab. The warehouse account is populated from the Warehouse List form (typically account 132 for goods). These accounts are then transferred to the receipt line item on the Accounting/Details tab.

If you select a Main Code from the price list for goods assigned to a group, the line item posting on the Accounting/Details tab => Credit of base: will be adjusted according to the offset account configured here for the selected item's group — the For goods receipt into warehouse field.

At the same time, the Copy value from document header flag will be unchecked.

The same posting behavior applies when a goods receipt is generated automatically upon purchasing on invoice or for cash.

This option determines the offset account used when posting a goods issue from the warehouse — both when an issue slip is created manually and when it is generated automatically upon selling price list goods on invoice or for cash. In the latter case, "Automatically generate warehouse documents" must be enabled in the issued invoice type and in the cash register list. The warehouse account is configured in the warehouse list.

When manually creating an issue slip, depending on the selected warehouse, the posting template is saved to the issue slip header in the "Document Specification" tab, and subsequently the account from that template is saved to the "Accounting" tab in the "Offset Account" field. The warehouse account is saved from the warehouse list (typically account 132 for goods). These accounts are then transferred to the "Accounting/Details" tab. If you select a price list code in the "Main" tab for goods assigned to a group, the line item posting in the "Accounting/Details" tab => "Debit of base:" will be adjusted according to the offset account configured here for the selected item's group — the "For goods issue from warehouse" field. At the same time, the "Copy value from document header" checkbox will be unchecked.
​

The same posting behavior applies when an issue slip is generated automatically upon selling on invoice or for cash.

Note

Some accounts in this configuration are pre-filled. We recommend reviewing these settings carefully and adjusting them to suit your needs.

Note

This tab is part of a service that extends the price list functionality.

Minimum Margin (%) The minimum difference between the purchase price and the selling price, expressed as a percentage.

Determines which type of selling price the price rounding applies to; select one of the following options:

Based on the selling price calculation method, the selling price excluding VAT is calculated from the purchase price, then rounded according to the price rounding method, and the precisely calculated VAT is added. This produces the final selling price including VAT, which is not rounded further.

Based on the selected selling price calculation method, the exact selling price excluding VAT is calculated from the purchase price, and the precisely calculated VAT is added. This produces the precisely determined selling price including VAT, which is then rounded according to the price rounding method. The VAT is then back-calculated precisely from this rounded selling price.

Handles the rounding of the selling price for the given product group. Which price is rounded is determined by the Price Type (excluding VAT, including VAT – exact, including VAT – coefficient).

Method – Select from the following options: up, down, mathematically.

Precision – Choose from the following options: no rounding, or round to thousandths, hundredths, tenths, ones, tens, hundreds, thousands.

Apply to price list – If you make a change to a product group, using this option will propagate the changes to all price list items belonging to this group.

A separate selling price calculation method can be defined for each product and material group.

Base Price

This is the starting price used to calculate the basic selling price for the given product group; select from the following options:

Calculation Method

This field is available if you selected Purchase Price in the Base Price field. You can choose one of the following options:

Example: You buy something for CZK 50 and sell it for CZK 100, i.e. at a profit equal to what it cost you. The margin is therefore 100%.

% (percentage) – Specifies the percentage depending on the calculation method. This may be a margin percentage or a discount percentage.

For each product and material group, selling prices with volume discounts can be defined. You can use the same calculation method as in the previous selling price calculation by setting a lower discount or lower margin.

There is also an additional option:
– to base the calculation on current selling prices by applying trade discounts. This option is intended particularly for wholesaler-to-dealer transactions where the supplier sets the selling price and the dealer's purchase price is negotiated. Since the only available base price is the selling price, it must be taken as the base (100%) for calculating the dealer's purchase price. The discount percentage indicates by how much the dealer's purchase price will be lower than the standard selling price.

Calculation = SP – (SP / 100 * %discount)

Example: You offer a dealer that what you sell for CZK 100 can be purchased for CZK 50. You are therefore giving them a 50% discount.

Base Price

The starting price used to calculate the basic selling price for the given product group; select from the following options:

Calculation Method

"purchase price" – the calculation method offers two options: margin or discount,

"selling price" – only one calculation option is available: apply a discount.

From Quantity

Up to 4 quantity levels can be defined, creating 4 volume discount tiers. If you set volume discounts from quantities of, for example, 10, 50, and 100 units (units = kg, pcs, litre — as specified in the price list), then when selling 1–9 units the base price (1st) will be automatically offered, when selling 10–49 units the 2nd price will be offered, when selling 50–99 units the 3rd price will be offered, and when selling 100 or more units the 4th price will be offered.

% (percentage) – Specifies the percentage depending on the calculation method. This may be a margin percentage, a discount percentage, or a discount rate.

If you make a change to a product group, using this option will propagate the changes to all price list items belonging to this group.

Description – Information entered in this field is printed in the product group print report.

Note – Here you can enter any additional information you need to store for the given product group.

Tags – you can attach various tags to a specific product or material group; click the Attach button to display the tag selection table; from the left-hand Available Tags table, use the arrow to move the tags you want to assign to the given record into the right-hand Selected Tags table, then confirm your selection by clicking OK; if you need to add a tag that is not yet in the left-hand Available Tags table, use the Manage Tags button; this opens the tags register (menu Tools – Registers – Tags), where you can add the required tag.

The "Administration" tab contains information about the time validity and visibility of the given record in the register (list). The validity of a record is specified as a range of calendar years. The record is valid within the specified range of years; outside that range, the record is not valid and will not appear in the register at all. By restricting validity, you ensure that users are not slowed down by having to scroll through obsolete records during routine use of the register.

Because time validity is tied to calendar years, it does not correspond to fiscal accounting periods.

Valid From – The calendar year from which the record's validity begins.

Valid To – The calendar year in which the record's validity ends. If you require the record to have unlimited validity, do not change the default value of "0" in the Valid From field and "9999" in the Valid To field. The record will then be usable in all calendar years and will appear in the list in every calendar year.

If you enter "2016" in both the Valid From and Valid To fields, the record will only be usable in the year 2016, meaning it will only be visible in the list during that year (see accounting period in the sidebar navigation header).