Distributing Expenses, Revenue, and Overhead to the Partners

Before You Begin

This 30-minute tutorial shows you how to distribute expense, revenue, and overhead transactions to the joint venture partners. You will review the distributions made to the partners for the joint venture and remove distribution detail records for a transaction so that it can be directly billed to the managing business unit.

Scenario

It is the end of the month for the joint venture A-GREENACREHOLDINGS. You have pulled in expenses, revenue, and overhead expenses that have occurred for the joint venture, and assigned divisions of interest (DOIs) to the transactions. You are now ready to distribute the transactions among the partners by running the Generate Joint Venture Distribution Detail program (R09J402). You analyze the result and determine that a transaction was incorrectly distributed. Instead of distributing to all the partners in the DOI, the transaction should have been directly billed to the managing business unit of the joint venture.

What Do You Need?

• The expenses, revenue, and overhead expenses are loaded in the Joint Venture Management system.
• The DOIs or Direct Billed To are assigned to the transactions.

Distributing Joint Venture Transactions to the Partners

In this task, you will distribute the joint venture account ledger transactions to the partners for the joint venture A-GREENACREHOLDINGS.

1. Navigate to EnterpriseOne Menus, Financials, Joint Venture Management (G09J), Periodic Processing, Distribute G/L Transactions, Generate Joint Venture Distribution Detail (R09J402).
2. On the Work With Batch Versions form for Generate Joint Venture Distribution Detail (R09J402), select the XJDE0001 version. Then, from the Row menu, select Processing Options.

   

3. On the Select tab, leave the Ledger Type processing option blank.

   This will create distribution detail records for the AA ledger.

4. On the Process tab, leave the AA Ledger as Distribution Only processing option blank.

   All distribution detail records that are entered can be used to create journal entries, invoices, and vouchers.

5. On the Work with Batch Versions form, select the XJDE0001 version. Then, from the Row menu, select Data Selection.
6. On the Data Selection form, enter the following values on the first row and click OK:
   
   
   • Left Operand: Joint Venture Name (F09J30) (JVNAME) [BC]
   • Comparison: is equal to
   • Right Operand: Literal

   Literal Value field under Single Value tab: A-GREENACREHOLDINGS

   Your Data Selection form should look like this:



7. To submit the version for processing, complete the following steps:
   
   
   1. On the Work with Batch Versions form, with the XJDE0001 version selected, click Select.
   2. On the Version Prompting form, click Submit.
   3. On the Printer Selection form, click OK.
8. Review the PDF report. This will list all joint ventures that are processed with a message that indicates if any errors and/or warning were encountered. In this case, the message should be empty.
   

   

Reviewing the Distributed Transactions

In this task, you will review and analyze the distributed transactions.

1. Navigate to EnterpriseOne Menus, Financials, Joint Venture Management (G09J), Daily Processing, JV Distribution Summary by Partner (P09J12B).
2. On the Review JV Distribution Summary by Partner form, enter A-GREENACREHOLDINGS in the Joint Venture Name field and click Find.

   Note that the Joint Venture Company, Joint Venture Currency, Period Number, and Fiscal Year fields are populated with default values from the joint venture.

   Your distribution summary by partner records should look like this:

   

   You review the distribution summary and find that the distributed cost/expense amounts for an outside partner is more than expected.

3. To review the distribution detail, select the outside partner 7500010 – Thomson Company and from the Row menu, select Partner Dist Detail.

The system displays the Revise Joint Venture Distribution Detail by Partner form of the JV Distribution Detail by Partner program (P09J12C).

The records for the distribution detail by partner should look like this:



4. Scroll to the right and note that there is a distribution for 4000.00. You find that this is incorrect. This amount should have been billed directly to the managing business unit (981 – Green Acre Holdings Share).
   

   

5. Continue to scroll to the right until you are able to find the source transaction information that this distribution record was based on. Note down the following information. You will use this information in the next task.
   
   
   • Document Number = 10125581
   • Doc Type = JE
   • JE Line Number = 1.0

   

Deleting Distribution Detail Records and Reassigning the Account Ledger Record

In the previous task, you found that a transaction was incorrectly distributed. Instead of distributing to all the partners in the division of interest, the transaction should have been directly billed to the managing business unit of the joint venture. In this task, you will delete the distribution detail records and reassign the joint venture account ledger record to the managing business unit.

1. Navigate to EnterpriseOne Menus, Financials, Joint Venture Management (G09J), Daily Processing, JV Account Ledger Revisions (P09J11).

The Joint Venture Account Ledger Revisions form is displayed.

2. Scroll to the right until you find the source document columns (Document Number, Doc Type, and JE Line Number). In the QBE fields for these columns, enter the values for the source transactions that you have noted in step 5 of the previous task, and click Find.

   The joint venture account ledger record that the system displays should look like this:

   

3. Select the record and from the Row menu, select Distribution Detail.

The system displays the Revise Joint Venture Distribution Detail form of the P09J12 program. This form has information about how the source transaction was distributed to each of the partners.



4. Scroll to the right of the form to see the 4000.00 that was distributed to the outside partner 7500010 – Thomson Company as well as the distributions made to the other partners.
   

   

5. Click Close on the Revise Joint Venture Distribution Detail form.
6. On the Joint Venture Account Ledger Revisions form, select the record and from the Row menu, click Delete Dist Selected. This will delete all the distribution detail records associated with the source transaction line.

Refer the graphic below for the Joint Venture Account Ledger Revisions form with the distribution detail record and the Row menu options.



7. On the Confirm Delete window that is displayed, click Yes to confirm the delete.
8. Note that the Transaction Status is now Available to Process for the record.

   

9. Clear the DOI Name field and populate the Direct Billed To Insider BU field with the value 981.

   

10. Click OK.

Processing the Changes Made to the Transactions and Reviewing the Changes

1. Navigate to EnterpriseOne Menus, Financials, Joint Venture Management (G09J), Periodic Processing, Distribute G/L Transactions, Generate Joint Venture Distribution Detail (R09J402).
2. Follow steps 2 to 7 in the section Distributing Joint Venture Transactions to the Partners (R09J402) to submit the XJDE0001 version again.
3. Review the PDF report to verify that the joint venture was processed successfully with the changes and there is no error or warning.

   

4. Navigate to EnterpriseOne Menus, Financials, Joint Venture Management module (G09J), Daily Processing, JV Distribution Summary by Partner (P09J12B).
5. On the Review JV Distribution Summary by Partner form, enter A-GREENACREHOLDINGS in the Joint Venture Name field and click Find.
6. Review the distribution summary for A-GREENACREHOLDINGS and note that the Distributed Cost/Expense amounts for the partners reflect the changes you made.