## Appendix: JD Edwards EnterpriseOne Contract and Service Billing Reports

This appendix enables you to:

- View a summary table of all reports.

- View details for selected reports.

### JD Edwards EnterpriseOne Contract and Service Billing Reports: A to Z

This table lists the Contract and Service Billing reports, sorted alphanumerically by report ID.

Report ID and Report Name | Description | Navigation
R48096B Billing Rate / Markup Table Listing | This report produces a list of the markup rules, grouped by key type and table key. | Table Information (G48S41), Billing Rate / Markup Table Listing Table Information (G5241), Billing Rate / Markup Table Listing
R48127 Tax Derivation Table Listing | This report includes information about the tax derivation rules that meet the data selection criteria. | Table Information (G48S41), Tax Derivation Table Listing
R48128 G/L Offset and Retainage Table Listing | This report produces a list of all of the G/L offset and retainage rules that meet that data selection criteria. | Table Information (G48S41), G/L Offset and Retainage Table Listing
R48300 Journal Edit Register | This report shows invoice, G/L, or voucher journal entries summarized by general ledger date, document type, document number, business unit, object, subsidiary, and subledger | Invoice Processing (G48S21), Batch Review Invoice Processing (G5221), Batch Review Voucher Processing (G48S23), Batch Review On Work With Batches, select the batch and then select Journal Edit Reg from the Row menu.
R48405 Workfile Print | This report prints a list of selected transactions. | Daily Processing (G48S11), Workfile Print Workfile Processing (G5211), Workfile Print
R4860 Component Table Listing | This report lists the effective dates and currency code for each component table that meets the data selection criteria. The information listed on the report is the same information that is available on the Component Table Revisions form. | Table Information (G48S41), Component Table Listing Table Information (G5241), Component Table Listing
R48S412 Workfile Transaction Exception Report | This report lists all workfile transactions that meet the data selection criteria of the report version that you are running. | Daily Processing (G48S11), Workfile Transaction Exception Report Workfile Processing (G5211), Workfile Transaction Exception Report
R48S496 Billing Rate / Markup Table to Expire | This report produces a list of all billing rate and markup tables for which the ending date is between the dates that you specified in the processing options of the Billing Rate/ Markup Table to Expire report. | Table Information (G48S41), Billing Rate / Markup Table To Expire Table Information (G5241), Billing Rate / Markup Table to Expire
R48S95 Billing AAIs Table Listing | This report lists the billing AAIs that you have set up for the Service Billing and JD Edwards EnterpriseOne Contract Billing systems. | Table Information (G48S41), Billing AAIs Table Listing Table Information (G5241), Billing AAIs Table Listing
R48TW Workfile Totals Report | This report lists the revenue, invoice, and cost totals for both domestic and foreign workfile transactions. The report lists totals for base amounts, as well as total amounts including components. | Daily Processing (G48S11), Workfile Totals Report Workfile Processing (G5211), Workfile Totals Report
R5201 Contract Print | Prints a detailed list of contracts. The report includes contract master information for each contract, as well as detailed information about each of the billing lines on the contract, including cross-reference information. You can also print attachments. | Daily Processing (G5210), Contract Print
R52412 Workfile Transactions by Contract | This report lists workfile transactions that originated in Contract Billing, grouped by contract number. | Workfile Processing (G5211), Workfile Transactions by Contract
R52425 Contract History Report | Lists the schedule of values and the invoice information associated with each contract. | Invoice Processing (G5221), Contract History Report

#### Control Reports

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

Report ID and Report Name | Description | Navigation
R48S710 Workfile Control Report | This report identifies records in the Billing Detail Workfile table (F4812) that are not correct based on other information within the F4812 table. | Billing Control Reports (G48S33), Workfile Control Report
R48S711 Workfile History Control Report | This report identifies records in the Billing Workfile History table (F4812H) that are not correct based on other information within the F4812H table. | Billing Control Reports (G48S33), Workfile History Control Report
R48S720 G/L Link to Acct Ledger Control Report | This report verifies that the information contained in the G/L Link table (F48S912) accurately represents the information that has been written to the Account Ledger table (F0911). | Billing Control Reports (G48S33), G/L Link to Acct Ledger Control Report
R48S721 Acct Ledger to G/L Link Control Report | This report verifies that each record in the Account Ledger table (F0911) that was created by the revenue process in the Service Billing or JD Edwards EnterpriseOne Contract Billing system has at least one corresponding record in the G/L Link table (F48S912). | Billing Control Reports (G48S33), Acct Ledger to G/L Link Control Report
R48S730 Workfile to G/L Link Control Report | This report identifies integrity issues between the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) and the G/L Link table (F48S912). | Billing Control Reports (G48S33), Workfile to G/L Link Control Report
R48S731 G/L Link to Workfile Control Report | This report identifies records that are missing from the Billing Detail Workfile table (F4812) and the Billing Workfile History table (F4812H), based on data contained within the G/L Link table (F48S912). | Billing Control Reports (G48S33), G/L Link to Workfile Control Report
R48S751 Invoice Summary to Workfile Control Report | This report verifies that the amounts in the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) match the amounts in the Invoice Summary Work File table (F4822). | Billing Control Reports (G48S33), Invoice Summary to Workfile Control Report
R48S761 Invoice Summary to Customer Ledger Control Report | This report verifies that the amounts in the Invoice Summary Work File table (F4822) match the amounts in the Customer Ledger table (F03B11). | Billing Control Reports (G48S33), Invoice Summary to Customer Ledger Control Report
R48S771 Customer Ledger to Invoice Summary Control Report | This report verifies that each invoice transaction in the Customer Ledger table (F03B11) that originated in the Contract Billing or Service Billing system has at least one corresponding source transaction in the Invoice Summary Work File table (F4822). | Billing Control Reports (G48S33), Customer Ledger to Invoice Summary Control Report

See Also

Reviewing Control Reports

### JD Edwards EnterpriseOne Contract and Service Billing Reports: Selected Reports

This section provides detailed information about individual reports, including important fields and tables accessed. This section also lists processing options for the reports that are included in this appendix, but are not discussed elsewhere in this implementation guide. The reports are listed alphanumerically by report ID.

#### R48096B - Billing Rate / Markup Table Listing

The information on the Billing Rate / Markup Table Listing report is the same information that appears on the Billing Rate / Markup Revisions form.

The Billing Rate / Markup Table Listing retrieves information from the Billing Rate / Mark up Table (F48096).

#### R48127 - Tax Derivation Table Listing

The information on the Tax Derivation Table Listing report is the same information that appears on the Tax Derivation Revisions form.

The Tax Derivation Table Listing retrieves information from the Tax Derivation Information table (F48127).

#### R48128 - G/L Offset and Retainage Table Listing

The information on the G/L Offset and Retainage Table Listing report is the same information that appears on the Work With G/L Offset and Retainage Table form.

The G/L Offset and Retainage Table Listing report retrieves information from the G/L Offset and Retainage Information table (F48128).

#### R48405 - Workfile Print

You might want to use this report to:

- Create an exception report, such as a report that lists all of the transactions that have not been invoiced

- Compare information to the detail information in the Account Ledger table (F0911)

To compare the workfile transactions to the detail information in the Account Ledger table, you can review the Account Ledger table online using the Account Ledger Inquiry program (P09200), or you can print the G/L by Object Account report (R09421).

If you find a discrepancy, make the necessary changes to the Billing Detail Workfile table (F4812) before you continue with the billing process.

The Workfile Print report includes the:

- G/L Date

- Cost

- Units

- Rate

- Billed Amount

- Account Number

- Subledger

- Contract

- Job Type

- PDBA Code

- Employee/Supplier

- Equipment

- Journal Batch

- Invoice Batch

- Invoice

- Pay Item

#### Processing Options for Workfile Print (R48405)

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

Print Options

This processing option lets you specify how many lines of detail information to print on the report.

1. Print Detail | Use this processing option to create a report that prints transactions that are not invoiced. Values are: Blank Display five lines of information per transaction. 1 Display one line of information per transaction.

#### R4860 - Component Table Listing

The report also lists this information about each component in the selected component tables:

- Component code

- Component description

- Component rate

- Rate basis

- Component cross-reference

The Component Table Listing report retrieves information from these tables:

- Component Table Master (F4860)

- Component Table Detail (F4861)

- Component Cross Reference (F4862)

#### R48S412 - Workfile Transaction Exception Report

You can use this report identify workfile transactions that might need to be reviewed before you continue with the billing process, such as transactions that are on hold, transactions without markup information, and transactions without customer information. The report lists this information for each transaction:

- Customer Number

