A JD Edwards EnterpriseOne Job Cost Reports

This appendix contains the following topics:

A.1 Job Cost Reports

The JD Edwards EnterpriseOne Job Cost system offers you a variety of reports that help review and manage job cost information. Use management summary reports to review:

  • Date sensitive account balance information for a selected job. You can review the information by job or cost code, or break it down by units and labor.

  • Financial details of the subcontracts associated with the jobs.

  • Analysis of date sensitive information related to specific accounts over a given period.

You can generate reports that show all of the jobs in the system or the chart types that you have set up. You can also generate a report that shows the accounts that relate to a specific job.

A.2 Job Cost Summary Reports: A to Z

This table lists the job cost reports, sorted alphanumerically by report ID.

Report ID and Report Name Description Navigation
R51006P

Job Master List

Use this program to review all of the jobs in the system. You can select a summary or detailed version of this report. The system takes the information from the Business Unit Master table (F0006). ob Cost Reports (G5113), Job Master List
R510901

Job Account Master List

Use this program to review all of the accounts that relate to a specific job. The five versions of this report are based on reordering of information from the Account Master table (F0901). Job Cost Reports (G5113), Job Account Master List
R51091P

Chart Types

Use this program to review all of the chart types that you have set up in the system. Job Cost Reports (G5113), Chart Types
R512000P

Job Status Inquiry

Use this program to review the Job Status Inquiry User Defined Columns information. ob Cost Reports (G5113), Job Status Inquiry
R51412

Master Job Cost

Use this program to review date sensitive account balance information for a specific job. Job Cost Reports (G5113), Master Job Cost Report
R514122

Summary by Cost Type

Use this program to review date sensitive account balance information for a specific job by cost type. Job Cost Reports menu (G5113), Summary by Cost Type
R514121

Unit Cost Analysis

Use this program to review date sensitive account balance information for a specific job. Job Cost Reports menu (G5113), Unit Cost Analysis
R51420

Detail by Job

Use this program to review the main details of a job. Job Cost Reports menu (G5113), Detail by Job
R51425B

Transaction Analysis

Use this program to review detailed transaction information by account. Job Cost Reports menu (G5113), Transaction Analysis
R51430

Period Trend Analysis

Use this program to review date sensitive job cost information for selected accounts over a specified time interval Job Cost Reports menu (G5113), Period Trend Analysis
R51443

Executive Summary

Use this program to review and manage the profit information related to projects, jobs, or subledgers within jobs. Profit Recognition (G5122), Executive Summary
R51445

Profit Recognition Job Status

Use the program to review cost, revenue, and gross profit information for each job. Profit Recognition (G5122), Profit Recognition Job Status
R51520

Cost of Construction detail

Use this program to view cost details per account over a selected period. Job Draws and Reporting (G5123), Cost of Construction detail
R51525

Cost of Construction summary

Use this program to view summarized cost information over a selected period. Job Draws and Reporting (G5123), Cost of Construction summary
R51530

Job Detail by Subledger

Use this program to review the details of a classified job using subledgers. Job Cost Reports menu (G5113), Job Detail by Subledger
R51540

Budget Revisions

Use this program to review all additions and changes made to the budget of a job. Job Cost Reports menu (G5113), Budget Revisions

A.3 Selected Job Cost Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed alphanumerically by report ID in this appendix.

A.3.1 R512000P Job Status Inquiry Print

Use the Job Status Inquiry Print report (R512000P) to review the Job Status Inquiry User Defined Columns information. You can print this report from the Job Cost Reports menu or from the Job Status Inquiry form. If you print the report from the Job Status Inquiry form, the system prints the first eight columns that have been selected to display on the form. If you print the report from the menu, you must enter a column version. The system prints the first eight columns based on the version that you enter.

A.3.2 Setting Processing Options for Job Status Inquiry Print (R512000P)

Processing options enable you to specify the default processing for programs and reports.

A.3.2.1 Display

1. Column Version

Specify the column version to use to print the columns on the report. If you leave this processing option blank, the system uses the column version for the user ID, which the system automatically saves when you exit the Job Status Inquiry User Defined Columns program.

2. Date Range

From Period/Date

Specify the start date or period to select information to print on the report. If you leave this processing option blank, the system determines the date to use based on the value entered in the Account Balance Type processing option.


Note:

If you enter a value in this processing option, do not enter a value in the Account Balance Type processing option or the system prints an error on the report.

Thru Period/Date

Specify the through date or period to select information to print on the report. If you leave this processing option blank, the system prints an error on the report.

3. Account Balance Type

Specify which account balances to display on the report. Do not complete this processing option if you have completed the Date Range processing option. Values are:

Blank or 1: Inception to Date

2: Cumulative Year to Date

3: Period

4. Account Level of Detail

Specify the default level of detail (values 3 through 9) to use to print account details. The system summarizes accounts for levels of detail that are higher (less detailed) than the value that you enter. For example, if you enter 5 in this processing option, the system prints amounts for accounts assigned level of detail 3 and 4, summarizes accounts from levels of detail 5, 6, 7, 8, and 9 and prints the total for the account assigned level of detail 5. If you leave this processing option blank, the system uses a default value of 9 and prints all accounts.

5. Account Sequence

Specify the account sequence to use to print the account information on the report. Values are:

Blank: Job, Cost Code, Cost Type.

A: Alternate Cost Code, Cost Type, Job.

C: Cost Code, Cost Type, Job.

O: Job, Cost Type, Cost Code.

T: Cost Type Cost Code, Job.

1: Account Category Code 1.

2: Account Category Code 2.

3: Account Category Code 3.

A.3.3 R51412 Master Job Cost Report

The Master Job Cost report (R51412) provides date sensitive account balance information for a specific job and includes these details:

  • Revised budget

  • Actual current

  • Actual to date

  • Percent spent

  • Percent complete

  • Projected final cost

  • Remaining to complete

  • Projected over/under

  • Cost code

  • Cost type

  • Method of computation

When you select to print this report, you can also direct the system, using processing options, to print the Unit Cost Analysis (R514121) and the Cost Type Summary (R514122) reports.

A.3.4 Setting Processing Options for Master Job Cost Report (R51412)

Processing options enable you to specify the default processing for programs and reports.

A.3.4.1 Edits

Enter an as-of-date, limit reporting to a specific subledger, or designate a subledger type for the reports with these options.

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Subledger

Specify the subledger to use to select information to print on the report. If you enter a value in this processing option, you must complete the Subledger Type processing option. Enter * to select all subledgers, or leave this processing option blank to select records without subledgers.

3. Subledger Type

Specify the subledger type that corresponds to the value that you entered in the Subledger processing option. The subledger type that you enter must exist in UDC 00/ST.

4. Cost Code Range

From Cost Code

Specify the beginning cost code (subsidiary) account in the range of accounts to print on the report. If you leave this processing option blank, the system prints all cost codes through the value entered in the Thru Cost Code field.

Thru Cost Code

Specify the ending cost code (subsidiary) account in the range of accounts to print on the report. If you leave this processing option blank, the system displays all cost codes from the value entered in the From Cost Code field.

5. Cost Type Range

From Cost Type

Specify the beginning cost type (object) account in the range of account to print on the report. If you leave this processing option blank, the system displays all cost types through the cost type entered in the Thru Cost Type field.

Thru Cost Type

Specify the ending cost type (object) account in the range of accounts to print on the report. If you leave this processing option blank, the system displays all cost types from the value entered in the From Cost Type field.

A.3.4.2 Print

Enter account level of detail, job address information, page breaks on different jobs, cost code and cost type print, zero amount print suppression, and unit print specifications for a job with these options.

1. Account Level of Detail

Specify the default level of detail (values 3 through 9) to use to print account details. The system summarizes accounts for levels of detail that are higher (less detailed) than the value that you enter. For example, if you enter 5 in this processing option, the system prints amounts for accounts assigned level of detail 3 and 4, summarizes accounts from levels of detail 5, 6, 7, 8, and 9 and prints the total for the account assigned level of detail 5. If you leave this processing option blank, the system uses a default value of 9 and prints all accounts.

2. Job Address Information

Specify whether to print the job address and who's who information on the report. Values are:

Blank: Do not print the job address and who's who information.

1: Print the job address and who's who information.

3. Page Break on Different Job

Specify whether to start a new page for each job that prints on the report. Values are:

Blank: Do not start a new page for each job.

