View Inventory by Attribute

This document explains the expanded display of available inventory filtered by specific attribute values to include all attributes. The functionality also assists by providing suggested attributes for filtering based on attributes from given quality specifications, attributes from custom specifications for a customer or delivery customer, and attributes from the attribute model of the item. See the document Create Attribute Model.

For more information on quality specifications, see

Outcome

Items, which are defined as attribute-managed and connected to attribute models, can be used in the Quality Management System (QMS). The implementation of attribute-controlled items in QMS allows the system to perform specification matching. Specification matching involves the comparison of order requirements as defined by order line specifications to inventory and, based on that comparison, the system suggests the lots whose actual test results match the expected test values indicated in an order line specification.

The 'Inventory by Attribute' (ATS010/H) panel provides the functionality of reviewing and confirming inventory based on attribute values, including quality-controlled attributes.

Note: When you enter search criteria on the 'Inventory by Attribute' (ATS010/H) panel, the system retrieves data that matches any of the criteria. It does not filter search results that meet all the criteria entered.

When search attributes and attribute values are added or updated, the records are stored on the Order Attributes (MOATTR) table.

The MOATTR file contains the expected values from the requirements and demands.

Before you start

  • The '407 Quality Management' field on the K panel of 'Company. Connect Division' (MNS100) must be defined as 'Quality management system'.
  • When using the Quality Management System (QMS), lot-controlled items must be defined as using an Inspection code in on the E panel of 'Item. Open' (MMS001).
  • Items that are not lot-controlled must be defined as Quality inspected on the Q panel of 'Item. Open' (MMS001) .
    Note: Lot-controlled items cannot be grouped into the same quality group as items that are not lot-controlled. In addition, packaged items cannot be grouped into the same quality group as bulk items in 'Item. Open' (MMS001).
  • The attributes and attribute models that are to be used within the company must have been created.
  • The items must have been defined as attribute managed and connected to attribute models.

Follow these steps

  1. Start 'Balance Identity. Open Toolbox' (MWS068).

  2. On panel B, the View field controls the information to be displayed.

  3. After the balance identity details for the inventory are displayed, highlight a row in the grid.

  4. Select Related > Inventory by Attribute to navigate to 'Inventory by Attribute' (ATS101/H) where the Warehouse and Item will default.

  5. Specify the attribute selection criteria, such as Customer, Delivery Customer, or Specification/Effective Date.

  6. Click Apply.

  7. In the grid, specify the attributes and corresponding attribute values.

  8. Click Next.

  9. When you return to the B panel of 'Balance Identity. Open Toolbox' (MWS068), the data is filtered by the attribute search criteria that you specified on the 'Inventory by Attribute' panel (ATS101/H).

Related topics