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.