Products

Use this function to enter and describe new items to your stock, and to view or amend details of these or existing stock items. Your stock can include finished goods, subassembly BOMs (bills of material), raw materials, spare parts, products, services, prototypes. Products can be manufactured, bought, subcontracted, and sold according to a management policy adapted to each product or stock unit.

Note - tipMany of the fields populate automatically from the product category record.
Note - informationRefer also to the Products-sites documentation.

Prerequisites

Note - informationRefer to the documentation on Implementation.

Screen management

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

  • Home section: The home information provides key tracking information, including the product category and status.
  • Identification: The main section for this function. Use this section to enter basic information about a stock item.
  • Management: Use this section to specify parameters for managing the stock.
  • Units of measure: Use this section to assign default management and packing units, such as when the packing type needs to change based on an order quantity.
  • Financials: Use this section to define accounting data for the product.
  • Sales: Use this section to define sales management rules for the product. This section is only available for sold products.
  • After-sales: Use this section to define information for the product that the Customer relation (CRM) module can use.
  • Customers: Use this section to define sales management rules for specific customers. This section is only available for sold products.
  • Purchasing: Use this section to define purchasing management rules for the product. This section is only available for bought products.
  • Suppliers: Use this section to define purchasing management rules for specific suppliers. This section is only available for purchased products.
  • Attributes: Use this section to assign characteristics to the product. These characteristics can then be referenced in your manufacturing processes.

Home section

The home section provides key tracking information, including the product category.

Tab Identification

Use this section to define the product characteristics. You can download an image of the product.

Tab Management

Use this section to specify stock management parameters.

Note - informationThis section is only available for products managed in stock. If the stock management method for the product is set to Not managed, some fields in this section are not available for entry.

Tab Units of measure

Use this section to reference all the product units: the stock unit and the associated label format, the weight unit, the volume unit, the statistical unit, and the default EU unit.

For all units except the stock units, you need to define a conversion factor with the stock unit.

For the default sales unit, specify whether the conversion factor for this unit with the stock unit can be modified when entering a sales order.

If there are active purchase transactions, the defined purchase unit and conversion factor should not be modified. Any changes could result in conversion errors in active transactions.

The various units can be accessed depending on the category type such as purchased, manufactured, sold, etc.

A Packing unit table provides 4 default packing units. The number of packing units that can be entered is subject to the NUC–Number of packing units activity code. It contains the packing unit code, the conversion factor for this unit with the stock unit, the 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.

Tab Financials

Use this section to define the accounting data such as the accounting code, tax levels, and analytical dimensions for the product.

Tab Sales

Use this section to define sales management rules for the product.

Note - settingsThis section is only available for sold products, as defined by the assigned Category.

Tab After-sales

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

Tab Customers

Use this section to define sales management rules for the product for specific customers.

Note - settings This section is only available for sold products, as defined by the assigned Category.

Tab Purchasing

Use this section to define the purchasing management rules for the product.

Note - settingsThis section is only available for purchased products, as defined by the assigned Category.

Tab Suppliers

Use this section to define purchasing management rules for specific suppliers. You can specify if your supplier is the default, blocking, back-to-back, etc. The purchasing management rules are applied during supply planning and for purchase transactions.

You’re advised not to change the purchase unit and conversion factor that are already set when there are active purchase documents for the product and supplier.

You can customize these management rules to specify a default supplier by site, for example. This setup can be defined in the Products-sites record.

Note - settingsThis section is only available for purchased products, as defined by the assigned Category.

Tab Attributes

Use this section to categorize your product by assigning it a set of common characteristics that will be useful especially in your manufacturing processes. For example, if the product is a bicycle frame that needs to be painted in a certain color during the assembly process, use this section to add an attribute to your product corresponding to the paint, and an attribute value corresponding to the color. The Attributes and attribute values that you specify are customizations specific to your organization. This information is defined in a setup time matrix for the products and attributes. It’s transmitted to your scheduling solution to optimize manufacturing lead times.

Note - warningAttributes can only be used by your scheduling solution. You cannot use them for work orders or in Production Scheduler. The Finite scheduler provides a connector developed by Sage, to connect to Sage X3 Web Scheduling or to any web scheduling solution (either cloud or on-premise).

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

Actions menu

Error messages

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

The record already exists.

This message is only displayed when creating or duplicating a record. The product code that you’re trying to create already exists.

The record does not exist.

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

Product category: ...non-existent record

The entered code does not exist. You can directly access the Product category function (GESITG) to create a code.

The product has been created with the reference...

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

Access code: ...non-existent 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.

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

The statistical group code does not exist. You can directly access the corresponding miscellaneous table to create a statistical group code.

EU regulations: ...non-existent record

The customs reference does not exist. You can directly access the NC8 BOMs function (GESINO) to create a code.

Tab without object for the current update

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

Document sequence number: ...non-existent record

The sequence number does not exist.

Product: ...non-existent record

The alternate product code does not exist.

Product1 already replaces product_x...

The search for alternate products reveals that the product that’s being modified is itself an alternate product for one of the products in the list. There is a loop.

Technical sheet... : non-existent record

The technical sheet does not exist.

Unit ... : non-existent record

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

Accounting code: ... Record does not 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 dimension table.

Packaging: ...non-existent record

The packaging code does not exist. You can directly access the Packaging function (GESTPA) to create a code.

Customer: ...non-existent record

The customer code does not exist in the customer table.

Users: ...non-existent record

The user code does not exist in the user table. You can directly access the Users function (GESAUS) to create a user.

Stock transactions: ...non-existent record

The transaction code does not exist.

Supplier: ...non-existent record

The supplier code does not exist in the supplier table.

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

Tables used

Note - informationRefer to the documentation on Implementation.