1. SCM (Supply Chain Management)
  2. Item Record Management
  3. Item Types
  4. Lot Numbered Items
  5. Lot Auto Numbering SuiteApp
  6. Creating Additional Lot Fields
  7. Mapping Additional Lot Fields to Selected Items

Mapping Additional Lot Fields to Selected Items

Use the following procedure to map additional lot fields to specific items.

To map additional lot fields to selected items:

  1. Go to Lists > Lot Auto Numbering > Additional Lot Fields.

  2. Click Edit.

  3. Click the Item–Element Mapping button.

  4. In the popup window, do one of the following to select items for mapping:

    • From the Items list, select the items to which you want to map the elements.

    • If you have a saved search to select items, you can use the saved search. Choose the Select Items Using Saved Search radio button and then select a saved search from the Saved Search for Selecting Items list.

      Note:

      The Saved Search for Selecting Items list filters the saved searches locked by any other SuiteApp.

  5. In the Elements sublist, make the following selections:

    1. From the Element list, select the item number field that you want to use as additional lot field.

      To create item number field, see Create Item Number Fields.

    2. From the Purchase Order list, select the applicability of the element in a purchase order.

    3. From the Work Order list, select the applicability of the element in a work order.

    4. Click Add.

    5. To add more fields, repeat Steps a to d.

  6. Click Submit.

    A banner shows the progress of the mapping. When the mapping is complete, the banner provides a link to view the mapping report. Depending on the system resources and concurrency limit, you may face delay in item element mapping appearing in the item record.

    Depending on the selection in the purchase order and work order columns, the additional lot fields appear as columns in the Inventory Detail popup window.

You can also map elements to an item from the Item Additional Lot Fields sublist in Lot Numbering subtab of the item record.

Map Additional Lot Fields Using CSV Import

You can use the CSV import feature to map additional lot fields with items. The import type is Custom Records and record type is Item Additional Lot Fields. When using CSV import, you must:

  • Choose Add as the Data Handling option.

  • Check the Run Server SuiteScript and Trigger Workflows box.

For more information about the CSV import feature, see CSV Imports Overview.

Guidelines for Mapping Additional Lot Fields to Matrix Items

When mapping additional lot fields to matrix items, note the following:

  • When you map additional lot fields to matrix items using CSV import and include the parent item in the import, the subitems are automatically mapped.

  • For matrix items, the additional lot fields defined in Item Additional Lot Fields sublist of the parent item are not propagated to the child items.

  • You can map item lot information using CSV import for only existing matrix items and subitems. The CSV import feature cannot map item lot information for parent-child relationships that are not created before import.

  • When you map a parent matrix item using CSV import, the SuiteApp can map up to 499 child items.

Related Topics

Creating Additional Lot Fields

General Notices