Legal | Privacy
Managing Intercompany Transactions in Financial Management

Managing Intercompany Transactions in Financial Management

This tutorial covers entering, matching, posting, and verifying intercompany transactions in Financial Management.

Approximately 1 hour

Topics

This tutorial covers the following topics:

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

This tutorial covers entering, matching, posting, and verifying intercompany transactions in Financial Management.

Back to Topic List

Your company is closing its books for January 2007 and discovers that its Connecticut sales office owes $35,000 to its California sales office. You must enter and reconcile the intercompany transactions between the two sales offices. In the Intercompany Transaction module of Financial Management, you enter, match, post, and verify the intercompany payables and receivables transactions.

Back to Topic List

Prerequisites

Before starting this tutorial, you should:

1.

Have access to or have installed Financial Management 9.3.1

2.

Have access to or have created the Reports application

Back to Topic List

Entering Intercompany Transactions

In this part of the tutorial you enter intercompany payables and receivables transactions for Connecticut.EastSales and California.West Sales. Before entering transactions, you open the period in which the transactions occur.

Opening Periods for Intercompany Transactions

1.

On your desktop, perform the following actions:

a. Double-click the Workspace icon.

b. Enter user name trnadmin and password hyperion.

c. Click Log On to log on to Workspace.

 

2.

Select Navigate > Applications > Consolidation > REPORTS.

The Reports application is displayed.


3.

In the Browser View pane, expand Tasks > IC Transaction Tasks, and select Manage IC Periods.

The Manage IC Periods page is displayed.

 

4.

Perform the following actions:

a. In the Scenario list, select Actual.

b. In the Year list, select 2007.

c. In the Period column, select January.

d. Click Open Period.

 

5.

Verify that the period January for year 2007 and scenario Actual is open.

You have successfully opened a period.

 

Back to Topic

Entering Intercompany Payables Transactions

1.

In the Browser View pane, select IC Transaction Tasks > Process IC Transactions.

The Intercompany Transactions page is displayed.

 

2.

Perform the following actions:

a. Verify that the point of view is set as follows: Actual, 2007, January.

b. Click New.

The New Intercompany Transaction page is displayed.


3.

Perform the following actions:

a. In the Transaction ID box, enter ES-IC 501.

b. Click Pick Members.

The Point of View page is displayed.

 

4.

Perform the following actions:

a. Set the members as follows:

Dimension Value
Entity Connecticut.EastSales
Account ShortTermPayInterco
ICP WestSales
LineOfBusiness [None]
Markets [None]
Grades [None]
Units&Flows Increases

b. Click OK.

The New Intercompany page displays the selected members.

 

5.

Perform the following actions:

a. In the Transaction Amount box, enter 35000.

b. In the drop-down list, select USD.

c. In the Conversion Rate box, enter 1.

d. Click Save.

e. Click Close.

 

6.

Verify that the ES-IC 501 transaction is listed on the Intercompany Transactions page.

You have successfully entered an intercompany payables transaction for Connecticut.EastSales.

 

Back to Topic

Entering Intercompany Receivables Transactions

1.

On the Intercompany Transactions page, click New.

The New Intercompany Transaction page is displayed.

 

2.

Perform the following actions:

a. In the Transaction ID box, enter WS-IC 1001.

b. Click Pick Members.

The Point of View page is displayed.


3.

Perform the following actions:

a. Set the members as follows:

Dimension Value
Entity California.WestSales
Account ShortTermRecInterco
ICP EastSales
LineOfBusiness [None]
Markets [None]
Grades [None]
Units&Flows Increases

b. Click OK.

The New Intercompany page displays the selected members.

 

4.

Perform the following actions:

a. In the Transaction Amount box, enter 35000.

b. In the drop-down list, select USD.

c. In the Conversion Rate box, enter 1.

d. Click Save.

e. Click Close.

 

5.

Verify that the WS-IC 1001 transaction is listed on the Intercompany Transactions page.

You have successfully entered an intercompany receivables transaction for California.WestSales.

 

Back to Topic

Matching and Posting Intercompany Transactions

After entering the transactions, you match the transactions. The matching process ensures that all entries are entered and reconciles differences between the intercompany account balances. Finally, you post the intercompany transactions to include them in an account balance.

1.

On the Intercompany Transactions page, select Match > Auto Match.

The AutoMatch page is displayed.

 

2.

Perform the following actions:

a. In the Entity box, select California.WestSales.

b. In the Partner box, select Connecticut.EastSales.

c. Select Match by Account.

d. Click Add.


3.

Perform the following actions:

a. In the member list, select Intercompany.

b. In the list of intercompany accounts, select ShortTermRecInterco.

c. Click OK.

The account is displayed on the AutoMatch page.

 

4.

Click Add.

 

5.

Perform the following actions:

a. From the member list, select Intercompany.

b. From the list of intercompany accounts, select ShortTermPayInterco.

c. Click OK.

Both accounts are displayed on the AutoMatch page.

 

6.

Click Match.

The Running Tasks window is displayed.

 

7.

Verify that the process is completed, and click X to close the window.

The AutoMatch page is displayed.

 

8.

Click Close.

The Intercompany Transactions page is displayed.

 

9.

Verify that the Status column is updated.

Note: The green squares in the Status column indicate that the transactions are matched.

 

10.

Select Post > Post All.

The Running Tasks window is displayed.

 

11.

Verify that the process is completed, and click X to close the window.

The Intercompany Transactions page is displayed.

 

12.

In the Browser View pane, select Process IC Transactions.

The page is refreshed.

 

13.

Verify that the Status column is updated again.

Note: The green flag in the Status column indicates that the transactions were posted.

You have successfully matched and posted intercompany transactions between California.WestSales and Connecticut.EastSales.

 

Back to Topic List

Verifying Intercompany Transactions

After entering, matching, and posting the intercompany transactions, you can verify and review the transactions in the Transactions Details report.

1.

In the Browser View pane, expand Documents, and select Data Grids > ICOTrans.

The sum totals of the posted intercompany transactions are displayed.

 

2.

Select the EastSales, ShortTermRecInterco cell.


3.

Right-click the selected cell, and select Intercompany Transactions.

The progress window is displayed.

 

4.

Verify that the process is completed, and click the Report icon to the right of Intercompany Transaction Report.

The Transaction Details report is displayed.

 

5.

Verify that the grand total of the transaction is -35000 and that the status is Matched.

 

6. Select File > Close.
7.

Select the WestSales, ShortTermPayInterco cell.

 

8.

Right-click the selected cell, and select Intercompany Transactions.

The progress window is displayed.

 

9.

Verify that the process is complete, and click the Report icon to the right of Intercompany Transaction Report.

The Transaction Details report is displayed.

 

10.

Verify that the grand total of the transaction is 35000 and that the status is Matched.

The two intercompany transactions are reconciled and matched.

 

Back to Topic List

In this lesson, you learned to:

Back to Topic List

Back to Topic List

Place the cursor over this icon to hide all screenshots.

 

 

 

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy