Transactions

The NRAC provides one of these values for each notice:

  • Catalog number
  • Item number
  • Model number
  • Specify unit number
  • Part number
  • NDC
  • Product code
  • Product number

With the exception of NDC numbers, these values are treated as manufacturer numbers in Item Lifecycle Management. The NDC value is always treated as an NDC number.

Handling manufacturer numbers

When a notice for a product is created or updated, values can be added in the Product Identifier section.

  1. Select Manage Notices and open a recall notice record.
  2. In the Products section, create or open a product item record.
  3. In the Product Identifier section, specify the values.

    These are two methods by which values can be added:

    • Manually, by upload using Infor Spreadsheet Designer
    • By a notice from NRAC

To capture valid records, when Manufacturer Number, Vendor Item, and NDC Number are used to find items and vendor items, all non alpha-numeric characters are removed. For example, if a Manufacturer Number is 1234/78 in the Product Identifier and 1234-78 on a Vendor Item, these values are considered a match.

Handling product identifiers

This table contains information about how product item records are created:

Product identifier From item From vendor item Notes
Manufacturer Number

Include the Manufacturer Code if it is specified on the Notice header

 Creates Notice Item for Item and Manufacturer Information from Item based on matching Manufacturer Number. Optionally, Manufacturer Code. Creates Notice Item for Item, Vendor Item, and Manufacturer Information from Vendor Item based on matching Manufacturer Number and optionally, Manufacturer Code Creates Notice Item for Manufacturer Information if Item and Vendor Item are not found
Vendor Item

Including Vendor if specified on the Notice header

 NA Creates Notice Item for Item, Vendor Item, and Manufacturer Information from Vendor Item based on matching Vendor Item, and, optionally, Vendor Creates Notice Item for Vendor Item if Item and Vendor Item not found
NDC Number Creates Notice Item from Item based on NDC associated with Item NA Creates Notice Item for NDC Number if Item not found
GTIN Creates Notice Item from Item based on GTIN associated with Item NA NA
SKU Creates Notice Item from Item based on SKU associated with Item NA NA
UPN1 Creates Notice Item from Item based on UPN1 associated with Item NA NA
UPN2 Creates Notice Item from Item based on UPN2 associated with Item NA NA
UPC Creates Notice Item from Item based on UPC associated with Item NA NA

Product transaction query

The Product Transaction Query is run against product items for a single notice. This action is to determine whether any transactions or documents exist for the recalled items. Depending on the transaction or document, you can use Item, Vendor Item, Manufacturer Number or NDC Number to find the information.

Note:  When Vendor Item and Manufacturer Number are used, all of the non-alpha numeric characters are removed from Product Item and Transaction information. The non-alpha numeric characters are removed before attempting to find a match.

This table describes how Transactions and Documents are located:

Transaction or Document Product Item values Records selected
Requisition Lines Item = Item or Vendor Item = Vendor Item or Manufacturer Number = Manufacturer Number or Manufacturer Number = Item or NDC Number = Item (on Req Line) for special item Unreleased or Released requisitions where a Purchase Order or Shipment has not yet been created and creation date is within the query date range.
Purchase Order Lines Item = Item or Vendor Item = Vendor Item or Manufacturer Number = Manufacturer Number or Manufacturer Number = Item or NDC Number = Manufacturer Number or NDC Number = Item (on PO Line) for special item Non Stocks or Specials that were not fully canceled and inventory items where the quantity was not fully received or canceled. The search is performed for each company within the procurement group (item lifecycle management group) where the PO date falls within query date range
Inventory Item = Item Item location records that have stock on hand for each company within the item group (item lifecycle management group/procurement group).
Par Locations Item = Item Par items for each company within the item group (item lifecycle management group/procurementgroup).
Inventory Issue Transactions Item = Item Doc Types of IS for each company within the item group (item lifecycle management group/procurement group) where the transaction date is within the query date range.
Inventory Intransit Transfer Transactions Item = Item Doc Types of IR or IT and a System Code of IC for each company within the item group--item lifecycle management group/procurement group--where the transaction date is within the query date range.

Direct transfers are not shown, as they are already reflected in the Inventory balances.
Procurement Template Lines Item = Item or Manufacturer Number = Manufacturer Number Matches on item for the procurement group (item lifecycle management group).
Sourcing Event Lines Item = Item or Manufacturer Number = Manufacturer Number Matches on non-service items for all companies within procurement group (item lifecycle management/sourcing group) where the event line is not closed or canceled.
Contract Lines Item = Item or Vendor Item = Vendor Item or Manufacturer Number = Manufacturer Number Matches on non-service items for the procurement group (item lifecycle management group) where the contract line is not inactive or closed.