Overview:
Import Change Orders directly into Sage 100 Contractor. Simply download your change orders into Excel, review and apply
change order information and import directly into Sage 100 Contractor 6-4-1 Change Orders.
Are you tired of manually keying in Change Orders one by one into Sage 100 Contractor? Would you rather download your change orders,
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-4-1 Change Orders data entry form.
Key Features:
- Download Change Orders into Excel
- Edit key change order information in Excel
- Bulk import change orders directly into Sage 100 Contractor
- Supports all native features and functions of the 6-4-1 Change Orders Entry Form
Import Template Download:
Import File Layout:
Header
Column | Reference | Data Type | Tab | Example | Description |
COL1 | Required | String (6) | Header | PJCO | (File Type Code) |
COL2 | Required | String (1) | Header | H | Header Record |
COL3 | Required ** | Numeric | Header | | Job No |
COL4 | Required | String (20) | Header | | CO Number |
COL5 | Required | Date | Header | yyyy-mm-dd | CO Date |
COL6 | Required | String (50) | Header | | CO Description |
COL7 | Required ** | Numeric | Header | 1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected | CO Status |
COL8 | ** | Numeric | Header | | Job Phase No |
COL9 | | String (50) | Header | | CO Reason |
COL10 | | String (50) | Header | | User Def 1 |
COL11 | | String (50) | Header | | User Def 2 |
COL12 | | String (30) | Header | | Client PO No |
COL13 | | Date | Header | yyyy-mm-dd | Submitted Date |
COL14 | | Date | Header | yyyy-mm-dd | Approved Date |
COL15 | | Date | Header | yyyy-mm-dd | Invoiced Date |
COL16 | | Numeric | Header | | Delay Request Days |
COL17 | | Numeric | Header | | Delay Approved Days |
COL18 | ** | Numeric | Header | | Change Type |
COL19 | | String (50) | Header | | Submitted To |
COL20 | ** | Numeric | Header | | Submitted By |
COL21 | | Numeric | Header | 1=Yes;0=No | Hot List |
COL22 | | Numeric | Header | 1=Yes;0=No | Lock Edit |
COL23 | | Numeric | Header | 1=Yes;0=No | Upgrade |
COL24 | | Text | Header | | Notes |
** 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
Prime Change Details
COL1 | Required | String (6) | Prime | PJCO | PJCO |
COL2 | Required | String (1) | Prime | P | Prime Detail Record |
COL3 | Required | Numeric | Prime | | Job No |
COL4 | Required | String (20) | Prime | | CO Number |
COL5 | Required | String (50) | Prime | | Line Description |
COL6 | | Numeric (10,2) | Prime | | Estimated Amount |
COL7 | | Numeric (10,2) | Prime | | O/H Rate |
COL8 | | Numeric (10,2) | Prime | | Profit Rate |
COL9 | (1) | Numeric (10,2) | Prime | | Requested |
COL10 | Required | Numeric (10,2) | Prime | | Approved Amount |
COL11 | Required | Numeric(9,3) | Prime | | Cost Code |
COL12 | Required ** | Numeric | Prime | | Cost Type |
COL13 | | String (50) | Prime | | User Defined |
COL14 | | Text | Prime | | Notes |
** 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
(1) If O/H Rate or Profit Rate then Request Amt is Calced
Budget and Sub Change Details
COL1 | Required | String (6) | Subcontract | PJCO | PJCO |
COL2 | Required | String (1) | Subcontract | S | Prime Detail Record |
COL3 | Required | Numeric | Subcontract | | Job No |
COL4 | Required | String (20) | Subcontract | | CO Number |
COL5 | Required | String (50) | Subcontract | | Line Description |
COL6 | | Numeric (6,2) | Subcontract | | Budget Hours |
COL7 | | Numeric (8,4) | Subcontract | | Budget Units |
COL8 | | Numeric (8,4) | Subcontract | | Budget Amount |
COL9 | ** (1) | Numeric | Subcontract | | Vendor |
COL10 | ** (2) | Numeric | Subcontract | | Subcontract |
COL11 | ** (3) | Numeric | Subcontract | | Subcontract Line No |
COL12 | (4) | String (20) | Subcontract | | Change No |
COL13 | ** (5) | Numeric | Subcontract | 1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected | Line Status |
COL14 | | Date | Subcontract | | Line Change Date |
COL15 | Required ** | Numeric(9,3) | Subcontract | | Cost Code |
COL16 | Required ** | Numeric | Subcontract | | Cost Type |
COL17 | | String (50) | Subcontract | | User Defined |
COL18 | | Text | Subcontract | | Notes |
COL19 | | Numeric (5,2) | Subcontract | | Overhead Rate |
** 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
(1) Vendor No is required if a subcontract is Entered
(2) Subcontract No is required if a vendor is Entered
(3) If a Subcontract No is entered and and a contract line is not entered a new line will be added to the contract
(4) Change No is required if a subcontract is Entered
(5) Change Status is required if a subcontract is Entered otherwise 0
File Example:
PJCO,H,2017008,CO-2,2019-07-07,Test CO 2,1,,,udf1,udf2,PO2,,,,,,,,,,,,notes
PJCO,P,2017008,CO-2,prime line 1,100,5,10,115.5,100,2020.000,4,udf1,notes
PJCO,P,2017008,CO-2,prime line 2,200,10,10,242,206.04,2010.000,4,udf1,notes
PJCO,S,2017008,CO-2,sub line 1,0,0,150,231,108,1,1,1,44197,2120.000,4,udf1,notes,1
PJCO,S,2017008,CO-2,sub line 2 no contract,0,0,300,,,,,1,44197,2120.000,4,udf1,notes,1