1: Start a new page for each job.

4. Cost Code and Cost Type Print

Specify whether to print the cost code and cost type on the report. Values are:

Blank: Do not print the cost code and cost type on the report.

1: Print the cost code and cost type on the report.

5. Zero Amount Print Suppression

Specify whether to print detail accounts with zero amounts on the report. Values are:

Blank: Print detail accounts with zero amounts.

1: Do not print detail accounts with zero amounts.

6. Units Print

Specify whether to print units on the report. Values are:

Blank: Do not print units on the report.

1: Print units on the report. The system prints actual, revised budget, and committed units on the report.


Note:

If you set up additional budget ledgers, the system prints the sum of the units for all ledgers.

A.3.4.3 Versions

Use these processing options to specify whether to print the Unit Cost Analysis and Cost Type Summary reports in addition to printing this report. Leave these processing options blank to omit printing the reports.

1. Unit Cost Analysis Version (R514121)

Specify whether to additionally print the Unit Cost Analysis report (R514121) by entering the version of the report to print.

2. Cost Type Summary Version (R514122)

Specify whether to additionally print the Cost Type Summary Report (R514122) by entering the version of the report to print.

A.3.5 R514122 Summary by Cost Type

The Summary by Cost Type report (R514122) provides date sensitive account balance information for a specific job by cost type. The report includes:

  • Revised budget

  • Actual current

  • Actual to date

  • Percent spent/complete

  • Projected final

  • Remaining to complete

  • Projected over/under

  • Cost type

A.3.6 Setting Processing Options for Summary by Cost Type (R514122)

Processing options enable you to specify the default processing for programs and reports.

A.3.6.1 Defaults

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Subledger

Specify the subledger to use to select information to print on the report. If you enter a value in this processing option, you must complete the Subledger Type processing option. Enter * to select all subledgers, or leave this processing option blank to select records without subledgers.

3. Subledger Type

Specify the subledger type that corresponds to the value that you entered in the Subledger processing option. The subledger type that you enter must exist in UDC 00/ST.

A.3.6.2 Print

1. Job Address Information

Specify whether to print the address and who's who information on the report. Values are:

Blank: Print job address and who's who information.

1: Do not print job address and who's who information.

2. Zero Amount Print Suppression

Specify whether to print detail accounts with zero amounts on the report. Values are:

Blank: Print detail accounts with zero amounts.

1: Do not print detail accounts with zero amounts.

A.3.7 R514121 Unit Cost Analysis

The Unit Cost Analysis report (R514121) provides date sensitive account balance information for a specific job. The report includes these details:

  • Revised budget

  • Actual current

  • Actual to date

  • UM

  • Budget units

  • Revised budget

  • Budget amount/units

  • Actual units

  • Actual amounts

  • Actual amount/units

  • Unit amount variance

  • Percent complete

  • Projected final

  • Projected over/under

  • Method of computation

  • Cost code

  • Cost type

A.3.8 Setting Processing Options for Unit Cost Analysis (R514121)

Processing options enable you to specify the default processing for programs and reports.

A.3.8.1 Defaults

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Subledger

Specify the subledger to use to select information to print on the report. If you enter a value in this processing option, you must complete the Subledger Type processing option. Enter * to select all subledgers, or leave this processing option blank to select records without subledgers.

3. Subledger Type

Specify the subledger type that corresponds to the value that you entered in the Subledger processing option. The subledger type that you enter must exist in UDC 00/ST.

1. Account Level of Detail

Specify the default level of detail (values 3 through 9) to use to print account details. The system summarizes accounts for levels of detail that are higher (less detailed) than the value that you enter. For example, if you enter 5 in this processing option, the system prints amounts for accounts assigned level of detail 3 and 4, summarizes accounts from levels of detail 5, 6, 7, 8, and 9 and prints the total for the account assigned level of detail 5. If you leave this processing option blank, the system uses a default value of 9 and prints all accounts.

A.3.8.2 Print

1. Job Page Break

Specify whether to start a new page for each job that prints on the report. Values are:

Blank: Do not start a new page.

1: Start a new page.

2. Report Heading Format

Specify whether to print the address and who's who information on the report. Values are:

Blank: Do not print the address.

1: Print the address.

