Common data > Products > 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.

Product categories

Products-sites

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The Products function contains a home and a section for each feature of the requirement:

  • Header information. The header information 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 where, for example, the nature of the item packing varies according to the quantity ordered/received.
  • 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 products that are sold.
  • 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 products that are sold.
  • Purchasing. Use this section to define purchasing management rules for the product. This section is only available for products that are purchased.
  • Suppliers. Use this section to define purchasing management rules for specific suppliers. This section is only available for products that are purchased.
  • Attributes. Use this section to assign characteristics to this product that can be referenced by your manufacturing processes.

Header

Presentation

The header information provides key tracking information, including the category (purchased, manufactured, sold, subcontracted) to which the product is assigned. The home information is displayed irrespective of the section being selected.

Close

 

Fields

The following fields are present on this tab :

Use this field to identify the category of product to which this product is assigned.

SEEWARNING 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 sequence number - automatic generation or manual creation of the product code.
  • Category type - product, service, tool, etc.
  • Creation method - controls the initial status of the product.

  • Product status (field ITMSTA)

The product status determines how its availability has evolved. The different statuses are: Active, In development, On shortage, Not renewed, Obsolete and Not usable.

During product creation, the default status is dependent on the creation method defined for the assigned product category:

  • If the product category Creation method is set to Direct, the product status will be Active.
  • If the product category Creation method is set to With validation, the product status submitted by default will be In development.
Impact of the product status in the sales and purchase modules

Sales

  • An Active, product can be entered and selected in all sales documents.
  • An In development, On shortage, Not renewed or Obsolete product can be entered (a warning message is displayed) in all sales documents but it will not be submitted for selection.
  • A Not usable product cannot be entered (blocking message) or submitted for selection.

Purchases

  • An Active product can be entered and selected in all purchase documents.
  • An In development, On shortage, Not renewed or Obsolete product can be entered (a non-blocking warning message is displayed) in all purchase documents but it will not be submitted for selection.
    Upon receipt of the product, an order or a delivery can be selected.
    A product with an In development status can be entered on a request for quote.
  • A Not usable product can be entered in the following documents (a warning message is displayed) but will not be submitted for selection:
    • Purchase orders
    • Contracts
    • Buyer plan
    • Planning workbench - generation of orders or delivery requests only.
    • Enterprise planning - generation of orders or delivery requests only.
    • Grouping workbench - the orders for products with this status have the suffix "-".
    • Purchase invoices.

    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:

  • Active. The product is available in all the processes.
  • In development
  • On shortage. The product does not appear in search results, but it can be used by directly entering its code. A non-blocking warning message appears. If the product category creation method is With validation, the status cannot be accessed and its value is forced to the In development value.
  • Not renewed
  • Obsolete
  • Not usable. The product does not appear in search results and cannot be used in scripts. It can however be used in purchase invoices, by directly entering its code. In that case, a non-blocking warning message is displayed.

Non blocking and blocking messages according to the context and status:

  • Context - Input
    • Non-blocking message: In development, On shortage, Not renewed, Obsolete.
    • Blocking message: Not usable.

  • Issues - BOMs
    • Non-blocking message: Not renewed, Obsolete, Not usable.

  • Work order (component)
    • Non-blocking message: In development, On shortage.
    • Blocking message: Not renewed, Obsolete, Not usable (product not returned).

  • Work order (parent product)
    • Non-blocking message: On shortage.
    • Blocking message: In development, Not renewed, Obsolete, Not usable.

  • Sales order
    • Non-blocking message: In development, On shortage, Not renewed, Obsolete.
    • Blocking message: Not usable.

  • Purchase order
    • Non-blocking message: On hold.
    • Blocking message: In development, Not renewed, Obsolete, Not usable.

  • Assembly - On shortage
    • Compound assembled:
      • Non-blocking: In development, Not renewed, Obsolete.
    • Component:
      • Non-blocking: In development, Not renewed, Obsolete.

  • Disassembly - On shortage
    • Compound assembled:
      • 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:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

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.

SEEINFOThe connection language must be defined as a default language for thefolder.

Close

 

Tab Identification

Presentation

You use this section to define characteristics that will identify this product. You can:

  • Enter basic information that describes this product.
  • Download an image of this product.

Close

 

Fields

The following fields are present on this tab :

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:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

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.

SEEINFOThe connection language must be defined as a default language for thefolder.

  • 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 check box 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 check box 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.

A product line is used to:

  • Define specific identifiable fields for a product group.
    SEEINFO  The Configurator module is based on the item product lines, but product lines can be used separately from the configurator.
  • Define matching rules between products.

  • 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:

  • None
  • Product
  • Service
  • Other (including fixed assets).
  • GTIN (field GTIN)

Statistical groups

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 five 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 five 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.

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.

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 must 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:

  • Enter information on the product as a note. This information can relate to product availability, additional or substitute products, or a promotional message.
    This information is available for inquiry in the functions that have been selected at the Note category level.
  • Define a validity period for the note.
  • Specify if the note must be displayed automatically.
  • Create multiple notes for the same product, and indicate if they must be displayed as a priority.

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.

Close

 

Tab Management

Presentation

You 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 many fields in this section are not available for entry.

 

Fields

The following fields are present on this tab :

Stock management

  • Stock management (field STOMGTCOD)

Use this field to define how stock of this product is managed:

  • Not managed. This product is not managed in stock. It is a service or a general purchase, for example.
  • Managed
  • Potency managed. A management rule is applied. Management of quantities in stock requires an active quantity and a physical quantity.

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.

SEEREFERTTO 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:

  • Not managed. This product is not managed by lot. This rule is applied to stock issues and receipts.
  • Optional lot. A lot number is accepted. It is not mandatory. With this value, stock lines for this product can be defined with and without lots.
  • Mandatory lot. Transactions for this product must reference a lot number.
  • Lot and sublot. A lot can be subdivided into sublots.

This value can only be changed if this product has no stock.

Lot sequence number counter that defines the format of lot numbers for this product. The lot number can be a maximum of 15 characters.

SEEINFO 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 check box if stock of this product that is not yet present in the system can be issued.

Example:
Stock has physically been delivered or manufactured and needs to be issued to a customer, but the receipt details have not yet ben input into the system. With this check box selected the system can generate a "pending" issue. This issue is adjusted upon input of the stock into the system.

 
  • Management mode (field STDFLG)

Use this field to define the management mode for this product:

  • Available stock
  • By order

This value is used in the MRP and MPS reorder calculations.

  • Traceability (field TRKCOD)

Use this field to define if movements of this product must update a log file.

  • Detailed traceability. Every movement of this product is recorded on a log file.
  • Summary traceability. Movements that relate to a single product, lot, status, document and transaction are totaled and recorded on a log file.
    This value is recommended for work order receipts and issues so the returned log is only split once.
  • No traceability. Stock movements for this product are not recorded on 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:

  • Existence check - the product is available for selection.
  • Loop check - to avoid using the same product during cascading replacements.

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:

  • Not managed. This product does not require serial number management. This rule is applied to all transactions for this product.
  • Issued. Serial numbers are not managed in stock, but they are used upon issue for customer tracking purposes.
  • Received / issued. Management of serial numbers is per unit. A serial number will differentiate stock lines: n serial numbers of the same lot / sublot / status / location are present on n different stock lines. Similarly, a stock movement is generated for each serial number.
  • Global received / issued. Management of serial numbers is global. The serial number will not differentiate stock lines: a range of n serial numbers of the same lot / sublot / status / location is present on one stock line. Similarly, only one stock movement is generated for a range of n serial numbers for products with identical stock characteristics.

  • Negative stock is not authorized.
  • The stock must be managed with stock units.
  • You cannot enter the serial number of products which are on an Awaiting put-away location. You must enter them when storing them in stock.
  • A product with serial numbers managed by Global received / issued cannot be used as a component in a subcontract BOM.
  • Serial numbers are not automatically determined during the allocation automatic determination (GENSTOALL component), but they are during the automatic determination of the stock to be issued (GENSTOSORW component).
  • The serial numbers can be identified on the detailed allocations of pick lists, deliveries and supplier returns. They cannot be identified on sales orders, work orders, subcontract orders and project tasks.

  • You cannot change this value from Not managed or Issued to Global received / issued once stock transactions for this product have been recorded.
  • You cannot change this value from Received / issued to Global received / issued. Use the Serial management modification function (FUNSERMGT) to do this instead.

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:

  • Not managed. With no management, the fields status and lead time cannot be entered.
  • Without rounding. The expiration date is calculated based on the number of days.
  • Rounding month end. The expiration date is calculated based on a rounded value on the month's end.
  • Rounding beginning month + 1. The expiration date is calculated based on a rounded value on the next month's start.
  • Mandatory entry. With this value, an entry window for the expiration date will automatically open when recording a stock receipt. The expiration date will be initialized based on the reference date and lead time.
  • Manual entry. With this value, an entry window for the expiration date will open automatically when recording a stock receipt. The expiration date will be blank.

SEEINFO 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:

  • A. The status of this product does not change on expiry.
  • Q. This product can be controlled on expiry, for a potential date extension or rejection.
  • R. When this product reaches its expiration date it is rejected.


  • 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.

SEEWARNING 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:

  • A. The status of this product moves to Q or R when the new control date is reached.
  • Q. This product can be controlled on expiry, for a potential date extension or rejection.
  • R. When this product reaches its new control date it is rejected.

  • UBD coefficient (field DLU)

The use-by date (UBD) conversion factor can only be accessed when the following conditions are met:

  • Expiration is managed for the product.
  • Expiration management (Management field (EXYMGTCOD)) is not based on a rounded value (start or end of the month).

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.

SEEWARNING  The value of the conversion factor must 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:

  • Shelf life = 2 months (60 days)
  • UBD coefficient = 0.5
  • UBD lead time = 30 days
  • UBD = receipt date + 30 days

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 one 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 must 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 must 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 must 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:

  • Major. Major versions might be used where there have been increased or significant changes to the original or previous version, that is the form, fit or function has changed. If you select this value you must assign a sequence number counter for major versions.
  • Major and minor. Minor versions might be used where there have been minor features or changes in functionality, or significant fixes applied to a specific major version. If you select this value, both major and minor versions of this product are managed. You must assign two sequence number counters, one counter for a major versions and one counter for minor versions.

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.

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 Stoppedstatus.

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.

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 check box if routings for this product can be version-managed. This check box 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 check box to manage (major and minor) routing versions independently of any stock version or bills of materials (BOM) for this product.

Leave this check box 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 check box 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 which field (subtotal) the material cost for this product must be posted.

Activity code MAT - Number of material groups defines how many family cost groups are available.

Project

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 materials (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.

  • If this is a manufactured product, you cannot edit this field because it displays the allergen codes based on the allergen rollup function performed for the parent product. The rollup explodes the BOM/recipe and collects all unique allergen codes. This can be useful if there are concerns about the results, or if the information is up to date.
  • If this product is a purchased product, you can edit this field based on the allergen selection function. You can select multiple items per product.
  • 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

If necessary, enter or select the UN number of the product. This number always contains four 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

Presentation

You use this section to reference all product units: the (mandatory) stock unit and the associated label format, the weight unit, statistical unit and EU unit.

For those units other than the stock units, you must 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 on entry of a sales order.
When the purchase unit and its conversion factor are defined, this information should not be modified once there are active purchase transactions. In fact, any modification could trigger conversion errors in active transactions.

The various units can be accessed based on the category type (purchased, manufactured, sold, etc.).

A Packing unit table is provided for 4 default packing units. It can be modified using the sizing code NPU (Number of Packing units). It contains the packing unit code, the conversion factor for this unit with the stock unit, a changeable Yes/ No indicator, a label format and an indicator defining the unit management when a stock issue represents a fraction of this packing unit.

Close

 

Fields

The following fields are present on this tab :

Units of measure

This field indicates the product management unit in which are expressed:

  • The stock
  • The standard price
  • The BOM link quantity, etc.

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).

This fields corresponds to the format of the stock labels.

The weight unit.

  • STK weight (field ITMWEI)

Weight of a product stock unit, expressed in the displayed weight unit.

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.

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 two purchase units:

  • Purchase unit defined on the product record.
  • Purchase unit linked to the supplier.

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.

SEEINFO 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.

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 check box if modification of the conversion factor between the sales unit and the stock unit on sales transactions is authorized.

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.

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

It is possible to specify a packing unit by supplier.
This product can have several packing units:

  • A packing unit defined on the product record (from the Packing units table). These units are proposed during stock transaction entry.
    The number of packing units that can be entered is subject to the NUC - Number of packing units activity code.
  • A packing unit linked to the supplier (defined on the product-supplier record).
  • Two customer packing units (from the product-customer record). These can be used as sales units in order entry.

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 check box if modification of the conversion factor between the packing unit and the stock unit on purchase orders or receipts is authorized.

This filed indicates the label format.

  • Issuing PAC (field PCURUL)

Use this field to define how to split stock lines during the unpacking process.

  • Unpack. The fractional part of the stock line is set back to stock units, and the line is split if necessary. This option is only available when conversion factor entry is authorized.
    Example:
    A stock line contains 5 boxes each containing 12 units. 18 units are taken from the stock line.
    This results in two stock lines: one line with 3 boxes containing 12 units and one line with 6 units.
  • Adjust coefficient (recalc PAC coeff). The stock line conversion factor can be adjusted as required, and the line is split if necessary. This option is only available when conversion factor entry is authorized.
    Example:
    A stock line contains 5 boxes each containing 12 units. 18 units are taken from the stock line.
    This results in two stock lines: one line with 3 boxes containing 12 units and one line with 1 box containing 6 units.
  • Fraction (calculate decimal PAC). The stock line quantities can be adjusted by division (split).
    As a consequence, the packing unit must be decimalized.
    Example:
    A stock line contains 5 boxes each containing 12 units. 18 units are taken from the stock line.
    This results in a stock line of 3.5 boxes containing 12 units.

