26 Printing Joint Venture Billing Reports for Partners (Release 9.2 Update)

This chapter discusses:

26.1 Understanding the Process to Generate the Joint Venture Billing Report

Periodically or on a need basis, you generate the Joint Venture Billing report for each partner in your joint ventures. This report lists the partner's share of the activities for each of the joint ventures over the time period specified when running the report. For each partner, a separate report is generated for each managing company that the partner is associated with. Therefore, if a partner participates in several joint ventures that are managed by different managing companies, the partner will receive one report for each managing company. The report includes:

  • Cover page with partner and joint venture managing company information

  • Summary of the distributed expenses and revenue by joint venture, business unit, and account

  • Extended Legal Entities information

  • Summary of all the cash calls for the partner and managing company

  • Details of the distributed transactions included on the summary page

The Embedded BI Publisher for JD Edwards EnterpriseOne is used to print and deliver the report to the partners. A report definition is delivered with the software that is preconfigured with a report template in RTF format, a source program, and delivery information outlined earlier.

Note:

To modify the Joint Venture Management Billing Report RTF template, you can use the BI Publisher Object Repository program (P95600) to find the XML Publisher template (TP09J650R01) and download the RTF document. You can modify the template provided or create a new template. For example, a customer may choose to remove the Joint Venture Billing Detail section from the delivered template. The user can delete the Joint Venture Billing Detail section and then upload the new template to the XML Publisher object.

See the JD Edwards EnterpriseOne Tools BI Publisher for JD Edwards EnterpriseOne Guide for information about the XML Publisher lifecycle. This guide includes information on how to create and modify documents, upload templates to the EnterpriseOne system, create report definitions, and run the reports.

This table shows the relationship between the report definition, source program, and report template that are used by the BI Publisher to print the Joint Venture Billing report:

Report Definition Source Program Version of the Source Program Template Name Template Type
RD09J650

Joint Venture Management Billing Report Definition

R09J650

Joint Venture Billing

XJDE0001 TP09J650R01

Joint Venture Management Billing Report Template

.rtf file

You use the BI Publisher Report Definitions program (P95620) to submit the report definition RD09J650 (Joint Venture Management Billing Report Definition). The RD09J650 report definition uses the Joint Venture Billing program (R09J650) and the version XJDE0001 to create and attach the Joint Venture Billing Report to an email.

The version of the Joint Venture Billing program (R09J650) selects the distribution detail information from the Joint Venture Distribution Detail table (F09J12) based on your data selection values. The program provides data selection options for the fields in the Account Master (F0901), Business Unit Master (F0006), Joint Venture Master (F09J30), and Joint Venture Distribution Detail (F09J12) tables, enabling you to select data on a joint venture, account number, distribution document, and so on. The system provides more than 300 columns over the joint venture data set that you can use to personalize your reports. The report is automatically sent to the primary contact of each partner.

The report definition also includes bursting, delivery, and email information that the BI Publisher uses to process and deliver the billing report.

For each partner, the system sends the billing report through an email to the partner's primary contact. The emails will be generated for each partner and managing company combination.

26.2 Understanding the Joint Venture Billing Report Generated by BI Publisher for JD Edwards EnterpriseOne

The TP09J650R01 report template includes a cover page, billing summary by joint venture, cash call summary, legal entity information, and joint venture billing detail.

Cover Page

The Cover Page includes this information:

  • Description of the managing company and the time period for which the report is generated

  • Partner's information

    This includes the legal name, address book number, alpha name, mailing name, and address of the partner, and the phone number and e-mail address of the primary contact for the partner.

  • Billing information

    This includes the partner's billing information, such as the alpha name, mailing name, and address of the person the report will be mailed to.

  • Payment terms

  • Remit To information

    This includes the name and address of the joint venture managing company.

  • Currency used for the amounts

The information in the Cover Page is retrieved from these tables: Company Constants (F0010), Legal Entities (F09J10), and Address Book - Who's Who (F0111).

Billing Summary by Joint Venture

The Billing Summary by Joint Venture section lists the partner's expenses and revenue summarized by account for every business unit included in each of the joint ventures that the partner participates.

For each business unit included in a joint venture, the Billing Summary by Joint Venture section includes the following details for distributed expenses and revenue:

  • Business unit description and number

  • Project number description and number, if available

  • Original transaction amount, partner's distributed amounts summarized by account, and the amounts that were vouchered, invoiced or drawn from a cash call to cover the distributed expense

  • Totals of these amounts for the business unit: original transaction amount, partner's distributed amounts, and the amounts that were invoiced or drawn from a cash call

Then, for each joint venture, the system prints the totals of the amounts (actuals, distributed, vouchered, invoiced, and drawn from cash calls) for all the business units in the joint venture.

The information in the Billing Summary by Joint Venture section is retrieved from these tables: Joint Venture Distribution Detail (F09J12), Joint Venture Master (F09J30), Account Master (F0901), and Business Unit Master (F0006).

Cash Call Summary

The Cash Call Summary section lists all the cash calls for the partner and the joint ventures that are under the managing company for which the report is generated. The system includes all the cash calls, regardless of whether they are invoiced, not invoiced, applied to distributed expenses, closed, on hold, and so on. You can set a processing option to exclude closed cash calls.

For each cash call, the system prints the following information:

  • Cash call description and ID

  • Cash call information, such as the business unit and project defined for the cash call, cash call effective date, cash call original amount, cash call amount applied to the distributed expense during the reporting time-period, cash call open amount, and cash call status

  • Cash call ledger information

    This can include cash call invoice information, transfer information, close and refund information, and so on. For example, this section will include the invoice date, invoice amount, invoice number, and document type in the case of a cash call invoice.

The information in the Cash Call Summary section is retrieved from these tables: Cash Call Definition (F09J40), Cash Call Ledger table (F09J41), and Joint Venture Distribution Detail (F09J12).

Joint Venture Legal Entity Description

For the joint ventures, partner, managing company, and business units included in the Billing Summary by Joint Venture section, the system prints the legal name and the first 1000 characters of the extended legal name from the Legal Entities table (F09J10). The system prints the extended legal name only when you have specified to print the extended legal name in the processing option for the R09J650 program.

Joint Venture Billing Detail

This section includes information grouped in the same way as in the billing summary. The only difference is that every distributed account transaction in the F09J12 table is listed in detail along with the amount that was invoiced or drawn from a cash call to cover the distributed amount. Additionally, the system also includes the invoice and voucher document number and type.

Note:

The system also prints the Distribution Only transactions. These transactions do not have invoice, cash call, or voucher information.

The information in the Joint Venture Billing Detail section is retrieved from these tables: Joint Venture Distribution Detail (F09J12), Joint Venture Master (F09J30), Account Master (F0901), and Business Unit Master (F0006).

26.3 Prerequisites

Before you complete the tasks in this section:

  • Ensure that you post all the documents that will be included in the billing report.

    These can include:

    • Cash call invoice documents to request the cash from the partners

    • Cash call journal entry documents to draw on the cash calls

    • Vouchers, invoices, and journal entries to bill and pay the partners

  • Set up the processing options for the Joint Venture Billing program (R09J650).

    On the Select tab, enter values for the following processing options:

    • Date for Data Selection: Specify whether to use the service tax date or the distribution G/L date to select distributed transactions for the joint venture billing report. The system uses this processing option to determine which date is used in conjunction with the Data Selection From Date and Data Selection Thru Date processing options.

    • From Date: Specify the start date of a date range that the system uses when selecting distributed transactions for the joint venture billing report. This processing option is required. If left blank, distributed transactions are not selected.

    • Thru Date: Specify the end date of the date range that the system uses when selecting distributed transactions for the joint venture billing report. This processing option is required. If left blank, distributed transactions are not selected.

    On the Process tab, enter values for the following processing options:

    • Reverse Revenue Amounts: Specify whether to reverse the sign of the revenue gross amount and revenue distributed amount. This option applies to revenue amounts and is used for display purposes only.

    • Closed Cash Calls: Specify whether to include or exclude closed cash calls from the Cash Call Summary content of the report.

    On the Currency tab, enter values for the following processing options:

    • Include Currency Amounts: Specify whether to include foreign currency amounts in the joint venture billing report. If you leave this processing option blank, foreign currency amounts will not be included.

    • Exchange Rate Date

      Specify the date that the system uses to retrieve the exchange rate. If you leave this processing option blank, the system date is used.

    On the Legal Entity tab, enter a value for the Print Extended Legal Name processing option.

    You use this processing option to determine whether to print the extended legal name for joint ventures, partners, and the joint venture business units if their extended legal names are available in the Joint Venture Legal Entities table (F09J10). Extended legal names are stored as text attachments in the F09J10 table.

    Note that the system prints only the first 1000 characters of the extended legal name.

26.4 Running the Joint Venture Billing Program (R09J650) to Print Joint Venture Billing Reports

From the Joint Venture Management module (G09J), select Periodic Processing, Process Distributed Transactions, and then select Joint Venture Billing.