Loading UNSPSC codes

If you use UNSPSC codes, then this procedure explains how to load the UNSPSC codes using a CSV file. You can attach the codes to the Item Master records to create an item hierarchy. You must attach the UNSPSC code must to an item in the Item Master file to be active. This allows you to search on categories in Infor Lawson Requisition Center.

Place the CSV file in this directory and name the file that you want. The layout is:

UNIX users: $LAWDIR/productline/interface directory

Windows NT users: %LAWDIR%\productline \interface directory\

IBMi users: LAWDIR/productline /interface directory

Field Max size
SEGMENT 2
FAMILY 2
CLASS 2
COMMODITY 2
CODE-SDESC 20
CODE-LDESC 250

To load UNSPSC codes, complete these steps:

  1. Access Load UNSPSC Product Codes (IC516).
  2. Specify the name of the file to import. If left blank, then the default file name of ICITEMCODECSV is used.
  3. Specify or select the item groups that the imported codes should be assigned to. The process can be re-run for additional item groups.
  4. Select Yes in the Report Only field to review what will be produced. No records will be updated if you select Yes. Select No if you want to update without reviewing the report.