SEEINFOThe sales and purchasing units must exist in the packing units table if the transaction unit entered in the resulting stock line must be retained. Otherwise, the resulting stock line is managed in stock units.

 

Close

 

Tab Financials

Presentation

You use this section to define the accounting data (accounting code, tax levels, analytical dimensions) for this product.

Close

 

Fields

The following fields are present on this tab :

Accounting

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.

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.
SEEREFERTTO See the documentation on Tax determination for further information.
The tax level only displays the list of the different rates applied within a same rule.

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 check box is used when the Fixed Assetsmodule 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.

SEEINFO 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 (check boxes Fixed asset tracking and Expense creation activated).

Grid Analytical

This table is populated automatically with the default dimension types associated with this product.

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

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.

This field can only be accessed if the product is capitalizable.
It is used to enter the Fixed assetGroup 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:
- view the values determined by the associations, for the entered group code,
- access the entry/modification screen of the values of these associations.

Close

 

Tab Sales

Presentation

You use this section to define sales management rules for this product.

This section is only available for products that are sold (as defined by the assigned product Category).

Close

 

Fields

The following fields are present on this tab :

Sales data

  • Type (field ITMTYP)

A sold product can be:

  • a standard product,
  • a BOM parent product: defines a group of products usually sold together. You can delete products from the BOM as required.
  • a fixed kit: defines a group of products that must be sold together. You cannot delete products from the BOM.
    A product falling in the Service and Non-deliverable category cannot be defined as having the Fixed kit type.

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.

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.

SEEWARNING This control can be blocked by theSDACLOK - Non block control price, profit, quantity parameter (VEN chapter, AUZ group).

  • Maximum quantity (field MAXQTY)

Maximum quantity of order, in sales units.

Invoicing

This field can only be accessed when the following conditions are met:

  • The category type is Service or Generic,
  • The flow type is Sold and not Deliverable.

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.

  • Entered. The base sales price is populated directly in the corresponding field.
  • Purchase price %. The base sales price is determined according to the base purchase price (Purchasing section) and to the percentage entered in the purchase % applied field (PURPRIPRC), as follows: Base purchase price + (Base purchase price * % applied).
 
  • % 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.

SEEINFO 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.

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.

SEEINFO 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.
SEEWARNING This control can be blocking according to the value of the user parameterSDACLOCK-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.

SEEINFO 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.
SEEWARNING This control can be blocking according to the value of the user parameterSDACLOCK-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.

SEEINFO 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.
SEEINFO 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 three types of back-to-back orders:

  • The purchase back-to-back order with receipt
  • The direct purchase back-to-back order (the supplier delivers the goods to the customer)
    This back-to-back order type cannot be used in an intercompany context.
  • The production back-to-back order

The back-to-back order type submitted by default is dependent on:

  • The product category
  • The reorder suggestion type defined on the Product/Site record
  • The direct quantity specified on the Sales link of the product record.

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) check box activated) must be associated in the Planning link.

  • Version preloading (field LOAECCFLG)

Select this check box to specify that the last active version of this product must 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 check box indicates that a sales text exists for this product (via the Text / Sales action). The text will be used with sales transaction lines.

Close

 

Tab After-sales

Presentation

You use this section to define information for the product that can be used by the Customer relation (CRM) module.

Close

 

Fields

The following fields are present on this tab :

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:

  • validation of the sales deliveries,
  • validation of the sales invoices,
  • entry of the sales returns,
  • entry of loan returns.

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.

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.

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.

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 must 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 MUST be associated with a unit.

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

This field is used to associate a BOM designed with after-sales use.
For example, this BOM is used to facilitate the identification of the components forming a complete product and therefore which may 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 = Other

This is in general a product having a physical existence.
For this product type, the following functionalities are available:

  • automatic generation of the product base on the sales entries,
  • assignment of a loan contract,
  • assignment of a warranty,
  • assignment of a warranty voucher template,
  • definition of points deduction rules,
  • definition of the token assignment rules,
  • assignment of an alternative BOM suitable for the identification of defective components,
  • product base inquiry,
  • competitive product inquiry,
