Product categories
Use this function to create individual groups to assign to products that share a common purpose or attribute.
Prerequisites
Screen management
The Product categories function contains a home information section and a section for each feature of the requirement:
- Home section
- Tab Description
- Tab Management
- Tab Units of measure
- Tab Receipts
- Tab Issue flow
- Tab Accounts/Costs
- Tab Purchase/Sales
- Tab Planning
- Tab Warehouses
Home section
Tab Description
Use this section to define the characteristics of the product category.
Characteristics
| Short description (TCLSHOAXX) |
| The category short description. |
| Product sequence (ITMREFCOU) |
| The product sequence number that's used to automatically generate the product code. |
| Creation method (ITMCREMOD) |
|
The initial status of the product. Direct: The product is set to Active status. It's available immediately for all processes. With validation: The product is set to In process status. The product status needs to be changed before the product is available. |
Managers
| Access code (PLAACS) |
|
Use this access code to specify a user that is responsible for the product quality for the product category. This user can modify or cancel the product if this access code is associated with their profile and their modification indicator is set to Yes. |
| Buyer (BUY) |
| The operator responsible for replenishing the product. |
| Planner (PLANNER) |
| The operator responsible for planning production or ordering the product. |
Category types
| Service (SCSFLG) |
| Indicates that the category is for subcontracted products and subcontract routing operations. |
| Phantom (PHAFLG) |
| Indicates that the category is for grouping components used in production. |
| Tools (TOOFLG) |
| Indicates that the category is for tools used in routing operations. |
| Generic (GENFLG) |
| Indicates that the category is for generic products that are not managed in stock. |
| Maintenance (MCEFLG) |
|
This field is subject to the MMS—MMS interface - X3 activity code. Selected indicates that products assigned to the category are exported to the AXEL - MMS software. |
Flow types
Miscellaneous
| ABC class (ABCCLS) |
|
The classification to use with the product with regard to its importance to the turnover or to the stock, for example. The ABC category is used as a selection criterion in the stock count lists. Values between A and D can be entered manually or set up to update from the ABC statistical analysis. At the time of creation, the product is not associated with any statistical data and is classified in category D, by default. |
| Product line (CFGLIN) |
|
A product line is used to:
|
| SAF-T product type (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:
|
Statistical groups
| TSICOD |
|
Alphanumerical code from the statistical group table. Statistics groups are used in the statistical processings and as selection criteria in many programs. There are a maximum of 5 statistical groups, and their number and their title can be set up when installing the software. Assignment of a statistical group representing the commercial group for a product is mandatory. It subdivides the product catalogue in the database. The CODEFAMCIA general setup determines which of the 5 product statistical groups is dedicated to this use. |
Tab Management
Use this section to specify stock management parameters.
Stock management
Stock parameters
| Negative stock (NEGSTO) |
|
Indicates if stock of the product that's not yet present in the system can be issued. Example:
|
| Management mode (STDFLG) |
|
The management mode for the product:
This value is used in the MRP and MPS reorder calculations. |
| Count mode (CUNCOD) |
|
The frequency of counts for products in this category. Annual count Cycle count Not counted: This frequency is only available for products that are not managed in stock. |
| Stock withdrawal mode (STOCOD) |
|
The stock issue mode. The mode can be defined at category level, then refined by site category. You need to specify, for the product, when it’s defined as a material for a finished or semi-finished product:
2 parameters from the material tracking transaction are associated with the issue mode. When tracking materials, the materials to be proposed for consumption in the transaction (post consumption / immediate / all stock issue in the Materials tab in the tracking transaction) can be filtered. The parameters are: Immediate: In the tracking transaction, it’s possible to impose a detailed entry of the material consumption (Strict manual issue parameter). Post consumption: The products will be consumed when closing the work order. They can be excluded from a manual material issue entry for the work order. No management: For a product not managed in stock. |
| Traceability (TRKCOD) |
|
Defines if movements of the product need to update a log file. Detailed traceability: Every movement of the 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. Note - tipThis value is recommended for work order receipts and issues so the returned log is only split once.
No traceability: Stock movements for the product are not recorded on a log file. |
| Product type (INVPRODTYP) |
|
The product types published by Portuguese Fiscal Authorities and regulated for the fiscal year inventory declaration. You need to select a value for this field when the KPO—Portuguese Localization activty code is active. The values are defined in the 2051—Product type local menu. The value you select is included in the XML fiscal year inventory export declaration generated by the Inventory extraction function (GESINVEXT). |
Lot management
| Lot management (LOTMGTCOD) |
|
Defines if products in the category are managed by lot. A lot number differentiates stock lines. Note - informationStock lines
The 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. They're 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 the product, as follows:
Note - warningYou can only edit the value if the product has no stock.
|
| Lot sequence number (LOTCOU) |
|
Lot sequence number counter that defines the format of lot numbers for products in the category. The lot number can be a maximum of 15 characters. Note - settingsManagement of lots and sublots is subject to the LOT–Lot management and SLO–Management by sub-lots activity codes.
|
Serial no. management
| Serial no. management (SERMGTCOD) |
|
Controls serial number management for the product category. Not managed: The category does not require serial number management. This rule is applied to all transactions for the product. Issued: Serial numbers are not managed in stock, but they’re used upon issue for customer tracking purposes. Received / issued: Management of serial numbers is per unit. A serial number differentiates 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 1 stock line. Similarly, only 1 stock movement is generated for a range of n serial numbers for products with identical stock characteristics. Note - information
Note - warning
|
| Serial sequence (SERCOU) |
| Sequence number code that is used to automatically assign the serial numbers. |
Quality
| QC management (QUAFLG) |
|
Defines whether the product needs to be controlled on receipt into stock. 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 edited. 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.
Periodic control: This control is automated according to the number of receipts for this supplier and the product. The stock status can still be modified during entry. |
| Technical sheet (QLYCRD) |
|
The quality control process for the product can be described using a technical record. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. Note - tipYou can specify this record for a product and a supplier.
|
| Access code (QUAACS) |
|
Provides access to the product for a quality control operator. The user profile needs the access code defined to modify the status of a product and perform quality control. |
Expiration
| Expiration management (EXYMGTCOD) |
|
The calculation mode for the expiration date. Expiration management is subject to the EXY–Expiration management activity code. Not managed: With no management, the fields Expiration 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 opens automatically when recording a stock receipt. The expiration date is initialized based on the reference date and lead time. Manual entry: With this value, an entry window for the expiration date opens automatically when recording a stock receipt. The expiration date is blank. Note - settingsExpiration 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. |
| Expiration status (EXYSTA) |
|
Note - settingsThis field is not available if the expiration Management field (EXYMGTCOD) is set to No management.
The process used to change the status of a lot in stock when it expires. A: The status of the product does not change on expiry. Q: The product can be controlled on expiry, for a potential date extension or rejection. R: When the product reaches its expiration date, it’s rejected. |
Packing
| Packing (PCKFLG) |
| Indicates that the product is considered when packing. |
| Stock detail (PCKSTKFLG) |
| Specifies if stock information such as the lot and serial number needs to be displayed on the packaging. |
| Packaging (PCK) |
|
The packaging code to use when delivering the product. This code is used for automatic packing. |
| Packaging capacity (PCKCAP) |
| The number of products, expressed in the sales unit, that the packaging can contain. |
Version management
| Version management (ECCFLG) |
|
Management of versions is subject to the ECC–Product version management activity code. During the lifetime of a product, some of its characteristics can be modified. These modifications can be tracked back by activating version management. To use version management, the product needs to be managed in stock. Versions will then be active in Manufacturing functions. For the tracking of versions to be effectively managed at the stock level, the product needs to also be managed by lot. The Lot management field (LOTMGTCOD) needs to be 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 the product is created, if management of versions is activated, a message is displayed to suggest automatic creation of the first major version of the product. This version is assigned a To be activated status. To use the version, its status needs to be modified. |
| Stock version (ECCSTO) |
|
This field is only available if versions are managed at the stock level. The product needs to be managed by lot and management of versions is activated. Major: Major versions might be used where there have been increased or significant changes to the original or previous version. The form, fit, or function has changed. You need to 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. Both major and minor versions of the product are managed. You need to assign 2 sequence number counters, 1 counter for a major versions and 1 counter for minor versions. Note - tipYou can click the link icon to access the Versions management screen.
|
| Major sequence (ECCMAJ) |
|
If major versions are managed for the product, assigns the major version sequence counter to use to automatically assign a code to each major version of the product. For example, each major version of the product can be identified by an alphanumeric code, A then B, then C, etc. |
| Minor sequence (ECCMIN) |
|
If major and minor versions are managed for the product, assigns the minor version sequence counter to use to automatically assign a code to each minor version of the product. For example, each major version of the 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. |
Storage
| Location management (LOCMGTCOD) |
| Indicates that locations are managed for products in the category. |
| Container management (LPNMGTCOD) |
|
Indicates that locations are managed for products in the category. This field is subject to the LPN—License plate no. management activity code. The information is defined by default at product category level. You can modify it. If this checkbox is selected, you can:
|
Bill of lading
| Freight class (FRTCLS) |
| The freight class to use when creating a new product-site record for use in Bill of lading. The value is controlled by the legislation and site groupings. |
| NMFC (NMFC) |
|
The NMFC (National Motor Freight Codes) code to use when creating a new product-site record for use in Bill of lading. The value is controlled by the legislation and site groupings. Note - settingsThis field is only available if the KUS—Localization USA activity code and the USABOL—Bill of Lading parameter (LOC chapter, USA group) are set to Yes.
|
Grid: Dedicated locations
| Location category (LOCDES) |
| You can only access this field when if Location management checkbox (LOCMGTCOD) is selected. This table lists the location categories. You can use it to set up the locations to link to the product category by default. |
| Default icon type (DEFLOCTYP) |
|
The icon to link to the product category, by default. The location type can be used with stock movements. You can enter a code with a generic character such as *, #, !, or ?. |
| Default locations (DEFLOC) |
|
The location to link to the product category, by default. The location can be used with stock movements if the LOCSUG—Suggested locations parameter (STO chapter, MIS group) is set to Based on product setup. You can enter a code with a generic character such as *, #, !, or ?. If the location is a dedicated location, an assignment needs to be defined for the product. |
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.
Units of measure
| Stock unit (STU) |
| The unit in which the product is stored. It provides the key to prices, costs, volumes, etc. It cannot be modified. |
| STK label format (STULBEFMT) |
| The format of the stock labels. |
| Weight unit (WEU) |
| The weight unit. |
| STK weight (ITMWEI) |
| Weight of a product stock unit, expressed in the displayed weight unit. |
| Volume unit (VOU) |
| The product volume unit. It’s used when distributing invoicing elements on the lines according to the pro rata calculation of product volumes. |
| STK volume (ITMVOU) |
| The volume of a product stock unit in the volume unit displayed. |
| Purchase unit (PUU) |
|
The purchase unit defined for the product-supplier combination, or for products that do not exist in the product-supplier record. The product has 2 purchase units:
This purchase unit cannot be modified. It’s 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. Note - tipWhen invoicing a product, the product purchase unit is used.
|
| PUR-STK conv. (PUUSTUCOE) |
|
Conversion factor used to calculate the quantity in stock units from a quantity entered in purchase units: Quantity in STK = Qty in PUR * conversion factor. This conversion factor can be accessed if the Purchase unit field (PUU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
| Sales unit (SAU) |
|
The unit in which the 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. (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 (DACSAUCOE) |
| Indicates if modification of the conversion factor between the sales unit and the stock unit on sales transactions is authorized. |
| Statistical unit (SSU) |
| This unit is used for the calculation of statistics in quantity. It’s used to carry out analyses with a unit that’s common to all products, when the analysis criteria are of type customer or supplier, for example. |
| STA-STK conv. (SSUSTUCOE) |
|
Conversion factor used to calculate the quantity in stock units from a quantity entered in statistical units: Quantity in STK = Qty in statU * conversion factor. This conversion factor can be accessed if the Statistical unit field (SSU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
| Intrastat additional unit (EEU) |
| The additional EU unit in which is expressed the quantity issued for the Customs Document File. |
| EU-STK conv. (EEUSTUCOE) |
|
Conversion factor used to calculate the quantity in stock units from a quantity entered in additional EU units: Quantity in STK = Qty in EEU * conversion factor. This conversion factor can be accessed if the EU unit field (EEU) has been entered, and has a value different from the stock unit. It can be initialized using the conversion factor table if the combination exists. |
Grid: Packing unit
| Unit (PCU) |
|
The unit associated with the supplier. The product can have several packing units:
Only packing type units from the units of measure table can be selected. |
| PAC-STK conv. (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 (DACPCUCOE) |
| Indicates if modification of the conversion factor between the packing unit and the stock unit on purchase orders or receipts is authorized. |
| Label format (LBEFMT) |
| The label format. |
| Issuing PAC (PCURUL) |
|
Defines 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. Adjust coefficient (recalc PAC coeff): The stock line conversion factor can be adjusted as needed, and the line is split if necessary. This option is only available when conversion factor entry is authorized. Fraction (calculate decimal PAC): The stock line quantities can be adjusted by division (split). Note - settingsThe sales and purchasing units need to exist in the packing units table if the transaction unit entered in the resulting stock line needs to be retained. Otherwise, the resulting stock line is managed in stock units.
|
Tab Receipts
Use this section to define the rules for receipts.
This table is preloaded by default based on a set of global rules defined in the Stock management rules function (FUNSTORUL).
Grid: Management rules
| Movement type (TRSTYPE) | ||||||||||||||||
| The type of stock movement transaction. | ||||||||||||||||
| Movement code (TRSCODE) | ||||||||||||||||
|
The movement code is used to define specific stock receipt and issue rules for some transactions. For example, a dedicated transaction associated with experienced users can authorize the receipt to stock of goods at quality status A, while other users might be associated with a transaction authorizing the receipt to stock of goods at quality status Q. Note - settingsThe movement codes need to be created in the 14 miscellaneous table.
|
||||||||||||||||
| Location (LOCNUME) | ||||||||||||||||
| The location to link to the stock movement type. | ||||||||||||||||
| Authorized statuses (AUZSTAE) | ||||||||||||||||
| The statuses that are authorized for this stock movement type. | ||||||||||||||||
| Authorized substatuses (AUZSSTE) | ||||||||||||||||
|
The substatuses that are authorized for this stock movement type. This field is automatically populated with the substatus templates corresponding to the authorized statuses, if you leave this field blank. |
||||||||||||||||
| Default status (DEFSTA) | ||||||||||||||||
| The default substatus that is authorized for this stock movement type. | ||||||||||||||||
| Analysis request (QLYCTLFLG) | ||||||||||||||||
|
Use this parameter to save an analysis request to be processed by the Quality control function (GESSTQ), in the event that the status is entered with a Q value. Note - tipIf the value of this parameter is No, you cannot switch the status to A or R in the Quality control function. You need to use the Stock change transactions function (GESSCS) instead.
|
||||||||||||||||
| Lot entry (DACLOT) | ||||||||||||||||
|
The manual entry requirements of the lot code for the stock movement type. Free: A lot code can be entered. New lot: The lot code needs to be unique. No: You cannot enter a lot code. The default value for the lot code is used and the number is assigned by the lot sequence number. |
||||||||||||||||
| Lot by default (LOTSUPINH) | ||||||||||||||||
|
The default value for the lot. None Supplier lot: The supplier lot number. Document number: The document number from the receipt transaction. The following table summarizes the impact of the management rule on Receipt transactions.
(*) The lot counter linked to the product. |
||||||||||||||||
| License plate number (DACCTR) | ||||||||||||||||
| Specifies whether a license plate number is Optional or Mandatory. |
Tab Issue flow
Use this section to define the rules for stock issues.
This table is preloaded by default based on a set of global rules defined in the Stock management rules function (FUNSTORUL).
Allocation rules
| Order (ALLRULORD) |
| The allocation rules code. |
| Work order (ALLRULMAT) |
| The allocation and issue rules code for work orders. |
Global allocation
Issue rules
| Shipment (ALLRULSHI) |
| The assignment rule to apply to deliveries and picks. |
| Material consumption (ALLRULMFG) |
| The assignment rule to apply to work orders and material tracking, for components that are not attached to subcontract operations. |
| Internal movement (ALLRULTRF) |
| The assignment rule to apply to internal movements such as miscellaneous issues, assembly or disassembly, and transfers. |
| Subcontract dispatch (ALLRULSCO) |
| The assignment rule to apply to subcontract deliveries and consumption reorder plans for subcontractor locations. |
| Subcon. consumption (ALLRULSCC) |
|
The assignment rule to apply to material tracking, for components that are assigned to subcontract operations. Note - informationThis rule is also used in the subcontract operations without a work order, when allocating materials to a subcontract order.
|
Grid: Management rules
| Movement type (TRSTYPS) |
| The type of stock movement transaction. |
| Movement code (TRSCODS) |
|
The movement code is used to define specific stock receipt and issue rules for some transactions. For example, a dedicated transaction associated with experienced users can authorize the receipt to stock of goods at quality status A, while other users might be associated with a transaction authorizing the receipt to stock of goods at quality status Q. Note - settingsThe movement codes need to be created in the 14 miscellaneous table.
|
| Location 1 / 2 / 3 (LOCNUM / LOCNUM2 / LOCNUM3) |
| The location to link to the stock movement type. |
| Authorized statuses (AUZSTAS) |
| The statuses that are authorized for this stock movement type. |
| Authorized substatuses (AUZSSTS) |
|
The substatuses that are authorized for this stock movement type. This field is automatically populated with the substatus templates corresponding to the authorized statuses, if you leave this field blank. |
| Output lot (SHLLOT) |
|
The stock issue rules for expired lots for this stock movement type. No, expiration date control: The expiration date needs to be controlled before a lot is issued. No, use by date control: The use-by date needs to be controlled before a lot is issued. Yes: A lot can be issued, irrespective of the expiration date or use-by date. |
| Prototype version (AUZPRO) |
|
The issue rules for stock of versioned-managed prototypes for this stock movement type. No: Prototypes are not issued from stock. Yes, except on hold: Prototypes can be issued from stock only if the stock is not on hold. Yes: Prototypes can be issued from stock. |
| Active version (AUZACT) |
|
The issue rules for an active stock version for this stock movement type. No: Stock is not issued. Yes, except on hold: Stock can be issued only if the stock is not on hold. Yes: Stock can be issued. |
| Version stopped (AUZSTP) |
|
The issue rules for a discontinued stock version for this stock movement type. No: Stock is not issued. No, unless exception: A discontinued stock version can only be issued to meet an exception date or period. Yes: A discontinued stock version can be issued. |
| Exclusive entry version (ORDVER) |
| Indicates whether the version entered in the issue line should be exclusive or not. |
Tab Accounts/Costs
Use this section to define the accounting data such as the accounting code, tax levels, and analytical dimensions for the product.
Accounting
| Accounting code (ACCCOD) |
|
The accounting code of the category. The accounting code is a default value used when setting up accounting entries. It refers to a table that lists a certain number of elements such as collective accounts, accounts or parts of accounts that can be used for the determination of the documents that will be posted. |
| Tax level (VACITM) |
|
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. Note - informationRefer to the Tax determination documentation for further information.
The tax level only displays the list of the different rates applied within a same rule. |
| SST tax code (SSTCOD) |
|
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
Project
| Cost type (PCCCOD) |
|
Assigns the 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. Note - settingsYou should only define a project cost type for products managed as Available stock and for purchased products managed By order. You do not need to define a cost type for manufactured products managed By order as the products to be valued, as per their cost type, will be the components in the bill of material (BOM), not the manufactured product itself. The components will either be managed as Available stock or purchased By order.
|
Grid: Analytical
| Dimension type code (DIE) |
| This table is populated automatically with the default dimension types associated with the product category. |
| Dimension (CCE) |
|
An analytical dimension is an element of the analytical chart of accounts on which accounting entries can be posted. Each analytical dimension type represents a specific division of the company into a set of analytical payment attributes. An analytical dimension is therefore an analytical payment attribute within a dimension type. |
Costing
| Valuation method (VLTCOD) |
|
The valuation method to apply to stock transactions or movements. The default value is defined for the valuation method specified at product category level. Note - tip
A history of the last 3 changes to the valuation method is stored in the Products-sites table (ITMFACILIT), with the date and time of each change.
Note - dangerWhen set, you’re advised not to change the valuation method. Changing the valuation method can affect the value of work orders currently in progress.
Note - informationFor more information on stock valuation, see the related documentation: Basic principles for the valuation of the stocks.
|
| Cost group (BRDCOD) |
|
Cost calculations are used to break down material costs. The field (subtotal) the material cost for the product is posted to. Note - settingsThe MAT–Number of material groups activity code defines how many family cost groups are available.
|
| Standard cost update (STDCSTUPD) / Revised std. cost update (CUTCSTUPD) / Budgeted std. cost update (BUDCSTUPD) / Simulated cost update (SIMCSTUPD) |
|
The cost update indicator for each type. Calculated: The existing entered or calculated cost will be overwritten by the next calculation run. The corresponding column can still be entered. Entered: The cost calculation does not modify the data entered for this type of cost, and it is not passed on to the lower levels of the BOM. |
Grid: Overhead
| Movement type (OTRSTYP) |
| The movement type that specifies the overheads that match this entry type. |
| Overhead (OVECOD) |
|
The overhead code. Overhead codes are used as follows:
The overheads column that contains the formula or fixed rate to be used in the cost price calculation functions is defined by parameters. For standard cost calculations the OVECOLSTD—Standard calc overhead column parameter (GPA chapter, COS group) applies. You can modify the column to be applied before running the calculation. |
| Include lower level ovrh. (OVECPNFLG) |
|
The calculation type. Total: The overhead calculation for the manufactured product does not include the overhead amount for the lower-level products. Cascade: The overhead calculation for the manufactured product includes the overhead amount for the lower-level products. Note - information
The lower-level products are products that are not finished products, the semi-finished products, and the raw materials.
|
Tab Purchases/Sales
Use this section to define the purchasing and sales management rules for the product.
Purchasing
| Firm horizon (FIMHOR) |
| Horizon for which the firm delivery requests need to be carried out, based on a week, month, or other unit. |
| FIMHORUOM |
| Unit of time in which the firm horizon will be expressed. |
| Planning horizon (FRTHOR) |
| The period, expressed in number of days, weeks, or months during which the provisional delivery requests can be completed. |
| FRTHORUOM |
| Unit of time in which the planning horizon will be expressed. |
| Reorder LT (OFS) |
|
For purchasing:
This information is used for the calculation of net requirements only, in order to calculate the start date of subcontract operation suggestions when the product does not have a product-site record. For a direct order or a purchase request: This lead time is also used in the MRP calculations to calculate the requirement start date. |
| JOURS1 |
| The purchasing leads are always expressed in calendar days. |
| Delivery tolerance % (MINRMNPRC) |
|
The tolerance percentage used during the receipt of goods. It’s used to determine if the associated order line should be closed taking into account the remaining quantity to be received. This value is combined with the value given by the POHCLE setup. |
| Matching tolerance (MATTOL) |
|
The match code for a given product. For any new product, this field inherits from the code defined for the product category. This code can be edited. This code originates from the Match tolerance function. Note - information
Reminder: The 3-way match is a reconciliation process that's used to validate the payment of an invoice, with a minimum and a maximum tolerance threshold. The reconciliation is carried out:
|
| Received product (RCPFLG) |
| Select to prevent receipt of the product if it's not managed in stock. |
| Mandatory PO request (PRQFLG) |
|
Select to specify if the product needs a purchase request to be created before being ordered.
|
| Version preloading (LOAECCFLG) |
| Select to specify that the last active version needs to, by default, be preloaded when the product is received into stock. This setup can be refined by supplier. |
| Purchase unit (ITMPUU) |
| The purchase unit defined in the Units of measure section. |
Sales
| Type (ITMTYP) |
|
A sold product can be:
A flexible kit or a fixed kit directly defines a sales BOM. On entry of a product of this type in a sales document, the system searches for the associated BOM with the same name according to the sales alternative specified and will note in the document the assembly and all the components, the options, or variants comprising this sales BOM. |
| Delivery tolerance % (SALRMNPRC) |
| The tolerance percentage below which the order line will be closed in the case of a partial delivery. |
| Minimum quantity (MINQTY) |
|
The minimum quantity expressed in the sales unit that can be entered on a sales order. Note - dangerThis control can be blocked by the SDACLOK–Non block control price, profit, quantity parameter (VEN chapter, AUZ group).
|
| Maximum quantity (MAXQTY) |
| Maximum order quantity, in sales units. |
| Loan authorized (LNDFLG) |
| Authorizes loans for a customer for the product category. |
| Back-to-back order (CTMFLG) |
|
When a product is defined as being managed by back-to-back order, the option to generate a back-to-back order when an order line is created is provided automatically. There are 3 types of back-to-back orders:
The back-to-back order type submitted by default depends on:
In the event of a purchase back-to-back order, it’s a direct back-to-back order with the supplier delivering the goods to the customer, when the quantity ordered is greater than the direct quantity, as expressed in the product sales units. At Product-Site record level and for each site for which the product should be managed with back-to-back orders, an allocation rule with the back-to-back order type and the Back to back method (1 to 1) checkbox selected needs to be associated in the Planning link. |
| Back-to-back direct qty. (CTMQTY) |
| The quantity, as expressed in sales units from the direct order. |
| Price origin (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’s 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 in the Purchasing section and to the percentage entered in the purchase % applied field (PURPRIPRC), as follows: Base purchase price + (Base purchase price * % applied). |
| % applied (PURPRIPRC) |
| This field is only accessible if the Price origin field (BASPRIORI) is set to Purchase price %. It’s 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. |
| Invoicing term (INVCND) |
|
This field is only available when the following conditions are met:
Use this field to enter an Invoicing term. This information is optional. This information is used as the default invoicing term on the sales order lines when the header invoicing term is not entered and cannot be used to initialize the invoicing term on order lines. |
Landed costs
| Landed cost coef. (CPRCOE) |
|
Landed costs management enables the routing costs of the goods ordered from a supplier to be quantified and allocated to the products upon order, receipt, or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used. The choice of method is performed at the product management level. Use this field to enter a conversion factor to be included in the calculation of the purchase cost and stock cost. This value needs to be greater than 1. Note - warning
Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the cost structure to erase after a warning message.
Note - dangerWhen the PIHCPR—Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant for accounting purposes. The Goods received not invoiced (RNI) account will not balance. 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’s possible to enter, for each product-supplier, different landed costs for each storage site. You can add these values directly in the Suppliers section in the Products-sites function (GESITF). You can also add these values via the Landed costs-supplier-site icon or using the Landed costs-site function (GESSTCITF). |
| Fixed cost per unit (CPRAMT) |
|
Landed costs management enables the routing costs of the goods ordered from a supplier to be quantified and allocated to the products upon order, receipt, or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used. The choice of method is performed at the product management level. Use this field to add a fixed cost for each unit. 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, which is defined in the user's function profile. It refers to the display currency. The amount is stored in the folder currency, with the conversion from the average monthly exchange rate. If a site is not entered on the function profile, the amount is expressed in the folder currency. Note - warning
Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the cost structure to erase after a warning message.
Note - dangerWhen the PIHCPR—Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant for accounting purposes. The Goods received not invoiced (RNI) account will not balance. 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’s 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 (STCNUM) |
|
Landed costs management enables the routing costs of the goods ordered from a supplier to be quantified and allocated to the products upon order, receipt, or invoice. These costs are used for the calculation of the purchase cost and stock cost. The evaluation of these costs can be performed according to 1 of the following methods:
Only 1 method can be used. The choice of method is performed at the product management level. Use this field to add a cost structure used in the calculation of the cost price. You can manually enter this value or select Selection or Cost structure (access to the Cost structure function) from the Actions icon. For any new supplier, the default value for this field is the cost structure from the Purchasing section. Note - warning
Only 1 method can be selected to calculate the landed costs. If a cost structure is entered, entering a landed cost conversion factor and/or a fixed cost per unit triggers the reinitialization of these elements after a warning message.
Note - dangerWhen the PIHCPR—Invoice price adjustment parameter (ACH chapter, INV group) is set to With landed costs, the configuration is not compliant for accounting purposes. The Goods received not invoiced (RNI) account will not balance. 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’s 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). |
Tab Planning
Use this section to plan your stock policy to ensure that enough stock is available to complete work and sales orders on time.
Planning
| Firm horizon (PLH) |
|
The fixed horizon (in lead time unit) is used in the calculation of the Master Production Schedule (MPS) and Material Requirements Planning (MRP). It can be used to freeze the production plan on a given period: the suggestions used to cover the shortages located within this horizon are transferred onto the first period beyond this horizon. These suggestions are subject to a specific marking in the MRP results and MPS results inquiries: in the Order column, the order code is followed by an asterisk (*). |
| PLHUOT |
| The planning horizon lead time unit. This can be weeks, fortnights, or months. |
| Demand horizon (FOH) |
|
The request horizon, expressed in the number of days. The request horizon is used to calculate projected stock. The available stock is calculated using the customer order book below this horizon. Forecasts are calculated above this horizon. |
| FOHUOT |
| The request horizon lead time unit in weeks, fortnights, or months. |
| Trend profile (SESCOD) |
| An allocation curve used to create forecasts, based on a seasonality variation structure that can be parameterized. Seasonality curves are created in the seasonality table. |
| Shrinkage percent (SHR) |
|
The loss percentage corresponds to the production or storage loss. The production loss corresponds to the totaled loss generated for each routing operation. This percentage is included in the Material Requirements Planning calculations and in work order management. It's used to calculate the quantity to be reordered to obtain the quantity to cover the requirement. |
Manufacturing
Reorder
| Reorder mode (REOMGTCOD) |
|
The reordering mode. Not managed: No reorder management By MRP: Reordering is calculated by the MRP requirements By MPS: Reordering is calculated by the MPS By ROP: Reorder on threshold By period: Reorder by periodic replenishment |
| Reorder frequency (REOPER) |
| For a periodic reorder mode, the number of calendar days between 2 reorders. |
| JOURS8 |
| The reorder frequency is always expressed in calendar days. |
| Reorder policy (REOPOL) |
|
The reorder policy used for the calculation mode of suggestions in the MRP calculations:
|
| Coverage (DAYCOV) |
|
Coverage is an MRP parameter. If you need to define coverage, you need to express it in weeks. With coverage expressed, you can work with changeable security and reorder lots depending on the order book or on the forecasts recorded during the coverage period. |
| SEMAINE |
| Coverage is always expressed in weeks. |
| Suggestion type (REOCOD) |
|
The suggestion type is used when running Material Requirements Planning. It’s used to define if the product needs to be subject to:
If the suggestion is an Intersite type, the reorder site needs to be specified in the Reorder site field (REFCY). |
| Reorder site (REOFCY) |
|
The supplier site from which a replenishment needs to be carried out for an Intersite type suggestion. The intersite suggestion is mirrored by a requirement at the replenishment site. Note - information
An intersite reorder suggestion is between 2 sites in a single company.
|
| Safety stock (SAFSTO) |
|
The security stock used in the Material Requirements Planning calculations. It's additional stock implemented to be able to meet a longer deadline to obtain stock or a request for more than an average request. |
| Reorder threshold (REOTSD) |
|
The minimum stock level. The reorder threshold is used with on order stock management. It's the stock level from which a reordering or a work order is triggered. It's generally equal to the total consumption during the reorder time to which security stock is added. |
| Maximum stock (MAXSTO) |
|
The maximum stock level. The maximum stock is used in the reorder calculations. |
| EOQ (REOMINQTY) |
|
The minimum reorder quantity The minimum reorder quantity is used in the Material Requirements Planning calculations according to the selected reorder policy. It’s submitted as the calculation quantity in the cost calculations. It represents:
|
| Technical lot (MFGLOTQTY) |
|
The lot or batch size. The lot size is used in the Material Requirements Planning calculations. According to the reorder policy, the lot size lets you perform the following actions:
|
Parameters
| Assignment rule (PTOCOD) |
|
The assignment rule creates a link between a requirement such as a sales order or material requirement and a resource such as a work order or purchase order. It specifies the link to create. If the Direct order (1 to 1) mode checkbox is selected, the system will authorize the assignment of a sales order to a purchase order, for instance, but not the assignment of a sales order to several purchase orders because it needs to be 1 to 1. This rule is applied during order update or creation. If you do not specify a rule, the rule specified in the DEFPTO—Assignment rule MTO parameter (STO chapter, SCH group) applies by default in the Automatic assignment, Automatic deassignment, and WIP resynchronization functions. |
Tab Warehouses
Use this section to plan your logistics.
Reports
By default, the following reports are associated with this function:
- TABITMCLS: Product categories
This can be changed using a different setup.
Specific actions
| Select this action to access the description of the default management rules set up for the folder. These rules are applied in the absence of information at product category level. |
Error messages
The only error messages are the generic ones.