Monitor commissioned lots

Use the Monitor Commissioned Lots menu item to investigate data about lots that have been commissioned in TraceLink, sourced from Serial Number Exchange, Serialized Operations Manager, and Master Data Exchange in Track & Trace Services.

The data in Monitor Commissioned Lots can be useful for completing certain supply chain tasks:

  • Manufacturing line tasks:
    • Monitor manufacturing activity to ensure business as usual.
    • View information about the items produced at each packaging level.
    • View the products and lots produced for each market.
    • Reconcile lot production in TraceLink against the L3 system.
  • Warehouse tasks:
    • Identify a returned item with a damaged lot number (i.e. the lot number is not legible, but the serial number is).

Dashboard view

The dashboard view shows a summary of the data, providing a visualization of the commissioning activity. The Commissioning Details chart shows the quantity of serial numbers commissioned for each product by lot and packaging level.

By default, the dashboard view shows data for the last 100 products most recently commissioned within the specified date range.

  1. Select the Main Menu icon .

  2. Select Serialized Product Intelligence.

  3. Select Monitor Commissioned Lots in the side navigation, below Do.

    The dashboard view displays by default with the Dashboard View icon selected in the upper right.

Use the options in the Filter Results section to narrow the data on the screen, and use the filters in the Commissioning Details section to adjust the data displayed in the chart.

To filter data in the Filters section

    • Last Week (default) – View data from the last 7 days.
    • Last Month – View data from the last 30 days.
    • Last 3 Months – View data from the last 90 days.
    • Last 6 Months – View data from the last 180 days.
    • Custom Range – View data from a specified time period (maximum range of one year).
  2. Select Show Additional Filters and fill in the following fields to further filter the results:
    1. Select the type of filters to apply from the Filter Options drop-down:
      • Product and Location – Narrow the data to a specific product and location.
      • Target Market and Location – Narrow the data to products with one or more specific target markets and a specific location.
      • Product and Lot Number – Narrow the data to a specific product and lot number.
    2. Complete the following fields, depending on which Filter Option is selected:
      • Product field – The name or identifier of the product to narrow the data by.
      • Location field – The location to narrow the data by.

      • Product Released drop-down – Indicates whether to filter for lots that have been part of a product release:

        • Yes – Only lots with serialized items that have been part of a product release.
        • No – Only lots with serialized items that have not been part of a product release.

      • Manufactured By drop-down – The company that manufactured the lot:

        • All – Any company manufactured the lot.
        • My Company – The SPI Owner manufactured the lot.
        • Partner Company – The SPI Owner's trade Partner manufactured the lot.

        The Manufactured By value is determined from the lot's commissioning location. If the commissioning location exists in Company Master Data, the lot's Manufactured By value is My Company. Otherwise, the value is Partner Company.

      • Target Market Type drop-down – Indicates whether to filter for single-market or multi-market products:

        • Single Target Market – The product is produced for a single market.
        • Multiple Target Markets – The product is produced for more than one market.
      • Value field – The single target market or combination of target markets.
      • Location field – The location to narrow the data by.

      • Product Released drop-down – Indicates whether to filter for lots that have been part of a product release:

        • Yes – Only lots with serialized items that have been part of a product release.
        • No – Only lots with serialized items that have not been part of a product release.

      • Manufactured By drop-down – The company that manufactured the lot:

        • All – Any company manufactured the lot.
        • My Company – The SPI Owner manufactured the lot.
        • Partner Company – The SPI Owner's trade Partner manufactured the lot.

        The Manufactured By value is determined from the lot's commissioning location. If the commissioning location exists in Company Master Data, the lot's Manufactured By value is My Company. Otherwise, the value is Partner Company.

      1. Product field – The name or identifier of the product to narrow the data by.
      2. Lot Number field – The lot number to narrow the data by.
  3. Select Add Another Filter to specify another filter option.

    Select the Remove icon to remove filter criteria.

  4. Select Apply.

    The results display in the table.

To filter data in the Commissioning Details section

  1. Enter the name or identifier of a Product to locate it in the chart and narrow the data.
  2. Select the Each, Inner Pack/Bundle, Case, and Pallet checkboxes to the left of the chart to narrow the data to only that packaging level (at least one checkbox must be selected).
  • To view the dates when the commissioning occurred, select Show Event Dates in the lower right of the Commissioning Details chart.
  • To view more details about a specific data point in a chart, select the data point, and then select View Data.
  • To view master data information for a product, select the row for that product in the chart.
    • Product Name – The name of the product.
    • Description – The description of the product.
    • Item Code – The primary item code (e.g. Internal Material Number or Country Drug Code) that identifies the product.
    • Target Markets – The target markets that the product is commissioned for.
    • Package Size – The number of individual doses in the pack.
    • Dosage Form – The form the product is dispensed in (e.g. tablet or pill).
    • Strength – The strength of the product (e.g. 100 mg).

