In Cockpit: Production items application you can view the production items, that is items with the Production view created and defined in Items application. The application consists of:
- Query pane – contains the buttons and fields used to filter data displayed in the work pane table.
- Work pane – displays data according to the filter criteria specified in the query pane.
Query pane
Following buttons are available in the query pane:
[New] – opens an empty list sheet.
[Refresh] – refreshes/opens data in the work pane table.
[Refresh] → [Refresh (background)] – refreshes the work pane data in the background.
[Refresh] → [Stop] – stops the update process in case of a large amount of data to refresh.
[Refresh] → [Count objects] – recalculates the quantity of the table line items corresponding to the specified criteria. A relevant information message is then displayed.
[Calculate and display totals] → [All objects] – adds up of all the records displayed in work pane table. The total is presented in a separate row below the table. The value Production lot size is added up.
[Calculate and display totals] → [All objects with group totals] – adds up of all the record groups displayed in work pane table. The total is presented in an additional row below each group. The value Production lot size is added up.
[Calculate and display totals] → [Selected objects] – adds up the records selected in the first table column. The total is presented in an additional row.
[Calculate and display totals] → [Hide totals] – hides all rows presenting totals of the records.
[Export] – exports data to a file. More information can be found in chapter Export of data.
- [Export] → [Export displayed objects]
- [Export] → [Export objects according to search criteria]
- [Export] → [Copy hyperlink with search criteria]
Data in the application can be filtered by:
- Item – displays a specific item or multiple items. Multiple items can be selected using the [Value assistant] button.
- Item description – displays items with provided descriptions.
- Unit encoding – displays only the data with a specified basic unit of measure.
- Replacement status – filters data by its status. Selectable options are:
- (All) – displays all items, regardless of their statuses
- Not replaced – displays only not replaced items
- Replaced – displays only the replaced items
- Replaced if availability = 0 – displays only items that were replaced because they were not available
- Expired – displays only withdrawn items
- Expired if availability = 0 – displays only items that were withdrawn because they were not available
- Production lot size – displays items with a specified lot size only.
- Deletion marker – allows the selection of deletion marker-relevant items. Selectable options are:
- (All) – displays items marked and not marked for deletion.
- Marked as deleted – displays only the items marked for deletion.
- Not marked for deletion – displays only the items not marked for deletion.
- Production method – displays items with an alternate production method assigned.
- Bill of resources – displays items with a specific bill of resources assigned.
- Bill of material – displays items with a specific bill of material assigned.
- Routing – displays items with a specific routing assigned.
- Classification 1 – displays items with assigned classification 1.
- Classification 2 – displays items with assigned classification 2.
- Classification 3 – displays items with assigned classification 3.
- Classification 4 – displays items with assigned classification 4.
- Classification 5 – displays items with assigned classification 5.
Export of data
[Export] → [Export displayed objects] action
This action exports objects currently displayed in the work pane table. It opens a dialog window Output objects.
It opens a dialog window Output objects.
The dialog window consists of the following tabs, sections and fields:
- Format and options tab – export settings are defined in this tab.
- Output format section – the basic settings, such as document format and orientation, can be defined in this section. Fields in this section are the following:
- Format – specifies the file format to which data will be exported. Available formats are XLS and PDF.
- Page format – specifies the sheet size. Available size values are: A4 and A3.
- Orientation – specifies the orientation of the exported document. Selectable options are Portrait and Landscape.
- Output range section – specifies a range of exported data. Fields in this section are the following:
- All objects – exports all records from the table.
- Selected objects – exports only selected objects from the table.
- Following records – exports only the table line items with numbers specified in the From record/To
- Visible objects only – exports only the objects visible in the table.
- Options section – specifies additional export options:
- Output total lines – exports data together with the rows presenting totals.
- Display pictures – exports data together with defines images.
- Display colors – exports colored data.
- Wrap to cell width – exports data from the table by wrapping text content to the defined column width.
- Utilize monitor font – exports data in the font used in the system.
- Scaling – scales the view of the exported data. Selecting the option Automatically adjusts the scaling value and selecting the option None sets the value to 100%. User-defined scaling allows the edition of the percentage value.
- Margins and headers/footers tab – specifies the margin size and the type of data to be displayed in the header and footer.
- Output format section – the basic settings, such as document format and orientation, can be defined in this section. Fields in this section are the following:
[Export] → [Export objects according to search criteria] action
This action exports the data as specified in the search criteria. It opens the Export objects according to search criteria window.
The dialog window consists of the following tabs, sections and fields:
- Application tab – detailed export settings are defined in this tab.
- Batch application – defines the application that will be run in the background to export the data.
- Development object – technical name of the application that exports data.
- Action section – contains the File name field in which you can specify the target folder path and the file name with exported data.
- General section – you can specify the format of the exported data in this section.
- Output format – file format into which data will be exported. Available file formats are: XLS, XLSX, CSV, XML, HTML.
- Output units – method of outputting units into an output voucher. Quantity and unit can be output in one column or in two separate columns.
- Export column headings (checkbox) – if selected, the data is output together with the table column names.
- Data recipient – data recipient that will be added to the operation log file.
- Intended use – the purpose of data output, which will be added to the operation log file.
- Column sequence section – you can specify the column order in the output file in this section.
- Background settings tab – the batch job processing settings can be specified in this tab.
[Export] → [Copy hyperlink with search criteria] action
This action generates a link to download the defined file with data after typing it into the browser window. It opens the Copy hyperlink with search criteria dialog window.
The dialog window consists of the following tabs:
- General tab – you can specify the format of the exported data in this tab.
- Output format – file format into which data will be exported. Available file formats are: XLS, XLSX, CSV, XML, HTML.
- Output units – method of outputting units into an output voucher. Quantity and unit can be output in one column or in two separate columns.
- Export column headings (checkbox) – if selected, the data is output together with the table column headings.
- Short URI for MS Office (checkbox) – used to generate a short URI address.
- REST service URI – link address that needs to be copied in order to download the file with data.
- Data recipient – data recipient that will be added to the operation log file.
- Intended use – the purpose of data output, which will be added to the operation log file.
- Column sequence tab – you can specify the column order in the output file in this section.
Work pane
The application work pane displays data according to the filter criteria specified in the query pane.
Buttons available in the work pane table are the following:
[Alternate production methods] – displays for an item an additional row presenting a defined alternate production method.
[Define query and result properties] – used to define a view, add/delete a table column and modify the sort settings.
[Hide/show ranges] – used to modify the table view, selectable options:
- Hide/Show list header – hides/shows the table column heading.
- Hide/Show line status – hides/shows the column with the line status.
- Show grouping and sort area – by dragging the column heading into the highlighted area above the table header it groups data by the selected attribute.
- Hide grouping and sort area – hides the grouping and sort area.
- Expand all groups – expands the grouped line items in the table.
- Reduce all groups – collapses all grouped line items in the table.
- Show all areas – shows all columns and their headings.
- Hide all areas – hides all columns and their headings.
Columns in the table correspond to the fields available in the query pane.