The where-used function of components is used to list all the parent products of a component from the BOM file, with the quantity used for the latter.

The lists of where-used can be obtained simultaneously for several BOMs and displayed on the screen or printed.

The where-used cases are the following:

  • first level where_used case: lists of products that use the selected component directly,
  • multi-level where-used cases: lists of products that use the selected component directly or indirectly. If a component is itself a component, the parent products using this component will be listed and so on until the last level.
  • last level where_used case: list of parent products of lowest level (without displaying intermediary levels) that use the selected component.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

The user can use the first screen to specify selection criteria.

The second screen displays, for a specific code, the list of products that use the selected component.

When there are multiple codes, the Next and Previous buttons display the pages of the other codes.
A contextual button on the BOM code can be used to select the requested code directly.

Inquiry screens of the first-level and multi-level where-used

  • They are similar.
  • They display the details of the BOM links

Inquiry screen of the last-level where-used

Only the quantities are displayed. They are submitted to a level calculation: the BOM quantities are progressively multiplied by taking into account the shrinkage percentage (gross quantity) or not (net quantity)

Header

Block number 1

Component (field CPNSEL)

The processing is used to search how to use a component.
Major version (field ECCVALMAJ)
Minor version (field ECCVALMIN)

Block number 2

BOM code type from (field ALTTYPDEB)
BOM code type to (field ALTTYPFIN)
BOM code from (field ALTDEB)

The code specifies the BOM in which the search for components is done.

SEEINFO BOMs without inquiry authorization rights for the user are not taken into account in the process. This inquiry authorization is indicated via access codes defines in the BOM profile and table.
BOM code to (field ALTFIN)
Reference date (field DATREF)

The reference date is used to select the products according to their validity start date and end date.
The entry of a date dated 00/00/00 is used to select all the products irrespective of their validity date.

SEEINFO The reference date cannot be equal to zero or be earlier than the current date.
Selection formula (field FORMULE)

Processing

Processing mode (field TRT)

This flag is used to select the elements to process.

SEEINFO The user can choose to print only the first level links, the last level links, or the multi-level BOM.

Issues

Screen (field SCRFLG)

The result of the process will be displayed on the screen if this indicator is set.
Report (field PRNFLG)

It is possible to view these where-used cases on the screen, on a print or both.
If both options are retained, the screen view is suggested first.

Tab Production Links

Block number 1

BOM code (field ALTAFF)

This is the BOM code for which the where-used are displayed.
It is possible to choose a code among the existing ones when all codes have been selected. The screen will display the where-used that are associated with it.

Grid

Sequence (field BOMSEQ)

This field identifies the sequence number of this component in this BOM (bill of materials). It identifies a component where multiple components with the same product code are defined as variants or options.

The BOMSTE - Component sequence increment parameter (TC chapter, BOM group) defines the first sequence number and the increment applied to subsequent component sequence numbers.
Lev. (field NIV)

Number of BOM levels above the component.
Parent product (field ITMREF)

This field indicates the product reference code. It is generated by a sequence number counter (set up in function Sequence number counters) in the case when the product category has a sequence number counter code.

The reference cannot be modified. It is automaticaly assigned and displayed at product creation end.
UOM (field BOMUOM)

This field displays the unit of measure (volume or mass).
UOM-STK factor (field BOMSTUCOE)

This field indicates the UOM-S conversion coefficient used to calculate the quantity in US, from a quantity entered in UOM: Qty in US = Qty in UOM * coeff.
This coefficient is initialized from the conversion factor table if the combination exists.
UOM link quantity (field BOMQTY)

The link quantity specifies the number of components required for the basic quantity of the parent product.
It is entered in a variable format (fluctuating number of decimals).
For a management unit of Percentage, the sum of the link quantities must be equal to 100.

The corresponding value is initialized from the one defined at BOM level.

STK link quantity (field LIKQTY)

The link quantity specifies the number of components required for the basic quantity of the parent product.
It is entered in a variable format (fluctuating number of decimals).
For a management unit of Percentage, the sum of the link quantities must be equal to 100.
STK (field STU2)
Component type (field CPNTYP)

Use this field to define what type of component this is. You can set it to one of the following values:

  • Normal. A component of this bill of materials.
  • By-product. An unplanned by-product or secondary product.
  • Text. Free-format text to be displayed on a work order.
  • Costing. When a value must be calculated for the provisional cost and the production cost price of the parent product.
Link quantity code (field LIKQTYCOD)

The code of the link quantity can be:

  • Proportional: the quantity is multiplied by the required quantity for the parent product used in the processing,
  • Fixed: the quantity is fixed regardless of the quantity required for the parent product.
Qty rounding (field QTYRND)

The quantity of BOM links is entered with a maximum accuracy, which is not always useful for the stock management.
This code is used to manage the quantity rounding mode, based on the stock unit decimal, in the processes using the BOM.
The rounding can be to the nearest, highest or lowest.
Link description (field BOMSHO)

This field displays the short description of the bill of material (BOM).
% scrap (field SCA)

