Documentation
Back to website >

Article

General

The article management in EULANDA® contains a warehouse system based on warehouse accounts. This allows you to manage any number of storage locations and bins (both optional). The account balance of the main warehouse is displayed in the master data screen of the article. All other warehouses can be called up via the information system, provided the multi-warehouse module has been licensed.

Article mask

Article fields on the "General" tab

Number (alphanumeric, unique, max. 30 characters)
The article number is alphanumeric, so it can contain digits and letters, but must be unique.
To ensure a smooth data exchange with the Internet, e.g. via a web shop, only characters should be used in the article number that are also permitted in Internet file names. If possible, only digits, letters, hyphens, underscores and dots should be used.
With the "Copy article" function, the article number is automatically increased to obtain a unique article number. A "KA-21B (2)" is generated from an article number "KA-21B" when copying.
Matchcode (alphanumeric, max. 30 characters)
The matchcode is a field for managing an alternative search name. This can occur more than once in the article master.
Barcode (alphanumeric, unique, max. 30 characters)
The field Barcode must be unique when used. A barcode usually identifies a product using the EAN number. It is not mandatory to use the Barcode field as an EAN number. If products are imported via data carriers, these are usually EAN codes, so it makes sense to also assign EAN to your own articles.
In this case, internal bar codes should always start with 20. These numbers are never used externally, so that collisions cannot occur under any circumstances. In addition to EAN8, EAN13, EAN128, Code39, UPC and others can be used in the report designer.
If letters are also required in the field Barcode, only the Code39 or the EAN128 code can be used here.
VAT Gr.
VAT is managed via the "Settings" program item, which you can access via the quick start bar under "Accessories". When maintaining articles, this is only selected in the selection box.
The order category is used during invoicing to determine whether VAT is calculated or not. This is done by comparing the country code of the address with an EU country list and taking into account whether a VAT ID is stored for the address.
VAT is calculated for domestic invoices and invoices to other EU countries with a missing VAT ID. In all other cases VAT-free delivery. The euro zone can be changed in the settings.
PC Net (numerical display)
The product purchase price can be entered directly or calculated using the net list price and a discount. The Ek always refers to the specified price unit, i.e. usually to 1 piece.
Multi (calculating field)
The multiplier is a calculation aid for calculating the net list using an equity net amount. The Multi is not stored, but calculated by the SQL server for display only.
Net list (numerical display)
Specifies the net sales price of the item, that is, without tax. Net list always refers to the specified price unit, that is, usually to 1 piece.
After entering the net-list price, the gross-list price is automatically calculated. The VAT stored in the selection box is used as a basis.
If the net list price is entered, we speak of a net-exact price, in contrast to gross-exact prices. Modules such as the cash register work gross-oriented so that an exact amount can be taken over.
In addition to the standard list price, any number of price lists with any number of quantity-related prices can be stored for each article. Scaled prices are assigned to the article via the Extra menu. The article must already exist.
Discount (calculated field)
The discount allows you to calculate the purchase price backwards from the net price. With a price list net 50 EUR and a discount of 25% the Ek is calculated with 37.50 EUR. The discount is not saved, but calculated by the SQL server for display only.
Gross List (Numerical Display)
Indicates the gross sales price of the item, that is, including tax. Gross list always refers to the specified price unit, that is, usually to 1 piece.
After entering the gross-list price, the net-list price is automatically recalculated and also inserted in the template. The VAT stored in the selection box is used as a basis.
If the gross-list price is entered, we speak of a gross-exact price, in contrast to net-exact prices. Modules, such as the cash register, are gross-oriented so that an exact amount can be taken over.
Discount Gr
The discount group is set via a selection box. All discount groups that can be used are defined in the settings. They are used for pricing and statistics. Items can be divided into discount groups and customers into customer groups. You can use the settings to link any groups together by assigning a discount rate to each combination. This is proposed as a line discount in order management.
Stock (calculating field)
The warehouse stock is a calculated field and internally the account balance of the warehouse. EULANDA® works with a stock accounting. The predefined warehouse is the main warehouse of an item. The total of all account movements results in the account balance.
You cannot change the stock in this field; this requires a posting, such as a goods receipt in the main Warehouse Management menu.
Weight (numerical representation)
The weight is managed in the unit kg. Due to the four decimal places, the smallest weight unit is the gram.
The weight is used for identification on delivery notes. The weights of all products in a delivery result in a calculated package weight.
Unit of measure
The unit of measure is set via a selection box. All usable units of measure are defined in the settings. Units of measure can be placed in front of the item number in the report, for example, quotations, invoices, delivery notes. Units of measure are often transferred via the product text during data medium exchange; for this reason, they are not used in the standard reports. However, you can use the units of measure as a field in your quotations, invoices, etc. at any time.
Packing unit (numerical representation)
The packaging unit specifies the number of units in which a sales unit is packed. The packaging unit has nothing to do with price determination, as is the case with the price unit. For example, the packaging unit can be specified in 12 bottles if beverages are only to be offered in crates.
Goods group
The material group is set via a selection box. All usable material groups are defined in the settings. They are used for structuring the articles and for statistics.
Revenue-Gr
The revenue group is set via a selection box. All usable revenue groups are defined in the settings. The revenue groups are used for further processing of data in Financial Accounting and for statistical purposes.
The revenue account is only set during billing. The system compares the revenue group with the constants/settings and checks which order type is involved (domestic invoice, EU foreign invoice, invoice for the rest of the country). The revenue account stored there is used on the basis of the order type.
EULANDA® automatically recognizes the order type by comparing the country code of the address with the euro zone. The euro zone can be changed in the settings.
Storage type
Each storage type corresponds to a defined value, which is stored in the database and can be used for external modules.

