Sage 100 Contractor 4-4 Vendor Certificates
Overview:
Import Vendor Certificates directly into Sage 100 Contractor. Simply download your vendor certificates into Excel, review and apply vendor certificate information and import directly into Sage 100 Contractor 4-4 Vendor Certificates.
Are you tired of manually keying in Vendor Certificates one by one into Sage 100 Contractor? Would you rather download your vendor certificates, 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 Certificates data entry form.
Key Features:
- Download Vendor Certificates into Excel
- Edit key vendor certificate information in Excel
- Bulk import vendor certificates directly into Sage 100 Contractor
- Supports all native features and functions of the 4-4 Vendor Certificates Entry Form
Import Template Download:
Import File Layout:
| Field | Reference | Data Type | Tab | Example | Description |
| filetype | Required | APVENDCERT | APVENDCERT | (File Type Code) | |
| recnum | Required | Numeric | Certificates | 231 | Vendor No |
| dscrpt | Required (1) | String (50) | Certificates | General Liability | Certificate Description |
| expdte | Required | Date | Certificates | YYYY-MM-DD | Expires |
| jobnum | ** | Numeric | Certificates | Job No | |
| dtercv | Date | Certificates | YYYY-MM-DD | Date Received | |
| cntwrn | String (1) | Certificates | Y=Yes; N=No | Warning | |
| stppay | String (1) | Certificates | Y=Yes; N=No | Stop Pay | |
| ntetxt | Text | Certificates | Notes |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
(1) The description field is treated as a key field and therefore considered to be unique and not used more than once. When updating records the "Description" is used in determining which row to update. If the description is not found then a new record will be created if "Inserts" are allowed.
File Example:
filetype,recnum,dscrpt,expdte,jobnum,dtercv,cntwrn,stppay,ntetxt
APVENDCERT,231,"General Liability","12/31/2020",,"","","",""
APVENDCERT,231,"Workers Compensation","11/30/2020",,"","","",""