List of WOs

• Production site (field MFGFCY)

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

• Order status (field MFGSTASTR)

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

• Start date (field STRDATSTR)

Filter for results within a range of dates. For a single day, enter the same date in the Start date and End date fields. You can leave the Start date field blank to search all records to date.

• End date (field ENDDATSTR)

• Selection formula (field MFIFOR)

Enter, select or build an Enterprise Management filter calculation expression using the formula editor.

 An error message is displayed if you refer to tables which are not generally used by the configurator, or to unknown variables.

• Work order (field MFGNUMSTR)

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 ITMREFSTR)

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.

• field BOMALT

Use this field to filter the work orders to those for a specific bill of materials (BOM) code. 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).

• Routing (field ROUNUMSTR)

Filter for results within a range of routings. For a single route, enter the same routing code in the from/start Routing and to/end Routing fields.

• field ROUALT

Use this field to filter the work orders to those using a specific routing code. Multiple routings can be defined for a single product. Each routing code can be assigned specific management features. These include restriction of the routing to a specific site and to specific areas of functionality (for use in a manufacturing environment, for costing or for capacity planning).

• Project (field PJTSTR)

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).

 This field is populated by default with the project code if you accessed this function directly from the project. If you accessed this function from the project structure the project code and project budget/task code is displayed accordingly.

• 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".

• Original document (field VCRORISTR)

Filter for results within a range of source documents. For a single source document, enter the same document reference in the from/start Original document and to/end Original document fields.

• Component (field CPNITMSTR)

Filter for results within a range of components. For a single component, enter the same component code in the from/start Component and to/end Component fields.

• Selection formula (field MFMFOR)

Enter, select or build an Enterprise Management filter calculation expression using the formula editor.

 An error message is displayed if you refer to tables which are not generally used by the configurator, or to unknown variables.

• Materials detail (field MFMFLG)

Click this check box to display component information for each work order selected.

 You can choose to display component information or operation details, but not both.

• Expected W/C (field EXTWSTSTR)

Filter for results within a range of planned work centers. For a single work center, enter the same work center code in the from/start Expected W/C and to/end Expected W/C fields.

• Actual work center (field CPLWSTSTR)

Filter for results within a range of actual work centers. For a single work center, enter the same work center code in the from/start Actual work center and to/end Actual work center fields.

• Selection formula (field MFOFOR)

Enter, select or build an Enterprise Management filter calculation expression using the formula editor.

 An error message is displayed if you refer to tables which are not generally used by the configurator, or to unknown variables.

• Operations detail (field MFOFLG)

Click this check box to display operation details for each work order selected.

 You can choose to display component information or operation details, but not both.

• No. W.O. (field MFGNUM)

This field displays the work order number.

• Status (field MFGSTA)

This field indicates the status of the work order. This status can be 'Firm', 'Planned' or 'Closed'.

• Product (field ITMREF)

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.

The BOM code matches the product code.

• Product description (field ITMDES1)

This is the description from the product record.

• Major version (field ECCVALMAJ)

This field indicates which version of this product 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 product code defined in the Product field is not version managed.

• Minor version (field ECCVALMIN)

This field indicates which minor version of this product 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 product code defined in the Product field is not version managed.

• WO line (field MFGLIN)

This field displays the line number of the released product.

• Production site (field MFGFCY)

The production site from which the work orders are to be processed.

• Stock unit (field STU)

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

• Planned quantity (field EXTQTY)

This field displays the planned quantity. The quantity is expressed in the stock unit.

• Actual accepted qty (field CPLQTY)

This field contains the quantity of the product to be released, expressed in the stock unit.

• Lot (field LOT)

This is the lot to be assigned to the released product, based on the product management mode.

If the product is managed with automatic lot numbers, the lot number is assigned by the system when the work order is created.

• Allocation date (field IPTDAT)

This field displays the date the stock was allocated to this work order line.

• Release unit (field UOM)

This field displays the release unit of measure (volume or mass) for this product for this order. This unit and any applicable unit conversion are defined for this product on the product record.

• STK conversion (field UOMSTUCOE)

This field displays the product-specific conversion factor applied between the stock unit and the release unit of measure. This unit conversion is defined for this product on the product record.

• Routing (field ROUNUM)

This routing code describes a particular sequence of shop floor processes for a particular product. That is, the sequence of operations and tools that are used in a particular routing.

The routing code is a product code which can be the reference for a manufactured product or a generic reference (parent routing) linked to multiple products.

• Routing code (field ROUALT)

Multiple routings can be defined for a single product. Each routing code can be assigned specific management features. These include restriction of the routing to a specific site and to specific areas of functionality (for use in a manufacturing environment, for costing or for capacity planning).

