Use this screen to modify existing serial/lot information and correct any discrepancies that may occur between the serial/lot inventory tables and the standard inventory location tables. This utility is not intended to be used as a standard data entry screen for loading serial/lot information.
Run this process when you need to rectify serial/lot discrepancies.
Enter, or use the binoculars icon to select, a part number for which serial/lot modification is required.
Enter, or use to select, a revision number of the part for which serial/lot modification is required.
This field displays the unit of measure for the part/revision entered.
This group box displays the tracking requirement for the part as in the part master.
This field displays either Y (Yes) or N (No) depending on whether or not lot tracking is required.
This field displays either Y (Yes) or N (No) depending on whether or not serial tracking is required.
Enter up to 20 alphanumeric characters for the internal serial number for the part.
Enter up to 20 alphanumeric characters for the internal lot number for the part.
Enter P if the serial/lot originated from a purchase order, or M if it originated from a manufacturing order.
Enter, or use to select, the PO or MO number from which the serial/lot originated.
Enter the PO release number from which the serial/lot originated.
Enter the PO line number from which the serial/lot originated.
Enter, or use to select, the transaction type from which the serial/lot originated.
Enter, or use to select, the warehouse from which the serial/lot originated.
Enter, or use to select, the transaction ID from which the serial/lot originated.
Enter the transaction line number from which the serial/lot originated.
Enter the date on which the serial/lot was created.
Enter the total quantity of the part/lot combination.
Enter the date on which the vendor's warranty expires for the serial/lot.
Enter the shelf life expiration date for the serial/lot.
Enter, or use to select, the ID of the manufacturer who created the serial/lot. This field can be up to 10 alphanumeric characters.
This field is automatically loaded once the Manufacturer ID is entered.
Enter, or use to select, the manufacturer part number for the serial/lot. This is loaded if you entered the Original Order and it displays the manufacturer part number. This field can be up to 30 alphanumeric characters.
Enter the manufacturer revision number for this serial/lot. This is automatically displayed if the Manufacturer Part field is populated. This field can be up to three alphanumeric characters.
Enter, or use to select, the ID of the vendor who supplied the serial/lot. This field can be up to 12 alphanumeric characters.
This field is automatically loaded after the Vendor ID is entered.
Enter, or use to select, the vendor part number for the serial/lot. This field can be up to 30 alphanumeric characters.
Enter the vendor revision number for the serial/lot. This is automatically displayed if Vendor Part is populated. This field can be up to three alphanumeric characters.
Enter the manufacturer/vendor serial number for the part. This can be up to 20 alphanumeric characters.
Enter any free-form text associated with this serial/number.
Enter the manufacturer/vendor lot number for the part. This can be up to 20 alphanumeric characters.
This field displays additional information required for the first user-defined field, which is established in the Serial/Lot User-Defined Labels screen.
This field displays additional information required for the second user-defined field, which is established in the Serial/Lot User-Defined Labels screen.
This field displays additional information required for the third user-defined field, which is established in the Serial/Lot User-Defined Labels screen.
This field displays additional information required for the fourth user-defined field, which is established in the Serial/Lot User-Defined Labels screen.
This field displays additional information required for the fifth user-defined field, which is established in the Serial/Lot User-Defined Labels screen.
Enter, or use to select, the valid configuration ID for the item. The configuration is established in the Configuration Identifiers (Materials » Bills of Material » Bills of Material Controls) screen.
Enter, or use to select, a valid routing number for the item, if routing is required when building this serial/lot.
Enter the Bills of Material as-of used date when building this serial/lot.
Enter, or use to select, the vendor warranty code assigned by the vendor.
Enter the date on which the vendor's warranty began for this serial/lot.
Enter, or use to select, the warranty code assigned to the customer.
Enter the date on which the customer's warranty began for this serial/lot.
Enter the date on which the customer's warranty expires for this serial/lot.
Enter the sales order tag number for this serialized item.
Enter Y (Yes) or N (No) to indicate whether the customer has purchased maintenance for this item.
Enter, or use to select, the sales order number for the maintenance provided to the customer.
Enter the sales order release for the maintenance provided to the customer.
Enter, or use to select, the sales order line for the maintenance provided to the customer.
If a Unique Item Identifier already exists for the selected row, it displays in this field.
Initially, this field has no default value. If you auto-generate a UID for this row, this field populates with information entered in the Unique Item Identification (UID) subtask of the Serial/Lot Settings (Materials » Inventory » Inventory Controls) screen. If you enter a type not listed in the table, a warning displays but you are still able to make your entry.
Enter or use to select the UID Type from those existing in the system maintained table. Current UID Types maintained in the system are:
ESN - Electronic Serial Number (Telecommunications Industry Association)
GIAI - EAN.UCC Global Individual Asset Identifier
GRAI - EAN.UCC Global Returnable Asset Identifier
OTHER - For UIDs without an assigned UID Type
UID1 - Unique Identification Construct 1, Serialization within the Enterprise
UID2 - Unique Identification Construct 2, Serialization within the Original Part
VIN - Vehicle Identification Number
If you plan to use auto-generation for the UID, you must select UID1 or UID2. This selection determines the method used to auto-generate the remainder of the UID code. These selections generate results as follows:
UID1 – Select this option when the Unique Across Parts serial tracking option is selected in the Serial/Lot Settings (Materials » Inventory » Inventory Controls) screen. Since serial numbers are unique for all "individual" parts, the UID does not include the part number within it. The generated UID consists of the UID prefix followed by the serial number.
UID2 – Select this option when the Unique By Part serial tracking option is selected in the Serial/Lot Settings (Materials » Inventory » Inventory Controls) screen. Parts could have the same serial number. This option includes the part number within the UID in order to make it unique. The generated UID consists of the UID prefix, followed by the part number, followed by the serial number.
Initially, this field has no default value. If you auto-generate a UID for this row, this field populates with information entered in the Unique Item Identification (UID) subtask of the Serial/Lot Settings (Materials » Inventory » Inventory Controls) screen. You can manually enter your assigned Issuing Agency Code (IAC) or modify the code displayed but a warning displays if the row has a previously saved UID code.
Initially, this field has no default value. If you auto-generate a UID for this row, this field populates with information entered in the Unique Item Identification (UID) subtask of the Serial/Lot Settings (Materials » Inventory » Inventory Controls) screen. You can manually enter your assigned Enterprise Identifier (EI) code or modify the code displayed but a warning displays if the row has a previously saved UID code.
Click this button to view or modify quantity information for the serial/lot.
Click this button to auto-generate a UID for the selected row.
The PART and SERIAL_LOT tables store the settings from this screen. This screen also relies on the settings in the INVT_SETTINGS table. Information is also stored in and/or pulled from the following tables: ALT_PART, BOM_CONFIG, INVT_TRN_LN_SR_LT, INVT_WHS_LOC_SR_LT, MANUF, MO_SERIAL_LOT, PO_HDR, PO_LN, ROUTING_HDR, SO_ISS_SERIAL_LOT, SO_LN, VEND, WARRANTY.