25 Printing Joint Venture Invoices (Release 9.2 Update)

This chapter discusses:

25.1 Understanding the Joint Venture Invoice Print Process

After you have created joint venture invoices for the partners, you print the invoice for each partner in a format that outlines the charges for each business unit, and e-mail the invoice to the partner.

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

Note:

To modify the Joint Venture Invoice Print RTF template, you can use the BI Publisher Object Repository program (P95600) to find the XML Publisher template (TP09J505R01) 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 Invoice Distribution Detail by Joint Venture section from the delivered template. The user can delete the Invoice Distribution Detail by Joint Venture 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 joint venture invoices:

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

Joint Venture Management Invoice Print

R09J505

Joint Venture Invoice Print

XJDE0001 TP09J505R01

Joint Venture Management Invoice Print Template

.rtf file

You run the XJDE0001 version of the Joint Venture Invoice Print program (R09J505) to source invoice information for printing. The program selects joint venture invoices from the Customer Ledger table (F03B11) based on your data selection values. The program provides data selection options for the fields in the F03B11 and F09J12 tables, enabling you to select data on a joint venture, document number, and so on.

The report definition also includes delivery and e-mail information that the BI Publisher uses to process and deliver the invoice report.

The system e-mails the invoice for each partner to the partner's primary contact. If your data selection is on a joint venture that involves several partners, then the system will split the XML file by invoice document number into several XML files, one XML file for each partner and joint venture company in order to print and deliver a separate invoice to each partner.

25.2 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).

25.3 Prerequisite

Before you complete the tasks in this section, set up the Print Extended Legal Name processing option for the Joint Venture Invoice Print program (R09J505). You use this processing option to determine whether to print the extended legal name for joint ventures, partners, or 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.

25.4 Running the Joint Venture Invoice Print Program (R09J505) to Print Joint Venture Invoices

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