Sage 100 Contractor 3-5 Job Contacts
Overview:
Import Job Contacts directly into Sage 100 Contractor. Simply download your job contacts into Excel, review and apply job contact information and import directly into Sage 100 Contractor 3-5 Job Contacts.
Are you tired of manually keying in Job Contacts one by one into Sage 100 Contractor? Would you rather download your job 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 3-5 Job Contacts data entry form.
Key Features:
- Download Job Contacts into Excel
- Edit key job contact information in Excel
- Bulk import job contacts directly into Sage 100 Contractor
- Supports all native features and functions of the 3-5 Job Contacts Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | ARJOBCONT | ARJOBCONT | ARJOBCONT | |
| recnum | Required | Numeric | Contacts | 2019021 | Job 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
ARJOBCONT,2017504,"Steve Harold","President"
ARJOBCONT,2017504,"Mark Rice","Manager"