The loss percentage is used to increase the link quantity in order to take into account the loss due to the production process.
In the various inquiries, two quantities can be displayed:

  • Net quantity: calculation of the quantity necessary to produce a parent product, without taking the loss into account.
  • Gross quantity: calculation of the quantity necessary to produce a parent product, when taking the loss into account.
Valid from (field BOMSTRDAT)

The validity start date is the date from which the link is valid.
It is initialized by default with the validity start date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
Valid to (field BOMENDDAT)

The validity end date is the date beyond which the link is no longer valid.
It is initialized by default with the validity end date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
From lot (field BOMSTRLOT)

For components that are managed by lot, this is the first lot for which this link is valid.
To lot (field BOMENDLOT)

For components that are managed by lot, this is the last lot for which this link is valid.
Routing oper (field CPNOPE)

If you do not need this component to be readily available at the start of the production process, use this field to define the specific operation or stage in the manufacturing process at which this component must be available to it. Holding back availability of this component until it is needed can be particularly beneficial in some circumstances. For example, for cost savings if this component is an expensive purchased product or storage costs are expensive, for saving on warehouse floor space if it has a large volume or for catering for specific characteristics such as a cooling period. 

This becomes the default operation number and can be changed for an order if necessary.

 
Ope LT (field BOMOFS)

The operation lead-time is used at the release and in the MRP calculation, in order to offset the component requirement with respect to the production start date of the parent product. This lead-time is expressed in business days.
Mt. slip print. (field PICPRN)

Use this field to specify if this component must be printed on work order material issue slips.
Pick list code (field PKC)

Use this field to inform warehouse staff of any actions that apply when this component is picked for issue. You can select one of the following values:

  • Component not weighed on weighing stations – the field Setup level (field LEVSET) and the Weighing tolerance +/- (%) fields (fields ITMTOLPOS/ITMTOLNEG) are disabled.
  • Component weighed on weighing stations
  • Component weighed in production
  • Excipient phase on weighing stations
  • Excipient phase in manufacturing
  • Final work order excipient phase on weighing stations
  • Final work order excipient phase in manufacturing
  • Material correction on weighing stations – the Setup level field can be blank.
  • Material correction in manufacturing – the Setup level field can be blank.
  • QFS at end of manufacture – 'QFS' equates to the term 'Quantum Satis' meaning 'Add as much of this component as is needed to achieve the desired result, but not more.'. You might use it, for example, if this component is used to compensate for weight differences in other components or as an additive to achieve a specific weight. This value is especially relevant within the pharmaceutical and food industries.

The list of values available for selection are defined in Local menu 2328 - Code to serve.

 The value you set for this field directly impacts entry of the weighing tolerances. See the field Setup level (field LEVSET).

 This field is only available if the MWM-Weighing station activity code is active.

 
Gross quantity (field GROQTY)

Gross quantity
This quantity is formatted according to the component stock unit. It represents the total quantity of the selected component by moving up the BOM and by taking into account the scrap percentage.
Net quantity (field NETQTY)

Net quantity
This quantity is formatted according to the component stock unit. It is obtained by multiplying the link quantity by uploading the BOM without taking into account the scrap/SCA< percentage. /P>

BOMs

Tab Commerce Links

Block number 1

BOM code (field ALTAFF2)

This is the BOM code for which the where-used are displayed.
It is possible to choose a code among the existing ones when all codes have been selected. The screen will display the where-used that are associated with it.

Grid

Sequence (field BOMSEQ)

This field identifies the sequence number of this component in this BOM (bill of materials). It identifies a component where multiple components with the same product code are defined as variants or options.

The BOMSTE - Component sequence increment parameter (TC chapter, BOM group) defines the first sequence number and the increment applied to subsequent component sequence numbers.
BOM sequence number (field BOMSEQNUM)

Supplementary sequence number used for options and variants in Commercial BOMs. This number relates to the component type, enabling you to define a component as a variant or an option.

The list of possible options or variants for the same component must have the same sequence number. You use the supplementary sequence number to classify component options and variants into a given order for sales transaction selection.
Lev. (field NIV)
Parent product (field ITMREF)

This field indicates the ID of the component product.
Link quantity (field LIKQTY)

The link quantity specifies the number of components required for the basic quantity of the parent product.
It is entered in a variable format (fluctuating number of decimals).
For a management unit of Percentage, the sum of the link quantities must be equal to 100.
Link quantity code (field LIKQTYCOD)

The code of the link quantity can be:

  • Proportional: the quantity is multiplied by the required quantity for the parent product used in the processing,
  • Fixed: the quantity is fixed regardless of the quantity required for the parent product.
Unit (field STU2)

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

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

This information is always displayed, regardless of the transaction used. It cannot be modified.
Qty rounding (field QTYRND)

The quantity of BOM links is entered with a maximum accuracy, which is not always useful for the stock management.
This code is used to manage the quantity rounding mode, based on the stock unit decimal, in the processes using the BOM.
The rounding can be to the nearest, highest or lowest.
Component type (field CPNTYP)

Use this field to define what type of component this is. You can set it to one of the following values:

  • Normal. A component of this bill of materials.
  • By-product. An unplanned by-product or secondary product.
  • Text. Free-format text to be displayed on a work order.
  • Costing. When a value must be calculated for the provisional cost and the production cost price of the parent product.
Link description (field BOMSHO)

Enter the short description.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

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

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.
Valid from (field BOMSTRDAT)

The validity start date is the date from which the link is valid.
It is initialized by default with the validity start date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
Valid to (field BOMENDDAT)

The validity end date is the date beyond which the link is no longer valid.
It is initialized by default with the validity end date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
Print acknowledgment (field OCNPRN)

Use this field to specify if this component must be printed on sales order acknowledgements.
Print slip (field NDEPRN)

Use this field to specify if this component must be printed on delivery notes.
Print inv (field INVPRN)

Use this field to specify if this component must be printed on sales invoices.
Products
BOMs

Tab Sub-contract links

Block number 1

BOM code (field ALTAFF4)

This is the BOM code for which the where-used are displayed.
It is possible to choose a code among the existing ones when all codes have been selected. The screen will display the where-used that are associated with it.

Grid

Sequence (field BOMSEQ)

This field identifies the sequence number of this component in this BOM (bill of materials). It identifies a component where multiple components with the same product code are defined as variants or options.

The BOMSTE - Component sequence increment parameter (TC chapter, BOM group) defines the first sequence number and the increment applied to subsequent component sequence numbers.
Lev. (field NIV)

Number of BOM levels above the component.
Parent product (field ITMREF)

This field indicates the ID of the component product.
UOM (field BOMUOM)

This field displays the unit of measure (volume or mass).
UOM-STK factor (field BOMSTUCOE)

This field indicates the UOM-S conversion coefficient used to calculate the quantity in US, from a quantity entered in UOM: Qty in US = Qty in UOM * coeff.
This coefficient is initialized from the conversion factor table if the combination exists.
UOM link quantity (field BOMQTY)

The link quantity specifies the number of components required for the basic quantity of the parent product.
It is entered in a variable format (fluctuating number of decimals).
For a management unit of Percentage, the sum of the link quantities must be equal to 100.

The corresponding value is initialized from the one defined at BOM level.

STK link quantity (field LIKQTY)

The link quantity specifies the number of components required for the basic quantity of the parent product.
It is entered in a variable format (fluctuating number of decimals).
For a management unit of Percentage, the sum of the link quantities must be equal to 100.
STK (field STU2)

The product storage units used to carry out the stock movement are, depending on the situation, either those of the delivery, or those of the return on receipt. They cannot be modified.
Component type (field CPNTYP)

Use this field to define what type of component this is. You can set it to one of the following values:

  • Normal. A component of this bill of materials.
  • By-product. An unplanned by-product or secondary product.
  • Text. Free-format text to be displayed on a work order.
  • Costing. When a value must be calculated for the provisional cost and the production cost price of the parent product.
Link quantity code (field LIKQTYCOD)

The code of the link quantity can be:

  • Proportional: the quantity is multiplied by the required quantity for the parent product used in the processing,
  • Fixed: the quantity is fixed regardless of the quantity required for the parent product.
Qty rounding (field QTYRND)

The quantity of BOM links is entered with a maximum accuracy, which is not always useful for the stock management.
This code is used to manage the quantity rounding mode, based on the stock unit decimal, in the processes using the BOM.
The rounding can be to the nearest, highest or lowest.
Link description (field BOMSHO)

This field displays the short description of the bill of material (BOM).
% scrap (field SCA)

The loss percentage is used to increase the link quantity in order to take into account the loss due to the production process.
In the various inquiries, two quantities can be displayed:

  • Net quantity: calculation of the quantity necessary to produce a parent product, without taking the loss into account.
  • Gross quantity: calculation of the quantity necessary to produce a parent product, when taking the loss into account.
Valid from (field BOMSTRDAT)

The validity start date is the date from which the link is valid.
It is initialized by default with the validity start date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
Valid to (field BOMENDDAT)

The validity end date is the date beyond which the link is no longer valid.
It is initialized by default with the validity end date of the header. It remains modifiable but it must fall between the start and end dates of the validity displayed in the header.
From lot (field BOMSTRLOT)

For components that are managed by lot, this is the first lot for which this link is valid.
To lot (field BOMENDLOT)

For components that are managed by lot, this is the last lot for which this link is valid.
Mt. slip print. (field PICPRN)

Use this field to specify if this component must be printed on work order material issue slips.
Products
BOMs
BOMs

Error messages

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

"Record does not exist (product)"

The component for which the where-used should be extracted does not exist in the product table.

"No where-used for these selections"

The product entered does not exist in the BOM file.

"Writing error on BOMWUS file"

  • A problem has occurred when creating the work file. Please try again.
  • At least one code must be entered.
  • No code has been selected manually and the All button has not been validated either.

Tables used

SEEREFERTTO Refer to documentation Implementation