Bill of Materials >
BOM Processes >
Relationship Validation
You use this program to verify the logical relationships between stock codes within a structure and to produce a report of any errors that are encountered.
This enables you to identify structural flaws arising from the manner in which stock codes have been defined, and the way in which structures and routings have been entered.
You use the BOM Structure Validation program to validate the number of components attached to a parent part and to identify parent/component loops within the structure.
In addition to this validation, the program also checks the following for stock items not attached to a Bill of Materials:
- Inadmissible MPS item
- Inadmissible kit type
- Inadmissible bulk issue flag
- Inadmissible traceable/inspection flag
- Inadmissible serial tracking flag
- Cannot be a temporary item
- Lead time equal to zero
- DTF greater than lead time
- DTF equal to zero
- Stock on hand not equal to zero
- Stock on order not equal to zero
- Warehouse to use not found
- Warehouse to use cost equal to zero
| Field | Description | ||||
|---|---|---|---|---|---|
| Stock code selection | Indicate the stock code(s) that must be selected for validation. | ||||
| Routing selection |
Indicate the routing(s) for which stock items must be selected for relationship validation.
|
||||
![[Note]](images/note.png)
Selectively indicate which error conditions you want to report on.
| Field | Description |
|---|---|
| Operation chain missing | Select this to print a message if the stock item has been defined with a part category of subcontract or made-in against which no operations are attached. |
| Inadmissible operation chain | Select this to print a message if the stock item has not been defined with a part category of made-in or subcontract and operations are attached. |
| Subcontract operation with zero cost exists | Select this to print a message if the stock item has been defined with a part category of subcontract and at least one related subcontract operation has a zero cost. |
| Inadmissible subcontract operation exists | Select this to print a message if the stock item has been defined with a part category of made-in against which a subcontract operation is held. |
| Subcontract operation required | Select this to print a message if the stock item has been defined with a part category of subcontract against which no subcontract operations exist. |
| Component structure missing | Select this to print a message if the stock item has been defined with a part category other than bought-out against which no components are attached. |
| Inadmissible component structure | Select this to print a message if the stock item has been defined with a part category of bought-out against which components are attached. |
| Parent missing | Select this to print a message if the stock item has been defined with a part category of phantom against which no parent part is attached. |
| Excluded component has included parent | Select this to print a message if you indicated that the component must be excluded from the relationship validation (Stock Code Maintenance) but for the parent you indicated that it must be included in the relationship validation. |
| Inadmissible parent | Select this to print a message if the stock item has been defined with a part category of planning bill, or kit part, and is attached to a parent part. |
| Inadmissible parent category | Select this to print a message if the stock item has been defined with a part category of Phantom and the parent part to which it is attached has a part category of kit part. In addition, this message is printed if the stock item has been defined as an MPS item and the parent part to which it is attached has a part category other than planning bill, or kit part. |
| Inadmissible MPS item | Select this to print a message if an MPS stock item has been defined with a part category of planning bill, phantom, or kit part. |
| Traceable component - parent non-traceable | Select this to print a message if the component stock item is traceable, but the parent is not, and you specified that the parent must be traceable if the component is traceable (Lot Traceability Setup). |
| Notional part has no parent information attached | |
| Notional part has no co-products attached | |
| Co-product not in the same warehouse as notional part | Select this to print a message if the co-product for a notional part is not in the same warehouse as the parent part. This only applies where the parent is a notional part. |
| Inadmissible statistical item | Select this to print a message if a make to order or statistical stock item has been defined with a part category of planning bill, phantom, or Kit part. |
| Inadmissible bulk issue flag | Select this to print a message for bulk issue stock items with a part category of planning bill, phantom, or kit part, or the item is defined as an MPS item. |
| Inadmissible traceable/inspection flag | Select this to print a message for traceable stock items with a part category of planning bill, phantom, or kit part. |
| Inadmissible serial tracking flag | Select this to print a message for serialized stock items having a part category of planning bill, phantom or kit part. |
| Cannot be a temporary item | Select this to print a message if the stock item has been defined with a part category other than bought-out; or is an MPS item where the stock code status is set to temporary. |
| Inadmissible kit type | Select this to print a message if the stock item has been defined with a part category of kit part and the kit type is not a kit type or sub type (and vice versa). The message is also printed if the item has been defined as an MPS item, and the kit type is set to kit type or sub type. |
| Stock on hand not equal to zero | Select this to print a message if the stock item has been defined with a part category of planning bill, phantom, or kit type and the stock on hand quantity in any warehouse is non-zero. |
| Stock on order not equal to zero | Select this to print a message if the stock item has been defined with a part category of planning bill, phantom, or kit type and the on order quantity in any warehouse is non-zero. |
| Lead time equal to zero | Select this to print a message if the stock item has been defined with a part category of bought-out and the lead time is zero. |
| DTF greater than lead time | Select this to print a message if the demand time fence for a make to order stock item exceeds the lead time. |
| DTF equal to zero | Select this to print a message if the demand time fence held against a made to order stock item is zero. |
| Warehouse to use not found | Select this to print a message if the entry held against the field: Warehouse to use for the stock item does not exist. |
| Warehouse to use cost equal to zero | Select this to print a message if the cost of the stock item held against the field: Warehouse to use is zero. |
| Select All | Select this to include all error conditions in the report. |
| Deselect All | Select this to exclude all error conditions. All error conditions are selected by default. You typically select this function if you only wanted to generate the report for a few error conditions. Once all conditions are deselected, you can then select the few conditions for which you want to generate the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The following messages may be printed on the report:
| Column | Description |
|---|---|
| OPERATION CHAIN MISSING | This message is printed if the stock item has been defined with a part category of S (subcontract) or M (made-in) against which no operations are attached. |
| INADMISSIBLE OPERATION CHAIN | This message is printed if the stock item has not been defined with a part category of M (made-in) or S (subcontract) and operations are attached. |
| SUBCONTRACT OPERATION WITH ZERO COST EXISTS | This message is printed if the stock item has been defined with a part category of S (subcontract) and at least one related subcontract operation has a zero cost. |
| INADMISSIBLE SUBCONTRACT OPERATION EXISTS | This message is printed if the stock item has been defined with a part category of M (made-in) against which a subcontract operation is held. |
| SUBCONTRACT OPERATION REQUIRED | This message is printed if the stock item has been defined with a part category of S (subcontract) against which no subcontract operations exist. |
| COMPONENT STRUCTURE MISSING | This message is printed if the stock item has been defined with a part category other than B (bought-out), against which no components are attached. |
| INADMISSIBLE COMPONENT STRUCTURE | This message is printed if the stock item has been defined with a part category of B (bought-out) against which components are attached. |
| MPS PARTS IN COMPONENT STRUCTURE | This message is printed if the stock item has been defined with a part category of G (phantom), S (subcontract), or M (made-in) and MPS items are attached as components. |
| PARENT MISSING | This message is printed if the stock item has been defined with a part category of G (phantom) against which no parent part is attached. |
| INADMISSIBLE PARENT | This message is printed if the stock item has been defined with a part category of P (planning bill), or K (kit), and is attached to a parent part. |
| INADMISSIBLE PARENT CATEGORY | This message is printed if the stock item has been defined with a part category of G (phantom) and the parent part to which it is attached has a part category of K (kit). In addition, this message is printed if the stock item has been defined as an MPS item and the parent part to which it is attached has a part category other than P (planning bill), or K (kit) |
| INADMISSIBLE MPS ITEM | This message is printed if an MPS stock item has been defined with a part category of P (planing bill), G (phantom) or K (kit). |
| INADMISSIBLE STATISTICAL ITEM | This message is printed if a make to order or statistical stock item has been defined with a part category of P (planning bill), G (phantom), or K (kit). |
| INADMISSIBLE BULK ISSUE FLAG | This message is printed for bulk issue stock items with a part category of P (planning bill), G (phantom), or K (kit), or the item is defined as an MPS item. |
| INADMISSIBLE TRACEABLE/INSPECTION FLAG | This message is printed for traceable stock items with a part category of P (planning bill), G (phantom), or K (kit). |
| INADMISSIBLE SERIAL TRACKING FLAG | This message is printed for serialised stock items having a part category of P (planning bill), G (phantom) or K (kit) |
| INADMISSIBLE KIT TYPE | This message is printed if the stock item has been defined with a part category of K (kit) and the kit type is not K or S, or vice versa. The message is also printed if the item has been defined as an MPS item, and the kit type is set to K or S. |
| CANNOT BE A TEMPORARY ITEM | This message is printed if the stock item has been defined with a part category other than B (bought-out); or is an MPS item where the clearing flag is set to T (temporary). |
| STOCK ON HAND NOT EQUAL TO ZERO | This message is printed if the stock item has been defined with a part category of P (planning bill), G (phantom), or K (kit type K or S) and the stock on hand quantity in any warehouse is non-zero. |
| STOCK ON ORDER NOT EQUAL TO ZERO | This message is printed if the stock item has been defined with a part category of P (planning bill), G (phantom), or K (kit type K or S) and the on order quantity in any warehouse is non-zero. |
| LEAD TIME EQUAL TO ZERO | This message is printed if the stock item has been defined with a part category of B (bought-out) and the lead time is zero. |
| DTF GREATER THAN LEAD TIME | This message is printed if the demand time fence for a make to order stock item exceeds the lead time. |
| DTF EQUAL TO ZERO | This message is printed if the demand time fence held against a made to order stock item is zero. |
| WAREHOUSE TO USE NOT FOUND |
This message is printed if the warehouse to use for the stock item does not exist (i.e. is spaces or is invalid). This error message is also printed for stock items that are not part of a Bill of Materials. The reason is that the Relationship Validation report validates a number of areas which do not directly pertain to whether or not the item exists on a bill of materials. |
| WAREHOUSE TO USE COST EQUAL TO ZERO | This message is printed if the cost of the stock item held against the warehouse to use is zero. |
| TRACEABLE COMPONENT(S) - PARENT NON-TRACEABLE | This message will occur if the Lot Traceability installation option: Parent traceable if component traceable is selected and the component stock item(s) are defined as traceable, but the parent has not. |
| The component quantity required based on EBQ does not match the number of decimals allowed, and may cause rounding of quantity values | This warning is displayed when using any unit of
measure other than stocking and the EBQ multiplied by the
component quantity results in the quantity value exceeding
three decimal places. This is only a warning and not an indication of an invalid or incorrect bill of materials. |