Filter tables via filter dialog

In the following tabs, entries in tables can be filtered using the filter dialog:

• Menu item Material management > Material creation:

  eASN Checks, Goods Receipt, Repacking, Pairings and On Setup Label Creation

• Menu item Material management > Configuration:

  Blocking Rules and On Setup Label Creation Rules

Procedure

1. In the header, click Filter to open the Filter dialog window.

   

2. Select the desired filter on the left-hand side.
3. Enter the filter criterion on the right-hand side.

   The filter criterion must be entered in full.

4. If necessary, select additional filters and enter the filter criterion.
5. Use Apply to accept the selected filters.

The table shows all entries that match the selected filter criteria. The selected filter criteria appear below the header.

Use to remove the individual filter criteria below the header.
Use Reset to remove all restrictions.

Search for materials

To find the desired materials, a variety of filter criteria are available in the following tabs:

• Material Management > Material Search > Extended Search

  Filtering materials and displaying the details of the materials: Extended Search tab

• Material Management > MSD Treatment > MSD Statistics

  Filtering MSD materials and viewing MSD information: MSD Statistics tab

The filter criteria are divided into the Material, Production and Delivery categories. The categories can be expanded and collapsed for a better overview.

Materials whose label ID, material ID or dry location is known can be searched for directly using this information:

• Label per ID tab
• Material per ID tab
• Dry Box Content tab

Procedure

1. Open the Material management > Material search > Advanced search or Material management > MSD treatment > MSD statistics tab.
2. Expand the Material, Production and Delivery categories with and enter the desired filter criteria.

   Material category:
   
   Batch Query Type defines the rule to be searched for in batches:
   And:
   The materials searched for must meet the filter criteria specified under both Batch 1 and Batch 2.
   
   Or:
   The materials searched for must meet the filter criteria specified under Batch 1 or Batch 2, either in Batch 1 or Batch 2.
   
   Several values can be entered for batch 1 and batch 2.

   Production category:
   
   In the MSD Statistics tab, the two fields Consumed on from and Consumed on until are mandatory fields.

   The number of filter criteria entered is displayed in brackets after the category.

   

3. Click Search.

The materials that match the filter criteria entered at the time of the search are displayed in a table in the Results area.

The filter criteria entered are displayed under the header.

If the search result is older than 10 minutes, a corresponding message is displayed above the header.

Result — Advanced search

Result — MSD statistics

Export results table

The information in a results table can be downloaded in CSV or XLS file format, if available.

Prerequisites

• The results of a search are displayed in a results table (e.g. Search for materials).
• The export functionality is available in the header.

Procedure

1. Click Export in the header.

   

2. In the Options export dialog window, select a file format from the drop-down list.
3. If the obsolete name of the column titles is to be used in the export file, activate the Use obsolete column titles checkbox.

   Obsolete column titles	Column title of the Nexeed IAS
   MatId	Mat ID
   VendorId	Supplier ID
   CurrentLocation	Current Location
   StationInfo	Station Info
   CustomerPartNumber	TTNR
   ManufacturerPartNumber	TTNR Manufacturer
   ManufacturerDuns	Manufacturer No.
   MSL	MSL
   OriginalExpirationDate	Expiration Date
   FirstOpenedTimestamp	First Opened
   CreatedOn	Rcv. Timestamp
   Quantity	Quantity
   RemainingQuantity	Remaining Qty.
   QuantityUnit	Unit
   ErpId	ERP ID
   VendorBatch	Batch 1
   VendorBatch2	Batch 2
   OrderingCode	Order. Code
   ShippingNoteNumber	Shippingnote No.
   AdditionalPartInformation	Add. Info
   SapExpirationDate	SAP Exp. Date
   SapGoodsReceiptItemNumber	SAP Goods Rcpt Item No
   SapGoodsReceiptTimestamp	SAP Goods Rcpt Timestamp
   Batch	Sap Batch No.

4. Click Export.

The file with the selected information is saved in the download directory of the Internet browser.

If a semicolon (;) is used in the table in Nexeed IAS, it is displayed as a colon (:) in the export file.