New item
Introduction: Identification of products and related parts
The item registry of Fluentis plays a crucial role in managing and organizing information related to a company's items. It serves as a central database where details of each product are recorded and updated, allowing for a clear and systematic view of stock, costs, and warehouse movements.
The information contained in the item registry includes identifying details such as the item code, description, unit of measure, and information related to suppliers. In addition, data regarding prices, procurement policies, and lot management can be included, facilitating daily operations of purchasing, selling, and logistics.
Thanks to this registry, companies can track the status of items, automate processes such as reorder management, and obtain detailed reports for more effective purchase planning. Furthermore, integration with other Fluentis modules allows for better coordination of warehouse activities, improving operational efficiency and contributing to more accurate and adjusted stock management over time.
The procedure for creating a new item opens via the path:
- Home > Item > Create New Item,
or
- Home > Items > Search Items clicking on the New button present in the ribbon Bar of the relevant form.
The Item Registry form will open, consisting of a section where the mandatory characteristics of the item are defined and a lower section made up of various tabs that group its specific characteristics.
1. Header
The fundamental and mandatory characteristics that every item must have, found in the first part of the form, are: the Class (maximum 3 characters), the Code (maximum 50 characters), a brief Description, and the Unit of Measure.
The combination of class and code must be unique for that specific item.
Non-Mandatory Fields
- Second Description: a second description that can be assigned to the item;
- Configuration/Version: combo through which the version of the item is selected;
Once all the mandatory characteristics of the item have been defined, the more specific ones can be entered through the various tabs in the second part of the window, which are treated in the following documents.
Specific Buttons
Update LF LV with Formula: button that allows updating sales prices through specific formulas based on the list prices;
MRP Parameters: button that allows access to the MRP Parameters of that item, where the parameters needed to manage that item in production are defined; this button is also found within other forms related to the production area.
2. General Information
The General tab contains the main and logistical information of the items, such as the code, description, unit of measure, and other optional classifications, including the goods category and nature of the item.
This tab allows for defining additional details useful for the management and traceability of items within business processes, facilitating organization and reporting.
Specific Fields
Entry Date: field that is automatically filled in when the item is created, indicating the creation date of the item;
VAT Rate: combo through which the VAT rate related to that item is selected and entered; this field takes priority over the VAT rate assigned to the customer/supplier in the contact registry;
Agricultural Purchase VAT / Agricultural Sale VAT: which have a different management method;
Characteristic and Model: two non-mandatory fields that further define the item based on a series of groupings established within the company's product management;
Purchase Turnover: combo connected to a type of Purchase Turnover that has been defined in the chart of accounts for the accounting of purchase invoices;
Item Type: a non-mandatory table where an additional description of the item can be entered based on other internal groupings;
Nomenclature: in these fields, the nomenclature (i.e., the customs code of the item) is selected through help, useful for intrastat purposes for the declaration of goods for import or export, as well as for statistical purposes regarding the trade of items within the EU;
Perishable Goods Payment Days: connected to Article 62; for perishable goods, the invoice must be created and paid within a deadline of 30/60 days depending on the type of item. In this case, this check is done both on the item and on the type of payment entered so that invoices cannot be issued with a maturity date greater than that indicated;
Last edit date: indicates the date of the last modification of the item;
Tax Category: through this combo, the tax category to which the item belongs can be selected, which is useful for warehouse tax prints, to group inventories by tax category;
Product category: a statistical data similar to the characteristic, used in certain specific reports;
Sales Turnover: as with purchase turnover, this combo serves for the management of revenue detail accounts for the sale of the item;
Nature of Item: a field used to attribute specific characteristics to the item to be used in certain particular procedures. In the combo, there is a list of the various natures that can be attributed to the item (click for the glossary);
Equipment/Tool: this nature associates the item with the registry of measuring instruments and equipment found in the processing cycles. Machine/Plant: this nature is associated with the registry of machines; Items Family: defines the item as a family of articles/products in sales forecasting; Packaging: serves for the management of returnable packaging, for accounting (to understand how many packaging items I have in stock and how many I have given to the customer or supplier and thus how many they need to return to me); Services: for the management of post-sale interventions; Loan Use/Plant Component: used for maintenance management;
Available Options
Quality Control: if this flag is active, it triggers the quality control process, meaning that the item will enter the quality flow;
Phantom: if active, this flag serves to declare that the item should not be moved;
Tax Interest: if active, this flag serves to report the item in the tax prints of the warehouse;
ABC: for ABC, in inventory management for logistics purposes, it refers to a categorization method of inventory that divides items into three classes, namely A, B, and C, where A contains the most important items and C the least important items. It is a useful method to focus attention on few essential products rather than many products of little importance. If this method is used by the company, in this field will be the letter that defines the category to which the item belongs;
In exhaustion: if active, this flag indicates that the item is in exhaustion.
The conditions to receive the warning that the item is about to run out, in documents such as Customer Orders, are:
- in the customer order parameters the flag "Check items in stock" must be set;
- in the item registry, the "Out of Stock" flag must be set, and additionally, the "Out of Stock Date" must be less than or equal to the order date.
Date in exhaustion: indicates since when the item has been put out of stock;
Item without availability calculation: if the flag is active, the system will not consider availability for using the item;
Archived: if active, the item will no longer appear in the list of items that can be used, as it has become obsolete;
Copyright: if active, indicates that the item is subject to copyright/royalties and will be considered in the Royalties Management.
3. Administration
Within this tab, the business centers (cost centers) and any profit center of the item are entered, so that recalling the item in documents, the selected center or centers will be reported for use during accounting.
Grid of Business Centers: allows linking the item registry to one or more business centers;
Fields of the Corporate Centers Grid
Number: indicates the line number;
Cost Center: allows you to recall the cost center code;
Description: indicates the description;
Percentage: indicates the percentage of distribution among the various cost centers entered in the grid (if the center is unique, it will be 100%);
Division: allows pairing the association of the cost center to the item in relation to the selected Business Division;
Validity Start Date / Validity End Date: allow assigning validity to the relationship;
Dimension: allows specifying the size of the corporate center (for further details refer to the table of Corporate Centers);
Category: allows specifying the category of the corporate center (for further details refer to the table of Corporate Centers).
If the Controlling Management parameter, present in the Other Settings tab of the Company table, is deactivated, this field is used to input the cost center.
Profit Center: only if the Controlling Management parameter, present in the Other Settings tab of the Company table, is deactivated, will it be manageable and used to enter the profit center.
4. Procurement
The Procurement tab in the item registry of Fluentis allows you to define all the necessary parameters to optimally manage the stock of the item. In the first section, general data is set such as minimum and maximum stock levels, indicating the limits within which to maintain inventory quantities. Other parameters include coverage weeks, lead time for stock, and the reorder point, which establishes when a new order should be placed. Additionally, settings for label printers and label report types are available, useful for managing lots in different states (Unique, Compliant, Non-compliant, Quarantine). In the second section, these parameters can be specified for each warehouse where the item is present, offering accurate and customized inventory management.
In this tab, all the necessary data for the procurement of the item in question is defined.
The window consists of two parts:
a. In the first part, data for the general procurement of the item is set and not for individual warehouses:
Minimum and maximum stock: represents the minimum quantities that must always be present in stock for that item and the maximum quantities that can be held in stock;
Lead time for stock: represents the number of days needed to replace at least the minimum stock indicated for that item;
Coverage weeks: indicates the time frame (calculated in weeks) during which the stock will cover the need for that item;
Coverage Index: is an editable field where a percentage is entered that may or may not be considered by the scheduler or MRP for stock replenishment.
If the flag Consider Coverage Index is set in the MRP parameters, during scheduling the procedure will take into account the percentage indicated in this field to replenish the availability of the item for a quantity sufficient to cover the demand for the weeks specified in the Coverage Weeks field;
Reorder Point: here it is indicated at what quantity it is necessary to proceed with reordering that item;
Days for Reordering: necessary days for stock replenishment;
Reorder Point Review Interval: indicates how often the reorder point should be reviewed and updated;
Last Reorder Point Calculation Date: indicates the date of the last analysis made and when the reorder point mentioned above was established.
Then, there are two sections named:
-
Label Printers: allows you to choose the printers to propose by default for printing lot labels for different Lot States (Stati lotto); it will be possible to choose among the printer for the lot state Unique, Compliant, Non-compliant, and Quarantine.
-
Label Report Types: allows you to specify the default reports to print for the lots in different Lot States (Stati lotto); thus allowing different reports based on the status of the lot Unique, Compliant, Non-compliant, and Quarantine.
b. In the second part of the window, the various warehouses where the item can be found are indicated, and it is possible to define some of the above-mentioned data (minimum/maximum stock and lead time, reorder point and days for reordering, print unique/compliant/non-compliant/quarantine label) for each single warehouse. (for example, the minimum stock or the maximum stock that can be held for that item in that specific warehouse, and so on for the rest of the information).
5. Purchase Discount Categories
In this tab, the Discount Categories with which the item is purchased are entered. These categories are used by the Price Management in the purchasing module.
6. Sales Discount Categories
In this tab, the Discount Categorie with which the item is sold are entered. These categories are used by the Price Management in the sales module.
7. Customers
In this tab, you can associate to the item the list of customers who have purchased it.
Sampling Type: combo to define the default method of sample extraction from a production order for that item (for example, one sample every 100 pieces, or one sample every 3 orders, etc.). The sampling types are previously coded in the table under Tables > Logistics.
Upper Grid:
Customer: the account/detail account and description of the customer should be indicated;
Economic Lot: indicates the economic lot (the minimum quantity purchasable by the customer) with its corresponding unit of measure;
Customer Item: in this section, you can indicate the code and description that the customer assigns to the item in their database; by indicating their reference here, it will be displayed on all documents related to that customer for that item;
Usage Sector: here the customer's usage sector is indicated;
Sampling Type: in this case, you can select the sampling type of the item based on the associated customer, which may be different from the one selected in the initial combo of the window;
Data sheet: if there is already a technical sheet prepared for this item, this section will provide the details of the document;
Final Testing: this field is used to enter any information related to the type, year, code, and description of the final testing;
Variant: in this field, the possible variant of that item is entered, selecting it via the combo containing the variants previously coded in the Item Variants table;
Notes: section in which any notes can be entered.
The lower grid can contain information about Extra Data.
Specific Buttons
Insert Customers: allows you to insert a new customer;
Delete Customers: allows you to delete the record of a previously entered customer.
8. Barcode Codes
Within this tab, alternative codes also known as barcode codes representing the item can be entered.
Barcode codes are barcodes that contain some of the main information related to the coding of the item to which they are associated and are useful for warehouse operations. These codes are read through specific equipment called Mobile using laser beams or LED bars.
Barcode codes can come in different types.
The two types managed by the database are:
- EAN13 (this means that the barcode can have a maximum length of 13 characters)
- EAN128 (this means that the barcode must have an even length).
In Fluentis ERP, there are no predefined parameters indicating how to set the barcode in compliance with EAN13 and 128 regulations, but customized algorithms that adhere to the standard can be applied to verify that the entered barcode complies with the aforementioned regulations.
The form consists of a grid where a New barcode can be entered using the Insert button present in the ribbon bar, or by going directly to a new line.
In the Barcode Type field, the type of barcode to be encoded is selected via the respective combo, and in the Barcode field, the barcode itself is entered.
By activating the flag Export public administration, present in the table Barcode Types, the uniqueness check of the entered barcode is done only at the individual item level, while if the flag is deactivated, the uniqueness check of the barcode is performed globally, that is, for all items.
Specific Buttons
Validation: by pressing this button, the system will verify that the code complies with the regulations mentioned earlier regarding the length that the code must have based on the type of code being entered;
Delete Barcode Codes: allows you to delete a previously entered barcode.
9. Packaging
The packaging tab in the item registry of Fluentis is essential for defining how an item is packaged, specifying the types of Load Units that compose it. This configuration can have a tree structure, whereby a pallet, for instance, can contain different boxes, each of which can contain a certain number of items.
Accurately defining the packaging is crucial because it allows for the automatic generation of the necessary UDC for shipping when preparing an order.
Moreover, specific units of measurement for volume can be associated, and descriptions for customers or suppliers can be defined, thus allowing customized management according to the specific needs of each customer. Therefore, this tab serves as a key tool for optimizing logistics and inventory management.
Through this tab, the method of packaging the item is defined by specifying the types of load units that compose it.
It can be a tree structure since, for example, we can establish the pallet as the packaging method, which can contain a specified number of boxes, each of which can contain a specified number of items.
Defining the packaging allows the system to create the necessary load units for shipping when preparing an order for shipment;
The window consists of a grid within which the following information is entered:
Load unit type / Content load unit type: in these fields, the type of load unit, i.e., the type of packaging, and the type of content are entered by selecting the relevant option from the corresponding dropdown; the data present in these fields' dropdowns has been previously coded in the corresponding table Loading unit types;
Quantity: in this field, the quantity that the load unit can contain is specified;
Priority: in this field, the priority of the packaging is indicated (for example, if we have a pallet containing boxes, priority needs to be given so that when the system creates the load units it knows the packaging priority);
Account / Subaccount / Customer/Supplier Description: in this field, the customer/supplier requesting this type of load unit is entered. Thus, different load units can be defined at the individual customer level;
Unit of measure size: in this field, the unit of measure for the dimensions of the load unit is selected; upon entering the Load unit type, this value is retrieved from the table Loading unit types;
Height / Width / Depth: in these fields, the dimensions of the complete load unit are specified; upon entering the Load unit type, these values are retrieved from the table Loading unit types only if the Variable volume flag (present in Loading unit types) is deactivated; otherwise, the data will not be proposed and must be entered manually by the operator due to the impossibility of predicting how the items will be placed on the selected load unit. In any case, they can be modified manually, and any changes will also recalculate the Volume;
Volume unit of measure: in this field, the unit of measure for the volume of the load unit is specified; upon entering the Load unit type, this value is retrieved from the table Loading unit types;
Volume: in this field, the volume of the complete load unit is specified. If the Variable volume flag is active, when entering the Load unit type, this value is calculated by summing the empty load unit volume from the table Loading unit types and the article volume (taken from the Volume field present in the Weights / Dimensions tab of the item registry multiplied by the corresponding quantity) with the volume of contained load units. However, if the Variable volume flag is inactive, upon entering the Load unit type, the value of the empty load unit volume from the table Loading unit types will be reported directly since it is not variable. If the dimensions of Height / Width / Depth are modified, the Volume value will be recalculated accordingly. The volume will also be recalculated if there are changes in the volume of the Content load unit type. This value can always be modified manually;
Variable volume: indicates that this is a load unit with variable volume, meaning the total volume will vary depending on what and how it will be loaded; this field is read-only and filled in the table Loading unit types;
Weight unit of measure: in this field, the unit of measure for the weight of the load unit is specified; upon entering the Load unit type, this value is retrieved from the table Loading unit types;
Weight: in this field, the weight of the complete load unit is specified; upon entering the Load unit type and the Quantity, this value is calculated by summing the empty load unit weight from the table Loading unit types and the weights of the articles (taken from the Gross weight (Peso lordo) field in the Weights / Dimensions tab of the item registry multiplied by the corresponding quantity) or from the weight of contained load units. This value can always be modified manually;
Dimension tolerance/Quantity tolerance: are used in customizations and would be useful when creating a UDC picking list from a loading plan with available load units in the warehouse. The procedure should insert in the UDC list load units whose dimensions or quantities differ from those specified in the packaging by the specified percentages. Currently, they are not used as standard;
Mandatory dimensions: if active, this flag indicates that the specified dimensions are mandatory;
Mandatory load unit: if active, this flag indicates that this item must be managed through load units in production declarations and in goods receipt of the WMS;
Load unit description / Content load unit type description: in these fields, once the load unit type and the content load unit type are entered, the descriptions of the selected types will be automatically displayed.
10. Costs
In the Costs tab of the item registry in Fluentis, users can record various types of associated costs, including last cost and weighted average cost, which are automatically updated based on warehouse movements. The last cost represents the last recorded purchase price, while the average cost is the result of warehouse movements, useful for calculating the value of stock.
The tab also allows defining a standard cost, used as a reference for the year and usually updated annually. Additionally, the selling price can be entered, from which sales price lists can be created.
This information is fundamental for the valuation of stock and for financial planning, contributing to more effective management of stock items.
Within this tab, different costs associated with the item are entered.
Specific fields
Last cost and Average cost: for last cost, the most recent purchase cost is meant, while for weighted average cost, it refers to the average cost which results from warehouse movements. For both costs, the reason used for the warehouse movement must have the flag for updating Average cost/Last cost activated, as well as the flag for Update item cost and Fiscal interest; in this way, the relevant movements will be taken into account for cost calculation.
Standard cost/Subsequent standard cost: standard cost is a manually set or calculated cost that indicates the reference cost for a given item to be used during the year. It is usually a cost that gets updated at the beginning or end of the year. For purchased items, it usually corresponds to the average cost, while for other items, it is calculated using the Cost calculation procedure found in the Controlling area, as the sum of material costs and production phase costs.
All these costs can be used for bill of materials valuation, stock valuations, or (for purchased items) for production order (and related loading movements) item valuation when loading the item of a production order.
Selling price: base price from which to start creating a sales price list if a national starting price list is considered. If there are no price lists for this item, this price will be taken for the documents. (unless for return documents wherein the article will take the price indicated in the last cost by default to be verified) (it is not widely used).
Discount category/Price range configuration/Discount policy update formulas: these are commercial data used for price updates. The update formula is used in the procedure of Advanced Price List Creation.
No commercial conditions: when the item is used in documents, it will never display prices or discounts from the price lists it is included in, or the price from the item registry, and commissions on sales of this item will not be calculated.
11. Item Descriptions in Language
This tab allows entering the Description in language and Description 2 of the item in various working languages used.