Sage 100 Contractor 4-4 Vendor Contacts
Overview:
Import Vendor Contacts directly into Sage 100 Contractor. Simply download your vendor contacts into Excel, review and apply vendor contact information and import directly into Sage 100 Contractor 4-4 Vendor Contacts.
Are you tired of manually keying in Vendor Contacts one by one into Sage 100 Contractor? Would you rather download your vendor contacts, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 4-4 Vendor Contacts data entry form.
Key Features:
- Download Vendor Contacts into Excel
- Edit key vendor contact information in Excel
- Bulk import vendor contacts directly into Sage 100 Contractor
- Supports all native features and functions of the 4-4 Vendor Contacts Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | APVENDCONT | APVENDCONT | APVENDCONT | |
| recnum | Required | Numeric | Contacts | 231 | Vendor No |
| cntnme | Required | String (50) | Contacts | John Doe | Contact Name |
| jobttl | String (50) | Contacts | President | Job Title | |
| phnnum | String (14) | Contacts | Phone No | ||
| phnext | String (6) | Contacts | Phone Ext | ||
| e_mail | String (75) | Contacts | jdoe@gmail.com | ||
| cllphn | String (14) | Contacts | Cell Phone | ||
| faxnum | String (14) | Contacts | Fax No | ||
| othphn | String (14) | Contacts | Other Phone | ||
| othdsc | String (50) | Contacts | Other Description | ||
| ntetxt | Text | Contacts | Notes |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
File Example:
filetype,recnum,cntnme,jobttl
APVENDCONT,2017504,"Steve Harold","President"
APVENDCONT,2017504,"Mark Rice","Manager"