Sage 100 Contractor 6-3 Job Costs
Overview:
Import Job Costs directly into Sage 100 Contractor. Simply download your job costs into Excel, review and apply job cost information and import directly into Sage 100 Contractor 6-3 Job Costs.
Are you tired of manually keying in Job Costs one by one into Sage 100 Contractor? Would you rather download your job costs, 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-3 Job Costs data entry form.
Key Features:
- Download Job Costs into Excel
- Edit key job cost information in Excel
- Bulk import job costs directly into Sage 100 Contractor
- Supports all native features and functions of the 6-3 Job Costs Entry Form
Import Template Download:
Import File Layout:
| Field | Reference | Data Type | Tab | Example | Description |
| filetype | Required | PJJC | Header | PJJC | (File Type Code) |
| jobnum | Required [*] ** | Numeric | Header | Job Number | |
| trndte | Required | Date | Header | yyyy-mm-dd | Transaction Date |
| actgdte | Required | Date | Header | yyyy-mm-dd | Accounting Posting Period |
| dscrpt | Required | String(50) | Header | Description | |
| trnnum | Required [*] | String(20) | Header | Transaction Number | |
| cstcde | Required ** | Numeric | Header | Cost Code | |
| csttyp | Required ** | Numeric | Header | 1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=UDF6; 7=UDF7; 8=UDF8; 9=UDF9 | Cost Type |
| cstamt | Numeric (9,2) | Header | Cost Amount | ||
| phsnum | [*] ** | Numeric | Header | Phase Number | |
| wrkord | ** | String(20) | Header | Work Order Number | |
| empnum | ** | Numeric | Employee / Vendor / Equipment | Employee Number | |
| paytyp | ** | Numeric | Employee / Vendor / Equipment | Pay Type | |
| payrec | ** | Numeric | Employee / Vendor / Equipment | Pay Record Number | |
| csthrs | Numeric (5,2) | Employee / Vendor / Equipment | Hours | ||
| pieces | Numeric (9,2) | Employee / Vendor / Equipment | Pieces | ||
| grswge | Numeric (9,2) | Employee / Vendor / Equipment | Gross Wage | ||
| vndnum | ** | Numeric | Employee / Vendor / Equipment | Vendor Number | |
| eqpnum | ** | Numeric | Employee / Vendor / Equipment | Equipment Number | |
| eqptyp | ** | Numeric | Employee / Vendor / Equipment | 0-None;1-Operated;2-Standby;3-Idle | Equipment Type |
| eqpunt | ** | Numeric | Employee / Vendor / Equipment | 0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles | Equipment Unit |
| eqpqty | Numeric (5,2) | Employee / Vendor / Equipment | Equipment Quantity | ||
| bllsts | Required ** | Numeric | Time and Materials Billing | 1-Open;2-Not Billable;3-Billed | Billing Status |
| blgunt | ** | Numeric | Time and Materials Billing | 0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles;6-Mobilization;7-Not Billable | Billing Equipment Unit |
| blgqty | Numeric (5,2) | Time and Materials Billing | Billing Quantity | ||
| blgamt | (1) | Numeric (9,2) | Time and Materials Billing | Billing Amount | |
| ovrrde | Numeric | Time and Materials Billing | 1=Yes;0=No | Override Billing Amount | |
| taxabl | Numeric | Time and Materials Billing | 1=Yes;0=No | Subject to Sales Tax | |
| ntetxt | Text | Header | Notes |
[*] Key Fields - the combination of theses fields must be unique
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
(1) Override Billing Amount (ovrrde) must be set to 1 in order to set Billing Amount (blgamt)
File Example:
filetype,jobnum,trndte,actgdte,dscrpt,trnnum,cstcde,csttyp,cstamt,phsnum,wrkord,empnum,paytyp,payrec,csthrs,pieces,grswge,vndnum,eqpnum,eqptyp,eqpunt,eqpqty,bllsts,blgunt,blgqty,blgamt,ovrrde,taxabl
PJJC,2015034,2020-10-10,2020-10-10,"test2","1234a",2050.000,4,6500.00,0,"123",6,1,193,8.00,1.00,30.00,231,19103,1,1,4.00,1,0,4.00,4444.00,1,1
PJJC,150,2020-10-05,2020-10-05,"Medtronics description","ABC123b",3030.000,1,3000.00,0,"123",6,1,54,10.00,15.00,10.00,9,19102,1,1,17.00,1,1,10.00,3000.00,1,1