3. Print Cost Code and Cost Type

Specify whether to print the cost code and cost type on the report. Values are:

Blank: Do not print the cost code and cost type.

1: Print the cost code and cost type.

4. Zero Amount Suppression

Specify whether to print detail accounts with zero amounts on the report. Values are:

Blank: Print detail accounts with zero amounts.

1: Do not print detail accounts with zero amounts.

A.3.8.3 Process

1. Unit Cost Calculation

Specify whether to calculate unit cost information for the header (cost code) or detail (cost type) accounts. Values are:

Blank: Calculate unit cost information for the cost type (detail) accounts.

1: Calculate unit cost information for the cost code (header) accounts.

A.3.8.4 Versions

1. Cost Type Summary Version (R514122)

Specify whether to additionally print the Cost Type Summary report (R514122) by entering the version of the report to print. Leave this processing option blank to omit printing the report.

A.3.9 R51420 Detail by Job

Use the Detail by Job report (R51420) to review the main details of a job. The report includes these details:

  • Cost Code

  • Cost Type

  • Document Type

  • Document Number

  • General ledger Date

  • Budget Unit

  • Budget Amount

  • Year-to-Date Unit

  • Year-to-Date Amount

A.3.10 Setting Processing Options for Detail by Job (R51420)

Processing options enable you to specify the default processing for programs and reports.

A.3.10.1 Defaults

Enter an as-of-date, limit reporting to a specific subledger, or designate a subledger type for the reports with these processing options.

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Subledger

Specify the subledger to use to select information to print on the report. If you enter a value in this processing option, you must complete the Subledger Type processing option. Enter * to select all subledgers, or leave this processing option blank to select records without subledgers.

3. Subledger Type

Specify the subledger type that corresponds to the value that you entered in the Subledger processing option. The subledger type that you enter must exist in UDC 00/ST.

A.3.10.2 Print

These processing options enable you to set cost codes, cost types, subledger types, cost code and cost type summaries, amount and account details, commitments, and address information for a job.

1. Default Cost Code Range

From Cost Code

Specify the beginning cost code (subsidiary) account in the range of accounts to print on the report. If you leave this processing option blank, the system prints all cost codes through the value entered in the Thru Cost Code field.

Thru Cost Code

Specify the ending cost code (subsidiary) account in the range of accounts to print on the report. If you leave this processing option blank, the system displays all cost codes from the value entered in the From Cost Code field.

2. Default Cost Type Range

From Cost Type

Specify the beginning cost type (object) account in the range of account to print on the report. If you leave this processing option blank, the system displays all cost types through the cost type entered in the Thru Cost Type field.

Thru Cost Type

Specify the ending cost type (object) account in the range of accounts to print on the report. If you leave this processing option blank, the system displays all cost types from the value entered in the From Cost Type field.

3. Subledger and Subledger Type

Specify whether to include the subledger and subledger type columns on the report. Values are:

Blank: Do not include the subledger and subledger type columns.

1: Include the subledger and subledger type columns.

4. Cost Type and Cost Code Summaries

Specify whether to print summary totals for each job by cost type and by cost code. For each job, the cost type and cost code summary appears on separate pages before the detail. Values are:

Blank: Do not print the cost type and cost code summaries.

1: Print the cost type and cost code summaries.

5. Amount Detail

Specify the fields to retrieve for the amounts and units that print on the report. Values are:

Blank: Print year-to-date values. The system does not include the beginning balances.

1: Print the values for the current period and the beginning balances.

2: Print the inception-to-date values.

3: Print only the values for current period.

4: Print the values for the year-to-date and beginning balances.

6. Account Detail

Specify the account detail to print on the report. Values are:

Blank: Print all accounts.

1: Print only accounts that do not have budget amounts or units.

2: Print only accounts that have current period actual amounts or units.

3: Print only accounts that have current period actual amounts or units, but do not have budget amounts or units.

7. Commitments and Contracts

Specify whether to include columns for the units and amounts associated with commitments or contracts on the report. Values are:

Blank: Do not include columns for units and amounts associated with commitments or contracts.

1: Include columns for units and amounts associated with commitments or contracts.

8. Vendor Name on Commitment Lines

Specify whether to include the vendor name from change order commitment line details on the report. Values are:

