Skip to content
logo Knowledgebase

How to import a vendor list

Created on  | Last modified on 

Summary

Importing a vendor list.

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

  1. Make sure the file you are trying to import is in .CSV format.
  2. Make a back up of your company data.
  3. Go to File and click Select Import/Export.
  4. On the left select Accounts Payable.
  5. In the list of items that can be imported (on the right) select Vendor List and then click the Import icon.
  6. On the Fields tab, make sure that only the columns with the information you are importing are selected and that they are in the same order as they are in your .CSV file.
  7. Go to the Options tab and click the box with the triangle in it and then locate and select the file you are importing, then click Open.
  8. If your file contains headings on the first row, select First Row Contains Headings under Import Options.
  9. Click OK and your vendor list will be imported.

Note: For importing and field criteria, please go to Help, Sage 50 Help, click on Index tab, and type in Import, and double-click on Vendor list.

How to import data