To import a supplier catalog using Lawson Spreadsheet Designer

  1. Create the contract import header file in contract management:
    1. Access Utilities > Contract Import.
    2. From the Actions menu, select Create.
    3. On Create Contract Import, complete at least the required fields:

      Contract Group, Contract Import name, Supplier, Supplier Contact, Contract Type, Contract Classification

    4. Select Save.
  2. Prepare a Microsoft Excel spreadsheet for contract import

    • Make sure your spreadsheet includes at least the following columns that represent ContractGroup, ContractImport, VendorItem, BaseCost, UOM.

    • If you are updating existing contract import line records, include ContractLineImport (line number)

    • On the Upload Definition window, select the ContractLineImport business class

    • Optional. Map the columns in your worksheet to the fields in the class. Columns will map automatically if you have column headers corresponding to the field names.

  3. Import contract line records.

    In Lawson Spreadsheet Designer, use the Upload button to upload your contract import records.