Company Info

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:

Import Template Download:

Import File Layout:

HeaderReferenceData TypeTabExampleDescription
filetypeRequiredAPVENDCERTAPVENDCERTAPVENDCERT
recnumRequiredNumericCertificates231Vendor No
dscrptRequiredString (50)CertificatesGeneral LiabilityCertificate Description (1)
expdteRequiredDateCertificatesYYYY-MM-DDExpires
jobnum**NumericCertificatesJob No
dtercvDateCertificatesYYYY-MM-DDDate Received
cntwrnString (1)CertificatesY=Yes; N=NoWarning
stppayString (1)CertificatesY=Yes; N=NoStop Pay
ntetxtTextCertificatesNotes

** 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",,"","","",""


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite