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.
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 |
JB T&M Template Setup
Summary Level Options