Importing new price and discount records from Excel

Use these instructions to import records from an Excel spreadsheet. Include only those records that you want to process in the import file. If you specify a customer/ship to for the import set, that value is used. It overrides the customer/ship to specified in the import file. If you do not specify a customer/ship to, the customer/ship to from the imported file is used.
  1. Select Pricing and Discounting > EntryMass Maintenance.
  2. Click Import Excel with New Records.
  3. Specify the import file information and click OK.
  4. Specify the information for the import set and click Add.
  5. After you create all of your import sets, click OK.
  6. A message is displayed indicating that the set import is complete; click Close. You can now process the set.
  7. If the import fails, the errors are displayed in a message window. Correct the errors in the spreadsheet and repeat the import.
Related topics