Selection

Value

Description

(invalid)

16

Selects an invalid storage type

Storage type A,B,C

17-19

All these types are treated in the same way in Warehouse Management. They are all managed in the standard warehouse (account 1000, if no multiple warehouse is in use). Depending on Setting of stock management this stock allows negative quantities or not. The classification according to A, B and C can be done at your own discretion - for example according to availability. see below.

Storage type A

17

Items of storage type A should always be in stock. Typically, a minimum stock level is stored here in the article master.

Storage type B

18

Articles of storage type B are articles that are kept in stock but are only ordered if required. In contrast to storage type C, when an order is received, these articles are ordered above the current requirement, so that remaining stock is transferred to the warehouse after an order has been fulfilled.

Storage type C

19

Articles of storage type C are ordered individually for the order and always only in the quantity required.

Dispatch service

20

These items are not in stock and are reserved specifically for postage and freight and are available in unlimited quantities.

Inventory

21

Items with this ID are not managed in the standard warehouse, but in the inventory warehouse (account 500). This type is intended for the future inventory management module.

Internal consumption

22

This type is used to identify articles that are intended for personal use only and for which no stock management is required.

Work performance

23

No stock items and unlimited availability.

Office use

24

like own consumption

Production items

25

This layer type identifies articles that are manufactured in-house. In principle, storage is managed in the standard warehouse (account 1000), such as storage type A. In connection with the upcoming production module, these articles will be included in the production control. Without a production module, this type only serves as a further subdivision of the stock items in addition to types A,B,C.

Commision goods

26

Special bearing type in connection with the multi-bearing module

Rental

27

Special bearing type in connection with the multi-bearing module

Vvaluable article

28

This storage type is intended for pure credit memos without stock movements.