Product type = Spare part

This 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 functionalities are available:

  • definition of points deduction rules,
  • definition of the token assignment rules,
  • activation of stock issue by default functions,
  • competitive product inquiry.
Product type = Labor

This product type corresponds to the provision of a service.
For this product type, the following functionalities are available:

  • definition of points deduction rules,
  • definition of the token assignment rules,
  • definition of the time units used by default for time booking,
  • competitive product inquiry.
Product type =  Task expenses

This 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 contract

This product type corresponds to generally to maintenance contracts that can be invoiced.
Only one 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.

All item of the type labor MUST contain a unit for each of the following three notions:

  • Day,
  • Hour,
  • Minute.

These three pieces of information are essential to the conversions carried out by the automatic records of service requests time stamp.

 

  • Days - hours coef. (field COEHOUDAY)

 

All item of the type labor MUST contain a unit for each of the following three notions:

  • Day,
  • Hour,
  • Minute.

These three pieces of information are essential to the conversions carried out by the automatic records of service requests time stamp.

Close

 

Tab Customers

Presentation

You use this section to define sales management rules for specific customers for this product.

This section is only available for products that are sold (as defined by the assigned product Category).

Close

 

Fields

The following fields are present on this tab :

Grid

This field is used to enter the code used to identify the customer. It can be entered directly or selected from the Customer table.
SEEINFO This customer list is not exhaustive, any customer not present in this list can still order the product.

Customer data

This is the code and the Company Name of the customer being viewed.

  • 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.
SEEINFO When a customer is an inter-site customer type, the Inter-site tick box is automatically ticked.

Sales

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.

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.

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

This field displays the packaging usually used to deliver the products to the customer.
The packaging code is used in the packing function, 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:

  • Expiration is managed for the product.
  • Expiration management (Management field (EXYMGTCOD)) is not based on a rounded value (start or end of the month).

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.

SEEWARNING  The value of the conversion factor must 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:

  • Shelf life = 2 months (60 days)
  • UBD coefficient = 0.5
  • UBD lead time = 30 days
  • UBD = receipt date + 30 days

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 one 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.

 

SEEINFOIn creation mode, the UBD coefficient is blank.

Example 2 with UBD defined for the client:
Sales order with requested delivery date (determined from the shipment date + lead time): 01/11/2021
Lot A

  • Stock receipt date: 01/01/2021
  • Shelf life: 20 days - Expiry date: 01/20/2021
  • UBD coefficient for product-site: 0.6 - UBD lead time for product-site: 12 days - Product-site UBD date: 01/12/2021
  • UBD coefficient for customer-product: 0.4 - UBD lead time for customer-product: 8 days - Customer-product UBD date: 01/08/2021

Lot B

  • Stock receipt date: 01/01/2021
  • Shelf life: 20 days - Expiry date: 01/20/2021
  • UBD coefficient for product-site: 0.6 - UBD lead time for product-site: 12 days - Product-site UBD date: 01/12/2021
  • UBD coefficient for customer-product: not specified

Lot

Expiry date

Product-site UBD

Customer-product UBD

Requested delivery date

Allocation

A

01/20/2021

01/12/2021

01/08/2021

01/11/2021

NO

B

01/20/2021

01/12/2021

---------------

01/11/2021

YES

During the allocation:

  • Lot A was not selected because the customer-product UBD was dated 01/08/2021, which is prior to the delivery date 01/11/2021.
  • Lot B was selected because the product-site UBD was dated 01/12/2021, which is later than the delivery date 01/11/2021.
  • 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 check box 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 check box 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 check box to specify that the last active version of this product must be preloaded by default in transactions referencing the Major version and Minor version. The default value for this check box is the same as the check box in the Sales section.

Close

 

Action icon

Sales text

Click the Sales (Text / Sales) action to view, enter or modify text associated with this customer/product combination. This text is used in sales transactions and customer reports.

Pick ticket text

Click the Pick ticket (Text / Pick ticket) action to view, enter or modify sales preparation text associated with this customer/product combination. This text is used in picking notes, packing slips and internal reports.

 

Close

 

Tab Purchasing

Presentation

You use this section to define purchasing management rules for this product.

This section is only available for products that are purchased (as defined by the assigned product Category).

Close

 

Fields

The following fields are present on this tab :

Purchasing

  • Firm horizon (field FIMHOR)

Horizon for which the firm delivery requests must 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 is the number of calendar days, corresponding to:

  • The order lead-time for a purchased product,
  • The production lead-time for a finished or semi-finished product.

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
The reorder lead-time is used to calculate the planned receipt date when no lead-time can be determined from the price lists or product-site record.
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.

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 Three-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:

  • either between the invoice and the order,
  • or between the receipt and the invoice,
  • or in succession (order-receipt, then receipt-invoice).
  • Received product (field RCPFLG)

