Products-sites
Use this function to create, inquire upon, and update data associated with a specific product at a specific site. You can also customize the product-supplier management rules by site.
Many of the fields are populated automatically from the product category record.
Prerequisites
Refer to documentation Implementation
Screen management
The Products-sites function contains a home information section and a section for each feature of the requirement:
- Home information: The home information provides key product-site information, including the status of the product at the site.
- Management: This is the main section for this function. Use this section to define core management controls to run on the product and site, such as quality management and storage locations.
- Planning: This section displays the details of your stock policy, including any firm horizons, reordering, safety levels, and manufacturing or purchasing lead-times.
- Stock: This section is here for information purposes only. It displays stock totals for the product at the site.
- Totals: This section is here for information purposes only. It displays statistical movement data.
- Calculated data: This section displays the details of your stock management policy. You can use this information to make sure that enough stock to complete work and sales orders on time.
- Manufacturing: This section is available if the product is a manufactured product. It displays routing and weighing controls.
- Cost: This section displays the costing and pricing information, and the valuation method to use for the stock.
- Counts: This section displays the stock count information, including the date of the last stock count and statistical data for each stock count.
- Warehouses: This section displays logistics information.
- Suppliers: Use this section to customize the supplier product management rules by site.
- Attributes: Use this section to assign characteristics to the product for this site that can be referenced by your manufacturing processes.
Home
The home information provides key product-site information, including the status of the product at the site.
Category (field TCLCOD) |
The product categories are used to classify and filter the products according to their use. |
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:
Impact of the product status in the sales and purchase modulesSales
Purchases
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:
|
Product (field ITMREF) |
The product reference. The product reference is the first component of the product-site identifier. |
Stock site (field STOFCY) |
The product storage site. |
Stock unit (field STU) |
The unit in which the product is stored. It provides the key to prices, costs, volumes, etc. It cannot be modified. |
Tab Management
Use this section to define core management controls to run on the product and site.
You can associate a group of location types or default locations to a movement type using the * character if you're assigning default locations to the product and site.
To set up labels associated with locations, see the Product categories documentation.
Stock management
Packing
Packing (field PCKFLG) |
Indicates that the product is considered when packing. This information can be defined at the product category level and then modified at the product-site level. |
Stock detail (field PCKSTKFLG) |
Specifies if stock information such as the lot and serial number needs to be displayed on the packaging. |
Serial detail (field PCKSERFLG) |
Indicates that serial numbers are considered when packing. This checkbox is only available if:
|
Packaging (field PCK) |
The packaging code to use when delivering the product. This code is used for automatic packing. |
Packaging capacity (field PCKCAP) |
The number of products, expressed in the sales unit, that the packaging can contain. |
Stock parameters
Storage
Location management (field LOCMGTCOD) |
Container management (field LPNMGTCOD) |
Indicates that locations are managed for the product. 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:
|
Default container (field TCTRDEF) |
The default container to use when creating license plate numbers on the fly during a stock entry for the product-site. This field is subject to the LPN—License plate no. management activity code. It can only be entered if the Container management checkbox is selected. |
Recontrol/Expiration
Recontrol lead time (field SHLLTI) |
The lead time of the new control to be used when receiving stock. This value will be used to calculate the new control date based on the reference date. It’s entered in days or months.
The new control date cannot be extended beyond the limit date of lot use.
|
field SHLLTIUOM |
The time unit in days or months associated with the Recontrol lead time field. |
Recontrol status (field NEWLTISTA) |
The automatic stock status when a lot in stock reaches a new control date. A: The status of the product moves to Q or R when the new control date is reached. Q: The product can be controlled on expiry. The date can be extended or the product can be rejected. R: The product is rejected when it reaches its new control date. |
Recontrol quality record (field LTIQLYCRD) |
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 that can be used to carry out statistical analyses of the quality control results. You can specify this record for a product and a supplier. |
UBD coefficient (field DLU) |
The use-by date (UBD) conversion factor. The conversion factor can only be accessed if the following conditions are met:
This conversion factor is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level. UBD lead time = Shelf life x UBD coefficient.
The value of the conversion factor needs to be between 0.1 and 1. The UBD cannot exceed the expiration date.
This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date. UBD = Lot receipt date + UBD lead time Defining a UBD provides the customer receiving the lot with the guarantee that the use-by date of their goods is after the expiration date. Example:
A UBD conversion factor can be entered in the product record, in the product-site record, and in the customer-product record. The UBD conversion factor entered in the customer-product record is used to determine the use-by date specific to 1 customer. In this case, when allocating stock such as for an order or stock issue, the UBD defined for the customer overrules the one defined for the product-site.
In creation mode, this value is initialized by default with the UBD coefficient entered in the Product record. |
UBD lead time (field DLULTI) |
The use-by lead time, expressed in calendar days. The lead time is calculated based on the UBD coefficient field (DLU). It is not available for entry. |
field DLULTIUOM |
The UBD lead time, expressed in calendar days: UBD lead time = Shelf life x UBD coefficient. This field is not available for entry. |
Grid Default locations
Description (field LOCNUM) |
This table lists the location categories that have been defined for the Product category. You can use it to set up the Location type and Location to link to the product-site by default, for each location category. |
Type (field DEFLOCTYP) |
The Location type to link to the product-site, by default. The Location type can be used with stock movements. The default location type is defined for the Product category. You can enter a code with a generic character (*,#,!,?) or a code from the Location types table. |
Default location (field DEFLOC) |
The Location to link to the product-site, 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. The default location is defined for the Product category. You can enter a code with a generic character (*,#,!,?) or a code from the Locations table. If the location is a dedicated location, an assignment needs to be defined for the product. |
Grid Container capacity
Container (field TCTRNUM) |
The list of containers to use when you create container identifiers on the fly during a stock entry for the product-site. You need to add at least 1 line to authorize creation on the fly. This grid is subject to the LPN—Internal container management activity code. You can only select from "internal" containers if the Container management checkbox is selected. |
Unit (field PCU) |
The unit associated with the container. You can select either the stock unit or the packing unit defined for the product. |
No. of units/container (field TCTRPCUCOE) |
The quantity of possible units for the container. This information is used to control the capacity when you create containers on the fly during a stock entry for the product-site. |
Quality
QC management (field QUAFLG) |
Defines if the product needs to be controlled when receiving it 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. Non-changeable control: Quality control is needed 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 the supplier and the product. The stock status can be modified during entry. |
Frequency (field QUAFRY) |
The control frequency, if quality control is set to Periodic control. |
field QUANUM |
The number of entries carried out after the latest control. This total is reinitialized at each control. When a periodic control is carried out for the product-supplier pair, the total entry number carried out on the product-site record is also reinitialized. |
Technical sheet (field QLYCRD) |
The quality control process for the product can be described using a technical record. Technical records contain text descriptions, but also a set of questions and answers used for statistical analyses of the quality control results. You can specify this record for a product and a supplier. |
Access code (field 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. |
Sampling
Sampling (field SMPTYP) |
Defines the sampling mode. None: Sampling is not planned. Single: A single sample is controlled. The fields in the Sampling block are only available for entry if you select the value Single. |
General level (field GENLEVINS) |
The general control level for the product. The AFNOR (French Standardization Association) standard defines 3 control levels. Level 2 is the recommended AFNOR standard and is the regular level delivered by Sage. This field is only available in inquiry mode. |
AQL (field NQA) |
The Acceptable Quality Level (AQL). When entering a sampling, the Sample section returns the size of the rejection and the approval limit according to the quantity entered and the size of the sample.
The Acceptable Quality Level is the quality index for manufactured products. A quantity of samples from a group of finished products are picked according to the AFNOR NF X06-021 and X06-022 standards. The AQL mathematically guarantees a potential maximum number of defective products, as defined by a determined unit number. The product lots are rejected if the number of defective parts exceeds the norm.
The AQL is calculated according to 2 criteria:
|
Sampling mode (field SMPMOD) |
The sampling target. Global: The grouping is by product. Lot: The grouping is by product and lot. |
Managers
Planner (field PLANNER) |
The operator responsible for production planning or product ordering. |
Buyer (field BUY) |
The operator responsible for reordering the product for the selected site. This code is referenced in the buyer’s plan and supplier order entry. |
EU info
Region/State (field STAFED) |
The Federal state or region where the product was originally manufactured. This field is subject to the DEBR activity code. The possible values contained in the 80—State/Region miscellaneous table are filtered based on the legislation of the site. |
Bill of lading
Freight class (field FRTCLS) |
The default value from the product category. The value is controlled by the legislation and site groupings. You can modify it. It’s used when generating new bill of lading detail lines. |
NMFC (field NMFC) |
The default value from the product category. The value is controlled by the legislation and site groupings. You can modify it. It's used when generating new bill of lading detail lines. This 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. |
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: Use this block to define the firm horizons for requests for the product.
Lead times: Use this block to assign the average manufacturing lead-time or purchasing lead-time for the product and site.
Reordering: Use this block to define reorder and safety levels. These are used in Material Requirements Planning (MRP), the Master Production Schedule (MPS) and in reorder processing.
The lead time for a picked item is not included in the MRP calculations, the MPS calculations, or the statistical reorder suggestion calculations.
Planning
Firm horizon (field PLH) |
The fixed horizon in the lead time unit is used in the Master Production Schedule (MPS) and Material Requirements Planning (MRP) calculations. It can be used to freeze the production plan on a given period. The suggestions used to cover the shortages located within the horizon are transferred to the first period beyond the 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 (*).
|
field PLHUOT |
The planning horizon lead-time unit. This can be weeks, fortnights, or months. |
Demand horizon (field 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. |
field FOHUOT |
The request horizon lead-time unit in weeks, fortnights, or months. |
Trend profile (field 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 (field 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. |
Reordering
Reorder mode (field 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 (field REOPER) |
For a periodic reorder mode, the number of calendar days between 2 reorders. |
Reorder policy (field REOPOL) |
The reorder policy used for the calculation mode of suggestions in the MRP calculations:
|
Coverage (field 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. |
Suggestion type (field 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 (field 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. An intersite reorder suggestion is between 2 sites in a single company. |
Safety stock (field 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 (field 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 (field MAXSTO) |
The maximum stock level. The maximum stock is used in the reorder calculations. |
EOQ (field 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 (field 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:
|
Stock for project (field PJMSTRSTK) |
Indicates if available physical stock of the product needs to be allocated to meet demand for a project. Selecting this checkbox will ignore the Management mode (STDFLG) defined for the product (Available stock or By order) in the Products function (GESITM). |
Lead times
Production (field MFGLTI) |
The number of days corresponding to the production lead-time for a finished or semi-finished product. It's generally fixed for a given lot size and is used to calculate the start date for the MRP suggestions. |
Reduction factor (field MIC) |
The declining conversion factor as a percentage of the reorder lead time is used to calculate the start date of the MRP suggestions. It’s used to correct the reorder lead time in proportion to the replenishment when the planned or suggested quantity is greater than a lot: Corrected lead time = RL * [1 + (qty/lot - 1) * factor / 100], where RL = reorder lead time. This conversion factor is generally used for manufactured products. The supplier lead time is an average lead time that's not usually in proportion with the lot size. |
Quality control (field QUALTI) |
The quality control lead-time, in days. It’s used in the MRP calculations. It’s inserted between the requirement date and the suggestion end date to include the time needed for quality control. |
Multilevel (field TOTLTI) |
The total reorder lead time for the product, in days. It's the cumulative lead time of all BOM levels, including the quality control lead times. This field can be entered. It's only for information purposes. |
Purchase (field OFS) |
The number of days corresponding to the following:
In general, it's fixed for a given lot size and is used to calculate the start date for the MRP suggestions. |
Picking (field PRPLTI) |
The number of working days delay applicable for inventory control purposes. It's the number of days before the product can be used, such as in a manufactured product, a purchase, or before it can be shipped for a sale. This field is not included in MRP processing (FUNMRPG) calculations, MPS processing (FUNMPS) calculations, or the Statistical reordering (FUNSTKB) calculations. |
Parameters
Assignment rule (field 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. |
Availability date not applicable (field EXCFDMA) |
Replanning
Notes
Product notes (field ITMNOTE) |
Select the icon to display a screen where you can:
Notes are limited to a screen inquiry and cannot be printed.
|
Tab Stock
This section displays the stock totals for the product at the site.
Internal situation
External situation
BP stock situation
BP stock (field SCCLNDSTO) |
BP stock allocated (field SCCALL) |
WIP
Tab Totals
This section displays statistical data relating to goods in and goods out movements. Fiscal year and period totals are also provided.
Period
Fiscal year (field FIYNUM) |
Period start (field PERSTR) |
Period end (field PEREND) |
field SELPER |
Displays the history of the product-site totals. |
Period number (field PERNUM) |
Receipts
Last receipt (field LASRCPDAT) |
Date of last entry in stock. |
Monthly qty. received (field MONRCPQTY) |
The total of stock entries that have taken place after the last processing at the end of each month that update the monthly statistics. |
Annual qty. received (field YEARCPQTY) |
Monthly amt. received (field MONRCPAMT) |
The total of stock entries that have taken place after the last processing at the end of each month that update the monthly statistics. |
Annual amt. received (field YEARCPAMT) |
field RCPCUR |
Variance not absorbed (field AMTDEV) |
No. monthly receipts (field MONRCPMVT) |
No. annual receipts (field YEARCPMVT) |
Issues
Tab Calculated data
Use this section to enter additional details to support your stock management policy. You can use this information to make sure that enough stock is available to complete work and sales orders on time. You can enter the data manually or it can be calculated and updated automatically by the Statistical reordering function (FUNSTKB).
Entry data
Safety stock (field 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 (field 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 (field MAXSTO) |
The maximum stock level. The maximum stock is used in the reorder calculations. |
EOQ (field 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:
|
Calculated data
Tab Manufacturing
This section is available if the product is a manufactured product. Use it to define routing and weighing controls.
Routings
Production (field MFGROU) |
The routing is used in work order management. It needs to exist in an alternative authorized for the site, and have the Manufacturing checkbox selected. |
Code (field MFGROUALT) |
The alternative selected needs to be authorized for the site, and have the Manufacturing checkbox selected. This is the alternative used in transactions where there's no default alternative. |
Cost (field CSTROU) |
The standard costs calculation determines the added value by the production, from the range specified here. The range selected needs to exist in the alternative authorized for the site, and have the Manufacturing checkbox selected. |
Code (field CSTROUALT) |
The alternative selected needs to be authorized for the site and have the Cost checkbox selected. It will be used as a default value for the cost calculation. |
RCCP (field RCCROU) |
At the end of the MPS calculation, a global charge calculation can be required from the routing specified here. Rough Cut Capacity Planning is the translation of the French abbreviation "PGC" (for "Planification Globale des Capacités"). The routing selected needs to exist in the alternative authorized for the site and have the RCCP checkbox selected. |
Code (field RCCROUALT) |
The alternative selected needs to be authorized for the site and have the RCCP checkbox selected. This is the alternative used in processings where there's no default alternative. |
Parameters
Weighing
Access code (field WGRACS) |
Access code used to restrict user access to the product for weighing. |
Storage/Handling (field ISM) |
ISM (Instructions for Stock Management) record to use for the product. |
Method of correction (field REDMODFLG) |
Weighing tolerance +(%) (field ITMTOLPOS) |
The percentage used to calculate the weight variance. You can only modify this field if the Setup level is set to BOM. If the Setup level is SHI record or Product-site, this value is based on the product-site record (GESITF). This field is only available when the MWM—Weighing station activity code is active. |
Weighing tolerance -(%) (field ITMTOLNEG) |
The permitted "below weight" tolerance percentage for this component.
|
Tab Cost
Use this section to define costing and pricing information, and the valuation method to use for the stock.
Valuation
Method (field 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. 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.
When set, you’re advised not to change the valuation method. Changing the valuation method can affect the value of work orders currently in progress.
|
Prorata qty. adjust. (field PROPER) |
The percentage of the quantity below which the adjusted amount will be distributed in 2 parts: remaining stock and the stock already issued. This percentage is compared with the physical stock remaining and the global stock quantity produced by a work order. It's used to distribute the adjusted price amounts to the appropriate accounts. If this field is deactivated, the distribution is made without considering this limit. |
field PERCENT |
Grid Overhead
Movement type (field OTRSTYP) |
The Movement type that specifies the overheads that match this entry type. |
Overhead (field 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. (field 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. The lower-level products are products that are not finished products, the semi-finished products and the raw materials. |
Cost calculation
Landed costs
Landed costs-site (field STCNUMITF) |
Select to enter the landed costs for each product-supplier linked to the site. You can also enter the landed costs by site from the Suppliers tab in the Product record or directly from the Landed costs-site function (GESSTCITF). |
Price
Average cost (field AVC) |
The average price. This is calculated according to the formula (value received - value issued) / (quantity received - quantity issued) in a given period, or adjusted dynamically. |
field AVCDET |
Currency (field CUR) |
AUC base quantity (field AVCBASQTY) |
The quantity used for adjusting the average price. |
AUC base amount (field AVCBASAMT) |
The base amount used for adjusting the average price. |
Last receipt cost (field LASRCPPRI) |
The price of the last stock entry. |
field LASDET |
Last purchase price (field LASPURPRI) |
The purchase cost of the line. This field is not available for entry. It’s updated:
The following invoices are not considered:
Example:
|
Standard cost (field ITCSTD) |
The product standard cost. This field is not available for entry. |
field ITCSTDDET |
Validity start date (field ITCSTRDAT) |
The date from which the product is available. This field is not available for entry. |
Validity end date (field ITCENDDAT) |
Revised std. cost (field ITCACT) |
The new standard cost of the product. This field is not available for entry. |
field ITCACTDET |
Validity start date (field ITCSTRDATA) |
The new date from which the product is available. This field is not available for entry. |
Validity end date (field ITCENDDATA) |
Tab Counts
This section displays the stock count information, including the date of the last stock count and statistical data for each stock count.
Counts
Count in progress (field CUNLISNUM) |
The stock count list number. |
Last global stock count (field LASCUNDAT) |
The date of the last stock count. |
Last global list (field LASCUNLIS) |
The stock count list number. |
Stock last count (field CUNSTO) |
The actual stock recorded during the last stock count. |
Receipts since last count (field CUNRCPMVT) |
The quantity according to the stock conversion factor. This quantity represents the positive correction made to the stock after the stock count. |
Issues since last count (field CUNISSMVT) |
The quantity according to the stock conversion factor. This quantity represents the negative correction made to the stock after the stock count. |
Next count (field NEXCUNDAT) |
The next stock count date. |
No. of counts (field CUNNBR) |
For products in a cyclical count, the number of products of each class to be counted in stock is suggested based on the following:
You need to either confirm this number or enter a different value. After the stock count lists are generated, the system updates the number of counts selected. It considers the count number requested for each class and any product filters added. |
No. of accurate counts (field CUNNBREQU) |
Grid Count history
Tab Warehouses
This section displays logistics information.
Allocation flows
Order (field ORDWRH) |
The preferred warehouse by flow type, if the product-site authorizes management of locations. |
Issue flows
Shipment (field SHIWRH) |
The preferred warehouse by flow type, if the product-site authorizes management of locations. |
Tab Suppliers
Use this section to customize the supplier product management rules by site. You can specify a default supplier by site, if the supplier is blocked for the site, or if there's a back-to-back order supplier. These rules are used for the supply planning and for purchase transactions. You need to add these rules to use these functions if the ITMBPSFCY—Supplier-site referencing parameter (ACH chapter, REF group) is set to Mandatory.
Block number 5
Supplier (field BPSNUM) |
The table that declares each supplier for the product-site. You can only add suppliers referenced at the products-supplier level.
Add the associated code or select Select supplier-product from the Actions icon to select the code from the list of referenced products-suppliers. You then add the product-site management details for the supplier. In creation mode, fields inherit the setup defined for the products-supplier. The table provides key supplier information for the product-site at a glance, such as the priority level for each supplier, which is the default supplier and back-to-back order supplier. You can also see which suppliers are blocked or are back-to-back order suppliers. In the supply plans and in purchase entry documents, the ITMBPSFCY—Supplier-site referencing parameter (ACH chapter, REF group) controls references to the product-site for the supplier. |
Priority (field PIO) |
The priority level assigned to the supplier. The closer to zero the value, the greater the priority that's given to the supplier. A zero value represents the highest priority. |
Blocking (field DOUFLG) |
For the supply plans and purchase document entry, defines if the supplier:
|
Back-to-back order (field CTMBPSFLG) |
Indicates if this is a potential supplier for the back-to-back order. |
Default supplier (field DEFBPSFLG) |
Indicates if this supplier is a default supplier for the product at this site. 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 the product.
A supplier that has received a warning can still be a default supplier if it has the highest priority level. |
Default back-to-back (field DEFCTMBPSF) |
Indicates if this supplier is a default back-to-back order supplier for the product at this site. 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 the product.
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. For the transactions:
|
Supplier identification
Supplier (field XBPSNUM) |
The code of the supplier for the product. |
Management
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 following methods:
Only one 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. Only 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 cost structure to erase after 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 for accounting purposes. The Goods received not invoiced (RNI) account will not balance. This is a limitation of the system.
You can add these values directly in the Suppliers section in the Products function (GESITM). You can also add these values by selecting 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 following methods:
Only one 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 add this value or select Selection or Cost structure (access to the Cost structure function) from the Actions icon. Only one method can be selected to calculate the landed costs. If a landed cost coefficient and/or a fixed cost per unit are entered, entering a cost structure triggers the reinitialization of these elements after a warning message. You can also add the product-site-supplier landed costs in a dedicated window which can be accessed from the Products function (GESITM). Select the icon available from the Suppliers section. This window can also be opened from the Landed costs-site function (GESSTCITF). |
field CUR3 |
No help linked to this field. |
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 following methods:
Only one 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. Only one method can be selected to calculate the landed costs. If a landed cost coefficient and/or a fixed cost per unit are entered, entering a cost structure triggers the reinitialization of these elements after a warning message. You can also add the product-site-supplier landed costs in a dedicated window which can be accessed from the Products function (GESITM). Select the icon available from the Suppliers section. This window can also be opened from the Landed costs-site function (GESSTCITF). |
Tab Attributes
This section is populated by default from attributes defined on the product record. You use this section to classify the product-site combination by assigning a list of common identifiable characteristics defined specifically for your manufacturing processes. Both the attribute characteristics and the attribute values you assign are customized attribute classifications that are specific to your organization. You use these characteristics in a product-attribute matrix which supplies data to your web scheduling solution to optimize production times. For example, if the product is a bicycle frame that's sprayed a color as part of the manufacturing process of assembling a bicycle, you use this section to classify the product. You assign an attribute that applies to color or paint. You assign as an attribute value the specific color that applies to the product-site combination.
Grid
Attribute (field ATTCOD) |
Identifies a standard classification or characteristic of the product-site combination that can be referenced by your web scheduling processes. For example, if the product is painted during your manufacturing process, an attribute classification might be PAINT or COLOR. |
Attribute description (field ATTDESAXX) |
Identifies the standard characteristic that you’ve assigned to the product-site combination as an attribute. |
Attribute value (field ATTVALCOD) |
Identifies an individual characteristic of the attribute classification that applies to the product-site combination. 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 the product for this site, such as BLACK or RED. |
Attribute value description (field ATTVALDESA) |
Identifies the individual characteristic of this attribute classification that you’ve assigned to the product for this site. |
Reports
By default, the following reports are associated with this function:
ITMFORM: Product information by site
This can be changed using a different setup.
Specific actions
Product-warehouse |
Select the Products-warehouse action to view the associated product-warehouse record. |
Actions menu
Select the WIP action to view orders in process for the product or a range of products, for the site or for all sites. |
Select the Quote line action to view quotes for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific quotes. |
Select the Order line action to view sales orders for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific orders. |
Select the Delivery line action to view deliveries for the product from the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific delivery numbers. |
Select the Invoice line action to view sales invoices for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific invoices. |
Select the Return line action to view customer returns for the product to the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific returns. |
Select the Demand line action to view purchase requests for the product for the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific requests. |
Select the Order line action to view purchase orders for the product for the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific orders. |
Select the Receipt line action to view purchase receipts for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific receipts. |
Select the Return line action to view supplier returns for the product from the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific returns. |
Select the Invoice line action to view purchase invoices for the product for the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific invoices. |
Select the Subcon. consumption action to view subcontract orders for the product for the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific subcontract orders. |
Select the Production reporting action to view production details for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific tracking numbers or work orders. |
Select the Material consumption action to track material consumed for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific tracking numbers. |
Select the Cost price action to view production costs for the product at the site. |
Select the Production cost history action to view production cost prices for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific dates. |
Select the List of WOs action to view work order information, component information, and operation details for the product at the site. Filters can be applied within the inquiry function to provide simple and fast access to a range of, or to specific work orders. |
Select the Stock by site action to view the stock levels for the product at the site. |
Select the Projected stock action to view the projected stock movements for the product at the site. |
Select the Available stock action to project the available and available to promise stock for the product at this site in periods of days, weeks, or months. |
Select the Stock by date action to view the stock situation for the product at the site on a specific date. |
Select the Movements action to view the history of stock movements performed for the product at the site. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry:
Non warehouse siteThe site you added is not a warehouse. It cannot be used to create product-site records.
Non valid route for this usage at this siteThe route alternative selected is not authorized for the site or for the associated processing (Production, Cost, MRP, RCCP).
The reorder policy that require a maximum stockThis message is displayed when the maximum stock is left at 0 and the reorder policy requires a "maximum stock addition".
The reorder threshold needs to be >= safety stockor
The maximum stock needs to be >= the reorder threshold
or
The maximum stock needs to be >= the safety stock
Verify the coherence of these fields.
One routing version existsThe routing version defined already exists for the product. Each major version and, if applicable, major plus minor version needs to be unique.
A link exists for site [site code] with routing [routing code]This message is displayed if the routing already exists at the displayed site.
The routing is used by the product-site [product-site code]This message is displayed if the routing already exists for the displayed product-site record.
Different routing version management between [product code] and [routing code]The format of the routing version defined is incorrect. Refer to the product record.
Tables used
Refer to documentation Implementation