Vendor Import Template
Use the Vendor Import Template in conjunction with the Import Setup Data screen function to import vendor information.
- Vendor
- Address
- Joint Payee
- Contact
- Taxes
- Compliance
- UDF
In most cases, each worksheet corresponds directly to a tab of the related entry screen. Required fields in a worksheet are highlighted yellow; fields that are required only under certain conditions are highlighted gray. Viewpoint suggests formatting all values as text in the Excel template.
Include the primary information for the records you want to import on the first worksheet, ensuring that that each record has unique values in the key fields for the import type. For most import types, the first worksheet is the only worksheet that is required. Use the additional worksheets as needed to provide record details. When importing, the application uses the key fields for the import type to prevent duplicate records and to link detail records to primary records.
For example, the key field for the Vendor import type is Vendor. In the Vendor import template, include each new vendor in the Vendor worksheet, ensuring that each record has a unique value in the Vendor. If needed, include details for those vendors (such as addresses, contacts, or tax authority settings) in the additional worksheets.
Vendor Worksheet
| Vendor | Vendor Name | One Time Vendor | Sort Name | Payment Terms | Sales Tax Authority | Default Invoice Status | 1099 Type | One Check Per Invoice | Check Reference Indicator | Only Print Details on Supplement Stub | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | TAY100 | Taylor Fuel | No | TAYLOR FUELS | N30 | NT | Open | None | No | Project Name | No |
| 2 | RW200 | R&W Steel | No | R&W STEEL | N30 | NT | Open | None | No | Project | No |
Address Worksheet
| Vendor | Address Type | Street 1 | Street 2 | City | State | Zip | Country | |
|---|---|---|---|---|---|---|---|---|
| 1 | TAY100 | Remit To | 2 Maple St | Philadelphia | PA | 19101 | United States | |
| 2 | RW200 | Remit To | 315 Main St | Springfield | PA | 19064 | United States |
If a detail record does not match a primary record based on key field values, the application marks the detail record as “orphaned” during the validation process. If you continue with the import without correcting orphaned records in the import file, you must manually enter the orphaned records into the system.
Importing vendors is part of vendor setup. Before importing vendors, you must complete the following setup:
- Accounts Payable Settings
- Purchasing Settings
These steps must be performed manually.