Select this check box to prevent receipt of this product if it is not managed in stock.

  • Mandatory PO request (field PRQFLG)

Select this check box to specify if this product must be the object of a purchase request before being ordered.

  • Version preloading (field LOAECCFLG)

Select this check box to specify that the last active version must, by default, be preloaded when this product is received into stock. This setup can be refined by supplier.

  • Purchase text (field WPURTEX)

This check box indicates that a purchasing text exists (via the Text / Purchasing action). The text will be used with purchase transaction lines.

Managers

Operator in charge of performing the production planning or product ordering.

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

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.

SEEINFO 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.

 

  • 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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 must 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.

seeinfoOnly one 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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 must 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.

seeinfoOnly one 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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.

seeinfoOnly one 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.

SEEWARNING 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 must 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 must be defined.Unit Conversion.

Close

 

Tab Suppliers

Presentation

You use this section to set purchase management rules for this product and for the registered suppliers. You can specify a default supplier, if the supplier is blocked, if it is a back-to-back order supplier, etc. These rules are used for the supply planning as well as for purchase transactions.

You are advised not to change the purchase unit and unit conversion factor once set, once there are active purchase transactions for this product and supplier.

You can customize these management rules for each site in order, for example, to specify a default supplier by site. This setting is performed at the product-site record level.

This section is only available for products that are purchased (as defined by the assigned product Category).

Close

 

Fields

The following fields are present on this tab :

Grid

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:

  • Is not subject to any control action
  • Is not subject to any blocking action
  • Has been issued a warning.

  • Back-to-back order (field CTMBPSFLG)

Select this check box if this supplier is a back-to-back supplier.

  • Default supplier (field DEFBPSFLG)

Select this check box 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.

  • The default supplier is defined as the supplier that is not "blocked" and that has the highest priority level (zero level).
  • If two suppliers that are not blocked have the same priority level, the default supplier is determined alphabetically by supplier code.
  • If only one supplier has the highest priority level but is is blocked, the default supplier is a supplier with a lower priority level that is not blocked.

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 check box 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.

  • The default supplier is defined as the back-to-back order supplier hat is not "blocked" and that has the highest priority level (zero level).
  • If two back-to-back order suppliers that are not blocked have the same priority level, the default supplier is determined alphabetically by supplier code.
  • If only one back-to-back order supplier has the highest priority level but is is blocked, the default supplier is a supplier with a lower priority level that is not blocked.

A back-to-back order supplier that has received a warning can still be the default back-to-back order supplier if it has the highest priority level.

Supplier identification

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:

  • No. The supplier is not subject to any controls.
  • Warning. The supplier is blocked. It will not be submitted as the default supplier and cannot be manually selected.
  • Hold. The supplier is suspended. It can still be submitted as the default supplier. Manually selecting this supplier will display a warning message.
  • 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 check box 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)

 

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 Three-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:

  • either between the invoice and the order,
  • or between the receipt and the invoice,
  • or in succession (order-receipt, then receipt-invoice).

Purchasing

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).

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 check box to specify that the last active version must, by default, be preloaded when a receipt is entered for this product.

When creating this product record this check box defaults to the same value as the Version preloading check box in the Purchasingsection.

It is possible to specify a packing unit by supplier.
This product can have several packing units:

  • A packing unit defined on the product record (from the Packing units table). These units are proposed during stock transaction entry.
    The number of packing units that can be entered is subject to the NUC - Number of packing units activity code.
  • A packing unit linked to the supplier (defined on the product-supplier record).
  • Two customer packing units (from the product-customer record). These can be used as sales units in order entry.

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 must 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.

  • No control. The control is based on the management rules. It can be modified manually.
  • Non-changeable control. Quality control is mandatory for stock receipts. Q is the only valid status.
  • Changeable control. For a miscellaneous receipt into stock, the quality status is initialized to the value Q. This status can be changed to A or R.
    The quality control code can also be defined at the purchase order level.
    • If in the order quality control is set to "Yes", quality control is mandatory and the receipt has one of the sub-statuses Q* defined in the product management rule for receipt movements.
      If no sub-status is defined, the status cannot be entered at the time of receipt.
    • If in the order quality control is set to "No", quality control is not mandatory.
      At the time of receipt, A is suggested as the default status. This can be changed to one of the statuses defined in the receipt movement rule for this product.
  • Periodic control. This control is automated according to the number of receipts for this supplier and this product. The stock status can still be modified during entry.

  • 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.

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.
SEEINFO 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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 must be greater than 1.

