Company Info

Sage 100 Contractor 6-7-1 Subcontracts

Overview:

Import Subcontracts directly into Sage 100 Contractor. Simply download your subcontracts into Excel, review and apply subcontract information and import directly into Sage 100 Contractor 6-7-1 Subcontracts.

Are you tired of manually keying in Subcontracts one by one into Sage 100 Contractor? Would you rather download your subcontracts, 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 6-7-1 Subcontracts data entry form.

Key Features:

Import Template Download:

Import File Layout:

Header
COL1RequiredString (4)PJSCPJSC
COL2RequiredString (1)HHeader Record
COL3RequiredString (20)Contract No
COL4RequiredDateyyyy-mm-ddSubcontract Date
COL5Required **NumericVendor
COL6Required **NumericJob No
COL7RequiredString (50)Subcontract Description
COL8**NumericJob Phase No
COL9**NumericCost Division
COL10String (50)User Def 1
COL11String (50)User Def 2
COL12**Numeric1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-ClosedStatus
COL13**NumericType
COL14Dateyyyy-mm-ddApproved Date
COL15Dateyyyy-mm-ddSched Start Date
COL16Dateyyyy-mm-ddSched End Date
COL17Dateyyyy-mm-ddActual Start Date
COL18Dateyyyy-mm-ddSubst Complete Date
COL19Dateyyyy-mm-ddActual Finish Date
COL20Numeric (10,2)Retention
COL21Numeric (10,2)Bid Bond
COL22Numeric (10,2)Perf. Bond
COL23Numeric1=Yes;0=NoHot List
COL24Numeric1=Yes;0=NoHold Payment
COL25Numeric1=Yes;0=NoLock Edit
COL26TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided

Details
COL1RequiredString (4)PJSCPJSC
COL2RequiredString (1)DDetail Record
COL3RequiredString (20)(same as header)Contract No
COL4RequiredString (50)Line Description
COL5Required **Numeric(9,3)Cost Code
COL6Required **Numeric1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udfCost Type
COL7Numeric(10,2)Line Amount
COL8String (1)Y or N for Canada; blank for USSubject to GST (Canada)
COL9String (1)Y or N for Canada; blank for USSubject to PST (Canada)
COL10String (1)Y or N for Canada; blank for USSubject to HST (Canada)
COL11String (50)User Defined
COL12TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided


File Example:
PJSC,H,CN-101,2019-07-05,231,2017008,CN Contract 101,,,udf1,udf2,1,,,,,,,,,,,,,,
PJSC,D,CN-101,Line 1,2120.000,4,99,,,,udf line 1,notes
PJSC,D,CN-101,Line 2,2140.000,4,58,,,,udf line 2,notes


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite