A JD Edwards EnterpriseOne Subcontract Management Reports

This appendix contains the following topics:

• Section A.1, "JD Edwards EnterpriseOne Subcontract Management Reports"

• Section A.2, "JD Edwards EnterpriseOne Subcontract Management Reports: A to Z"

• Section A.3, "JD Edwards EnterpriseOne Subcontract Management Selected Reports"

A.1 JD Edwards EnterpriseOne Subcontract Management Reports

The JD Edwards EnterpriseOne Subcontract Management system offers you a variety of reports to help you review and manage the contract information. You can print reports to review the financial details of the contracts. Financial reports can display this information:

• Job, subcontractor, and contract status.

• Price.

• Contract financial history.

• Committed costs and committed transactions.

You can print commitment reports to review the commitment details of the contracts. A commitment report can display:

• Committed cost information for a job.

• Commitment details and analysis for a contract.

• Commitment distribution among contracts for a job.

• American Institute of Architects (AIA) payment documentation.

You can print reports to review the log information for the contracts. Log reports can display:

• Log items related to a contract.

• Submittal and transmittal status information.

• Hierarchical log information.

A.2 JD Edwards EnterpriseOne Subcontract Management Reports: A to Z

This table lists the JD Edwards Subcontract Management reports, sorted alpha-numerically by report ID:

Report ID and Report Name	Description	Navigation
R43050 F4305 Logs Report	This report lists logs and their associated hierarchies.	Subcontract Reports (G43D111), F4305 Logs Report
R43415 Summary by Supplier Report	This report prints purchase order information by supplier, then by business unit. You can review individual amounts for each purchase order, including the amount received and the amount open. You can also review the total amount for all purchase orders. If a purchase order contains detail lines for multiple branch/plants, the same order might appear several times based on the branch/plant.	Subcontract Reports (G43D111), Summary by Supplier Report
R43415A Summary by Cost Center Report	This report prints purchase order information by business unit.	Subcontract Reports (G43D111), Summary by Cost Center Report
R43420 Purchase Journal	This report lists original detail line information and changes that have been made to the quantity or extended amount on each detail line. For each order that prints, you can review: The sum of the original detail line amounts. The sum of the detail line changes. The sum of the current detail line amounts. Information for this report comes from the F43199 table. This report is applicable only if you set up order activity rules to create ledger records.	Subcontract Reports (G43D111), Purchase Journal
R434201 Contract Analysis	Use this report to review a summary of contract commitment information for selected suppliers and jobs. This report uses information from the F4311 table and the F0902 table. You can review this order information: Budget amount Contract amount Invoice amount Amount paid Amount retained Remaining balance Extended amount Percent invoiced Percent retained	Subcontract Reports (G43D111), Contract Analysis
R43535 Print Order Revisions History	Use this report to review information about order revisions.	Subcontract Reports (G43D111), Print Order Revisions History
R43540 Logs (F4305) Report/Update	This program prints a contract management report and log associated text entries for contracts.	Subcontract Reports (G43D111), Logs (F4305) Report/Update
R4401P Print Subcontracts	The Print Subcontracts report is a version of the Order Detail Print batch application (R4401P). In this report, you can have the system print information about the subcontracts such as associated text and tax information. The system retrieves contract details from the F4311 table. You can also specify whether the system prints logs at simply the subcontract level, or at all of the hierarchical levels that you use in the logs. This report lists detail information about logs and commitment distribution for any contract. You can also review all of the multicurrency information that is associated with a contract if you have multicurrency turned on. You can print information about all jobs, a specific job, or an individual contract. The Subcontract Detail report uses information from the F4301 table, the F4311 table, the F4305 or F4303 table, and Contract Header Log Text (F52034) tables.	Subcontract Reports (G43D111), Print Subcontracts
R44425 Status Report by Supplier	This report displays the amounts that have been vouchered, paid, retained, and due for a contract.	Subcontract Reports (G43D111), Status Report by Supplier
R44440 AIA Application for Payment	This report lists base contract and change order commitment amounts in addition to previous amounts that were billed and retained. The subcontractors can use this report as a turnaround document.	Subcontract Reports (G43D111), AIA Application for Payment

A.3 JD Edwards EnterpriseOne Subcontract Management Selected Reports

This section provides detailed information, including processing options, for individual reports. The reports are listed alpha-numerically by report ID.

A.3.1 R43050 - F4305 Logs Report

You use the Logs Report (R43050) to print the logs and their associated hierarchies. In the processing options for R43050, you can specify the hierarchical level at which you want to report, as well as any associated text for that hierarchy. You can specify to print single or multiple log levels and their associated texts.

A.3.2 Processing Options for F4305 Logs Report (R43050)

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

A.3.2.1 Print Options

1. Print Contract Level Logs

Specify whether to print contract level logs. Values are:

Blank: Do not print.

1: Print contract level logs without attachments.

2: Print contract level logs with header and detail attachments.

2. Print Company Level Logs

Specify the printing of company level logs. Values are:

Blank: Do not print.

1: Print company level logs without attachments.

2: Print company level logs with header and detail attachments.

3. Print Subcontractor Level Logs

Specify the printing of subcontractor level logs. Values are:

Blank: Do not print.

1: Print subcontractor level logs without attachments.

2: Print subcontractor level logs with header and detail attachments.

4. Print Project Level Logs

Specify the printing of project level logs. Values are:

Blank: Do not print.

1: Print project level logs without attachments.

2: Print project level logs with header and detail attachments.

5. Print Job Level Logs

Specify the printing of job level logs. Values are:

Blank: Do not print.

1: Print job level logs without attachments.

2: Print job level logs with header and detail attachments.

A.3.3 R43535 - Order Revisions History Report

Use this report to review information about order revisions. The report lists this information:

• The number of revisions to each detail line.

• The latest detail line revisions.

• A history of all detail line revisions.

A.3.4 Processing Options for Order Revisions History Report (R43535)

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

A.3.4.1 Display

1. Specify revision number

Specify a revision number. Values are:

Blank: All

*: Last revision

2. Specify lines to print

Specify the number of lines to print for this report. Values are:

Blank: Print only those lines that changed at the specific number.

1: Print all lines that make up a revision.

3. Print line history

Specify whether to print history records for each purchase order line printed. Values are:

Blank: Do not print history records for each purchase order line printed.

1: Print all history records for each purchase order line printed.

A.3.5 R4401P – Print Subcontracts Report

You can review detail information about logs and commitment distribution for any contract on the Subcontract Detail report. You can also review all of the multicurrency information that is associated with a contract if you have multicurrency turned on. You can print information about all jobs, a specific job, or an individual contract.

The Subcontract Detail report uses information from the F4301, F4311, F4305 or F4303, and F52034 tables.

A.3.6 Processing Options for Print Subcontracts Report (R4401P)

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

A.3.6.1 Display

1. Log Information

Specify whether the system prints the log information associated with subcontracts. Values are:

Blank: Do not print log information.

1: Print only subcontract level logs.

2: Print logs at all hierarchical levels.

2. Text

Specify whether the system prints the text. Values are:

Blank: Do not print text.

1: Print text.

3. Tax information

Specify whether the system prints tax information. Values are:

Blank: Print tax information.

1: Suppress tax information.

A.3.7 R44425 - Detailed Status Report by Supplier

You can review detailed contract status information based on the subcontractor and the job on the Status Report by Supplier report (R44425).

You also can review the commitment distribution information for the contracts based on the job. This report uses information from the F4311 table. This information includes:

• Order identifying information.

• Budget amounts for selected accounts.

• Change order information.

• Amount billed.

• Retainage information.

• Amount released but not paid.

• Amount due on the selected as of date.

You can print this report at any time to review the current status of selected contracts.

A.3.8 Processing Options for Status Report by Supplier (R44425)

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

A.3.8.1 Report Display

1. Enter the As of Date on which to base the report. Leave blank (default) to use the Financial Reporting Date of Company '00000'. If no Financial reporting date has been set up, then today's system date is used.

Specify a date that identifies the financial period to which the transaction is to post.

The company constants table for general accounting specifies the date range for each financial period. You can have up to 14 periods. Generally, period 14 is for audit adjustments. If you leave this processing option blank, the system uses the Financial Reporting Date of Company 00000.

2. Enter '1' to print the associated job budget for contract cost codes

Specify the list of selection values associated with a data selection item in the Dream Writer. Values are:

Blank: Do not print the associated job budget for contract cost codes.

1: Print the associated job budget for contract cost codes.

3. Enter '1' to suppress the printing of a Budget total line

Specify whether to print a Budget total line. Values are:

Blank: Do not suppress printing.

1: Suppress printing.

4. Enter a '1' to print subledger and subledger type. Leave blank for no subledger and type.

Specify whether to print subledger and subledger type. Values are:

Blank: Do not print.

1: Print

5. Enter a Budget Ledger Type

Specify a value from UDC 09/LT that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units).

You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

6. Enter a '1' to print AP Detail information. Leave blank to print Summary.

Specify whether to print AP Detail information. Values are:

Blank: Print Summary.

1: Print AP Detail information.

A.3.9 R44440 - AIA Application for Payment

You can run the Application for Payment report either from the Subcontract Reports menu (G43D111) or during the A/P check run. This report is similar to the American Institute of Architects (AIA) Document G702, titled Application and Certificate for Payment. The report lists base contract and change order commitment amounts in addition to previous amounts that were billed and retained. The subcontractors can use this report as a turnaround document. You send an updated report to a subcontractor as an individual item or with a pay request. The contractor then completes it, has it notarized, and returns it to you.

You normally send an update of the Application for Payment report with each of the payments. The subcontractor then uses it for the next application. The subcontractor sends back the completed form as the invoice for payment. Completing this document does not necessarily mean that all work on the contract is complete. In most cases, it indicates only that the work that was scheduled between the last payment and the next scheduled payment is complete.

The system uses information from the F4311 table and the general ledger transactions.

Additionally, you can print and send the Waiver of Lien form when you send a subcontractor the AIA Application for Payment. The Waiver of Lien states that the subcontractor has been paid and that there are no outstanding liens associated with the work on the contract. The subcontractor signs the waiver, enters the date, and returns it to you. You can print the Waiver of Lien when you run the accounts payable check run.

A.3.10 Processing Options for AIA Application for Payment (R44440)

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

A.3.10.1 Processing

1. Include Units With Progress Billing

Specify whether the system includes units with progress billing. Values are:

Blank: Include amounts only.

1: Include units with progress billing.

2. As Of Date On Which to Base the Report

Enter the As Of Date on which to base the report. Leave blank (default) to use the Financial Reporting Date of company "00000". If no Financial Reporting Date has been set up for Co. "00000" then the system uses today's date.

A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.

3. Order Suffix

Specify whether the system breaks on order suffix. Values are:

Blank: Do not break on order suffix.

1: Break on order suffix.

4. Print the Certificate of the Subcontractor

Specify wither the system prints the certificate of the subcontractor. Values are:

Blank: Do not print the certificate of the subcontractor.

1: Print the certificate of the subcontractor.