Blank: Do not include the vendor name.

1: Include the vendor name.

9. Job Address and Who's Who Information

Specify whether to print the job address and who's who information on the report. Values are:

Blank: Do not print the job address and who's who information.

1: Print the job address and who's who information.

10. Include Unposted Transactions

Specify whether to include unposted transactions on the report. Values are:

Blank: Do not include unposted transactions.

1: Include unposted transactions.

11. Suppress Description and Reference Lines

Specify whether to include transaction description and reference lines on the report. Values are:

Blank: Include the transaction description and reference lines.

1Do not include the transaction description and reference lines.

A.3.11 R51425B Transaction Analysis

Use the Transaction Analysis report (R51425B) to review detailed transaction information by account. The report includes these account details:

  • Job number

  • Description

  • Cost code

  • Cost type

  • General ledger date

  • Document number and type

  • Vendor number

  • Invoice number

  • Purchase order number

  • Amount and unit values

  • Journal entry detail

A.3.12 Setting Processing Options for Transaction Analysis (R51425B)

Processing options enable you to specify the default processing for programs and reports.

A.3.12.1 Defaults

1. Ledger Type

Specify the ledger types to include on the report. Leave this processing option blank to include all ledger types.

2. Date Range

From Date

Specify the beginning date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

Thru Date

Specify the ending date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

3. Document Type

Specify the document type to use to select records to include on the report. Leave this processing option blank to include all records regardless of the document type.

4. Subledger

Specify the subledger to use to select information to print on the report. If you enter a value in this processing option, you must complete the Subledger Type processing option. Enter * to select all subledgers, or leave this processing option blank to select records without subledgers.

5. Subledger Type

Specify the subledger type that corresponds to the value that you entered in the Subledger processing option. The subledger type that you enter must exist in UDC 00/ST.

A.3.12.2 Print

1. Subledger / Subledger Type

Specify whether to include the subledger and subledger type columns on the report. Values are:

Blank: Do not include the subledger and subledger type columns.

1: Include the subledger and subledger type columns.

2. Transaction Type

Specify whether to limit the transactions that print on the report by posted code. Values are:

Blank: Print all transactions regardless of the posted code.

1: Print only posted transactions.

2: Print only unposted transactions.

3. Balance Forward

Specify whether to print the balance forward for the account on the report. Values are:

Blank: Do not print balance forward.

1: Print the balance forward.

4. Vendor

Specify whether to include the vendor name on the report. Values are:

Blank: Do not include the vendor name.

1: Include the vendor name.

A.3.13 R51430 Period Trend Analysis

You print the Period Trend Analysis report (R51430) to review date sensitive job cost information for selected accounts over a specified time interval. You can specify an as of date and an interval on which to report. The default interval is seven days for weekly reporting. The program treats the as of date as the ending date of the reporting interval and uses the interval to calculate all prior dates. You can use processing options to compute different ratios for comparing period information.

The Period Trend Analysis report includes these details:

  • Budget amounts and units

  • Actual amounts and units for selected intervals

  • Rolling averages for the interval

  • Job-to-date amounts and units

  • Percent spent and percent complete information

  • Remaining amounts and units

  • Projected final amounts and units

  • Projected over/under amounts and units

A.3.14 Setting Processing Options for Period Trend Analysis (R51430)

Processing options enable you to specify the default processing for programs and reports.

A.3.14.1 Defaults

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Days From

Specify the number of days to use for each interval. Leave this processing option blank to use a seven day interval.

A.3.14.2 Print

1. Detail Amount to Header Units Ratio

Specify whether to include the detail amount to header units ratio on the report. Values are:

Blank: Do not include the detail amount to header units ratio.

1: Include the detail amount to header units ratio.

2. Detail Units to Header Units Ratio

Specify whether to include the detail units to header units ratio on the report. Values are:

Blank: Do not include the detail units to header units ratio.

1: Include the detail units to header units ratio.

3. Header Units to Detail Units Ratio

Specify whether to include the header units to detail units ratio on the report. Values are:

Blank: Do not include the header units to detail units ratio.

1: Include the header units to detail units ratio.

4. Period Physical Percent

Specify whether to include the period physical percent ((*Interval Actual Amount / Projected Final Amount) * 100) on the report. Values are:

