Use this function to display material (component) consumption against the products (BOMs) on work orders at a specific site on one, or between a range of dates.

You can inquire by site for one or a range of components, tracking numbers and work order numbers. 

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

This function is customized to the needs of your organization and your processes. The Inquiry screens function for code 'MKM' determines the way in which you enter information, and how information is displayed and printed.

The Consumptions inquiry function contains a section for you to enter your selection criteria and a table (grid) in which the results of the search are displayed.

Header

Selection

Use this section to define the production site and date range. By default, the search is for the current date but can be changed to search within a range of dates.

Start - end range

Use this section to define the selection ranges to be used for filtering the results of the search.

You can use the Criteria action to enhance the selection criteria applied.

Selection

Production site (field MFGFCY)

Type in or select the production site from which the work orders are to be selected. This field is mandatory.
Tracking date (field MFGDATDEB)

Filter for results within a date range. For a single day, enter the same date in the from/start Tracking date and to/end Tracking date fields. You can leave the from Tracking date field blank to search all records to date.

Start - end range

Product (field ITMREFDEB)

Filter for results within a range of materials (components). For a single component, enter the same product code in the from/start Product and to/end Product fields.
Tracking number (field MFGTNUMDEB)

Filter for results within a range of tracking numbers. For a single tracking number, enter the same tracking number in the from/start Tracking number and to/end Tracking number fields.
Work order (field MFGNUMDEB)

Filter for results within a range of work orders. For a single work order, enter the same work order number in the from/start Work order and to/end Work order fields.

Tab Search results

This section displays all component consumption at the specified site that meets the defined selection criteria. The product to be manufactured and the quantities consumed to produce each product line are included.

The columns displayed in the grid or table and the order in which they are displayed is determined by the Inquiry screens function for code 'MKM'.

Grid

Tracking number (field MFGTRKNUM)

This field displays the tracking number generated for a work order released for production.
Line (field MATTRKLIN)

This field identifies the associated line on the source document or order.
Line no. (field MFGLIN)

This field displays the line number of the released product.
Product (field ITMREF)

This field displays a component code. This product code is the code of a component (material) required to produce what is referred to as a 'Bill of Materials' or a 'BOM'. A BOM contains structured information for making and costing a product. It defines the components that make up a product, and given this, the cost of the product.
Material type (field MATTYP)

This field displays the type of tracking:

  • 'BOM' if the tracking is by bills of material (BOM);
  • 'WO' if the tracking is by work order.
Major version (field ECCVALMAJ)

This field indicates which version of this component (material) applies. Major versions might be used where there have been increased or significant changes to the original or previous version, that is the "form, fit or function" has changed.

This field is not populated if the component code defined in the Component or Material field is not version managed.
Minor version (field ECCVALMIN)

This field indicates which minor version of this component (material) applies. Minor versions might be used where there have been minor features or changes in functionality, or significant fixes applied to a specific major version.

This field is not populated if the component code defined in the Component or Material field is not version managed.
BOM (field BOMNUM)

This field displays the original product code. This product code describes what is referred to as a 'Bill of Materials' or a 'BOM'. A BOM contains structured information for making and costing a product. It defines the components that make up a product, and given this, the cost of the product.
BOM code (field BOMALT)

Multiple bills of materials (BOMs) can be defined for a single product. Each BOM code can be assigned specific management features. For manufactured or subcontracted products this includes restriction of the BOM to a specific site and to specific areas of functionality (for costing or for capacity planning).
Consumed quantity (field USEQTY)

This field displays the quantity of this component consumed to produce the bills of materials (BOMs) on this work order.
Stock unit (field STU)

This field displays the unit in which the product is stored. It provides the key to prices, costs, volumes etc.
Allocation date (field IPTDAT)

This field displays the date the stock was allocated to this work order line.
Quantity type (field TYPQTY)

This field indicates if this component is stored in stock. This field can be set to one of the following values:

  • Physical. This is a physical component for which quantities are stored in stock.
  • Active. This is an active component such as nails or staples for which quantities are not stored in stock.
     
Component (field MFMITMREF)

This field displays a component code. This product code is the code of a component (material) required to produce what is referred to as a 'Bill of Materials' or a 'BOM'. A BOM contains structured information for making and costing a product. It defines the components that make up a product, and given this, the cost of the product.
BOM sequence (field BOMSEQ)

This field identifies the sequence number of this component in the BOM (bill of materials).
Preferred lot (field LOTPREF)

This field displays the preferred lot. This particular lot was selected manually when this component was allocated to this (firm) work order.
Storage location (field LOCPREF)

This field displays the preferred storage location. This location was selected manually when this component was allocated to this (firm) work order.
Preferential status (field STAPREF)

This field displays the preferred component status. This status was selected manually when this component was allocated to this (firm) work order.
No. W.O. (field MFGNUM)

This field displays the work order number.

Released product (field RELITM)

This field displays the code of the product to be released. The product code is valid for the defined production site. It is a manufactured product (product category), held in stock (stock management mode) and is active (product status).
Project (field PJT)

This field displays the associated project code. The content can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that is a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code.

If the content of this field includes a character such as an exclamation mark "!" this field links to the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational structure. For example, if a material task code is 'USA-P3' and a project code is 'USA12345678', this field displays a link to the project operational structure as 'USA12345678!USA-P3'.

To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (link to the project budget structure).
Order (field VCRNUMORI)

