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
Joint venture parent business unit and description, 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 joint venture parent business unit 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.
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).