• 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).

• 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).

• Source document type (field VCRTYPORI)

This field identifies the reason for the work order.

• Source document (field VCRNUMORI)

This field identifies the number of the source document or order.

• Start date (field STRDAT)

This field identifies the planned or actual production start date of the work order.

• End date (field ENDDAT)

This field identifies the end or required completion date for this work order.

• Allocation status (field ALLSTA)

The Allocation (materials), Scheduling and Status fields display a status for this work order. These fields are updated automatically by the system.

The current status, or progress of this work order is displayed in the Scheduling and Status fields. Selected combinations to note are as follows:

• 'Not scheduled' and 'Pending'. The work order is awaiting scheduling. It cannot be submitted for scheduling in Production Scheduler, Sage X3 Web Scheduling or in any web scheduling solution developed by an ISV (independent software vendor).
• 'Scheduled' and 'Pending'. The work order is scheduled but has not actually been submitted for scheduling.
• 'Scheduled' and 'Being optimized'. The work order is being scheduled (has been submitted for scheduling). At these statuses you cannot modify the work order.
• 'Optimized' and 'Pending'. The work order operations have been optimized by the scheduler.

The work order allocation values are defined in Local menu 336.
The scheduling status values are defined in Local menu 335.
The work order status values are defined in Local menu 339.

 For detailed scheduling, Activity code POPS activates the Production Scheduler functionality or the Generic finite scheduler interface.

 Production Scheduler only applies to on-premises instances of Sage X3. The Generic finite scheduler interface provides an integration connector to any web scheduling solution for either cloud or on-premises solutions.

• Scheduling status (field SCDFLG)

The Allocation (materials), Scheduling and Status fields display a status for this work order. These fields are updated automatically by the system.

The current status, or progress of this work order is displayed in the Scheduling and Status fields. Selected combinations to note are as follows:

• 'Not scheduled' and 'Pending'. The work order is awaiting scheduling. It cannot be submitted for scheduling in Production Scheduler, Sage X3 Web Scheduling or in any web scheduling solution developed by an ISV (independent software vendor).
• 'Scheduled' and 'Pending'. The work order is scheduled but has not actually been submitted for scheduling.
• 'Scheduled' and 'Being optimized'. The work order is being scheduled (has been submitted for scheduling). At these statuses you cannot modify the work order.
• 'Optimized' and 'Pending'. The work order operations have been optimized by the scheduler.

The work order allocation values are defined in Local menu 336.
The scheduling status values are defined in Local menu 335.
The work order status values are defined in Local menu 339.

 For detailed scheduling, Activity code POPS activates the Production Scheduler functionality or the Generic finite scheduler interface.

 Production Scheduler only applies to on-premises instances of Sage X3. The Generic finite scheduler interface provides an integration connector to any web scheduling solution for either cloud or on-premises solutions.

• WO status (field MFGTRKFLG)

• Operation (field OPENUM)

This field displays the sequence number of this operation.

• Expected W/C (field EXTWST)

This field identifies the production resource that is to be used for this operation.

• Planned work center title (field EXTWSTDES)

The description of the work center.

• Actual work center (field CPLWST)

This field identifies the production resource used for this operation.

• Actual work center title (field CPLWSTDES)

The description of the work center.

• Expected labor work center (field EXTLAB)

This field identifies the labor work center that is to be associated with this machine. For example, the labor work center that relates to the crew that operates this machine.

The work center site of a 'labor' work center must match the site for the routing code, if defined.

Scheduling is not carried out for labor work centers as they are considered secondary and 'always available' (or available at the same time as the main work center). Their load is managed for information purposes only using the coefficients defined for the main work center.

If the main work center is of type 'subcontracting' there is no associated secondary work center.

• Planned labor w c title (field EXTLABDES)

The description of the work center.

• Actual labor work center (field CPLLAB)

This field identifies the labor work center assigned to this machine. For example, the labor work center that relates to the crew that operates this machine.

The work center site of a 'labor' work center must match the site for the routing code, if defined.

Scheduling is not carried out for labor work centers as they are considered secondary and 'always available' (or available at the same time as the main work center). Their load is managed for information purposes only using the coefficients defined for the main work center.

If the main work center is of type 'subcontracting' there is no associated secondary work center.

• Actual labor w c title (field CPLLABDES)

The description of the work center.

• Operation situation (field MFOTRKFLG)

This field tracks the progress and status of this operation.

• Component (field CPNITMREF)

Component product reference.

• Component (field CPNITMDES1)

This is the description from the product record.

• BOM sequence (field BOMSEQ)

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

• Material situation (field MFMTRKFLG)

This field tracks the progress and status of this component.