This field identifies the number of the source document or order.
Operation (field OPENUM)

This field displays the sequence number of this operation.
Actual work center (field CPLWST)

This field identifies the production resource used for this operation.
Tracking date (field MFGTRKDAT)

This field displays the date the stock transactions associated with this tracking number were posted.
Work order

Click Work order from the Actions icon to view the work order details. The transaction you select determines the way in which you enter information, and how information is displayed and printed. If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.
Tracking detail

Click Tracking detail from the Actions icon to view the production tracking details for the selected work order. This includes parent product (BOM) information, component information and operation details. The transaction you select determines the way in which you enter information, and how information is displayed and printed. If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.
Tracked times

Click Tracked times from the Actions icon to view the time tracking details for the operations required to manufacture the product on the selected work order. This includes routing information, quantity information (actual and rejected) and time details. Times details include the time taken to set up machinery ready for use and the time taken to perform an operation for the displayed number of items.
Productions

Click Productions from the Actions icon to view the work order production details.
Stock by site

Click Stock by site from the Actions icon to view the inventory levels for the selected product, by site.

Specific actions

Click the Search action to load the table (grid) with work order component consumption lines that meet the entered selection criteria.

The maximum number of lines displayed is defined in the Inquiry screens function for code 'MKM'.

Click the Criteria action to access additional selection and display criteria. You can filter the work order lines to be produced by bill of materials (BOM), routing operation, project and sales order, and modify the sort order.

Screen code. You can select the required customized inquiry screen, if you are using personalized inquiries.

 Please see the Inquiry screens documentation.

You can save one or several sets of criteria using the Memo action. You can recall these using the Recall action or delete them using the Delete memo action.

Selection criteria

Memo code (field MEMO)

You use a memo code to save the criteria applied to an entry screen. Use this field to find out if a memo code has already been saved for the current screen values.

Use the following buttons to manage memos:

Recall: Recall a previously defined and saved memo.

Memo: Save the current values of the screen in a memo file with a code to be specified.

Del. Memo: Delete a previously saved memo.

If a memo named STD (standard) is associated with the screen, it is loaded when opening the function.

Start - end range

Product (field ITMREFDEB)

Filter for results within a range of materials (components). For a single component, enter the same product code in the from/start Product and to/end Product fields.
Tracking date (field MFGDATDEB)

Filter for results within a date range. For a single day, enter the same date in the from/start Tracking date and to/end Tracking date fields. You can leave the from Tracking date field blank to search all records to date.
Tracking number (field MFGTNUMDEB)

Filter for results within a range of tracking numbers. For a single tracking number, enter the same tracking number in the from/start Tracking number and to/end Tracking number fields.
Work order (field MFGNUMDEB)

Filter for results within a range of work orders. For a single work order, enter the same work order number in the from/start Work order and to/end Work order fields.
Released product (field RELITMDEB)

Filter for results within a range of finished products (BOMs). For a single bill of materials (BOM), enter the same product code in the from/start Released product and to/end Released product fields.
BOM (field BOMNUMDEB)

Filter for results within a range of bills of materials (BOMs). For a single BOM, enter the same product code in the from/start BOM and to/end BOM fields.
BOM code (field BOMALTDEB)

Filter for results within a range of bills of materials (BOM) codes. Multiple bills of materials (BOMs) can be defined for a single product. Each BOM code can be assigned specific management features. For manufactured or subcontracted products this includes restriction of the BOM to a specific site and to specific areas of functionality (for costing or for capacity planning).

For a single BOM code, enter the same sequence number in the from/start Code and to/end Code fields.
Operation (field OPENUMDEB)

Filter for results within a range of operation sequence numbers. For a single operation sequence number, enter the same sequence number in the from/start Operation and to/end Operation fields.
Project (field PJTDEB)

Use these fields to filter for results within a range of project codes. For a single project, enter the same project code in the From/start project and To/end project fields. The content can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that is a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code.

If the content of this field includes a character such as an exclamation mark "!" this field links to the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational structure. For example, if a material task code is 'USA-P3' and a project code is 'USA12345678', this field displays a link to the project operational structure as 'USA12345678!USA-P3'.

To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (link to the project budget structure).

 
Whole project (field PJTDSPALL)

Select this check box to view all records linked to the selected projects. To only view records linked to the selected structure of the projects, leave this check box clear.

If the value of the From/To project field includes a character such as an exclamation mark "!" the search includes the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3".
Order (field VCRORIDEB)

Filter for results within a range of order numbers. For a single order, enter the same order number in the from/start Order and to/end Order fields.
Tracking type (field MATTYPDEB)

Filter for results within a range of tracking types. Select one of the following:

  • 'WO' to filter the results by work order;
  • 'BOM' to filter the results by bills of material (BOM);
  • 'WO reintegration' to filter the results by components issued to a work order or to a bill of materials (BOM) that have been returned to stock;
  • 'BOM reintegration' to filter the results by components issued to a work order or to a bill of materials (BOM) that have been reintegrated back into stock.

For a single type of tracking, enter the same tracking type in the from/start Tracking type and to/end Tracking type fields.

Display

Screen code (field ECRAN)

The columns displayed in the search results grid or table, the order in which they are displayed and the layout of the associated graph is determined by a screen code. Use this field to apply a specific screen display code to the search results. Type in or select a code defined in the Inquiry screens function for this particular inquiry function.

 
Selection (field TRI)

Use this field to modify the sort order.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation