This form contains a list of all goods, materials, products, and services. A goods group can be assigned to each record, which simplifies accounting during purchasing and sales. You can also specify a selling price at which you want to sell a given item (it will then be offered when selling on invoice or for cash).

If you need to track serial numbers for any item, you must mark it accordingly. You can set a primary supplier for each item. Individual prices can be set for specific customers (or customer groups).

If the inventory type "Stock Goods" or "Product" is selected, stock cards are created for the price list item.

Warning:

Changes made are irreversible, so use this feature with caution.

Warning:

The price list includes certain options (settings for how selling prices are calculated, volume discounts, selling in whole packages, or selling in unit-of-measure multiples) that are included in a service that extends the price list.

This structure allows you to sort goods according to your own criteria regardless of goods groups. It is used for better navigation when the price list contains a large number of items.
You can show/hide the tree price list using the button to the left of the "Individual Price List" button.

Unattached Items

This folder contains all items that have not yet been attached to any folder. We recommend not renaming this folder.

Attached Items

You can create separate subfolders for this folder using the second button from the left. You can also create further subfolders within these subfolders.

As a first step, we recommend adding folders and subfolders for attached items. To add a new price list folder, proceed as follows:

You can freely create the necessary subfolders within the created folders. (The process is the same as creating folders — simply select the folder to which you want to add a subfolder with your cursor.) You can edit the created folders and subfolders using the first button and delete them using the button with a cross (third from the left).

After creating price list items, you need to attach them to the desired folder:

Similarly, you can detach specific price list items from a folder using the detach button.

Abbreviation

This field is used to enter an abbreviation and is not mandatory.

Name

This field is used to enter a name and is mandatory. If you have set up foreign languages in the initial setup, pressing the "+" button allows you to fill in the "Name" field in the selected foreign languages. These language variants of the name are printed on documents during foreign-language printing. Press the "-" button to close the foreign-language name fields.

Order

Here you set the order of the folder within the price list structure.

Icon Path

Using the button, you can assign an icon to the new subfolder.

Short Description; Keywords; Description; Text Above; Text Below

On this tab, you can store documents related to a given node in the price list tree structure.

The top toolbar contains a number of buttons, the meaning of some of which is described in the separate chapter "Program Controls".

Using the button, you can add a new attachment. When adding, you can choose from the following options:

An icon is displayed next to the inserted attachment, allowing you to view the attachment at any time. Using another icon, you can save the attachment to a different location. The button is used to scan the document; the second option allows you to select the scanner and scanning parameters.

Using this button, you can rename the "Attached Items" folder and any created subfolders, change their order, and add, edit, or delete icons.

Using this button, you can add separate subfolders. You can also create further subfolders within these subfolders.

Using this button, you can delete created subfolders.

Using this "+" button (third from the right), you can attach price list items to a folder.

Using this "-" button (second from the right), you can detach price list items from folders.

Using the last button, you can detach all price list items from folders and subfolders and move them to unattached items.

Warning
​There is no way to check how and where items from the price list are attached.

If a price list item is attached to a folder, it will no longer appear in the "Unattached Items" folder.

However, when selecting price list items to attach, items that are already attached to another folder are also displayed. For example, you sell portable car fridges and want them to appear in both the "Refrigerators" folder and the "Car Accessories" folder.

All price list items in a subfolder are simultaneously displayed in the parent folder. However, you can place a price list item only in the parent folder without assigning it to a subfolder. For example: you sell refrigerators (parent folder), but you also want to place those same portable car fridges in a separate folder.

Creating price lists and prices is a very extensive topic, so we recommend attending our training sessions, which will explain how to work effectively with the price list in ABRA FlexiBee.

Press the button or the keyboard shortcut Alt+N to open the form for a new record. If you want to attach a goods item to a specific folder/subfolder in the tree structure, simply have that folder or subfolder selected. After saving the form with the new record, it will be saved to the selected folder/subfolder.

The top toolbar contains a number of buttons, the meaning of which is described in the separate chapter "Program Controls".

Name

Required field, can contain up to 255 characters.

