Products-sites
Prerequisites
Refer to documentation Implementation
Screen management
The Products-sites function contains a home 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 link for this function. Use this section to define core management controls to run on the product and site, for example 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 this 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. The home information is displayed irrespective of the section being selected.
Category (field TCLCOD) |
The product categories are used to classify and filter the products according to their use. This step makes it possible to refine the selection prior to carrying out the adjustment process. This code is used in the Product record to enable selections. |
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
Upon receipt of the product, an order or a delivery can be selected. Use the status to change product availability. The titles in the local menu can be set up and managed as follows:
Non blocking and blocking messages according to the context and status:
|
Product (field ITMREF) |
Product reference |
Stock site (field STOFCY) |
Enter or select the storage site where the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
Stock unit (field STU) |
This field indicates the product management unit in which are expressed:
This information is always displayed, regardless of the transaction used. It cannot be modified. |
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 assigning default locations to the product and site.
To set up labels associated with locations see the Product categories documentation.
Stock management
Stock management (field STOMGTCOD) |
Use this field to define how stock of this product is managed:
|
Packing
Packing (field PCKFLG) |
Select this check box to indicate that this product is taken into account in the packing. |
Stock detail (field PCKSTKFLG) |
This field is used to specify whether the stock must be displayed in the parcels (Lot, Serial number, Status, etc.) |
Serial detail (field PCKSERFLG) |
Select this check box so serial numbers are taken into account in the packing. This check box can only be accessed if:
|
Packaging (field PCK) |
Code on 3 alphanumerical characters. Enter the packaging in which the product is to be delivered. |
Packaging capacity (field PCKCAP) |
It is the number of products, expressed in sales unit, that the packaging can contain. |
Stock parameters
ABC class (field ABCCLS) |
The ABC category allows the classification of products with regard to their importance to the turnover or to the stock for example. |
Count mode (field CUNCOD) |
Use this field to specify the frequency of counts for products in this category:
|
Stock withdrawal mode (field STOCOD) |
The stock issue mode can be defined at category level, then refined by site category.
Two parameters from the material tracking transaction are associated with the issue mode: upon material tracking, it is possible to filter the materials to be proposed for consumption in the transaction (« post consumption / immediate / all stock issue » in the materials tab in the tacking transaction). These parameters are:
|
Product type (field INVPRODTYP) |
Storage
Location management (field LOCMGTCOD) |
Container management (field LPNMGTCOD) |
This field is subject to the LPN - License plate no. management activity code. This information is defined by default at product category level. It can be modified.
|
Default container (field TCTRDEF) |
This field is subject to the LPN - License plate no. management activity code. This field can only be entered if the Container management check box is selected. Enter the default containers that you want to use when you create license plate numbers on the fly during a stock entry for this product-site. This default container must belong to the list of containers defined in the Container table. |
Recontrol/Expiration
Recontrol lead time (field SHLLTI) |
Type in the lead time of the new control to be used upon stock receipt. This value will be used to calculate the new control date based on the reference date. It is entered in days or months.
|
field SHLLTIUOM |
Scroll-down list used to determine the time unit (day or month) associated with the previous field. |
Recontrol status (field NEWLTISTA) |
When a lot in stock reaches a new control date, a process is used to automatically change its status:
|
Recontrol quality record (field LTIQLYCRD) |
The quality control process for the product can be described via a technical record, to be chosen from the technical record table. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. |
UBD coefficient (field DLU) |
The use-by date (UBD) conversion factor can only be accessed when the following conditions are met:
This conversion factor is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level. UBD lead time = Shelf life x UBD coefficient. The value of the conversion factor must be between 0.1 and 1. The UBD cannot exceed the expiration date. This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date. UBD = Lot receipt date + UBD lead time Defining a UBD provides the customer receiving the lot with the guarantee that the use-by date of their goods is more or less distant from the expiration date. Example:
In creation mode, this value is initialized by default with the UBD coefficient entered in the Product record. |
UBD lead time (field DLULTI) |
This field cannot be entered. It displays the use-by lead time calculated based on the UBD coefficient. |
field DLULTIUOM |
This field cannot be entered. The UBD lead time is always expressed in calendar days. |
Grid Default locations
Description (field LOCNUM) |
This table lists all the location categories which have been defined for the Product category. |
Type (field DEFLOCTYP) |
For each location category, you can specify the Location type that will be linked to the product-site by default. When a Location type is entered, it can be used in stock movements. |
Default location (field DEFLOC) |
For each location type, you can specify the Location that will be linked to the product-site by default. When a location is entered, it can be used in stock movements. However, the LOCSUG - Suggested locations parameter (STO chapter, MIS group) must be set to Based on product setup. The location suggested by default is the location entered at the Product category level. You can modify it. You can enter a code with a generic character (*,#,!,?) or a code from the Locations table. If the location is of a dedicated type, an assignment must be established for this product. |
Grid Container capacity
Container (field TCTRNUM) |
This grid is subject to the LPN - Internal container management activity code. It can only be accessed if the Container management check box is selected. |
Unit (field PCU) |
Select 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) |
Enter the quantity of possible units for this container. |
Quality
QC management (field QUAFLG) |
This code is used to define whether this product must be controlled on receipt into stock.
|
Frequency (field QUAFRY) |
If the quality control is periodic, then this field is used to enter the frequency of the controls. |
field QUANUM |
Number of entries carried out since the latest control. |
Technical sheet (field QLYCRD) |
The quality control process for the product can be described via a technical record, to be chosen from the technical record table. These records contain text descriptions, but also a set of questions and answers used to carry out statistical analyses concerning the quality control results. |
Access code (field QUAACS) |
Use this field to allow or prohibit access to this product by a quality control operator. The user can only modify the status of a product and execute quality control if the access code defined on their user profile permits modification. |
Sampling
Sampling (field SMPTYP) |
Use this field to define the sampling mode:
The fields in the Sampling block are not available for entry if you select the value None |
General level (field GENLEVINS) |
This field indicates the general control level of products. The AFNOR standard defines three control levels. Level 2 : recommended by the AFNOR standard, is the regular level delivered by Sage. This field is only available in inquiry mode. |
AQL (field NQA) |
Reminder: The Acceptable Quality Level is the quality index of the manufactured products. It requires to pick a certain quantity of samples on a group of finished products, according to the AFNOR NF X06-021 and X06-022 standards. The AQL mathematically guarantees a potential maximum number of defective products defined by a determined units number. The lots of products are rejected if the number of defective parts exceeds the norm. The AQL is calculated according to two criteria:
To determine the AQL, please see the documentation including the calculation tables. Select the AQL. When entering the sampling, the section "Sample" brings back the size of the rejection and the approval limit according to the quantity entered and the size of the sample. |
Sampling mode (field SMPMOD) |
Use this field to define the sampling target:
|
Managers
Planner (field PLANNER) |
Operator in charge of performing the production planning or product ordering. |
Buyer (field BUY) |
Enter or select the code of the operator responsible for reordering the product on the selected site. This code is referenced in several scripts, such as the buyer’s plan, the supplier order entry, etc. |
EU info
Region/State (field STAFED) |
This field is subject to the DEBR activity code. |
Bill of lading
Freight class (field FRTCLS) |
This field displays the default value of the product category but it can be modified. The value is controlled by the legislation and site groupings, and it is used when generating new bill of lading detail lines. |
NMFC (field NMFC) |
This field displays the default value from the product category when creating new records but it can be overwritten. The value entered in this field is used when generating new bill of lading detail lines. This field is available only 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, and 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 this product, taking the seasonality into account, if necessary.
- Lead times: Use this block to assign the average manufacturing lead-time or purchasing lead-time for this 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.
Planning
Firm horizon (field PLH) |
The fixed horizon (in leadtime 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 (*). |
field PLHUOT |
Planning horizon lead-time unit (weeks, fortnights or months). |
Demand horizon (field FOH) |
The request horizon, expressed in number of days, is used to calculate the projected stock: the available stock is calculated using the customer order book below this horizon, and the forecasts above this horizon. |
field FOHUOT |
Request horizon lead-time unit (weeks, fortnights or months). |
Trend profile (field SESCOD) |
Seasonality - This is 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 taken into account in the material requirements planning and in the work order management. it is used to calculate the quantity to be reordered to obtain the quantity to cover the requirement. |
Reordering
Reorder mode (field REOMGTCOD) |
Use this field to define the reordering mode:
|
Reorder frequency (field REOPER) |
For a periodic reorder mode, indicate here the number of calendar days between two reorders. |
Reorder policy (field REOPOL) |
The reorder policy is used to set up the calculation mode of suggestions in the MRP processing:
|
Coverage (field DAYCOV) |
The coverage, expressed in weeks, is one of the MRP parameters. It makes it possible to 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) |
This suggestion type is used when running material requirements planning. It is used to define if the product has to be subject to:
If the suggestion is of type Intersite, the reorder site must be specified in the Reorder site field (REFCY). |
Reorder site (field REOFCY) |
When the suggestion is of the type inter-site, this field serves to indicate the supplier site from which the replenishment must be carried out. The inter-site suggestion is coupled with a requirement at the replenishment site. The inter-site reorder is a flow between two sites in a single company. |
Safety stock (field SAFSTO) |
The security stock is used in the material requirements planning. It features an additional stock implemented to be able to face a longer deadline to obtain stock or a request higher than the average request. |
Reorder threshold (field REOTSD) |
The reorder treshold is used in the stock management on order. This is the stock level from which a reordering (or work order) is triggered. It is generally equal to the consumption sum during the reorder time, to which the security stock is added. |
Maximum stock (field MAXSTO) |
The maximum stock is taken into account in the reorder calculations. |
EOQ (field REOMINQTY) |
Minimum reorder quantity
|
Technical lot (field MFGLOTQTY) |
Lot size
|
Stock for project (field PJMSTRSTK) |
Select this check box if available physical stock of this product must be allocated to meet demand for a project. Selecting this check box will ignore the Management mode (STDFLG) defined for this product (Available stock or By order) in the Products |
Lead times
Production (field MFGLTI) |
Number of days corresponding to the production lead-time for a finished or semi-finished product. It is in general 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 (in percentage) of the reorder lead time is used to calculate the start date of the suggestions in MRP. It is used correct the reorder lead time proportionally 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, rarely in proportion with the lot size. |
Quality control (field QUALTI) |
The quality control lead-time (in number of days) is used in MRP: It is inserted between the requirement date and the suggestion end date to take into account the time necessary to carry out the quality control. |
Multilevel (field TOTLTI) |
Total reorder lead time for the product, expressed in a number of days: it is the cumulated lead time of all BOM levels (taking into account the quality control lead times). |
Purchase (field OFS) |
Number of days corresponding to:
It is in general fixed for a given lot size, and is used to calculate the start date for the MRP suggestions. |
Picking (field PRPLTI) |
Number of working days delay applicable for inventory control purposes. That is, the number of days before this 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 is used to create a link between a requirement (sales order, material requirement, etc.) and a resource (work order, purchase order, etc.). If no rule is specified in this field, the rule specified in the DEFPTO - Assignment rule MTO parameter (STO chapter, SCH group) will be the one taken into account by default in the Automatic assignment, Automatic deassignment and WIP resynchronization functions. |
Availability date not applicable (field EXCFDMA) |
Replanning
Protection in process (replan) (field WIPPRO) |
Select this check box to deactivate the replanning of orders in process for the product concerned.
|
Notes
Product notes (field ITMNOTE) |
Click this icon to display a screen where you can:
Notes are limited to a screen inquiry and cannot be printed. |
Tab Stock
This section displays the stock totals for the product at the site.
Internal situation
Internal 'A' (field PHYSTO) |
The physical stock field is formatted according to the stock unit. It represents the total of the lots whose status has been set to A (approved). |
Detail alloc. 'A' (field PHYALL) |
Internal 'Q' (field CTLSTO) |
The stock in quality control is formatted according to the stock unit. It represents the total of the lots whose status has been set to Q (currently in quality control). |
Detail alloc. 'Q' (field CTLALL) |
Internal 'R' (field REJSTO) |
The rejected stock is formatted according to the stock unit. It represents the total of the lots whose status has been set to R (rejected upon quality control). |
Detail alloc. 'R' (field REJALL) |
Detail shortage (field DETSHT) |
Global shortage (field GLOSHT) |
Global allocated (field GLOALL) |
Dock 'A' (field PLFPHYSTO) |
Dock 'Q' (field PLFCTLSTO) |
Dock 'R' (field PLFREJSTO) |
External situation
Subcon. 'A' (field SCOPHYSTO) |
Alloc. subcon. 'A' (field SCOPHYALL) |
Subcon. 'Q' (field SCOCTLSTO) |
Alloc. subcon. 'Q' (field SCOCTLALL) |
Subcon. 'R' (field SCOREJSTO) |
Alloc. subcon. 'R' (field SCOREJALL) |
Loan 'A' (field BPRPHYSTO) |
Loan 'Q' (field BPRCTLSTO) |
Loan 'R' (field BPRREJSTO) |
In-transit stock (field TRFSTO) |
In-transit stock corresponds to the stock total which has not yet been received on the current site from an intersite transfer. |
Transferred stock (field TRASTO) |
Transferred stock corresponds to the stock total sent from the current site to a different site which has not yet been received on the ship-to site. |
Stock on external sites (field EXTSTODET) |
BP stock situation
BP stock (field SCCLNDSTO) |
BP stock allocated (field SCCALL) |
WIP
On reorder (field ORDSTO) |
It is the replenishing stock count. |
Pending issues (field WAISTO) |
Select this check box if the planning calculations should decrease quantities related to suspended transactions from the available stock quantity. |
On sales orders (field SALSTO) |
The stock in customer order corresponds to the customer order total quantity and the inter-site demands for the product, not yet delivered. |
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 |
Button used to access in display mode 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) |
This quantity represents the total of stock entries that have taken place since the last processing at the end of each month that updates the monthly statistics. |
Annual qty. received (field YEARCPQTY) |
Monthly amt. received (field MONRCPAMT) |
This amount represents the total of stock entries that have taken place since the last processing at the end of each month that updates 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
Last issue (field LASISSDAT) |
Date of last issue entered in stock. |
Monthly qty. issued (field MONISSQTY) |
This quantity represents the total of stock issues that have taken place since the last processing at the end of each month that updates the monthly statistics. |
Annual qty. issued (field YEAISSQTY) |
Monthly amt. issued (field MONISSAMT) |
This amount represents the total of stock issues that have taken place since the last processing at the end of each month that updates the monthly statistics. |
Annual amt. issued (field YEAISSAMT) |
No. monthly issues (field MONISSMVT) |
No. annual issues (field YEAISSMVT) |
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 is used in the material requirements planning. It features an additional stock implemented to be able to face a longer deadline to obtain stock or a request higher than the average request. |
Reorder threshold (field REOTSD) |
The reorder treshold is used in the stock management on order. This is the stock level from which a reordering (or work order) is triggered. It is generally equal to the consumption sum during the reorder time, to which the security stock is added. |
Maximum stock (field MAXSTO) |
The maximum stock is taken into account in the reorder calculations. |
EOQ (field REOMINQTY) |
Minimum reorder quantity
|
Calculated data
Safety stock (field SAFSTOCLC) |
Checked if a safety stock recalculation previously carried out must be used as the basis of the reorder calculation. Formula: Security stock = K * sigma * lead time Where:
|
Reorder threshold (field REOTSDCLC) |
Checked if a preliminary recalculation of the replenishment threshold must be used at the calculation basis. Formula: Replenishment threshold = Average consumption during the reorder lead-time + security stock (according to parameters). The calculation is only carried out if there is a minimum history available. The number of months in the history used has a ceiling with a maximum number or months defined (the most recent months). |
Maximum stock (field MAXSTOCLC) |
Checked in the event where a safety stock recalculation previously carried out must be used as the basis of the reorder calculation. Formula: Average consumption / day * (reorder lead time + reorder time) The calculation is only carried out if there is a minimum history available. The number of months in the history used has a ceiling with a maximum number or months defined (the most recent months). |
EOQ (field REOMINCLC) |
Checked if a preliminary recalculation of the replenishment economic quantity must be used at the calculation basis. Formula (WILSON): Q = root of (24 * R * Oc) / (Sc * Pc) Where:
The calculation is only carried out if there is a minimum history available. The number of months in the history used has a ceiling with a maximum number or months defined (the most recent months). |
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) |
This routing is used in work order management. |
Code (field MFGROUALT) |
The alternative selected must be authorized for the site, and have the Manufacturing check box selected. This is the alternative used in transactions where there is 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 must exist in the alternative authorized for the site, with a checked "manufacturing" indicator. |
Code (field CSTROUALT) |
The alternative selected must be authorized for the site and have the Cost check box 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 must exist in the alternative authorized for the site, with a checked "RCCP" indicator. |
Code (field RCCROUALT) |
The alternative selected must be authorized for the site and have the RCCP check box selected. This is the alternative used in processings where there is no default alternative. |
Parameters
Release if shortage (field MFGSHTCOD) |
Select this check box to block this product with respect to the printing of the manufacturing folders and production tracking if there is a shortage of physical stock. |
Automatic closing % (field CLEPCTAUT) |
This percentage defines the threshold being applied to automatically close the materials during production tracking. For instance, if the value is 95% and the material requirement is 200 UN, the system will suggest to close the material if the consumed quantity is greater than or equal to 190 UN. |
Shrink with release (field RELSCATIA) |
This parameter is used to manage two loss management modes upon production release. |
Component sequence control (field COMSEQCON) |
Weighing
Access code (field WGRACS) |
Access code used to restrict access to data for certain users. If the field is entered, only the users that have this access code in their profile can use this product in weighing... |
Storage/Handling (field ISM) |
ISM record that will be used for this product. |
Method of correction (field REDMODFLG) |
Weighing tolerance +(%) (field ITMTOLPOS) |
This field displays 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-sites record (GESITF).
|
Weighing tolerance -(%) (field ITMTOLNEG) |
Use this field to define the permitted "below weight" tolerance percentage for this component. You can only modify this field if the Setup level (field LEVSET) field is set to BOM. If the Setup level is SHI record or Product-site this value will be based on the product-site record. Activity code MWM-Weighing station must be activated to use the Weighing |
Tab Cost
Use this section to define costing and pricing information, and the valuation method to use for the stock.
Valuation
Method (field VLTCOD) |
Use this field to define the valuation method to be applied to stock transactions, or movements. This field is mandatory. Its value is initialized using the valuation method specified at product category level. A history of the last three changes to the valuation method is kept in the Products-sites table (ITMFACILIT), with the date and time of each change. Once set, you are advised not to change the valuation method. Changing the valuation method can affect the value of work orders currently in progress. For more information on stock valuation, see the related documentation: Basic principles for the valuation of the stocks. |
Prorata qty. adjust. (field PROPER) |
The percentage of the quantity below which the adjusted amount will be distributed in two parts: remaining stock and the stock already issued. This percentage is compared with respect to the physical stock remaining and the global stock quantity produced by a WO. This is used to distribute the adjusted price amounts to the appropriate accounts. If this field is de-activated, the distribution is made without taking into account this limit. |
field PERCENT |
Grid Overhead
Movement type (field OTRSTYP) |
Select the Movement type to specify the overheads matching this entry type. |
Overhead (field OVECOD) |
Select an 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) |
This field is used to select the calculation type.
The lower-level products are products that are not finished products, in other words, the semi-finished products and the raw materials. |
Cost calculation
Standard cost update (field STDCSTUPD) |
Use this field to enter the cost update indicator (for each type):
|
Revised std. cost update (field CUTCSTUPD) |
Budgeted std. cost update (field BUDCSTUPD) |
Simulated cost update (field SIMCSTUPD) |
Landed costs
Landed costs-site (field STCNUMITF) |
This button opens a window used to enter the landed costs for each product-supplier linked to the site. |
Price
Average cost (field AVC) |
Moving average price. This is calculated according to the formula (value received - value issued) / (quantity received - quantity issued) in a given period, or in dynamic fashion. |
field AVCDET |
Currency (field CUR) |
AUC base quantity (field AVCBASQTY) |
Quantity serving for the calculation of the moving average price. |
AUC base amount (field AVCBASAMT) |
Base amount serving for the calculation of the moving average price. |
Last receipt cost (field LASRCPPRI) |
Price of last entry in stock. |
field LASDET |
Last purchase price (field LASPURPRI) |
This field is available for display but not for modification.
The following invoices are not taken into account:
Example:
|
Standard cost (field ITCSTD) |
This field can only be displayed and it cannot be modified. |
field ITCSTDDET |
Validity start date (field ITCSTRDAT) |
This field can only be displayed and it cannot be modified. |
Validity end date (field ITCENDDAT) |
Revised std. cost (field ITCACT) |
This field can only be displayed and it cannot be modified. |
field ITCACTDET |
Validity start date (field ITCSTRDATA) |
This field can only be displayed and it cannot be modified. |
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) |
Stock count list number. |
Last global stock count (field LASCUNDAT) |
This field displays the date of the last stock count. |
Last global list (field LASCUNLIS) |
Stock count list number. |
Stock last count (field CUNSTO) |
Last stock - This quantity represents the actual stock recorded during the last stock count. |
Receipts since last count (field CUNRCPMVT) |
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) |
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) |
This field indicates the next stock count date. |
No. of counts (field CUNNBR) |
For products in cycling count, a number of counts (number of products of each class to be counted in stock) is suggested based on:
It is necessary to either confirm this number or enter another value. |
No. of accurate counts (field CUNNBREQU) |
Grid Count history
Count date (field CUNDAT) |
Net accuracy (field NETACC) |
Absolute accuracy (field ABSACC) |
Expected count quantities (field CUNQTYCLC) |
Actual count quantities (field CUNQTYNEW) |
Count variance (field CUNQTYDEV) |
Tab Warehouses
This section displays logistics information.
Allocation flows
Order (field ORDWRH) |
When the product-site authorizes the management of locations, you can enter a preferred warehouse by type of flow. |
Issue flows
Shipment (field SHIWRH) |
When the product-site authorizes the management of locations, you can enter a preferred warehouse by type of flow. |
Tab Suppliers
Use this section to customize the supplier product management rules by site. You can specify a default supplier by site, also if the supplier is blocked for the site, if it is a back-to-back order supplier, etc. These rules are used for the supply planning as well as for purchase transactions. To use these functions, defining these rules is mandatory if the ITMBPSFCY - Supplier-site referencing parameter (ACH chapter, REF group) is set to Mandatory.
The supplier must have been previously defined at the supplier-products level.
Block number 5
Tab Attributes
This section is populated by default from attributes defined on the product record. You use this section to classify this product - site combination by assigning a list of common identifiable characteristics defined specifically for your manufacturing processes. For example, if this product is a bicycle frame that is sprayed a color as part of the manufacturing process of assembling a bicycle, you use this section to classify this product by assigning an attribute that applies to color or paint, and the specific color that applies to this product - site combination you assign as an attribute value. 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.
Attributes are only used with your web scheduling solution. They are not used with work orders or Production Scheduler. Finite scheduler is a generic interface that provides an integration connector, developed by Sage, to connect to Sage X3 Web Scheduling
Grid
Attribute (field ATTCOD) |
Use this field to identify a standard classification, or characteristic of this product - site combination that can be referenced by your web scheduling processes. For example, if this product is painted during your manufacturing process, an attribute classification might be "PAINT" or "COLOR". |
Attribute description (field ATTDESAXX) |
This field identifies the standard characteristic that you have assigned to this product - site combination as an attribute. |
Attribute value (field ATTVALCOD) |
Use this field to identify an individual characteristic of the attribute classification that applies to this 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 this product for this site, such as "BLACK" or "RED". |
Attribute value description (field ATTVALDESA) |
This field identifies the individual characteristic of this attribute classification that you have assigned to this product 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 |
Click the Products-warehouse action to view the associated product-warehouse record. |
Barre de menus
Click the WIP action to view orders in process for the product or a range of products, for the site or all sites. |
Click 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 specific, quotes. |
Click 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 specific, orders.
|
Click 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 specific, delivery numbers. |
Click 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 specific, invoices. |
Click 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 specific, returns. |
Click 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 specific, requests. |
Click 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 specific, orders. |
Click 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 specific, receipts. |
Click 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 specific, returns. |
Click 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 specific, invoices. |
Click 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 specific, subcontract orders. |
Click 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 specific, tracking numbers or work orders. |
Click 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 specific, tracking numbers. |
Click the Cost price action to view production costs for the product at the site. |
Click 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 specific, dates. |
Click 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 specific, work orders. |
Click the Stock by site action to view the stock levels for the product at the site. |
Click the Projected stock action to view the projected stock movements for the product at the site. |
Click the Available stock action to project the available and available to promise stock for this product at this site in periods of days, weeks or months. |
Click the Stock by date action to view the stock situation for the product at the site on a specific date. |
Click 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 entered (in creation) 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 must be >= safety stockor
The maximum stock must be >= the reorder threshold
or
The maximum stock must be >= the safety stock
Verify the coherence of these fields.
One routing version existsThe routing version defined already exists for this product. Each major version and, if applicable, major plus minor version must be unique.
A link exists for site [site code] with routing [routing code]This message will be displayed if the routing already exists at the displayed site.
The routing is used by the product-site [product-site code]This message will be 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. Please refer to the product record.