Company Info

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:

Import Template Download:

Import File Layout:

HeaderReferenceData TypeTabExampleDescription
filetypeRequiredPJJCHeaderPJJCPJJC
jobnumRequired **NumericHeaderJob Number
trndteRequiredDateHeaderyyyy-mm-ddTransaction Date
actgdteRequiredDateHeaderyyyy-mm-ddAccounting Posting Period
dscrptRequiredString(50)HeaderDescription
trnnumRequiredString(20)HeaderTransaction Number
cstcdeRequired **NumericHeaderCost Code
csttypRequired **NumericHeaderCost Type
cstamtNumeric (9,2)HeaderCost Amount
phsnum**NumericHeaderPhase
wrkord**String(20)HeaderWork Order Number
empnum**NumericEmployee / Vendor / EquipmentEmployee Number
paytyp**NumericEmployee / Vendor / Equipment0-None;1-Regular;2-Overtime;3-Premium;4-Sick;5-Vacation;6-Holiday;7-Piece;8-Per Diem;9-MiscellaneousPay Type
payrec**NumericEmployee / Vendor / EquipmentPay Record Number
csthrsNumeric (5,2)Employee / Vendor / EquipmentHours
piecesNumeric (9,2)Employee / Vendor / EquipmentPieces
grswgeNumeric (9,2)Employee / Vendor / EquipmentGross Wage
vndnum**NumericEmployee / Vendor / EquipmentVendor Number
eqpnum**NumericEmployee / Vendor / EquipmentEquipment Number
eqptyp**NumericEmployee / Vendor / Equipment0-None;1-Operated;2-Standby;3-IdleEquipment Type
eqpunt**NumericEmployee / Vendor / Equipment0-None;1-Hours;2-Days;3-Weeks;4-Months;5-MilesEquipment Unit
eqpqtyNumeric (5,2)Employee / Vendor / EquipmentEquipment Quantity
bllstsRequired **NumericTime and Materials Billing1-Open;2-Not Billable;3-BilledBilling Status
blgunt**NumericTime and Materials Billing0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles;6-Mobilization;7-Not BillableBilling Equipment Unit
blgqtyNumeric (5,2)Time and Materials BillingBilling Quantity
blgamtNumeric (9,2)Time and Materials BillingBilling Amount (1)
ovrrdeNumericTime and Materials Billing1=Yes;0=NoOverride Billing Amount
taxablNumericTime and Materials Billing1=Yes;0=NoSubject to Sales Tax
ntetxtTextHeaderNotes

Required(I) - required for inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields 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,dscrpt,trnnum,cstcde,csttyp,empnum,paytyp,csthrs,pieces,vndnum,eqpnum,eqptyp,eqpunt,eqpqty,bllsts,blgunt,blgqty,blgamt,ovrrde,taxabl
PJJC,1001,2000-01-01,"Description","ABC123",123.456,1,1,0,10,10,1,1,0,0,10,1,0,10,10,0,0
PJJC,1001,2000-01-01,"Description","ABC124",123.456,2,2,1,10,10,2,2,1,1,10,2,1,10,10,1,1


REQUEST A DEMO

System Requirements

Requires the Sage 100 Contractor Data Integration Suite