Image (binary image data)
Each article can be assigned two images, which are the same image but with different resolutions.
Double-click on the image area to open the image editor. Here you can read in images of different formats or scan in an image directly.
Short text1, short text2 (alphanumeric max. 60 characters)
The short text is stored in two lines. Each line can contain up to 60 characters of text.
The short text is copied to the long text if it is empty and the cursor is moved to the long text field by pressing ENTER. EULANDA® uses the short text as standard only for data medium exchange. However, it can be used in all transaction reports such as offers, delivery notes, etc.
Ultra short text (alphanumeric max. 50 characters
Is used especially for the cash module and is always single-line.
Long text (alphanumeric max. 2 million characters)
The long text is the actual working text used in all reports such as quotations, order confirmations, invoices, and so on. The long text is saved dynamically so that only the memory space that is absolutely necessary is used.
You should only separate lines within the long text with ENTER if it is a paragraph. All printouts use the long text with a variable line break that always uses the available width.
Info (alphanumeric max. 2 million characters)
The info is specially designed for internal information. However, it can also be used as an alternative text. The information text is saved dynamically, so that only the absolutely necessary memory space is used.
You should only separate lines within the info field with ENTER if it is a paragraph. All printouts use the info text with a variable line break that always uses the available width.

Article fields on the "Advanced" tab

The index card of the article mask can be changed using the "View" menu, the key combination CTRL+TAB or directly by clicking on the word "General" or "Advanced". In addition, you can select the "Advanced" tab with ALT+E and the "General" tab with ALT+A directly.

Extended index card

Shop Release (Yes, No)
Idenotes items that can be transferred to the eCommerce system.


Indicates items that are about to expire. This identification is transferred to the eCommerce system.

Special offer (Yes, No)
Idenotes items that can be purchased at special prices. This identification is transferred to the eCommerce system.

New article (Yes, No)
New articles. This identification is transferred to the eCommerce system.

Export date (date field)
The export date is set automatically as soon as the article is transferred to the eCommerce system. This date field determines whether the article must be transferred again. In this case, the internally used modification date is compared with the export date.
If you always want to transfer the article during the next synchronization, you set the date to a value such as "01.01.1980". The last change date is always newer, so that the article is always transferred.

Language (checkbox)
The language in which the article text is formulated is set in the Language field. As a rule, this field has the value Standard. The language of the installation is assumed. Other values are only possible with the multilingual module. With the multilingual module texts in different languages can be added to an article. If a language text does not exist, the text of the standard language is used in order management.

replacement article (alphanumeric, max. 30 characters)
The replacement article determines an article in the article master that is very similar in properties. For discontinued items, the replacement item should be the successor.
The Replacement Item field has no server check. The presence of a replacement article is therefore not mandatory.

Manufacturer number (alphanumeric, max. 30 characters)
The manufacturer number is a common product number assigned by the manufacturer. This number should not be confused with the barcode number.
A colour cartridge of the manufacturer Hewlett® Packard with the barcode number 088698707364, for example, has the "HP C1823D" as manufacturer number.

Goods number (alphanumeric, max. 20 characters)
The goods number is only required in connection with the Intrastat declaration. It denotes the goods number assigned by the Federal Statistical Office for all products.

Country of origin (alphanumeric, 2 characters)
The country of origin is required for the Intrastat declaration. The country of origin is indicated in ISO code.

Region (alphanumeric, 2 characters)
The region is required for the Intrastat declaration.

Serial number required (read only; Yes, no)
This identifier indicates whether serial number management is enabled for this item. It is a pure display field. The serial number module is optional. An item is set to serial number requirement by setting this menu item in Browse mode in the item's extra menu. Here EULANDA® creates all necessary accounts.

Commissionable (Yes, No)
You can use this ID to specify whether the article in question is commissionable. This concerns the optional substitute module.
by default this identifier is not evaluated. If it is to be used, the substitution settlement report must be adjusted accordingly.

Batchable (read only; Yes, no)
This property indicates whether the item is a batchable item. The batch module is optional. An article is set to batch management by setting this menu item in scrolling mode in the article's extra menu. Here EULANDA® creates all necessary accounts.

Min (numeric, display 18.4)
The minimum stock level. For order proposal lists, this field can be used to include the article in the proposal list.

Max (numerical, representation 18.4)
The maximum stock level - for information only.

Order quantity. (numeric, diagram 18.4)
The order quantity that is to be ordered by a product if the article has fallen below the minimum stock level.

storage bin (alphanumeric, max. 40 characters)
The storage bin is a location name for the main goods warehouse. If the optional multi-warehouse module is available, a storage bin can be specified for each warehouse account.

Warning (alphanumeric, max. 100 characters)
The text entered here will be displayed in the order management as soon as this position is selected.
Here you can display warning texts such as "Note safety instructions..." or "Attention, the article runs out" etc.

User fields (various)
User fields can be defined under System Administration, which you can access via the quick start bar. The place where these user fields are inserted after the restart is this region.

Funktionen

General Functions

The chapter on operation describes how to search for data, add data and navigate in the data. It also describes how to jump to connected program modules via hyperlinks. You can delete data via the navigator and there via the minus symbol or, if desired, even hide it.

Stock

The warehouse stock is maintained via the goods receipt. The display in the screen mask shows the account balance of the main warehouse on the screen.

The information system

The information system allows you to call up further information on each article displayed. It is called via the extra menu or the key combination CTRL+I. Operation of the information system is described in the chapter entitled "Operation.

The information system can immediately list all customers who have purchased the product, as well as the stock movements, the open orders in which the product appears, and the statistics.

Information system in articles

General information system

The general information system displays overviews that refer to all articles. This means that no special article needs to be displayed in scrolling mode. The general information system is called up using the special menu or the key combination CTRL+UMSCH+I.

Information System - General

Printing

There are two different printing scenarios: In the first case all articles loaded in the display are output with the selected report, in the second case lists are output independently of the loaded articles.

Master data, labels and price lists refer to the articles loaded in the display. If you want to print out all articles, set the number of hits to "all" and enter the ENTER key in the field Article number without text entry. Now all data is retrieved from the database server and can be transferred to the report. Since all search methods, including the characteristic tree, are available, the desired lists can be generated very easily in this way.

Statistiken werden unabhängig von den angezeigten Artikeln ausgegeben. Hier stehen Grafiken und die flexiblen Kreuztabellen zur Verfügung.

Print selection

View

Characteristics tree

The characteristic tree allows you to store any characteristics in a hierarchy that you can freely define. The list is displayed using this function and can be pinned to the mask with the pin in the right window corner if desired. In addition, the feature tree can be activated by clicking on the word "article" in the header bar.

The operation of the feature tree is described in the chapter entitled "Operation.

Characteristics tree

Short info

With the short info you can display additional information about the displayed article in a clear form. The short info is linked into the main window as an independent view area - like the characteristic tree. Therefore, your screen should have a resolution of at least 1280 × 720.

The "Actions" menu

Activities

Duplicate article (kopieren)

The "Duplicate article" function can be called up via the "Extra" menu. The reference article must be in scroll mode. This function is also available via the key combination ALT+Q.

During copying, the article number is automatically incremented by adding an additional number in parentheses to the existing article number. An article number such as "MK-345G" would then read "MK-345G (2)" or "MK-345G (3)", and so on. In this way, the reference article can be copied several times.

Merge Articles

Various articles can be merged via this menu item. This creates articles that are no longer required and are automatically deleted.

Reasons for merging

Delete Article

If you want to delete an article and determine that it is still needed in the system, you can remove this article using the "Merge article" function. Normal deletion would fail because no data record that is still in use in the system may be deleted.

The article to which the connections are connected can, for example, be a simple "dummy", i.e. an article that you have created as "miscellaneous" with article number and matchcode, for example. This can be used as a "collecting article" for articles that are no longer required.

The "Merge article" function selects all connections in the system that use the article to be deleted and transfers them to the "dummy".

Standardizing the Article Master

If you have imported the article master from wholesalers, it often happens that a different article number is used for one and the same article. If you now have several articles, all of which in reality represent one and the same article, you can select one after the other and merge them into the one with the best description text. Not only the references in the system are reconnected, but also the source of supply of the article. The new sole article contains information on the individual suppliers from whom it can be obtained.

These sources of supply can be viewed in the information system of the article. There is also the original article number of the supplier for each supplier. In this way you can still maintain the supplier's prices and EULANDA® always knows which is the new main item.

Mode of operation and limitations

First select the article that is no longer needed, then the function "Merge article" is used in the action menu of the article.

In the dialogue box that then appears, select the target article to which the transactions are to be reposted.

Merging articles is a complex process that also has its limitations:

  • The source article may contain no BOM. This must first be deleted manually via the parts list management.
  • If the source article has delivery sources, the system tries to copy them to the target article. If the target item already has a source of supply for the same vendor, the source of supply for the target item is retained.
  • If both articles serial numbers are required , the serial numbers are mixed together. Duplicate serial numbers are not allowed. Otherwise, the merge is aborted with an error message.
  • If only one of the two items requires a serial number, the item that does not require a serial number must not have warehouse stock. The same restrictions apply as when switching on serial numbers.
  • Price lists are not mixed. After merging, only the price list of the target item is retained.
  • Loaded articles cannot be merged

The "Advanced" Menu

Extended

Tier prices

<pEULANDA® can store any number of prices for an item. This is realized via price lists, which you can freely define. In each price list you can also store scales, i.e. quantity-based prices, if desired. Alternatively, the dialog for the graduated prices can also be opened with the small button with the designation"...".

Tier prices

Parts lists (optional)

In the structure you can load the part or subpart list into the display of the main window. To do this, click on the element and press the "Go to" button.

The display is updated in the main window. You can use the blue arrows marked "Go to" to switch to the views last used. The original main BOM is accessed via the house (Home).

Bill of material for a basic article

Specification

You can define as many BOMs as you like and nest them as deep as you like. If you want to define a BOM for an article, select the menu item "BOM" in the extended menu. The article must be in scrolling mode.

Use the "Add" button to select the individual articles. After pressing the button you can enter your search text in one of the lower article fields and search as usual. Press ENTER to add the article to the BOM with quantity 1. If you want to change the quantity or calculation, press the "Change" button.

The two tabs "Subordinate" and "Superordinate" allow quick orientation to the parts of the parts list or to other nested parts lists.

You can use the "Go to" buttons to display the article information for the subparts.

Note: All items in the BOM must have one and the same currency.

Tree structure

Via the "Tree" button in the parts list window or with UMSCH+F9 from the article mask, you can display the complete parts list with all sub-bOMs at any time. Double-click to call up the relevant part article or the part list. Use the * key to display all BOM levels.

Tree structure

Produce parts lists

Bills of materials can be produced or disassembled. To do this, enter the corresponding quantity for production next to the "Produce" button or a negative quantity if a BOM is to be split.

The warehouse posting process can be looked up in the warehouse system under "Warehouse posting".

Produce parts lists

Information

The extended index card of the article master immediately shows whether the current article is a BOM, part of a BOM or both.

Extended article index card

In search mode, when searching for parts lists or parts of a parts list, you can click on these boxes; they are evaluated as filters.

If the displayed article is a BOM or BOM item (= BOM part), the descriptions of the field are automatically hyperlinks and you can click on them. The hyperlink takes you straight to the parts list dialog.

The "Extras" menu

The "Extras" menu