Summarization

You use the options in the Summarize by list to specify how the system calculates totals for your selected job records. The options do not affect the display of records in the grid on the Work with Project Status Inquiry form. Instead, they affect how the system displays records, including the calculated totals, on the Project Status Inquiry form. You can specify an option on the Work with Project Status Inquiry form to determine the initial display of records on the Project Status Inquiry form, and then change it as necessary after you access the Project Status Inquiry form. If you change the summarization option on the Project Status Inquiry form, the system refreshes the display to show columns in the new summary order.

You can summarize jobs by these options:

Job Option

Description

Job

When you summarize by job, the Project Status Inquiry form displays a list of jobs in sequential order in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the selected job.

Project

When you summarize by project, the Project Status Inquiry form displays the projects sorted in sequential order in the Summary subform, and sorts the jobs within the project in sequential order. If you select a project-level line in the Summary subform, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the selected project. If you select a job-level line, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the job.

Company

When you summarize by company, the Project Status Inquiry form sorts and displays in the Summary subform the jobs sorted by the company number. If you select a company in the Summary subform, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the selected company.

Job Category Code

When you summarize by a job category code, you must also specify the category code to use. You can specify any one of the job category codes that you associated with the job in the Job Master Revisions program. The Project Status Inquiry form displays in the Summary subform the category code values and the jobs associated with the category code value. If you select a line in the Summary subform, the Project Status Inquiry form displays in the Account Details subform summarizations of the accounts associated with the category code value.

Supervisor

When you summarize by supervisor, the system groups the jobs by the supervisor assigned to the job and displays the jobs in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Accounts Details subform the account details associated with the job assigned to the supervisor.

Owner Address

When you summarize by the job owner, the system groups the jobs by the owner's address book number that you associated with the job on the More Detail tab in the Job Master Revisions program (P51006) and displays the jobs in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Accounts Detail subform the accounts associated with the selected job.

Address Number 1–5

When you summarize by an address book number, the system groups the jobs by the address book number that is associated with the job on the Cat Codes 41-50 / AB No tab in the Job Master Revisions program and displays the jobs in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Accounts Detail subform the accounts associated with the selected job.

State

When you summarize by state, the system groups the jobs by the state that you associated with the job and displays the jobs in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the selected job.

Contract Type

When you summarize by contract type, the system groups the jobs by the contract type that you associated with the job and displays the jobs in the Summary subform. If you select a job in the Summary subform, the Project Status Inquiry form displays in the Account Details subform the accounts associated with the selected job.

Account Category Codes

When you summarize by an account category code, you must also specify the category code to use. You can specify any one of the account category codes that you associated with the account. The Project Status Inquiry form displays in the Summary subform the category code values and the jobs associated with the category code value. If you select a line in the Summary subform, the Project Status Inquiry form displays in the Account Details subform summarizations of the accounts associated with the category code value.

Alternate Cost Code

In the JD Edwards EnterpriseOne Job Cost system, you can set up alternative codes by which to view costs. Select the Alternate Cost Code list item to view records summarized by the alternate cost code that you set up in the JD Edwards EnterpriseOne Job Cost system.