Understanding the Joint Venture Invoice Print Report Generated by BI Publisher for JD Edwards EnterpriseOne
The TP09J505R01 report template includes a cover page, invoice summary, legal entity information, and invoice distribution detail information.
Cover Page
The Cover Page includes this information:
Legal name for the joint venture company and the date the invoice is printed
Partner's information
This includes the partner's legal name, address book number, alpha name, mailing name, and address, and the phone number and e-mail address of the primary contact for the partner.
Invoice information
This includes the invoice number, invoice date, payment terms, payment due date, currency, and amount due.
Billing information
This includes the partner's billing information, such as the alpha name, mailing name, and address of the person the invoice is billed to.
Remit To information
This includes the name, mailing name, and address of the managing business unit, and the phone number and e-mail address of the primary contact for the managing business unit.
The information in the Cover Page is retrieved from these tables: Company Constants table (F0010), Legal Entities (F09J10), and Address Book - Who's Who (F0111).
Invoice Summary
The Invoice Summary section includes the same information about the partner, invoice, and Remit To that is printed on the cover page, and also lists the summarized charges for every business unit included in the joint venture and for all the joint ventures that the partner is associated with. For each joint venture, the joint venture name and description is printed. For each business unit included in a joint venture, the Invoice Summary section includes this information:
Business unit number and description
Actual expenditure and the partner's distributed amounts summarized by account
Totals of the actual expenditure and the partner's distributed amounts for the business unit
The end of the Invoice Summary section includes the totals of the amounts (actuals and distributed) for all the business units in the joint venture and the totals of the amounts (actuals and distributed) for all the joint ventures that the partner is associated with.
The information in the Invoice Summary section is retrieved from these tables: Joint Venture Distribution Detail (F09J12), Joint Venture Master (F09J30), Account Master (F0901), and Business Unit Master (F0006).
Joint Venture Legal Entity Description
For the joint ventures and business units included in the Invoice Summary 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 R09J505 program.
Invoice Distribution Detail by Joint Venture
The invoice distribution detail by joint venture includes the same information about the partner, invoice, and Remit To that is printed on the cover page and in the invoice summary. It also includes information grouped in the same way it is in the invoice summary. The only difference is that every distributed account transaction in the F09J12 table is listed in detail. For each joint venture, the joint venture name and description is printed.
For each business unit that is included in the joint venture, the Invoice Distribution Detail by Joint Venture section includes this information:
Business unit number and description
Every distributed account transaction for the business unit available in the F09J12 table
The system prints this information for each account transaction: the account number, account description, service tax date, explanation or remark for the transaction, actual transaction amount, the percent of interest for the partner, and the distributed amount for the partner.
Totals of the actual expenditure and the partner's distributed amounts by account
Totals of the actual expenditure and the partner's distributed amounts for the business unit
The end of the Invoice Distribution Detail by Joint Venture section includes the totals of the amounts (actuals and distributed) for all the business units in the joint venture, and the totals of the amounts (actuals and distributed) for all the joint ventures that the partner is associated with.
The information in the Invoice Distribution Detail 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).