Sage 100 Contractor 3-6 Client Locations
Overview:
Import Client Locations directly into Sage 100 Contractor. Simply download your client locations into Excel, review and apply client location information and import directly into Sage 100 Contractor 3-6 Client Locations.
Are you tired of manually keying in Client Locations one by one into Sage 100 Contractor? Would you rather download your client locations, 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-6 Client Locations data entry form.
Key Features:
- Download Client Locations into Excel
- Edit key client location information in Excel
- Bulk import client locations directly into Sage 100 Contractor
- Supports all native features and functions of the 3-6 Client Locations Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | ARCLLOC | ARCLLOC | ARCLLOC | |
| recnum | Required ** | Numeric | Locations | 123 | Client No |
| locnum | Required | Numeric | Locations | Location No | |
| locnme | Required (I) | String (50) | Locations | jdoe@gmail.com | Location Name |
| addrs1 | String (50) | Locations | Address 1 | ||
| addrs2 | String (50) | Locations | Address 2 | ||
| ctynme | String (50) | Locations | City | ||
| state_ | String (2) | Locations | State | ||
| zipcde | String (10) | Locations | Zipcode | ||
| phnnum | String (14) | Locations | Phone | ||
| contct | String (50) | Locations | Contact | ||
| srvgeo | ** | Numeric | Locations | Service Area | |
| maploc | String (10) | Locations | Map Location | ||
| crsstr | String (50) | Locations | Cross Street | ||
| taxdst | ** | Numeric | Locations | Tax District | |
| usrdf1 | String (50) | Locations | User Defined | ||
| ntetxt | Text | Locations | Notes |
Required(I) - required for Inserts only
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
File Example:
filetype,recnum,locnum,locnme,addrs1,addrs2,ctynme,state,zipcde,phnnum,contct,srvgeo,maploc,crsstr,taxdst,usrdf1,ntetxt
ARCLLOC,123,1,"Location 1","111 Blueberry St.","","Carson","CA","92526","","",,"","",,"",""
ARCLLOC,123,2,"Location 2","222 Curry Ln","","Oakland","CA","92687","","",,"","",,"",""
ARCLLOC,123,3,"Location 3","333 Fairmore St.","","Fairmore","CA","92102","","",,"","",,"",""