Blank: Do not include the period physical percent.

1: Include the period physical percent.

5. Job to Date Physical Percent

Specify whether to include the job-to-date physical percent ((Job to Date Interval Amount / Projected Final Amount) * 100) on the report. Values are:

Blank: Do not include the job-to-date physical percent.

1: Include the job-to-date physical percent.

6. Current Period Gain or Loss

Specify whether to include the current period gain or loss on the report. This value is represented by the change in the projected final amount (HA ledger) within the interval range. Values are:

Blank: Do not include the current period gain or loss.

1: Include the current period gain or loss.

7. Ratio Amounts on Accounts

Specify whether to include ratio amounts on accounts with zero actual amounts or units on the report. Values are:

Blank: Include ratio amounts on accounts with zero actual amounts or units.

1: Do not include ratio amounts on accounts with zero actual amounts or units.

A.3.15 R51443 Executive Summary Report

Generate an Executive Summary Report (R51443) to review and manage the profit information related to projects, jobs, or subledgers within jobs. The Executive Summary Report is available in one of two formats, depending on the processing options you use:

  • Report

  • Worksheet

You can manually write in numbers on the worksheet and then enter them in the system.

A.3.16 Setting Processing Options for Executive Summary Report (R51443)

Processing options enable you to specify the default processing for programs and reports.

A.3.16.1 Print

1. Report Totalling

Specify the type of report totaling to include on the report. Values are:

1: Include a total by effective date and a grand total.

2: Include a total by version number and a grand total.

Blank or 3: Include a total by effective date, version number, and a grand total.

2. Worksheet Format

Specify whether to print the report in worksheet format. Values are:

Blank: Do not print the report in worksheet format.

1: Print the report in worksheet format.

3. Quarter or Period Amounts

Specify which amounts to include on the report. Values are:

Blank: Include earned current period amounts.

1: Include earned quarter amounts.

A.3.17 R51445 Profit Recognition Job Status (Release 9.1 Update)

You can print the Profit Recognition Job Status report (R51445) to review cost, revenue, and gross profit information for each job by an effective date. The report prints this information by job:

  • Projected at Completion

  • Year To Date

  • Prior Period Balance

  • Current Period Balance

Use data selection to specify that the system selects that profit records that correspond to following summarization levels:

  • Project level

  • RPO level

For more information on reviewing the report for RPO, review the following section:

Reviewing the Profit Recognition Job Status Report (R51445) for Revenue Performance Obligations

A.3.18 Setting Processing Options for Profit Recognition Job Status Report (R51445)

Processing options enable you to specify the default processing for programs and reports.

A.3.18.1 Select

1. Effective Date

Specify the effective date to use to select information to print on the report. If you leave this processing option blank, the system uses the financial reporting date that is assigned to company 00000.

2. Provision for Loss

Specify whether to add the provision for loss to the job earned to date. Values are:

Blank: The system adds the provision for loss to the job earned to date cost. The system updates the Cost Job to Date field in the F5144 table. As a result, system also and as a result you will see on the P5144(Group Job Adjustments) and P51440 (Single Job Adjustments) that Cost Job to Date is not equal to Percent Complete Project Final Cost.

1: The system does not add the provision for loss to the job earned to date.

A.3.19 R51520 Cost of Construction Detail

Use this format to view cost details per account over a selected period

The Draw Status field designates whether the draw detail row is final (Draw Status field is 1), is not in the current draw (Draw Status field is empty), is on hold (Draw Status field is H), or is excluded from the draw (Draw Status field is X).

A.3.20 Setting Processing Options for Cost of Construction Detail (R51520)

Processing options enable you to specify the default processing for programs and reports.

A.3.20.1 Print

1. Date Range

From Date

Specify the beginning date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

Thru Date

Specify the ending date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

2. Total Line Spacing

Specify whether to include a single space or double space after total lines. Values are:

Blank: Double space.

1: Single space.

3. Cost Type Headings

Specify whether to include cost type headings on the report. Values are:

Blank: Do not include cost type headings.

1: Include cost type headings.

A.3.21 R51525 Cost of Construction Summary

Use this format to review summarized cost information per account over a selected period. The Draw Status field designates whether the draw detail row is final (Draw Status field is 1), is not in the current draw (Draw Status field is empty), is on hold (Draw Status field is H), or is excluded from the draw (Draw Status field is X).