Table view

The table view shows data for each packaging code and lot and allows for additional filtering to explore the data further.

  1. Select the Main Menu icon .

  2. Select Serialized Product Intelligence.

  3. Select Monitor Commissioned Lots in the side navigation, below Do.

  4. To view all data in the table, select the Table View icon in the upper right.

    or

    To view specific data in the table, select a data point in a chart, and then select View Data.

To filter data by a keyword

  • Enter Keywords in Filter By to return only rows that contain that text.

To filter data by specific values

  1.  Select Show Additional Filters and fill in the following fields to further filter the results:
    1. Filter By drop-down – The type of value to filter for (e.g. Lot Number).
    2. Value field – The value to view data for (e.g. Last Week).
  2. Select Add Another Filter to specify another filter option.

    Select the Remove icon to remove filter criteria.

  3. Select Apply.

    The results display in the table.

    • Packaging Code – The packaging code value that the Lot Number is commissioned for.
    • Packaging Code Type – The type of Packaging Code value (e.g. GTIN-14).
    • UOM – The unit of measure that the packaging code is for (e.g. Each).
    • Internal Material Number – The Internal Material Number identifier value that applies to the lot number's product, if applicable.
    • Lot Number – The lot number that the serial numbers are commissioned for.
    • Initial Commission Quantity – The total quantity of serial numbers for the Lot Number and UOM that were commissioned, including serial numbers that were later decommissioned.
    • Initial Commission Location Name – The name of the location where the serial numbers for the Lot Number were commissioned.
  1. Select the Export icon to export the messages.

    TraceLink begins generating the CSV file with the data displayed in the table. It is available in the Notifications panel when it is ready.

    See Column descriptions for the headings that display in the CSV output.

    You also receive an email when the CSV file is ready.

The following values display by default:

  • Packaging Code – The packaging code value that the Lot Number is commissioned for.
  • Packaging Code Type – The type of Packaging Code value (e.g. GTIN-14).
  • UOM – The unit of measure that the packaging code is for (e.g. Each).
  • Internal Material Number – The Internal Material Number identifier value that applies to the lot number's product, if applicable.
  • Lot Number – The lot number that the serial numbers are commissioned for.
  • Initial Commission Quantity – The total quantity of serial numbers for the Lot Number and UOM that were commissioned, including serial numbers that were later decommissioned.
  • Initial Commission Location Name – The name of the location where the serial numbers for the Lot Number were commissioned.

Select the Expand icon to view the following values:

  • Expiration Date – The expiration date associated with the Lot Number.
  • Country Drug Code Type – The type of Country Drug Code associated with the Country Drug Code value (e.g. NDC).
  • Country Drug Code – The Country Drug Code identifier value that applies to the Lot Number, if applicable.
  • Aggregated – Indicates whether the serial numbers associated to the Lot Number have been aggregated. Displays as Y or N (i.e. Yes or No).
  • Date Initially Commissioned – The date that the first serial number from the Lot Number was commissioned.
  • Initial Commission Location ID – The identifier of the location where the serial numbers for the Lot Number were commissioned (e.g. GLN).
  • Manufacturing Date – The official date provided in the commissioning event.
  • Target Market – The market that the lot is intended for.
  • Product Name – The name of the product that the lot is for.
  • Product Description – Description of the product, sourced from Product Master Data.
  • Dosage Form – The form the product is dispensed in (e.g. tablet or pill).
  • Strength – The strength of the product (e.g. 100 mg).
  • Packaging Size – The number of individual doses in the pack.
  • Product Release – Indicates whether the Lot Number has been part of a product release. Displays as Y or N (i.e. Yes or No).
  • Manufactured By – Indicates whether the lot was manufactured by the SPI Owner or a trade Partner. Displays as My Company or Partner Company.

    The Manufactured By value is determined from the lot's commissioning location. If the commissioning location exists in Company Master Data, the lot's Manufactured By value is My Company. Otherwise, the value is Partner Company.

  • Event Processed Date – Indicates the date on which an event was processed by Track & Trace Services.