Import Vendors
This preprocessor provides a means of transferring vendor data from an ASCII input file or database table into Costpoint.
This data transfer process automates the input of multiple vendor or vendor address records. This is useful when transferring large scale data from another system but are being migrated to Costpoint.
Before you can use this preprocessor, you must set up the following screens:
- Manage Accounts Payable Accounts
- Manage Cash Accounts
There are two ways to work with input files in Costpoint:
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click
in the
File Location field to select an alternate file location. If you choose the second option, leave the
File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
If you want to remove or deactivate a Ship ID for a vendor, you can do so on the Manage Vendors screen and not on the Import Vendors screen.
Input File Excel Template
Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.