For any new supplier, the default value for this field is the landed cost conversion factor from the Purchasing section.

SEEINFOOnly one 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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 must 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.

SEEINFOOnly one 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 one of the two following methods:

  • global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account,
  • method in which a set of costs detailed in a cost structure is taken into account.

Only one 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 Selectionor 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 Purchasingsection.

SEEINFOOnly one 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

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:

  • the lead time on the subcontract fee of the service associated to the supplier
  • the service subcontract lead time in the selected subcontract BOM
  • the subcontract lead time specified in the Product-supplier record of the Service
  • - the purchase lead-time specified in the Product-site record of the Service
  • the reorder lead time specified in the Product record of the Service.

If no lead time is associated to the service, the lead time of the subcontracted product is used, in the following priority order:

  • the subcontract lead time specified in the Product-supplier record
  • - the purchase lead time specified in the Product - Site record
  • the reorder lead time specified in the Product record.

Close

 

Action icon

Purchasing

Click the Purchasing(Text / Purchasing) action to view, enter or modify text associated with this supplier/product combination. This text is used in purchasing transactions and supplier reports.

 

Close

 

Tab Attributes

Presentation

You use this section to classify this product by assigning a list of common identifiable characteristics defined specifically for your manufacturing processes. For example, if this product is a bicycle frame that is sprayed a color as part of the manufacturing process of assembling a bicycle, you use this section to classify this product by assigning an attribute that applies to color or paint, and the specific color that applies to this particular product you assign as an attribute value. Both the attribute classifications, and the attribute values you assign are customized attributes that are specific to your organization. The attribute classifications are used in a product - attribute matrix which supplies data to your web scheduling solution to optimize production times.

Attributes are only used with your web scheduling solution. They are not used with work orders or Production Scheduler. Finite scheduler is a generic interface that provides an integration connector, developed by Sage, to connect to Sage X3 Web Scheduling or to any web scheduling solution developed by an ISV (independent software vendor) for either cloud or on-premises solutions.

Close

 

Fields

The following fields are present on this tab :

Grid

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.

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.

Close

 

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

Click the Product-site action to create, inquire upon and update data associated with this product at a specific site.

Click the Sales price action to view the lines from the active sales price lists that apply to this product.

Click the Purchase price action to view the lines from the active purchase price lists that apply to this product.

Actions menu

Text / Purchasing

Click this action to enter or modify a purchasing text for this product. This text can then be used with purchase transactions for this product.

When a purchasing text exists, the Purchase text check box in the Purchasing section is selected.

Text / Manufacturing

Click this action to enter or modify a manufacturing text for this product. This text can then be used with manufacturing transactions for this product.

When a manufacturing text exists, the Production text check box in the Identification section is selected.

Text / Sales

Click this action to enter or modify a sales text for this product. This text can then be used with sales transactions for this product.

When a sales text exists, the Sales text check box in the Sales section is selected.

Text / Pick ticket

Click this action to enter or modify a picking ticket text for this product. This text can then be used with picking tickets for this product.

When a text picking text exists, the Picking text check box in the Identification section is selected.

Inquiries / WIP

Inquiries / Installed base inquiry

Click this action to access the installed base in order to view the list of the installed base created from a product record.

Inquiries / Sales / Quotes

Click this action to access the quote lines inquiry for the selected product.
To display the lines, you must add filters on customers and customer groups.

Inquiries / Sales / Order

Click this action to access the order lines inquiry for the product.
To display the lines, you must add filters on customers and customer groups.

Inquiries / Sales / Delivery

Click this action to access the delivery lines inquiry for the product.
To display the lines, you must add filters on customers and customer groups.

Sales / Inquiries / Invoice

Click this action to access the invoice lines inquiry for the product.
To display the lines, you must add filters on customers and customer groups.

Inquiries / Sales / Return

Click this action to access the return lines inquiry for the product.

To display the lines, you must add filters on customers and customer groups.

Inquiries / Purchasing / RFQ

Click this action to access the purchase request lines for the product.
To display the lines, you must add filters on suppliers and supplier groups.

Inquiries / Purchasing / Order

Click this action to access the order lines inquiry for the product.
To display the lines, you must add filters on suppliers and supplier groups.

Purchasing / Inquiries / Receipt

Click this action to access the receipt lines inquiry for the product.
To display the lines, you must add filters on suppliers and supplier groups.

Purchasing / Inquiries / Invoice

