Skip to main content

Product Groups - WUI

Where to Find Product Groups in the Web Interface, How to Set Up Their Posting and Pricing, and How to Assign Them to Price List Items

Written by Petr Pech

The primary function of product groups is to set common properties for individual price list items and to categorize them. In this case, the properties in question are shared pricing and shared posting.

Table of contents:


Where to find product groups

The easiest way to find the Product and material groups module is by using search.

You can also find it in Settings at the bottom left, under Records › Goods and warehouses.


Setting up a product group

When you open the product groups module for the first time, it contains three groups by default:

  • Goods

  • Services

  • Material

You can edit these three default groups as you like, or create a new group (for example, by copying a default group). To open a group's detail, click the pencil icon that appears when you hover over the row.

Setting up shared posting

As an example, let's open the Goods group. On the Posting tab, we can see the preset posting.

If we create, for example, an issued invoice and add a price list item belonging to this group, account 604001 is filled into its posting (the issued inv. account field).

Setting up shared pricing

On the Pricing tab, you can set up shared pricing and apply it to the items in the group using the Apply to price list button.

For details on the pricing options for a product group, see our documentation.


Assigning a product group to a price list item

Switch to the price list and identify the items you want to add to the group. There are two ways to do this.

Individually (in the price list item detail)

If you want to assign a product group to a price list item individually, open the detail of the relevant price list item and fill in the Product group field.

The field should be visible by default. If it isn't, you can easily make it available by configuring the form.

In bulk (using bulk changes)

If you want to assign multiple price list items at once, use bulk changes.

Select all the price list items you want to add to the group, then click the … (More functions) button in the footer of the list and choose Bulk changes.

In the Bulk changes panel, keep the Set value operation, select Product group in the In field field, and in the New value field select the group you want to add the items to.

After you confirm by clicking Continue in the bottom right corner, the bulk change is applied.


Usage example

We'll demonstrate this on an issued invoice, to which we add one of the price list items belonging to the Goods group. We'll check whether the account 604001 mentioned above is filled in correctly.

So we open the issued invoices module, create a new invoice, and fill in an item belonging to the relevant product group. In our example, it is a USB-C hub.

If we open the item detail (using the pencil icon in the row), the Posting tab will show account 604001 in the Credit account – base field, which is the account set on the product group the price list item belongs to.

If a price list item belongs to a product group with an account set this way, copying the account from the document header (the Copy credit account – base option) is automatically turned off when the item is added to a document. The account set on the product group takes precedence.


Where posting comes from

The most common customer question is: "An account appeared on my document and I don't know where it came from." The account on a document item can come from three places. Flexi evaluates them in this order:

  1. Product group. As soon as you add a price list item to a document item, Flexi checks which group it belongs to and overwrites the account based on the posting set on that group. At the same time, it turns off copying the value from the document header, as shown in the example above. This is the most common reason an account appears on a document that the customer never entered manually.

  2. Posting template. If the group has no posting filled in, the account from the posting template specified in the document header is used. From there, accounts are transferred to individual items.

  3. Manual entry on the document. The last option is to enter the account directly on the document item.

⚠️ The warehouse account does not follow this sequence. It is always taken from the Warehouse account field in the warehouse list, usually 132 for goods. The product group determines only the offsetting account.


FAQ

What pricing setup options are available?

All pricing options are described in our documentation. For the settings available specifically for a product group, see this guide.

What is the difference between the price list tree and a product group?

The price list tree is used purely for categorizing items. For details on how to set it up, see our video tutorial. A product group, although it can also be used for categorization, primarily serves to set common properties.

Can I analyze sales or purchases by product group?

Yes, you can use the sales analysis or the purchase analysis. In the grouping options, select by product group. Each row of the analysis will then correspond to the relevant product group.

How do I filter price list items by product group?

In the price list, use the Product group filter above the table. All filtering options are described in the article on working with views; the older procedure is shown in this video tutorial.


Related articles

Did this answer your question?