Learn more

Standard Database Settings setup form

Fill out one copy of this form.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Job cost tab

$image\onestep.gif$ Job cost interface type (choose one):
Sage 300 Construction None

Complete the appropriate table (below) based on the interface type you selected. If you chose None, no additional entries are needed for this tab.

Sage 300 Construction Job Cost interface

Field Entry

Use Sage 300 Constructions Job Cost data

Select this option if you want to import
(cost codes, categories, etc) information from Job Cost.

Use the same format for Sage Estimating

(Select this check box to use the same format
and job cost phase codes for Sage Estimating and job cost phase codes.)

Transfer crew units as man hours Select this check box to convert crew units to man hours
during the transfer.

Job Cost phase suffix 0 digits 1 digit 2 digits 3 digits

Job Cost cost categories:

Labor ________________ Prefills with: LAB

Material ________________ Prefills with: MAT

Subcontract ________________ Prefills with: SUB

Equipment ________________ Prefills with: EQU

Other ________________ Prefills with: OTH

Export folder

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Miscellaneous tab (Estimating Standard)

Field Entry

Sage Estimating phase code suffix 0 digits 1 digit 2 digits 3 digits
Work Breakdown Structure (WBS):
Description (up to 10 characters) ____________________________________
Size (from 1 to 20 characters)_________

Labor/Equipment:
Hours per day _________ Prefills with: 8.0
Hours per week _________ Prefills with: 40.0
Hours per month _________ Prefills with: 173.33
Multiple Labor Productivities:	¨ Select this option if you want to use multiple labor productivity tables
When there is no labor productivity on the specified table	Choose one: ____ Use the labor productivity on the standard database item ____ Leave blank
Multiple Price:	¨Select this option if you want to use multiple price tables
When there is no price on the specified table	Choose one: ____ Use the price on the standard database item ____ Leave blank

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Miscellaneous tab

Field Entry

Sage Estimating phase code suffix 0 digits 1 digit 2 digits 3 digits

Labor/Equipment:
Hours per day _________ Prefills with: 8.0
Hours per week _________ Prefills with: 40.0
Hours per month _________ Prefills with: 173.33
Multiple Labor Productivities:	Select this option if you want to use multiple labor productivity tables
When there is no labor productivity on the specified table	Choose one: ____ Use the labor productivity on the standard database item ____ Leave blank
Multiple Price:	Select this option if you want to use multiple price tables
When there is no price on the specified table	Choose one: ____ Use the price on the standard database item ____ Leave blank

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Crew pricing tab

Field Entry

Default labor rate table (enter the table name)

Default equipment rate table (enter the table name)

Default crew pricing: Average cost per person Total cost of crew

Reporting hours: Man hours Crew hours

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

WBS tab

WBS Code \| Name \| Size \| Unit	Type (check one)
	1 Detail Item Takeoff
	2 Detail Item Takeoff
	3 Detail Item Takeoff
	4 Detail Item Takeoff
	5 Detail Item Takeoff
	6 Detail Item Takeoff
	7 Detail Item Takeoff
	8 Detail Item Takeoff
	9 Detail Item Takeoff
	10 Detail Item Takeoff
	11 Detail Item Takeoff
	12 Detail Item Takeoff
	13 Detail Item Takeoff
	14 Detail Item Takeoff
	15 Detail Item Takeoff
	16 Detail Item Takeoff
	17 Detail Item Takeoff
	18 Detail Item Takeoff
	19 Detail Item Takeoff
	20 Detail Item Takeoff
	21 Detail Item Takeoff
	22 Detail Item Takeoff
	23 Detail Item Takeoff
	24 Detail Item Takeoff
	25 Detail Item Takeoff
	26 Detail Item Takeoff
	27 Detail Item Takeoff
	28 Detail Item Takeoff
	29 Detail Item Takeoff
	30 Detail Item Takeoff
	31 Detail Item Takeoff
	32 Detail Item Takeoff
	33 Detail Item Takeoff
	34 Detail Item Takeoff
	35 Detail Item Takeoff
	36 Detail Item Takeoff
	37 Detail Item Takeoff
	38 Detail Item Takeoff
	39 Detail Item Takeoff
	40 Detail Item Takeoff

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Item Sorting tab

Item Sort Number and Description sort elements (choose up to four)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Productivities/Prices tab

This tab is available when you select to use multiple labor productivities or prices on the Miscellaneous tab.

Labor Productivity Tables

Price Tables

Name \| Description \| Source \| Default \| Source Web Address
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20