To import a supplier catalog using Lawson Spreadsheet Designer
- Create the contract import header file in contract management:
- Access Utilities > Contract Import.
- From the Actions menu, select Create.
- On Create Contract Import, complete at least the required fields:
Contract Group, Contract Import name, Supplier, Supplier Contact, Contract Type, Contract Classification
- Select Save.
- 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.
-
- Import contract line records.
In Lawson Spreadsheet Designer, use the Upload button to upload your contract import records.