Sum Option

Use this field to specify the level of summarization for each sequence line using the specified template. If the summary options available do not include the detail needed on the invoice, select full detail (Option 1) for that sequence. Each source is summarized in a different manner.

Note: When initializing billings, the summary options defined for a template are used to determine billing rates. Rates defined at the highest level of detail override all other rates. For example, rates at the Craft/Class/Employee/EarnType/Factor/Shift level will override rates at the Craft/Class/Employee/Earn Type level.

If you use the ‘effective’ date functionality for labor rates, you have the option to summarize billings by rate, in addition to summarizing by a specified PR-Labor/Burden CT level. Using the ‘Include Rate in Summarization’ column in the chart below, locate the option that corresponds to the desired PR-Labor/Burden CT level and enter that in the Sum Opt field for the applicable sequence. For example, to summarize by craft/class/employee only, you would enter ‘2’ as the summary option. However, if you also want to summarize by rate, you would enter ‘102’ as the summary option. When billings are initialized, the system will summarize by craft, class, and employee, and where the rate has changed, add a separate bill line for transactions using the old rate (before effective date) and one for transactions using new rate (on or after effective date).The following table lists the summary levels available for each source:

Source

Sum Opt

Include Rate in Summarization

Description

All

1

Full detail. One invoice detail record per JC detail record.

99

Summary. One invoice detail record per source/CT/category.

PR - Labor/Burden CT

2

102

Craft/Class/Employee

3

103

Employee

4

104

Craft/Class

5

105

Craft/Class/Employee/Earn Type

6

106

Employee/Earn Type

7

107

Craft/Class/Earn Type

8

108

Earn Type

9

109

Craft/Class/Employee/Factor

10

110

Employee/Factor

11

111

Craft/Class/Factor

12

112

Factor

13

113

Craft/Liability Type

14

114

Liability Type

18

118

Craft/Class/Employee/Factor/EarnType (use Sort Level 13)

19

119

Craft/Class/Employee/Factor/Shift (use Sort Level 14)

20

120

Craft/Class/Factor/Shift (use Sort Level 14)

PR-Equipment CT

15

EMCo/Equip/EMGroup/RevCode/Craft/Class/Employee

16

EMCo/Equip/EMGroup/RevCode/Employee

17

EMCo/Equip/EMGroup/RevCode/Craft/Class

MaterialCT - not AP

2

Location/Material

3

Location

4/5/6

Material

MaterialCT - AP

2

Vendor/APRef/Material

3

Vendor/APRef

4

Vendor/Material

5

Vendor

6

Material

7

Vendor/APRef/PO/Item

8

Vendor/PO/Item

9

PO/Item

AP - Expense

2/3

Vendor/APRef

(not material or subcontract)

4/5

Vendor

7

Vendor/APRef/PO/Item

8

Vendor/PO/Item

9

PO/Item

AP - Subcontract CT

2

Vendor/APRef/Subcontract/Item

3

Vendor/APRef

4

Vendor/Subcontract/Item

5

Subcontract/Item

EM - Equipment CT

2

EMCo/Equip/EMGroup/RevCode

3

EMCo/Equip

4

EMGroup/RevCode

15

EMCo/Equip/EMGroup/RevCode /Craft/Class/Employee

16

EMCo/Equip/EMGroup/RevCode/Employee

17

EMCo/Equip/EMGroup/RevCode/Craft/Class

Other Sources/CT’s

2-9

Summary Only

Note: Summary levels are not used if the sequence type is “N-No Bill,” “A-Amount,” “T-Total Addon,” or “D-Detail.”.

JB T&M Template Setup

Summary Level Options