It generally represents the record in overviews, print reports, or selection lists, so the record should be described in a unique way. If you have set up foreign languages in the initial setup, pressing the "+" button allows you to fill in the "Name" field in the selected foreign languages. These language variants of the name are printed on documents during foreign-language printing. Press the "-" button to close the foreign-language name fields.

Code/Abbreviation

The field can contain up to 30 characters. It serves as a unique identifier for the price list item. Using this code/abbreviation, you can more easily search for items in the price list. You can use it in business relationships with both suppliers and customers. It is generated automatically after you fill in the price list item name (it takes the first word from the Name field); it can be overwritten as needed. Note: we do not recommend using abbreviations that are unrelated to the name of the price list item (as they are difficult to remember).

VAT Rate – value added tax amount; the drop-down list contains the following values:

Price Type

This field relates to the set selling price. If you use the extended price list, this field also affects the rounding of the selling price. There are 3 options:

Selling Price Excluding VAT / Including VAT

This price is offered when selling the given goods on invoice or for cash. Depending on the purchased version, you either calculate it yourself or it is calculated based on the configured pricing. In either case, you can adjust it individually – by overwriting it.

Inventory Type

The value in this field must be selected before you start working with the price list item; otherwise, the system will not allow you to make any retrospective changes. For example, select the value "Goods" and check the Stock Goods flag. The following inventory types are available:

Types: goods, materials, work in progress, semi-finished products, finished products, and under certain circumstances also animals.

Types: service, fee.

Goods Group

Optional names based on anticipated use; selecting a value in this field is important from the perspective of pricing and accounting. The values offered are those recorded in the menu Goods – Goods and Material Groups.

For clarity, filling in the price list card is divided into several tabs.

​Tabs in the upper half of the card:

Tabs in the lower half of the card:

This tab is used to refine the details in the price list. The information is mostly optional (with the exception of the requirement to define a warehouse location for inventory types "Stock Goods" and "Product"), and it is up to the user whether to use it.

Unit of Measure

Use the drop-down list to select the appropriate unit of measure. Four basic units are set by default – kilogram, kilometer, piece, meter. If you need to add another unit of measure, press F2 to open the "Units of Measure" dialog, where you can add the required unit (menu Tools – Codebooks – Units of Measure).

Number of UoM Decimal Places

Up to 6 decimal places can be set.

Purchase Price

The purchase price is an important piece of information for Business and Premium version users who use the extended price list to calculate selling prices. In other cases, it is for informational purposes only. You can update this price using company settings. If you are a VAT payer, always enter the purchase price excluding VAT (the price type setting does not apply in this case).

EAN

An internationally unique company number assigned by the relevant authority, required for EDI electronic data exchange.

PLU Code

This is a goods identification number that came into use in the early 1990s. The reason for its introduction was more precise and faster control of stock levels. PLU codes made it easy to distinguish similar products with different prices. The PLU code is sometimes referred to as an "internal goods code" or internal ID in some systems. Today, PLU is used primarily as an additional product identifier in information systems, for sales purposes, or for inventory and stock-taking.

Individual Minimum Margin

Checking this flag enables the % field, where you can enter the value at which you want to sell the given stock item (e.g., the purchase price of a product is CZK 100 and the individual minimum margin is 10%; if you want to sell the product for CZK 110, you will be notified that you earn CZK 10 on each product).

Warranty

For goods subject to a warranty period other than the standard one, the warranty duration can be set. Use the drop-down list to choose between month/year. No other option can be set.

Weight (net)

The net weight of the given goods. Use the drop-down list to choose between kilogram/piece/meter. Press F2 to open the "Units of Measure" dialog, where you can add the required unit (menu Tools – Codebooks – Units of Measure).

Packaging Weight

The weight of the packaging for the given goods. This value is stated in the same units as the net weight (additional values can be added via the menu Tools – Codebooks – Units of Measure).

Volume

The volume of the given goods. Use the drop-down list to choose between kilogram/piece/meter. Press F2 to open the "Units of Measure" dialog, where you can add the required unit (menu Tools – Codebooks – Units of Measure).

Define Warehouse Location

If you have set the "Inventory Type" field in the main panel to "Stock Goods" or "Product", you must fill in the warehouse name where the goods or product is located. Press the Define Warehouse Location button to display the "Warehouse Selection" dialog. Use the right arrow or double-click to move the selected warehouse from the left column "Available Warehouses" to the right column "Selected Warehouses". Confirming this dialog transfers the selected warehouse to the empty field on the price list card. At this point, the system is instructed that a stock card must be created for these goods, in which all information about movement, status, and average price is stored. If you check Automatically add new goods to this warehouse in the warehouse list for the selected warehouse, this field will be automatically pre-filled with the warehouse.

If you view a price list item during the year and have stock on hand, the stock quantity will be shown in parentheses after the warehouse name.

Update Labels

Do not overlook this field. Labels are used to "attach" important information. The versatility of labels and the ability to assign multiple labels (any number of different labels to a single document) gives you unlimited options for creating selections based on various combinations of these labels. Press the Update Labels button to display the "Label Selection" dialog. Use the right arrow or double-click to move the selected label from the left column "Available Labels" to the right column "Selected Labels". Using the "Label Management" button, you can open the label list, where you can add labels with additional information important to you. Confirming the "Label Selection" dialog transfers the selected labels to the empty field on the price list card.

Track Serial Numbers

By checking this checkbox, you inform the system that serial numbers are required for this goods item. Without entering serial numbers, purchase and sales documents cannot be saved. Serial number tracking can be cancelled or newly activated during the year. In the latter case – when checking the "Track Serial Numbers" field – you will be notified that serial numbers will need to be added to documents containing this price list item. To find the relevant documents, use the "Stock Movements – Overview" option and filter the price list item using the filter. If serial numbers have been filled in for a document, the "S/N OK" field will be checked in the table view. Serial numbers are stored in a separate tab of the price list card. Information about them is also transferred to the stock card.

Serial Numbers Must Be Unique

This checkbox is only available when the Track Serial Numbers checkbox is checked. If checked, uniqueness of serial numbers will be verified among the serial numbers of the given goods when adding new serial numbers.

VAT Transfer Code

This field is intended for VAT payers subject to § 92a – the reverse charge mechanism for the supply of gold and the supply of goods listed in Annex No. 5. Use the magnifying glass button to select the relevant type of goods from Annex No. 5, which will then also be displayed in the price list table view.

Exclude from 1+1 Free Promotion

This checkbox is displayed only when the 1+1 free sales promotion is active; otherwise it remains hidden. When checked, the goods will be excluded from the 1+1 free promotion, meaning that purchasing it will not entitle the customer to an additional free item, nor will it serve as the free item.

Warning
This tab is part of the service that extends the price list. It can only be used in the Business and Premium editions. Here you record selling prices for a specific group of customers and goods group.

Each price list card has a goods group filled in on the main panel. Most of the information is then transferred from this goods group to this tab:

Therefore, these fields are currently inaccessible. If you want to keep this selling price calculation method, you have the option to fill in the following.

Number of UoM in Price

In most cases, the value "1" is preset (the system will allow the sale of 1 unit and then set the selling price as 1/2 of the defined selling price). Note: the value in this field can be overwritten at any time.

Purchase Price

The value in this field was transferred from the same-named field on the Details tab; the mechanism also works in reverse, i.e., if you fill in this field on the Pricing tab, its value will be transferred to the field on the Details tab.

This is an important piece of data for Business and Premium users who use the extended price list for calculating selling prices. In other cases, it is informational only. This price is not yet updated in response to price changes during purchasing. If you are a VAT payer, always enter the purchase price excluding VAT (the price type setting does not apply in this case).

Recalculate

Use the Recalculate button whenever the purchase price changes. This will recalculate the selling price according to the configured calculation method and round it according to the configured rounding method.

If you do not want to keep the current selling price calculation method based on the selected goods group, you have the option to define individual pricing.

Individual Pricing

Checking this enables the fields on the Pricing tab, allowing you to set individual pricing for this price list item only; the method of filling in is the same as in the menu Business Partners – Goods and Material Groups on the Basic Price Levels tab.

Base Price

From the drop-down list, select the base price: purchase price / no price

Calculation Method

Choose from the following options: margin – the difference between the acquisition price and the selling price; discount – a percentage reduction from the selling price provided by the supplier to the buyer.

Rounding Method

Choose how you want to round the price: up / down / mathematically

Rounding Order

Select the rounding precision: no rounding / thousandths / hundredths / tenths / units / tens / hundreds / thousands

Base Price

purchase price / selling price

Calculation Method

Choose from the following options: margin – the difference between the acquisition price and the selling price; discount – a percentage reduction from the selling price provided by the supplier to the buyer

From Quantity, %, Price 2nd, 3rd, 4th, 5th – the percentages and prices of calculations are based on the quantities you specify.

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

Here you record selling prices for a specific group of customers and goods group (selling in multiples, in different packaging). It contains information about conversions to other units of measure.

Manufacturer

This field is not mandatory. You can fill it in using the magnifying glass from the business partners list.

Standard Price

This is informational data that is not used further. It is primarily useful for online stores.

Classification

This field is informational. The user can enter, for example, the location of the goods in this field.

Enter the number of multiples if you do not sell goods individually but in multiples, e.g., pallets, tiles, notebooks with covers. Note: if you attempt to sell a different quantity, an error message will appear:
​

If you decide to sell in multiples, you can set the price for these multiples in the Number of UoM in price field on the Pricing tab. When selling individual units, the selling price offered is 1/X of the selling price, where "X" is set according to the Number of UoM in price field.

This section is used to record goods sold both individually and in various packages (carton, pallet, etc.). Up to 5 different packaging types can be set; if you also sell individual units, create just 1 unit for each packaging type. You configure the following values.

Name

Name of the packaging (e.g., individual, carton, pallet).

Number of UoM

How many UoM (unit of measure as specified on the Details tab) the packaging contains (e.g., for the name "individual", enter 1 UoM).

EAN

If you use barcodes, you can enter a barcode for each packaging type.

Price

A non-editable field that displays the selling price for the entire package, provided you have a selling price per UoM set in the form header.

Here you can fill in additional informational data. A situation may arise where the unit of measure on the "Details" tab is set to, for example, piece. However, the item is a small material and you know that, for example, 200 pcs weigh 1 kg. Therefore, you can set UoM No. 2 here and select this second UoM – kg. In the adjacent field UoM2/UoM1, enter the conversion coefficient as the ratio UoM2/UoM1, i.e., 1/200 = 0.005, meaning one piece weighs 0.005 kg. From this, you can easily calculate how many pieces you are selling if you sell 0.33 kg.

Track Batches

Track Expiry Dates

Shelf Life is X Days After Expiry

Warning
This conversion is not used anywhere else. This information is truly for your reference only.

This tab is used to provide more detailed information about the price list item. If you selected foreign languages in the initial company setup (Company – Settings – Legislation), you can also fill in this description in those languages. The description of the price list item is not printed anywhere; it serves as information for your reference only.

Description

More detailed information about the price list item in the default language.

Description EN, Description DE, Description FR

More detailed information about the price list item in English, German, and French, or more precisely in the languages you have selected.

This tab allows you to record any notes you need to keep associated with the given price list item.

Short Description

Keywords

Technical Parameters

Delivery Time

Export to Online Store

Intrastat is an electronic data collection system mandatory for all EU member states. This tab allows you to record all the required data.

Track Intrastat

Check this flag if the given goods are subject to Intrastat reporting.

Country

Select the country of origin of the goods from the drop-down list. Note: the country can also be filled in on the document.

Nomenclature

Using the icon on the right, you can select customs code codebooks – the menu Tools – Codebooks – Intrastat – Nomenclature Codes will open.

Goods Type Tracking Code

UoM Coefficient

Statistical Value Coefficient

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

Since time validity is tied to calendar years, it does not correspond to fiscal