- Customer Name

- Account Number

- Subledger

- Subledger Type

- Eligibility Code

- Cost Amount

- Invoice Amount

- Revenue Amount

- Hold Code

- Release Date

- Billing ID

The Workfile Transaction Exception Report retrieves information from the Billing Detail Workfile table (F4812).

#### R48S496 - Billing Rate / Markup Table to Expire

The report lists this information for each expiring table:

- Generation type

- Key type

- Table key

- Currency code

- Start date

- End date

The Billing Rate / Markup Table to Expire report retrieves information from the Billing Rate / Mark up Table (F48096).

#### Processing Options for Billing Rate / Markup Table to Expire (R48S496)

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

Select

These processing options let you specify the period during which the Billing Rate / Mark up Table (F48096) expires.

1. Expiration From Date | Specify the beginning date of the period during which the Billing Rate / Mark up Table (F48096) expires.
2. Expiration Thru Date | Specify the ending date of the period during which the Billing Rate / Mark up Table (F48096) expires.

#### R48S95 - Billing AAIs Table Listing

The report includes this information about each billing AAI:

- Key type

- Table key

- Effective dates

- Object accounts

- Subsidiary

- Subledger/Type

- G/L Offset

- Component Code

- Resulting Account Number

- Resulting Account Description

- Ledger type

- Distribution percentages

- Equipment/Employee/Unit Control

- Accounting rules

- Credit or debit

#### Processing Options for Billing AAIs Table Listing (R48S95)

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

Attachments

Include attachments | Enter 1 to include attachments on the report. If you leave this processing option blank, the report does not include attachments.

#### R48TW - Workfile Totals Report

You can run the Workfile Totals Report in any of these ways:

- Select Workfile Totals Report from a menu and run it as a batch program.

- From the Work With Workfile form, select Totals from the Form menu.

- From the Work with Detail History form, select Totals Report from the Form menu.

The Workfile Totals Report retrieves information from the Billing Detail Workfile table (F4812).

#### R5201 - Contract Print

The Contract Print program retrieves information from these tables:

- Contract Master (F5201)

- Contract Billing Line Detail (F5202)

- T and M, Unit Price and Lumpsum Cross Reference Accounts (F5212)

- Fee Billing Line Cross Reference Details (F5213)

- Milestone/Progress Billing Information (F5216)

#### Processing Options for Contract Print (R5201)

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

Print

These processing options let you specify whether the system prints cross reference information and attachments.

1. Cross-Reference Information | Leave this processing option blank to print cross-reference information. Enter 1 if you do not want to print cross-reference information.
2. Text Attachments | Specify which text attachments to print. Values are: Blank: Print attachments for all contract levels. 0: Suppress all attachments. 1: Print attachments at the contract level only.

Currency

This processing option lets you specify whether the system displays amounts in foreign or domestic currency.

1. Currency to print monetary amounts | Leave this processing option blank to display amounts in the domestic currency. Enter 1 to display amounts in the foreign currency.

#### R52412 - Workfile Transactions by Contract

This report lists this information about each workfile transaction:

- Customer name

- Business unit

- Workfile transaction

- Subsidiary

- Subledger type

- Cost amount

- Invoice amount

- Revenue amount

- Hold code

- Released date

- Billing control ID

The report also includes the total cost amount, invoice amount, and revenue amount for each contract.

The Workfile Transactions by Contract report retrieves information from the Billing Detail Workfile table (F4812).

#### R52425 - Contract History Report

The report includes this information:

- Application number

- Adjustment number

- Invoice number

- Invoice date

- Voids (optional)

- Base currency

- Invoice amount

- To date amount

- Balance to finish

- Percent complete (optional)

You can choose whether to include voided records on the report and whether to display domestic amounts, foreign amounts, or both.

#### Processing Options for Contract History Report (R52425)

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

Display

These processing options let you specify whether to included voided records on the report and whether to include the Percent Complete column on the report.

1. Print Voided Records | Leave this processing option blank to include voided records on the report. Enter 1 if you do not want to include voided records.
2. Print Percent Complete | Leave this processing option blank to include the percent complete on the report. Enter 1 if you do not want to include percent complete.

Currency

This processing option lets you specify whether to print domestic amounts, foreign amounts, or both.

1. Currency To Print | Specify the currency in which to print the amounts. Values are: D: Domestic F: Foreign 3: Both