Products
Use this function to enter and describe the products referenced in stock: finished goods, (parent) BOMs, raw materials, spare parts, products, services, prototypes. Products can be manufactured, purchased, subcontracted, and sold according to a management policy adapted to each product or stock unit.
Prerequisites
Refer to documentation Implementation
Screen management
- Header
- Tab Identification
- Tab Management
- Tab Units of measure
- Tab Financials
- Tab Sales
- Tab After-sales
- Tab Customers
- Tab Purchasing
- Tab Suppliers
- Tab Attributes
The Products function contains a header and a section for each characteristic to be entered:
- Header information. The header provides key tracking information, including the product category and status.
- Identification This is the main section of this function. Use this section to enter basic information about a stock item.
- Management Use this section to specify stock management parameters.
- Units of measure Use this section to assign default management and packing units when, for example, the product packing type varies based on the ordered/received quantity.
- Financials Use this section to define accounting data for the product.
- Sales Use this section to define sales management rules for the product. This section is only available for sold products.
- After-sales Use this section to define information for the product that can be used by the Customer relation (CRM) module.
- Customers Use this section to define sales management rules for specific customers. This section is only available for sold products.
- Purchasing Use this section to define purchasing management rules for the product. This section is only available for purchased products.
- Suppliers Use this section to define purchasing management rules for specific suppliers. This section is only available for purchased products.
- Attributes Use this section to assign characteristics to this product. These characteristics can then be referenced in your manufacturing processes.
Header
The header provides key tracking information, including the category (purchased, manufactured, sold, subcontracted) to which the product is assigned. The header information is displayed irrespective of the section being selected.
Category (field TCLCOD) |
Use this field to identify the category of product to which this product is assigned. Some fields are associated with this code in the Product category table (ITMCATEG) and will influence fields in this function as you create the product details:
|
Product status (field ITMSTA) |
The product status determines the availability of the product. The statuses are: Active, In development, On shortage, Not renewed, Obsolete, and Not usable. The default status when creating a new product is dependent on the creation method defined for the assigned product category:
Impact of the product status in the sales and purchase modulesSales
Purchases
Upon receipt of the product, an order or a delivery can be selected. Use the status to change product availability. The titles in the local menu can be set up and managed as follows:
Non blocking and blocking messages according to the context and status:
Non-blocking: In development, Not renewed, Obsolete Non-blocking: In development, Not renewed, Obsolete No message: In development, Not renewed, Obsolete |
New product in design mode (field NPIPROLAB) |
This warning is displayed if this product is still in design mode, that is this product has been created from a product design BOM revision that has only been released as a prototype product. It is not yet released as a full production BOM. |
Product (field ITMREF) |
This field indicates the product reference code. It is generated by a sequence number counter (set up in function Sequence number counters) in the case when the product category has a sequence number counter code. The reference cannot be modified. It is automaticaly assigned and displayed at product creation end. |
Description (field DES1AXX) |
This long description is used as a title in screens and reports. By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user. You can add your translation in another language using the Translation function:
A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language. The connection language needs to be defined as a default language for thefolder. |
Tab Identification
Use this section to define the product characteristics. You can:
- Enter the main information that defines the product
- Download an image of this product
Identification
Description 2 (field DES2AXX) |
This long description is used as a title in screens and reports. By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user. You can add your translation in another language using the Translation function:
A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language. The connection language needs to be defined as a default language for the folder. |
Description 3 (field DES3AXX) |
Use
Service life start (field LIFSTRDAT) |
Use this field to define the start-of-life date for this product. Sales orders cannot be raised for this product before its start-of-life date. |
Service life end (field LIFENDDAT) |
Use this field to define the end-of-life date for this product. Orders cannot be raised for this product after its end-of-life date. |
Production text (field WMFGTEX) |
This checkbox indicates that a manufacturing text exists for this product (via the Text / Manufacturing action). This text will be used with production transaction lines. |
Picking text (field WITPTEX) |
This checkbox indicates that a preparation text exists for the product/customer combination (via the Text / Pick ticket action). The text will be used on picking tickets and delivery notes. |
Miscellaneous
Search key (field SEAKEY) |
Alphanumeric field of 20 characters. This information is used as sort and selection criterion in the product search window and in the stock inquiry screens. |
Product line (field CFGLIN) |
A product line is used to:
|
UPC code (field EANCOD) |
Barcode identifying this product. Enable the predictive or automatic entry by setting the AUTOSEL – Automatic selection parameter (SUP chapter, INT group) to Yes. Start by entering a few characters contained in the reference or description (or other), and press Tab. A window displays a list of results. Select the value you require. AUTOSEL – Automatic selection parameter (SUP chapter, INT group) for the conditions for implementing the automatic search. |
Standard (field ITMSTD) |
Specify here the standard with which the product complies (manufacturing or quality national or international standard). |
User access (field PLAACS) |
Use this access code to specify a user that is in charge of the product quality for this product category (for correcting the product details). This user can modify or cancel this product if this access code is associated with their profile and their modification indicator is set to Yes. |
SAF-T product type (field ITMSFTTYP) |
This field is displayed only when the KPO–Portuguese localization activity code is activated. It only applies to the SAFT file generation. This file is exported according to the type of product indicated:
|
GTIN (field GTIN) |
Global Trade Item Number (GTIN) of the product This code contains 14 numerical characters. It needs to be the only one in the folder. It is not mandatory. |
Statistical groups
field TSICOD |
Alphanumerical code to choose in the statistical group table. The statistics groups are used in the statistical processings as well as selection criteria in many programs. There are a maximum of 5 statistical groups, and their number as well as their title can be set up when installing the software. The assignment of a statistical group representing the commercial group for a product is mandatory, it serves to sub-divide the product catalogue in the database. The CODEFAMCIA general setup makes it possible to determine which of the 5 product statistical groups is dedicated to this use. |
EU information
Sub Intrastat (field EECGES) |
Use this field to indicate if the product is subject to Intrastat. |
Customs reference (field CUSREF) |
This field is subject to the DEB–EU exchange declaration (Intrastat) activity code. It can only be accessed if the product is subject to Intrastat. Enter the Customs BOM associated with the product, used when extracting intra-community EU movements. |
Region/State (field STAFED) |
This field is subject to the DEBR–Intrastat state/region activity code. Use it to enter the Federal state or region where the product was originally manufactured. This information is only required for specific legislations. When extracting the data used to draw up the declaration, the information in this field is used as the default value, if not entered at the Product-site level. To be considered, its legislation needs to be identical to the legislation of the country specified on the document being extracted. |
Link
Product information (field PLMITMREF) |
This field is subject to the PLM–PLM - X3 interface activity code. It is only populated if the product has been created by import from the PLM @UDROS product when it will contain the original reference of the product from PLM. |
field BUTATTURL |
This icon is subject to the PLM–PLM - X3 interface activity code. It opens the URL that gives access to a web page containing the PLM documents linked with the product. |
PLM history (field BUTHISURL) |
This icon is subject to the PLM–PLM - X3 interface activity code. It opens the URL that gives access to a web page displaying the product history. |
Product notes (field ITMNOTE) |
Click this icon to display a screen where you can:
Notes are limited to a screen inquiry and cannot be printed. For further information, see the documentation on Notes. |
Image
Image (field IMG) |
Use this field to select an image to display on this record. |
Tab Management
Use this section to specify stock management parameters.
This section is only available for products managed in stock. If the stock management method for this product is set to Not managed, several fields on this section will no longer be available for entry.
Stock management
Stock management (field STOMGTCOD) |
Use this field to define how stock of this product is managed:
|
Lot management
Lot management (field LOTMGTCOD) |
Use this field to specify if this product is managed by lot. A lot number will differentiate stock lines. This product can also be managed with sublots, which are subdivisions of a lot. A sublot number will also differentiate stock lines. Sublot numbers are free-format (a number or group of 5-characters, by default, with the first sublot upon receipt of stock receipt suggested as 00001). Define the lot management method for this product, as follows:
This value can only be changed if this product has no stock. |
Lot sequence number (field LOTCOU) |
Lot sequence number counter that defines the format of lot numbers for this product. The lot number can be a maximum of 15 characters. Management of lots and sublots is subject to the LOT–Lot management and SLO–Management by sub-lots activity codes. |
Stock parameters
Stock < 0 authorized (field NEGSTO) |
Select this checkbox if stock of this product that is not yet present in the system can be issued. Example:
|
Management mode (field STDFLG) |
Use this field to define the management mode for this product:
This value is used in the MRP and MPS reorder calculations. |
Traceability (field TRKCOD) |
Use this field to define if movements of this product need to update a log file.
|
Potency % (field DEFPOT) |
This field indicates the average potency in percentage to be defined for the active products. It is used for receipt to stock as a default value, before the quality control measures the real potency. This field is accessible if the Stock management mode field (STOMGTCOD) is set to Potency managed. |
Alternate product (field RPLITM) |
Use this field to define a product code that can be used as an alternative for this product. This product can be displayed on the material issue slip or suggested if there is a shortage during manufacture (work order). Defining an alternate product results in the following checks:
If you enter an alternate product, version numbers are determined with respect to this new product. The Alternate product option is available from the action icon in the Ordered qty. field on sales order lines (Sales order function (GESSOH)). It is not available, however, if the order line has been allocated or partially delivered, billed, or prepared. |
Description (field RPLITMDES) |
The description of the alternative product. |
Product type (field INVPRODTYP) |
Serial no. management
Serial no. management (field SERMGTCOD) |
Use this field to control serial number management for this product. Select from the following serial number management methods:
|
Serial sequence (field SERCOU) |
Sequence number code which is used to automatically assign the serial numbers. |
Recontrol/Expiration
Management (field EXYMGTCOD) |
Expiration management is subject to the EXY–Expiration management activity code. The calculation mode of the expiration date can be set up according to the following criteria:
Expiration date management is only possible if the product is managed by lot. In this case, the status of expired lots can be planned. This information, if defined at the category level, is used at the product level where the shelf life can also be specified. |
Status (field EXYSTA) |
This field is not available if the expiration Management field (EXYMGTCOD) is set to No management. When a lot in stock is to expire, a process is used to automatically change its status:
|
Lead time (field SHL) |
This field is not available if the expiration Management field (EXYMGTCOD) is set to No management. Enter the expiration lead time for this product in days or months. This value is used in the calculation of the expiration date and use-by date (UBD) of a lot upon stock receipt. |
field SHLUOM |
Scroll-down list used to determine the time unit (day or month) associated with the previous field. |
Recontrol lead time (field SHLLTI) |
Type in the lead time of the new control to be used upon stock receipt. This value will be used to calculate the new control date based on the reference date. It is entered in days or months. The new control date cannot extended beyond the limit date of lot use. |
field SHLLTIUOM |
Scroll-down list used to determine the time unit (day or month) associated with the previous field. |
Recontrol status (field NEWLTISTA) |
When a lot in stock reaches a new control date, a process is used to automatically change its status:
|
UBD coefficient (field DLU) |
The use-by date (UBD) conversion factor can only be accessed when the following conditions are met:
This conversion factor is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level. UBD lead time = Shelf life x UBD coefficient The value of the conversion factor needs to be between 0.1 and 1. The UBD needs to be before the expiration date. This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date. UBD = Lot receipt date + UBD lead time Defining a UBD provides the customer receiving the lot with the guarantee that the use-by date of their goods is more or less distant from the expiration date. Example:
A UBD conversion factor can be entered in the product record, in the product-site record and in the customer-product record. The UBD conversion factor entered in the customer-product record is used to determine the use-by date specific to 1 customer. In this case, when allocating a stock (order, stock issue, etc.), the UBD defined for the customer overrules the one defined for the product-site. |
UBD lead time (field DLULTI) |
This field cannot be entered. It displays the use-by lead time calculated based on the UBD coefficient. This lead time is expressed in calendar days. |
field DLULTIUOM |
This field cannot be entered. The UBD lead time is always expressed in calendar days. UBD lead time = Shelf life x UBD coefficient |
Version management
Version management (field ECCFLG) |
Management of versions is subject to the ECC–Product version management activity code. During the lifetime of a product, some of its characteristics can be modified. These modifications can be tracked back by activating version management. To use version management, the product needs to be managed in stock. Versions will then be active in Manufacturing functions. For the tracking of versions to be effectively managed at the stock level, the product needs to also be managed by lot (Lot management field (LOTMGTCOD) is set to Mandatory lot). Version management can be initialized for the assigned product category then, provided the product has no stock, modified for individual products. When this product is created, if management of versions is activated, a message is displayed to suggest automatic creation of the first major version of this product. This version is assigned a To be activated status. In order to use the version, its status needs to be modified. |
Stock version (field ECCSTO) |
This field can only be accessed if versions are managed at the stock level. That is, the product is managed by lot and management of versions is activated. Select from the following:
You can click the link icon to access the Versions management screen. |
Versions (field ECSMGT) |
Click on the arrow for direct access to the Versions management screen. |
Major sequence (field ECCMAJ) |
If major versions are managed for this product, use this field to assign the major version sequence counter to be used to automatically assign a code to each major version of this product. For example, each major version of this product can be identified by an alphanumeric code, A then B, then C, etc. |
Major version (field ECCVALMAJ) |
This field displays the current active major version code for this product (the major version code with an Active status). If no major versions are currently active, this field displays the code of the last major version with a Stopped status. If only versions with a Prototype status exist, the version number is not displayed. |
Status (field ECCSTA) |
This field contains the status of the major version displayed. |
Minor sequence (field ECCMIN) |
If major and minor versions are managed for this product, use this field to assign the minor version sequence counter to be used to automatically assign a code to each minor version of this product. For example, each major version of this product can be identified by an alphanumeric code, A then B, then C, etc. with minor versions identified by a numeric code, 01, 02, 03, etc. |
Minor version (field ECCVALMIN) |
This field displays the current minor version code for this product. |
Routing version (field ECCROUFLG) |
Select this checkbox if routings for this product can be version-managed. This checkbox is only available when a sequence number of a major version (Major sequence field) has been defined for this product and if a major version is displayed. Select this checkbox to manage (major and minor) routing versions independently of any stock version or bills of materials (BOM) for this product. Leave this checkbox clear if you do not require routing versions for this product. Routings versions for this product can only be managed if this product is version-managed. You cannot change this checkbox once the first major routing version has been assigned to this product. |
Costs
Family (field BRDCOD) |
Cost calculations are used to break down material costs. Use this field to define the field (subtotal) the material cost for this product is posted to. The MAT–Number of material groups activity code defines how many family cost groups are available. |
Project
Cost type (field PCCCOD) |
Use this field to assign this product code to a specific cost type. Cost types are used in Project management. In a product context, a cost type defines the types of product that can affect a project such as the purchase of raw materials. You should only define a project cost type for products managed as Available stock and for purchased products managed By order. You do not need to define a cost type for manufactured products managed By order as the products to be valued, as per their cost type, will be the components in the bill of material (BOM), not the manufactured product itself. The components will either be managed as Available stock or purchased By order |
Food allergens
Allergens (field ALG) |
This field is subject to the FOA–Food allergens activity code. It displays the allergen associated with this product. The product category determines the options available.
|
Rollup date (field ALGDAT) |
This field is subject to the FOA–Food allergens activity code. It is used to display the allergen total date. It is updated when modifications are applied to the allergens linked to the product. |
Rollup code (field ALGBOM) |
This field is subject to the FOA–Food allergens activity code. It is used to display the allergen total BOM. It is updated when modifications are applied to the allergens linked to the product. |
Dangerous goods
UN number (field UNNBR) |
If necessary, enter or select the UN number of the product. This number always contains 4 characters. It identifies a type of dangerous goods which transportation is subject to regulations. This number is used in the electronic invoicing system SAFT-PT. |
Tab Units of measure
Use this section to reference all the product units: the (mandatory) stock unit and the associated label format, the weight unit, the volume unit, the statistical unit and the default EU unit.
For all units except the stock units, you need to define a conversion factor with the stock unit.
For the default sales unit, specify whether the conversion factor for this unit with the stock unit can be modified when entering a sales order.
If there are active purchase transactions, the defined purchase unit and conversion factor should not be modified. Any changes could result in conversion errors in active transactions.
The various units can be accessed depending on the category type (purchased, manufactured, sold, etc.).
A Packing unit table provides 4 default packing units. You can edit it using the NPU sizing code. It contains the packing unit code, the conversion factor for this unit with the stock unit, the Modifiable Yes/No indicator, a label format and an indicator defining the unit management when a stock issue represents a fraction of this packing unit.
Units of measure
Stock unit (field STU) |
This field indicates the product management unit in which are expressed:
This information is always displayed, regardless of the transaction used. It cannot be modified. |
Density (field DTY) |
This field is subject to the UML–Link quantity in unit of measure activity code. Use this field to define the product density. Density is the mass of the product (measured in g (grams) or Kg (kilograms), for example) divided by its volume (measured in ml (milliliters) or cm³ (cubic centimeters), for example). |
STK label format (field STULBEFMT) |
This fields corresponds to the format of the stock labels. |
Weight unit (field WEU) |
The weight unit. |
STK weight (field ITMWEI) |
Weight of a product stock unit, expressed in the displayed weight unit. |
Volume unit (field VOU) |
This field indicates the product volume unit. It is particularly used when distributing invoicing elements on the lines according to the prorata calculation of product volumes. |
STK volume (field ITMVOU) |
This field indicates the volume of a product stock unit in the volume unit displayed. |
Purchase unit (field PUU) |
This is the purchase unit defined for the product-supplier combination, or for products that do not exist in the product-supplier record. This product has 2 purchase units:
This purchase unit cannot be modified. It is used as the default value when entering an order, subcontract order or receipt. The supplier purchase unit is suggested by default when the product-supplier record exists. The purchase units are accessible depending on the type of category assigned. Upon invoicing a product, the product purchase unit is used. |
PUR-STK conv. (field PUUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in purchase units: Quantity in STK = Qty in PUR * conversion factor. This conversion factor can be accessed if the Purchase unit field (PUU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Sales unit (field SAU) |
The unit in which this product is sold. The sales price is attributed to this unit. This sales unit is also displayed by default in the Sales and Customer sections. The sales units are accessible depending on the type of category assigned. |
SAL-STK conv. (field SAUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in sales units: Quantity in STK = Qty in SAL * conversion factor. This conversion factor can be accessed if the Sales unit field (SAU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Changeable (field DACSAUCOE) |
Select this checkbox if modification of the conversion factor between the sales unit and the stock unit on sales transactions is authorized. |
Statistical unit (field SSU) |
This unit is used for the calculation of statistics in quantity. It is used to carry out analyses with a unit that is common to all products, when the analysis criteria are of type customer or supplier, for example. |
STA-STK conv. (field SSUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in statistical units: Quantity in STK = Qty in statU * conversion factor. This conversion factor can be accessed if the Statistical unit field (SSU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Intrastat additional unit (field EEU) |
This is the additional EU unit in which is expressed the quantity issued for the Customs Document File. |
EU-STK conv. (field EEUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in additional EU units: Quantity in STK = Qty in EEU * conversion factor. This conversion factor can be accessed if the EU unit field (EEU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Grid Packing unit
Unit (field PCU) |
It is possible to specify a packing unit by supplier. This product can have several packing units:
Only packing type units from the units of measure table can be selected. |
PAC-STK conv. (field PCUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in packing units: Quantity in STK = Qty in PAC * conversion factor. This conversion factor can be accessed if the packing Unit field (PCU) has been entered, and has a value different from the Stock unit field (STU). It can be initialized using the conversion factor table if the combination exists. |
Changeable (field DACPCUCOE) |
Select this checkbox if modification of the conversion factor between the packing unit and the stock unit on purchase orders or receipts is authorized. |
Label format (field LBEFMT) |
This filed indicates the label format. |
Issuing PAC (field PCURUL) |
Use this field to define how to split stock lines during the unpacking process.
The sales and purchasing units need to exist in the packing units table if the transaction unit entered in the resulting stock line needs to be retained. Otherwise, the resulting stock line is managed in stock units. |
Tab Financials
Use this section to define the accounting data (accounting code, tax levels, analytical dimensions) for this product.
Accounting
Accounting code (field ACCCOD) |
Use this field to specify the accounting code of the site. The accounting code is a default value used in the setting up of accounting entries. It refers to a table that lists a certain amount of elements (collective accounts, accounts or parts of accounts) that can be used for the determination of the documents that will be posted. |
field VACITM |
Use this field to specify the tax level. Each country being ruled by its own tax rates, the tax level alone does not enable the rate to be applied to be determined. The tax is generally determined by crossing the tax rule associated with a BP and the tax level associated with a product. See the Tax determination documentation for further information. The tax level only displays the list of the different rates applied within a same rule. |
SST tax code (field SSTCOD) |
Define the default value of the Sage Sales Tax (SST) tax code. This tax code is recognized by the Avalara system and is used to identify line types for fiscal purposes. All document costs are sent to SST in the form of document lines. It can include for example transport costs, handling costs and on-line product costs. This field is only available when the LTA activity code is activated. |
Fixed assets
Capitalizable (field FLGFAS) |
This checkbox is used when the Fixed Assets module is managed. When it is activated, it is used to identify the product as capitalizable, that is to say, that can be referenced on an expense saved by direct entry or automatically generated upon the posting of a stock miscellaneous issue movement. When the expense is created by validating a purchase invoice, the product does not need to be set up for capitalization: if the product can effectively be capitalized, the expense creation will be carried out automatically. However, if the product is not fit for capitalization, the expense will be created only after validation of a confirmation message. In both cases, the creation is authorized only if the setup of the account on which the invoice line is allocated allows it (checkboxes Fixed asset tracking and Expense creation activated). |
Grid Analytical
Dimension type code (field DIE) |
This table is populated automatically with the default dimension types associated with this product. |
Dimension (field CCE) |
An analytical dimension is an element of the analytical chart of accounts on which accounting entries can be posted. Each analytical dimension type represents a specific division of the company into a set of analytical payment attributes. An analytical dimension is thus an analytical payment attribute within a dimension type. |
Grid Asset group
Legislation (field LEGGRP) |
This column displays as many lines as there are legislations defined in the folder, making it possible to differentiate the product group code by legislation. |
Family (field ACGGRP) |
This field can only be accessed if the product is capitalizable. It is used to enter the Fixed asset Group of the product. It is possible to enter a specific group by legislation. The use of each group can be limited to a given legislation. This group is automatically assigned to the expense created on recording an expense related to this product. In the case where the section associations are set up for the Expense object, the fixed asset group can be used to define the values of the various sections, including the accounting allocations. The definition screen of Fixed asset groups which can be accessed by right-clicking on the field, is used to:
|
Tab Sales
Use this section to define sales management rules for this product.
This section is only available for sold products (as defined by the assigned Category).
Sales data
Type (field ITMTYP) |
A sold product can be:
A flexible kit or a fixed kit directly defines a sales BOM. On entry of a product of this type in a sales document, the system searches for the associated BOM (with the same name according to the sales alternative specified) and will note in the document the assembly and all the components, the options or variants comprising this sales BOM. |
Sales unit (field ITSSAU) |
This is the sales unit defined for this product (in the Units of measure section). |
Substitution product (field SBSITM) |
This information is used to replace a product from a certain date. During the entry of a product that should be substituted, the product code entered will automatically be replaced by the substitution product specified here. If you enter a substitution product, version numbers will be determined with respect to this new product. |
field SBSITMDES |
This field indicates the substitution product. |
Substitution date (field SBSDAT) |
This is the date from which the substitute product will replace the current product in a sales document. |
Quantities
Delivery tolerance % (field MINRMNPRC) |
This is the tolerance percentage below which the order line will be closed in the case of a partial delivery. |
Minimum quantity (field MINQTY) |
This is the minimum quantity expressed in the sales unit that can be entered on a sales order. This control can be blocked by the SDACLOK–Non block control price, profit, quantity parameter (VEN chapter, AUZ group). |
Maximum quantity (field MAXQTY) |
Maximum quantity of order, in sales units. |
Invoicing
Invoicing term (field INVCND) |
This field can only be accessed when the following conditions are met:
Use this field to enter an Invoicing term. This information is optional. This information is used as the default invoicing term on the sales order lines when the header invoicing term is not entered and cannot be used to initialize the invoicing term on order lines. |
Price
Price origin (field BASPRIORI) |
This field is used when entering a sales transaction if no price list has been defined, or if the price list search has been unsuccessful. It is used to specify how the default base sales price is obtained.
|
% applied (field PURPRIPRC) |
This field is only accessible if the Price origin field (BASPRIORI) is set to Purchase price %. It is used to specify what percentage is to be applied to the base purchase price specified in the Purchasing section in order to obtain the base sales price. |
Base price (field BASPRI) |
This field can only be accessed when the Price origin field (BASPRIORI) is set to Entered. Indicates the tax-exclusive base price of the product. This price is used as the sales price if no price list has been able to determine the gross price in the sales document. This amount is expressed in the company's management currency to which the default site is associated for the Common data management. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency, the amount being always stored in the folder's currency (the conversion is carried out, if necessary, from the average monthly exchange rate). If no site is entered at the function profile level, the amount is expressed in the folder currency. |
field CUR |
This amount is expressed in the company's management currency to which the default site is associated for the Common data management. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency, the amount being always stored in the folder's currency (the conversion is carried out, if necessary, from the average monthly exchange rate). If no site is entered at the function profile level, the amount is expressed in the folder currency. |
Minimum margin (field MINPFM) |
This is the margin percentage below which it is not possible to descend during sales document entry. This control can be blocking according to the value of the user parameter SDACLOCK-Price,margin,qty non-blocking ctrl(VEN chapter, AUZ group). |
Theoretical price (field THEPRI) |
This theoretical price is for information only. This amount is expressed in the company's management currency to which the default site is associated for the Common data management. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency, the amount being always stored in the folder's currency (the conversion is carried out, if necessary, from the average monthly exchange rate). If no site is entered at the function profile level, the amount is expressed in the folder currency. |
Minimum price (field MINPRI) |
This is the minimum selling price that can be entered for this product on a sales document. This control can be blocking according to the value of the user parameter SDACLOCK-Price,margin,qty non-blocking ctrl (VEN chapter, AUZ group). This amount is expressed in the company's management currency to which the default site is associated for the Common data management. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency, the amount being always stored in the folder's currency (the conversion is carried out, if necessary, from the average monthly exchange rate). If no site is entered at the function profile level, the amount is expressed in the folder currency. |
Miscellaneous
Warranty (month) (field GUAMON) |
This is the number of months of warranty for the product after its shipment. This information is not used by the Customer support module. It remains purely for information purposes. |
Loan authorized (field LNDFLG) |
This information is used to authorize the loans for a customer for a product. |
Back-to-back order (field CTMFLG) |
When a product is defined as being managed by back-to-back order, the system will automatically provide the option to generate a back-to-back order during the creation of an order line. There are 3 types of back-to-back orders:
The back-to-back order type submitted by default is dependent on:
In the event of a purchase back-to-back order, the system will determine that it is a direct back-to-back order (the supplier delivers the goods to the customer) when the quantity ordered is greater than the direct quantity (expressed in the product sales units). At Product-Site record level and for each site for which this product should be managed with back-to-back orders, an allocation rule with the back-to-back order type (and the Back to back method (1 to 1) checkbox activated) needs to be associated in the Planning link. |
Version preloading (field LOAECCFLG) |
Select this checkbox to specify that the last active version of this product needs to be preloaded by default in transactions referencing the Major version and Minor version. This setup can be individualized by customer. |
PO direct qty. (field CTMQTY) |
This field contains the quantity (expressed in sales units) from which the direct order will be straightforward. |
Sales text (field WITSTEX) |
This checkbox indicates that a sales text exists for this product (via the Text / Sales action). The text will be used with sales transaction lines. |
Tab After-sales
Use this section to define information for the product that can be used by the Customer relation (CRM) module.
Contract templates
Creation of customer base (field CREMAC) |
This field is used to activate all the automatic mechanisms of generation, the installed base tracking and the service contracts associated with the product when it comes to entering sales movement. These various mechanisms are implemented in the following functions:
|
Voucher category (field FLYCAT) |
This field is used to indicate the Crystal Report document that will be used to print the warranty coupon in case of a direct sale. |
Loan contract (field TPLCONLND) |
This field is used to indicate the warranty applied during the loan of this product. In fact, the standard coverage of a product on loan is not carried out thanks to a service contract but directly with a service contract template. |
Warranty contract (field TPLCONGUA) |
This field indicates if the product benefits from a warranty. It displays the warranty contract template that will be used as the basis of the service contract creation that will automatically benefit the customer at the time of acquiring the product. This information is only used if the creation of the customer installed base is activated. |
Service contract (field TPLCONSRV) |
This field only concerns the products corresponding to the notion of a service contract. The template indicated will be used as a support for the creation of a maintenance contract entered as a line in a sales order. |
Block number 2
Points debit (field PITDEB) |
It is possible to enter a point debit rule directly in a product record. The entry of a value in this field leads to the creation of a point debit rule where only the product component is entered. The debit indicated on the product only concerns direct debit. All the additional debits need to be entered on the points debit rule. |
Include unassigned items (field NULPIO) |
This option is used to block the tree of rules for debiting points during the analysis of a service request coverage. In other words, it is used to block any consumption of points for service requests concerning this product without cross-referencing with a particular skill. |
Tokens to be credited (field PITCDT) |
This field is used to indicate the number of tokens that a customer can accumulate for each order for this product. The value entered needs to be associated with a unit. |
all the (field PITCDTUOM) |
This unit is used to value the number of tokens that a customer can credit to each order for this product. It is indispensable for carrying out any conversions necessary for the token credit calculations. |
BOM
BOM code for after-sales (field ALTBOMHDK) |
This field is used to associate a BOM designed with aftersales use. For example, this BOM is used to facilitate the identification of the components forming a complete product and therefore which could potentially have defects. |
Consumption type
Product type (field HDKITMTYP) |
This field is used to segment the product catalogue into large product categories. This information is notably used during the entry of the service request consumptions. On the creation of the product record, the default product type is "Other". Product type = OtherThis is generally a physical product. For this product type, the following features are available:
Product type = Spare partThis is a product possessing a physical existence that is either sold to the customer as an accessory or consumed by after-sales technicians for maintenance or repairs. Characteristically for these products a BOM is rarely useful. In the same way, they are rarely subject to tracking via the customer base. The following features are available:
Product type = LaborThis product type corresponds to the provision of a service. For this product type, the following features are available:
Product type = Task expensesThis type is used to isolate from the product catalogue the task expenses that can be invoiced to the customers. The quantity of products of this type is generally limited. Their definition essentially provides important ergonomic gains at the time of the entry of after-sales consumptions. There is no additional information that is particularly useful for the product type. Product type = Service contractThis product type corresponds to generally to maintenance contracts that can be invoiced. Only 1 item of additional information is necessary in this case: the service contract template that will serve as the base for the contract creation from the sales order line entry. The competitive product inquiry can also be useful to compare the formulas and price lists recorded for the market. |
Stock issue by default (field STOISSDEF) |
This field only concerns products managed in stock. It is used to activate by default the opening of the stock issues entry window when the product is consumed as a service request. |
Unit for days (field DAYUOM) |
All items of the type labor needs to have a unit for each of the following:
These details are essential for the conversions carried out by the automatic records of service requests time stamp. |
Unit for hours (field HOUUOM) |
Days - hours coef. (field COEHOUDAY) |
Unit for minutes (field MNTUOM) |
All items of the type labor needs to have a unit for each of the following:
These details are essential for the conversions carried out by the automatic records of service requests time stamp. |
Tab Customers
Use this section to define sales management rules for the product for specific customers.
This section is only available for sold products (as defined by the assigned Category).
Customer (field BPCNUM) |
This field is used to enter the code used to identify the customer. It can be entered directly or selected from the Customer table. This customer list is not exhaustive, any customer not present in this list can still order the product. |
Customer data
Customer (field XBPCNUM) |
This is the code and the company name of the customer. |
Customer product (field XITMREFBPC) |
Reference of this product for the customer. It is possible to enter a sales document directly with this reference. The system automatically replaces this reference with the internal reference of the product. |
Customer description (field XITMDESBPC) |
Description of this product for the customer. |
Intersites (field XBETFCY) |
This field indicates whether the customer referenced is a customer of the group or not. When a customer is an inter-site customer type, the Inter-site checkbox is automatically selected. |
Sales
Sales unit (field XSAU) |
This field indicates the sales unit of the product for this customer. This unit can be different from the usual sales unit for this product. It is used by default in sales documents entry. |
SAL-STK conv. (field XSAUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in sales units: Quantity in STK = Qty in SAL * conversion factor. This conversion factor can be accessed if the Sales unit field (SAU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Packing 1 (field XPCU1) |
This field is used to define a first packing unit, usually requested by the client. |
PAC1-SAL conv. (field XPCUSAUCO1) |
Conversion factor used to calculate the quantity in sales units from a quantity entered in packing units: Quantity in SAL = Qty in PAC * conversion factor. This conversion factor can be accessed if the packing Unit field (PCU) has been entered, and has a value different from the Sales unit field (SAU). It can be initialized using the conversion factor table if the combination exists. |
Packing 2 (field XPCU2) |
This field is used to define a second packing unit, usually requested by the client. |
PAC2-SAL conv. (field XPCUSAUCO2) |
Conversion factor used to calculate the quantity in sales units from a quantity entered in packing units: Quantity in SAL = Qty in PAC * conversion factor. This conversion factor can be accessed if the packing Unit field (PCU) has been entered, and has a value different from the Sales unit field (SAU). It can be initialized using the conversion factor table if the combination exists. |
Packaging
Packaging (field XPCK) |
This field displays the packaging usually used to deliver the products to the customer. The packaging code is used in the packing functions, but it can be modified in order line entry. |
Packaging capacity (field XPCKCAP) |
It is the the number of products, expressed in sales units, that the package can contain. |
Expiration
UBD coefficient (field XDLUBPC) | ||||||||||||||||||
The use-by date (UBD) conversion factor can only be accessed when the following conditions are met:
This conversion factor is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level. UBD lead time = Shelf life x UBD coefficient. The value of the conversion factor needs to be between 0.1 and 1. The UBD cannot exceed the expiration date. This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date. UBD = Lot receipt date + UBD lead time Defining a UBD provides the customer receiving the lot with the guarantee that the use-by date of their goods is more or less distant from the expiration date. Example:
A UBD conversion factor can be entered in the product record, in the product-site record and in the customer-product record. The UBD conversion factor entered in the customer-product record is used to determine the use-by date specific to 1 customer. In this case, when allocating a stock (order, stock issue, etc.), the UBD defined for the customer overrules the one defined for the product-site. In creation mode, the UBD coefficient is blank. Example 2 with UBD defined for the client:
Lot B
During the allocation:
|
||||||||||||||||||
UBD lead time (field XDLULTI) | ||||||||||||||||||
This field cannot be entered. It displays the use-by lead time calculated based on the UBD coefficient. This lead time is expressed in calendar days. |
||||||||||||||||||
field XDLULTIUOM | ||||||||||||||||||
This field cannot be entered. The UBD lead time is always expressed in calendar days. UBD lead time = Shelf life x UBD coefficient. |
Miscellaneous
Sales text (field WITSTEX) |
This checkbox indicates that a sales text exists for the product/customer combination. The text will be used with sales transaction lines. |
Picking text (field WITPTEX) |
This checkbox indicates that a preparation text exists for the product/customer combination (via the Text / Pick ticket action). The text will be used on picking tickets and delivery notes. |
Version preloading (field XLOAECCFLG) |
Select this checkbox to specify that the last active version of this product needs to be preloaded by default in transactions referencing the Major version and Minor version. The default value for this checkbox is the same as the checkbox in the Sales section. |
Sales text |
Select the Sales action from the Text menu to view, enter, or edit text associated with this customer/product combination. This text is used in sales transactions and customer reports. |
Pick ticket text |
Select the Pick ticket action from the Text menu to view, enter, or edit the text associated with this customer/product combination. This text is used in pick tickets, packing slips and internal reports. |
Tab Purchasing
Use this section to define the purchasing management rules for this product.
This section is only available for purchased products (as defined by the assigned Category).
Purchasing
Firm horizon (field FIMHOR) |
Horizon for which the firm delivery requests need to be carried out (based on a week, month, or other unit). |
field FIMHORUOM |
Unit of time in which the firm horizon will be expressed. |
Planning horizon (field FRTHOR) |
This is the period, expressed in number of days, weeks, or months during which the provisional delivery requests can be completed. |
field FRTHORUOM |
Unit of time in which the planning horizon will be expressed. |
Reorder LT (field OFS) |
For purchasing
This information is used for the calculation of net requirements only in order to calculate the start date of sub-contract operation suggestions when the product does not have a product-site record. For an order direct creation or a purchase request This lead-time is also used in the MRP calculation to calculate the requirement start date. |
field JOURS1 |
The purchasing leads are always expressed in calendar days. |
Delivery tolerance % (field MINRMNPRC) |
This is the tolerance percentage used during the receipt of goods. It is used to determine if the associated order line should be closed taking into account the remaining quantity to be received. This value is combined with the value given by the POHCLE setup. |
Matching tolerance (field MATTOL) |
Use this field to specify the match code for a given product. For any new product, this field inherits from the code defined at the level of the associated product category. This code can be modified. This code originates from the Match tolerance function. Reminder: The 3-way match is a reconciliation process used to validate the payment of an invoice, with a minimum and a maximum tolerance threshold. The reconciliation is carried out:
|
Received product (field RCPFLG) |
Select this checkbox to prevent receipt of this product if it is not managed in stock. |
Mandatory PO request (field PRQFLG) |
Select this checkbox to specify if this product needs to be the object of a purchase request before being ordered. |
Version preloading (field LOAECCFLG) |
Select this checkbox to specify that the last active version needs to, by default, be preloaded when this product is received into stock. This setup can be refined by supplier. |
Purchase text (field WPURTEX) |
This checkbox indicates that a purchasing text exists (via the Text / Purchasing action). The text will be used with purchase transaction lines. |
Managers
Planner (field PLANNER) |
Operator in charge of performing the production planning or product ordering. |
Buyer (field BUY) |
It is the operator in charge of replenishing the product from the considered site. This information is used to define the roles of the users in charge of the product. According to the users entered here and the values of the general setups BUYFLT and GPLNFLT, restrictions can be applied when using these products in certain functions when users other than the users identified here use the products. |
Price
Purchase unit (field ITMPUU) |
This field displays the purchase unit defined in the Units of measure section. |
Base price (field PURBASPRI) |
This is the base purchase price of the product. This amount is expressed in the company's management currency to which the default site is associated for the Common data management. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency, the amount being always stored in the folder's currency (the conversion is carried out, if necessary, from the average monthly exchange rate). If no site is entered at the function profile level, the amount is expressed in the folder currency. |
field CUR2 |
Landed cost coef. (field ITMCPRCOE) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter the conversion factor to be included in the calculation of the purchase cost and stock cost. For any new product, this field defaults to the landed cost conversion factor recorded for the assigned product Category. It can be modified. The value entered needs to be greater than 1. When adding a new supplier, the entered value is used to load, by default, the landed cost conversion factor for the product-supplier record. If no conversion factor is defined for the supplier, enter the value 1. Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the erasing of the cost structure, after validation of a warning message. |
Fixed cost per unit (field ITMCPRAMT) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter a fixed cost per unit, expressed in the same currency as the Base price, that will apply to the purchase unit of this product, defined in the Units of measure section. The value entered needs to be a positive value. When adding a new product, the default value is the fixed cost per unit defined for the assigned product Category. When adding a new supplier, the entered value is used to load, by default, the fixed cost per unit for the product-supplier record. Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the erasing of the cost structure, after validation of a warning message. |
Cost structure (field ITMSTCNUM) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter or select a Cost structure to be included in the calculation of the purchase cost and stock cost. For new suppliers, this field inherits, by default, the cost structure recorded for the assigned product Category. It can be modified. When adding a new supplier, the entered value is used to load by default the cost structure from the product-supplier record. Only 1 method can be selected to calculate the landed costs. If a landed cost conversion factor or a fixed cost per unit are entered, entering a cost structure triggers their reinitialization, after validation of a warning message. If a cost structure with a unit not consistent with the product units is entered, a blocking message listing the different inconsistencies is displayed. The purchase unit of the cost structure needs to be the same as either the purchase unit, the stock unit, or the packing unit. If it is a weight or volume unit, its conversion with respect to the product units need to be defined. Unit Conversion. |
Tab Suppliers
Use this section to define purchasing management rules for specific suppliers. You can specify your supplier (default, blocking, back-to-back, etc.). The purchasing management rules are applied during supply planning and for purchase transactions.
You are advised not to change the purchase unit and conversion factor that are already set when there are active purchase documents for this product and supplier.
You can customize these management rules to specify a default supplier by site, for example. This setup can be completed in the Product-Site record.
This section is only available for purchased products (as defined by the assigned Category).
Supplier (field BPSNUM) |
Use this table to declare each supplier of the product, on each line: 1/ Enter or select the associated code from the list of active suppliers. You can also create a new supplier: click the Actions icon to access the supplier record, according to your authorizations. The other data in the table cannot be entered. 2/ Below the table, enter the various fields relating to the management of this product for this supplier. Once these fields have been entered, you can at a glance view the full list of the possible suppliers for this product: What is the priority level for each supplier? Which is the default supplier? Which is the default back-to-back order supplier? Is this a blocked supplier? A back-to-back order supplier? In the supply plans and on document entry in the purchasing flows, the type of control performed on the referencing of the product with the supplier is dependent on the value of the ITMBPS–Supplier referencing parameter (ACH chapter, REF group). |
Priority (field PIO) |
This field displays the priority level assigned to the supplier: the closer to zero the value, the more priority the supplier is given. The zero value represents the highest priority. |
Blocking (field DOUFLG) |
This field specifies in the supply plans as well as upon document entry in the purchasing flows whether the supplier:
|
Back-to-back order (field CTMBPSFLG) |
Select this checkbox if this supplier is a back-to-back supplier. |
Default supplier (field DEFBPSFLG) |
Select this checkbox if this supplier is a default supplier for this product. When entering the supply plans and purchase entry transactions, the supplier priority level is cross-referenced with the blocking level to determine the default supplier for this product.
A supplier that has received a warning can still be a default supplier if it has the highest priority level. |
Default back-to-back (field DEFCTMBPSF) |
Select this checkbox if this supplier is a default back-to-back order supplier for this product. When generating a back-to-back purchase order and during bulk generation of back-to-back orders, the supplier priority level is cross-referenced with the blocking level to determine the default back-to-back order supplier for this product.
A supplier that has received a warning can still be a default supplier if it has the highest priority level. |
Supplier identification
Supplier (field XBPSNUM) |
Use this field to define the code of the supplier for this product. |
Supplier product (field XITMREFBPS) |
Use this field to define the product code this supplier uses for this product. The supplier product code can be used when raising a purchase order for this product. The system will replace the supplier product code for this product code automatically. |
field XITMDESBPS |
The description of product this supplier uses for this product. |
Supplier UPC code (field XEANCODBPS) |
Use this field to define the universal product code, or barcode this supplier uses for this product. |
Management
Blocking (field XDOUFLG) |
Specify whether the following rules are applied in the supply plans as well as in purchase transaction entry:
|
Priority (field XPIO) |
Enter the priority level assigned to the supplier: the closer the value is to zero, the higher the supplier priority level. Zero is the highest priority. This information is used to sort out suppliers in some selection windows. In some functions, the default supplier is also determined by cross-referencing this priority level with the blocking level applied to the Product-supplier combination. |
Back-to-back order (field XCTMBPSFLG) |
Select this checkbox if this is a potential supplier for the back-to-back order. |
Intrastat increase (field XEECINCRAT) |
This field is subject to the Exchange of goods declaration (Intrastat). This conversion factor is used in the Intrastat declaration for the exchange of goods. It is used in supplier invoices and applied to the fiscal value of the product line to obtain the statistical value. It is initialized by either the increase conversion factor entered on the product-supplier record or the supplier record. |
Text (field WTEXFLG) |
Intersites (field XBETFCY) |
Matching tolerance (field XMATTOL) |
Use this field to specify a match code for a given product/supplier. For any new supplier/product, this field inherits from the code defined on the Repl. tab of the product. This code is chosen from the list created in the Matching tolerance function and can be modified. Reminder: The 3-way match is a reconciliation process used to validate the payment of an invoice, with a minimum and a maximum tolerance threshold. The reconciliation is carried out:
|
Purchasing
Purchase unit (field XPUU) |
It is the specific purchase unit of a supplier for this product. |
Minimum PO qty. (field XPURMINQTY) |
This is the minimum quantity, expressed in purchase unit, below which the supplier orders can be subject to a control. The level of control (blocking, warning or no control) relating to this quantity is defined by the parameter POHMINQTY–Minimum order qty control (ACH chapter, AUZ group). |
field XPUU2 |
This field recalls the purchase unit for this supplier according the purchase minimum quantity. |
PUR-STK conv. (field XPUUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in purchase units: Quantity in STK = Qty in PUR * conversion factor. This conversion factor can be accessed if the Purchase unit field (PUU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Version preloading (field XLOAECCFLG) |
Select this checkbox to specify that the last active version needs to, by default, be preloaded when a receipt is entered for this product. When creating this product record this checkbox defaults to the same value as the Version preloading checkbox in the Purchasing section. |
Packing unit (field XPCU) |
It is possible to specify a packing unit by supplier. This product can have several packing units:
Only packing type units from the units of measure table can be selected. |
PAC-PUR conv. (field XPCUPUUCOE) |
Conversion factor used to calculate the quantity in purchase units from a quantity entered in packing units: Quantity in PUR = Qty in PAC * conversion factor. This conversion factor can be accessed if the packing Unit field (PCU) has been entered, and has a value different from the Purchase unit field (PUU). It can be initialized using the conversion factor table if the combination exists. |
PAC-STK conv. (field XPCUSTUCOE) |
Conversion factor used to calculate the quantity in stock units from a quantity entered in packing units: Quantity in STK = Qty in PAC * conversion factor. This conversion factor can be accessed if the packing Unit field (PCU) has been entered, and has a value different from the Stock unit field (STU). It can be initialized using the conversion factor table if the combination exists. |
Quality
Quality rank (field XQLYMRK) |
Grade given to the supplier for quality compliance for this product. |
QC management (field XQUAFLG) |
This code is used to define whether this product needs to be controlled on receipt into stock. The assigned product Category determines the initial control value for the product-site record and the supplier-stock record. The supplier-stock record value provides the default value for purchase orders.
|
Frequency (field XQUAFRY) |
If the quality control is periodic, this field is used to enter the frequency of controls for this product and this supplier. This value has priority over the value of the product-site. |
Control number (field XQUANUM) |
Number of entries carried out since the latest control. This total is reinitialized at each control. When a periodic control is carried out for the supplier-product pair, the total of entry number carried out on the product-site record is also reinitialized. |
Technical sheet (field XQLYCRD) |
The quality control process for the product can be described via a technical record, to be chosen from the technical record table. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. It is possible to specify this record for a product and a supplier. |
Landed costs
Landed cost coef. (field XCPRCOE) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter a conversion factor to be included in the calculation of the purchase cost and stock cost. This value needs to be greater than 1. For any new supplier, the default value for this field is the landed cost conversion factor from the Purchasing section. Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the erasing of the cost structure, after validation of a warning message. When the PIHCPR–Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant with an Anglo-Saxon accounting. The Goods Received Not Invoiced (RNI) account will not be balanced. This is a limitation of the system. Since the different landed costs and especially the routing costs can vary according to the storage site, it is possible to enter, for each product-supplier, different landed costs for each storage site. You can enter these values directly in the Suppliers section in the Products-sites function (GESITF). You can also enter these values via the Landed costs-supplier-site icon or using the Landed costs-site function (GESSTCITF). |
Fixed cost per unit (field XCPRAMT) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter a fixed cost for each unit. This value needs to be greater positive. For any new supplier, the default value for this field is the supplier purchasing unit from the Purchasing section. This amount is expressed in the company's management currency for the default site. This setup is carried out at the level of the function profile assigned to the user. It refers to the display currency. The amount is stored in the folder currency, with the conversion from the average monthly exchange rate. If no site is entered at the function profile level, the amount is expressed in the folder currency. Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the erasing of the cost structure, after validation of a warning message. When the PIHCPR–Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant with an Anglo-Saxon accounting. The Goods Received Not Invoiced (RNI) account will not be balanced. This is a limitation of the system. Since the different landed costs and especially the routing costs can vary according to the storage site, it is possible to enter, for each product-supplier, different landed costs for each storage site. You can enter these values directly in the Suppliers section in the Products-sites function (GESITF). You can also enter these values via the Landed costs-supplier-site icon or using the Landed costs-site function (GESSTCITF). |
Cost structure (field XSTCNUM) |
The management of landed costs makes it possible to quantify the routing costs of the goods ordered from a supplier and to allocate them to the products upon order, receipt or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used, the choice of this method is performed at the level of the product management. Use this field to enter a cost structure used in the calculation of the cost price. You can enter this value manually or, from the Actions icon, you can click Selection or Cost structure (to access the Cost structure function (GESSTC)). For any new supplier, the default value for this field is the cost structure from the Purchasing section. Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the erasing of the cost structure, after validation of a warning message. When the PIHCPR–Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant with an Anglo-Saxon accounting. The Goods Received Not Invoiced (RNI) account will not be balanced. This is a limitation of the system. Since the different landed costs and especially the routing costs can vary according to the storage site, it is possible to enter, for each product-supplier, different landed costs for each storage site. You can enter these values directly in the Suppliers section in the Products-sites function (GESITF). You can also enter these values via the Landed costs-supplier-site icon or the Landed costs-site function (GESSTCITF). |
Landed costs-supplier-site (field STCNUMITF) |
Click this icon to enter, for each product-supplier, different landed costs for each storage site. You can also enter these values directly in the Cost section in the Products-sites function (GESITF) or using the Landed costs-site function (GESSTCITF). |
Subcontract
Subcontract BOM (field XBOMALT) |
This field is used to enter the reference of a default sub-contract BOM code for this product and this supplier. It can be entered only if the product belongs to the category: Sub-contracted |
Subcontract lead time (field XSCOLTI) |
This field is used to enter the sub-contract lead-time by default for this product and supplier. This lead-time, expressed in calendar days, can only be entered if the product is of the category: Sub-contracted. In a sub-contract operation without WO, the lead-times used to calculate the planned receipt date of the service are used in the following priority order:
If no lead time is associated to the service, the lead time of the subcontracted product is used, in the following priority order:
|
Purchasing |
Select the Purchasing action in the Text menu to view, enter, or edit the text associated with the supplier/product combination. This text is used in purchasing transactions and supplier reports. |
Tab Attributes
Use this section to categorize your product by assigning it a set of common characteristics that will be useful especially in your manufacturing processes. For example, if the product is a bicycle frame that needs to be painted in a certain color during the assembly process, use this section to add an attribute to your product corresponding to the paint, and an attribute value corresponding to the color. The Attributes and attribute values that you specify are customizations specific to your organization. This information is defined in a setup time matrix for the products and attributes. It is transmitted to your scheduling solution to optimize manufacturing lead times.
Attributes can only be used by your scheduling solution. You cannot use them for work orders or in Production Scheduler. The Finite scheduler provides a connector developed by Sage, to connect to Sage X3 Web Scheduling or to any web scheduling solution (either cloud or on-premise).
Grid
Attribute (field ATTCOD) |
Use this field to identify a standard classification, or characteristic of this product that can be referenced by your web scheduling processes. For example, if this product is painted during your manufacturing process, an attribute classification might be "PAINT" or "COLOR". |
Attribute description (field ATTDESAXX) |
This field identifies the standard characteristic that you have assigned to this product as an attribute. |
Attribute value (field ATTVALCOD) |
Use this field to identify an individual characteristic of the attribute classification that applies to this product. For example, if your company manufactures bicycles and the attribute classification is COLOR, this attribute value is the color used in the manufacturing process with this product, such as "BLACK" or "RED". |
Attribute value description (field ATTVALDESA) |
This field identifies the individual characteristic of this attribute classification that you have assigned to this product. |
Reports
By default, the following reports are associated with this function :
ITMFORM : Product information by site
ITMMASTER : Product master listing
ITMMASTERB : Master items/category
This can be changed using a different setup.
Specific actions
Select the Product-site action to create, inquire and update data associated with this product at a specific site. |
Select the Sales price action to view the lines of the active sales price lists that apply to this product. |
Select the Purchase price action to view the lines of the active purchase price lists that apply to this product. |
Actions menu
Select this action to enter or edit the text associated with the product. This text can then be used in the various purchase documents using the product. When there is already such a text, the Purchase text checkbox is selected in the Purchasing section. |
Select this action to enter or edit the production text associated with the product. This text can then be used in the product manufacturing transactions. When there is already such a text, the Production text checkbox is selected in the Identification section. |
Select this action to enter or edit the text associated with the product. This text can then be used in the product sales transactions. When there is already such a text, the Sales text checkbox is selected in the Sales section. |
Select this action to enter or edit a pick ticket text associated with the product. This text can then be used in the product pick tickets. When there is already such a text, the Picking text checkbox is selected in the Identification section. |
Select this action to access the Installed base and view the list of the installed base created from a product record. |
Select this action to access the Quote line inquiry for the selected product. To display lines, you need to add filters for customers and customer groups. |
Select this action to access the Order line inquiry for the selected product. To display lines, you need to add filters for customers and customer groups. |
Select this action to access the Delivery line inquiry for the selected product. To display lines, you need to add filters for customers and customer groups. |
Select this action to access the Invoice line inquiry for the selected product. To display lines, you need to add filters for customers and customer groups. |
Select this action to access the Return line inquiry for the selected product. To display lines, you need to add filters for customers and customer groups. |
Select this action to access the Purchase requests inquiry for the selected product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Order lines inquiry for the selected product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Receipt lines inquiry for the selected product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Invoice lines inquiry for the selected product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Return lines inquiry for the selected product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Subcon. consumption inquiry for this product. To display lines, you need to add filters for suppliers and supplier groups. |
Select this action to access the Production inquiry for this product. |
Select this action to access the Consumption inquiry for this product. |
Select this action to access the Production cost inquiry for this product. |
Select this action to access the Production cost history inquiry for this product. |
Select this action to access the List of WOs inquiry for this product. |
Select this action to access the Stock by site inquiry for this product. |
Select this action to access the Projected stock inquiry for this product. |
Select this action to access the Available stock inquiry for this product. |
Select this action to access the Stock by date inquiry for this product. |
Select this action to access the Stock transactions inquiry. |
Use this action to automatically create product-site records using the default values of the product category or categories/sites if any. Use the table to select the sites for which the product-site records need to be created. Only those sites that do not have any associated records are listed. It is possible to exclude or include all the sites. If your folder contains a single site, the product-site record is generated automatically. This action is optional. |
Select this action to access the Kits BOMC for the product. |
Select this action to access the Manufacturing BOM BOMP for the product. |
Select this action to access the Subcontract BOM BOMS for the product. |
Select this action to access the Routings management for the product. |
Select this action to access the Production slip function for the product. |
Select this action to display the Component where used of the product for all the codes, with the current date as the reference and in multi-level processing mode. |
Select this action to identify the products available on the market that share enough characteristics with the current product to be considered as competitor products. The associated products are chosen from a list of competitor products defined in the corresponding function, where it is also possible to create new competitor products. |
Select this action to view the Points debit rule associated with the product record. If there is no rule, you can set one up. |
Select this action to access the Standard costs inquiry. |
Select this action to access the Revised standard costs entry function. |
Select this action to access the Budget standard costs entry function. |
Select this action to access the Simulated standard costs entry function. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
The record already exists.This message is only displayed when creating or duplicating a record. The product code that you are trying to create already exists.
The record does not exist.This message is only displayed when searching for a record. The entered product code does not exist.
Product category: ...non-existent recordThe entered code does not exist. You can directly access the Product category function (GESITG) to create a code.
The product has been created with the reference...When the product reference is determined by a sequence number (specified in the category), the Product field cannot be entered.
Access code: ...non-existent recordThe access code (administrator or quality operator) does not exist.
Incorrect dateThe end of life date comes before the start of life date.
Product stat. group: ...non-existent recordThe statistical group code does not exist. You can directly access the corresponding miscellaneous table to create a statistical group code.
EU regulations: ...non-existent recordThe customs reference does not exist. You can directly access the NC8 BOM function (GESINO) to create a code.
Tab without object for the current updateA product category that is not stock-managed has been chosen (phantom, generic, sub-contractor). The Management section cannot be updated.
Document sequence number: ...non-existent recordThe sequence number does not exist.
Product: ...non-existent recordThe alternate product code does not exist.
Product1 already replaces product_x...The search for alternate products reveals that the product that is being modified is itself an alternate product for one of the products in the list. There is a loop.
Technical sheet... : non-existent recordThe technical sheet does not exist.
Unit ... : non-existent recordThe unit of measure code does not exist. You can directly access the Units of measure function (GESTUN) to create a unit of measure.
Accounting code: ... Record does not existThe accounting code does not exist.
Miscellaneous table : ...non-existent recordThe tax level does not exist in the tax level-product miscellaneous table.
Analytical dimension: ...non-existent recordThe analytical dimension does not exist in the analytical dimension table.
Packaging: ...non-existent recordThe packaging code does not exist. You can directly access the Packaging function (GESTPA) to create a code.
Customer: ...non-existent recordThe customer code does not exist in the customer table.
Users: ...non-existent recordThe user code does not exist in the user table. You can directly access the Users function (GESAUS) to create a user.
Stock transactions: ...non-existent recordThe transaction code does not exist.
Supplier: ...non-existent recordThe supplier code does not exist in the supplier table.
File: …. Key: …. ....... Record already existsTables used
Refer to documentation Implementation