Click this action to access the invoice lines inquiry for the product.
To display the lines, you must add filters on suppliers and supplier groups.

Purchasing / Inquiries / Return

Click this action to access the return lines inquiry for the product.
To display the lines, you must add filters on suppliers and supplier groups.

Purchasing / Inquiries / Sub-con replenishment

Click this action to access the Subcon. consumption inquiry.
To display the lines, you must add filters on suppliers and supplier groups.

Manufacturing / Inquiries / Productions

Click this action to access the production tracking inquiry.

Manufacturing / Inquiries / Consumptions

Click this action to access the Material consumption tracking inquiry.

Manufacturing / Inquiries / Cost price

Click this action to access the cost price inquiry.

Manufacturing / Inquiries / Production Cost History

Click this action to access the Production cost history inquiry.

Manufacturing/Inquiries/List of WOs

Click this action to access the WO list inquiry for this product.

Inquiries / Stock / Stock by site

Click this action to access the stock by site inquiry.

Inquiries / Stock / Projected stock

Click this action to access the Projected stock inquiry.

Inquiries / Stock / Available stock

Click this action to access the available stock inquiry.

Inquiries / Stock / Stock by date

Click this action to access the stock by date inquiry.

Inquiries / Stock / Movements

Click this action to access the Stock transactions inquiry.

Functions / Product site creation

Use this action to automatically create product-site records from 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 must 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 file contains only a single site, the product-site record is generated automatically. You do not have to use this action.

Functions / Kits

Click this action to access the commercial BOM for the product.

Functions / Manufacturing BOM

Click this action to access the production BOM for the product.

Functions/Subcontracting BOM

Click this action to access the subcontract BOM for the product.

Functions / Routing

Click this action to access the routing management for the product.

Functions / Production slip

Click this action to directly access the Production slip function.

Functions / Where-used

Click 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.

Functions / Competitor products

Click this action to identify some products that are available on the market and that share a sufficiently large number of 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.

Functions / Point debit

Click this action to view the rule about the point debitsassociated with the product record. If there is no rule, you can set up one.

Costs / Products-cost

Costs / Standard cost

Click this action to access the standard cost inquiry.

Costs / Revised standard costs

Click this action to access the revised standard cost entry function.

Costs / Budget standard cost

Click this action to access the budget standard cost entry function.

Costs / Simulated standard cost

Click this action to access the simulated standard cost entry function.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Record that already exists

This message only appears when creating or copying the record. The product code that you have attempted to create already exists.

Record does not exist

This message only appears when searching for a record. The entered product code does not exist.

Product category : ...non-existent record

The entered code does not exist. You can jump to the Product categories function (GESITG) to create the code.

The product has been created with the reference...

When the product reference is determined by a sequence number counter (specified in the product category), the Product field cannot be entered.

Access code : ...non-existent record

The access code (administrator or quality operator) does not exist.

Incorrect date

The end-of-life date comes before the start-of-life date.

Item stat. group: ...non-existent record

The statistical group code does not exist. You can jump to the miscellaneous table to create the group.

EU regulations: ...non-existent record

The customs reference code does not exist. You can jump to the EU commodity codes function (GESINO) to create the code.

Tab without object for the current update

A not managed in stock product category has been chosen (phantom, generic, sub-contractor). The Management section cannot be updated.

Document serial number sequence ...non-existent record

The sequence number counter code does not exist.

Product: ...non-existent record

The replacement or substitution product code does not exist.

Product1 already substitutes product_X...

The search of substitution/replacement products reveals that the product that is being modified is itself a substitution/replacement product for one of the products in the list. There is a loop.

Technical record ... : non-existent record

The technical record sheet does not exist.

Unit ... : non-existent record

The unit of measure code does not exist. You can jump to the Units of measure function (GESTUN) to create the unit.

Accounting code: ...  Record does not exist

The accounting code does not exist.

Miscellaneous table : ...non-existent record

The tax level does not exist in the Tax level - product miscellaneous table.

Analytical dimension: ...non-existent record

The analytical dimension does not exist in the Analytical dimensions table.

Packaging: ...non-existent record

The packaging code does not exist. You can jump to the Packagings function (GESTPA) to create the code.

Customer: ...non-existent record

The customer code does not exist in the Customer table.

Users: ...non-existent record

The buyer code entered does not exist in the user table. You can jump to the Users function (GESAUS) to create the user.

Stock transactions: ...non-existent record

The transaction code entered does not exist.

Supplier: ...non-existent record

The supplier code does not exist in the Supplier table.

File: …. Key: …. ....... Record that already exists

Tables used

SEEREFERTTO Refer to documentation Implementation