A.3.22 Setting Processing Options for Cost of Construction Summary (R51525)

Processing options enable you to specify the default processing for programs and reports.

A.3.22.1 Print

1. Date Range

From Date

Specify the beginning date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

Thru Date

Specify the ending date to use to select records to include on the report. Leave this processing option blank to include all transactions up to the system date.

2. Account Level of Detail

Specify the default level of detail (values 3 through 9) to use to print account details. The system summarizes accounts for levels of detail that are higher (less detailed) than the value that you enter. For example, if you enter 5 in this processing option, the system prints amounts for accounts assigned level of detail 3 and 4, summarizes accounts from levels of detail 5, 6, 7, 8, and 9 and prints the total for the account assigned level of detail 5. If you leave this processing option blank, the system uses a default value of 9 and prints all accounts.

3. Level of Detail Print Suppression

Specify the level of detail to use (3 through 9) for print suppression. The report does not include accounts with zero balances at the level of detail (LOD) specified or higher. For example, if you enter 5, the system does not include the account with zero balances on the report for this LOD and also for the accounts at a higher level of detail (6 through 9). If you leave this processing option blank, the system includes all accounts regardless of whether the balance is zero.

A.3.23 R51530 Job Detail by Subledger

Use the Job Detail by Subledger report (R51530) to review the details of a classified job using subledgers. The report includes these details:

  • Subledger

  • Cost Code

  • Cost Type

  • Document Date

  • Document Number

  • Document Type

  • Invoice Number

  • Payment Number

  • Contract Number

  • Description

  • Amount

A.3.24 Setting Processing Options for Job Detail by Subledger (R51530)

Processing options enable you to specify the default processing for programs and reports.

A.3.24.1 Default

This processing option enables you to specify the date through which the report should be based.

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

A.3.24.2 Print

This processing option enables you to specify the heading that you do not want to print.

1. Omit Headings Before Detail Lines

Specify whether to print headings for the address number, subledger, and subledger type before the detail lines of this report. The report totals by subledger type, subledger, and address number, as well as by job and company. Company and job titles appear at the top of each page of the report. Address number, subledger, and subledger type titles can be omitted to conserve space. Values are:

Blank: Print all total headings before detail lines.

1: Do not print all total headings before the detail lines.

A.3.25 R51540 Budget Revision Detail

Use the Budget Revision Detail report (R51540) to review all additions and changes made to the budget of a job. The report includes these details:

  • Cost Code

  • Cost Type

  • Description

  • Original Budget Estimate

  • Budget Changes This Period

  • Accumulated Changes to Estimate

  • Revised Budget Estimate

A.3.26 Setting Processing Options for Budget Revision Detail (R51540)

Processing options enable you to specify the default processing for programs and reports.

A.3.26.1 Defaults

These processing options enable you to specify the date through which the report should be based, and whether you want an additional ledger type for costs reflected on the report.

1. As of Date

Specify the date through which the system selects information to print on the report. If you leave this processing option blank, the system uses the current financial reporting date for the company assigned to the job.

2. Ledger Type

Specify the budget ledger type to use to select values on the report. If you leave this processing option blank, the system accumulates the values for all revised budget ledger types.

A.3.26.2 Print

These processing options enables you to specify the lowest level of detail that you want to print and the level of detail for print suppression.

1. Account Level of Detail

Specify the default level of detail (values 3 through 9) to use to print account details. The system summarizes accounts for levels of detail that are higher (less detailed) than the value that you enter. For example, if you enter 5 in this processing option, the system prints amounts for accounts assigned level of detail 3 and 4, summarizes accounts from levels of detail 5, 6, 7, 8, and 9 and prints the total for the account assigned level of detail 5. If you leave this processing option blank, the system uses a default value of 9 and prints all accounts.

2. Level of Detail Print Suppression

Specify the level of detail to use (3 through 9) for print suppression. The report does not include accounts with zero balances at the level of detail specified or higher. For example, if you enter 5, the system does not include the account on the report if the balance of it and the accounts at a higher level of detail (6 through 9) are zero. If you leave this processing option blank, the system includes all accounts regardless of whether the balance is zero.