This chapter covers the following topics:
Advanced Global Intercompany System provides extensive reports that help you in reviewing and reconciling transactions reports. Intercompany reports are built using Oracle XML Publisher technology. Oracle XML Publisher enables you to easily change the layout and publishing format of the reports thus allowing you to customize the reports to suite your requirements. The reports available in Intercompany are:
Oracle Intercompany Transaction Summary Report
Oracle Intercompany Account Details Report
Intercompany Reconciliation Report
Navigate to the Schedule Requests page to run the reports.
Note: For each parameter, the list of values displays the options associated with the user running the report. If no option is selected, then the report is generated for all the options in the list of values.
The Intercompany Transaction Summary report includes all appropriate transaction columns. This report provides information about intercompany transaction lines grouped by outbound and inbound transactions. You can customize this report for one or more intercompany organizations. Specifically, use this report to find if a period contains open transactions in it by listing the transactions for a particular batch or transaction status. The following table explains selected parameters of the report.
| Parameter | Description |
|---|---|
| Recipient | The recipients you select represent the recipients for outbound transactions. |
| Transaction Status | If the batch type is outbound, the transaction status displays initiator transactions or vice versa. |
| Destination | The invoicing rule for outbound and inbound transactions. Displays Receivables or Payables for outbound and inbound transactions respectively, if invoices are required. Otherwise, it is General Ledger. |
| AR/AP Invoice Number | As invoice numbers are similar for initiator and recipient transactions, depending on the option selected for Batch Type, the initiator and recipient transactions, or both are displayed in the report. |
The Intercompany Account Details report provides information about accounting details (outbound and inbound transactions) of intercompany transactions. Outbound transaction accounts include initiator distribution and initiator receivables accounting. Inbound transaction accounts include recipient distribution and recipient payables accounting. The following table explains selected parameters of the report.
| Parameter | Description |
|---|---|
| Transacting Legal Entity | This field is displayed if the Initiator From and Initiator To are the same legal entity. |
| Transaction Ledger | Displays the primary or secondary ledger of the selected legal entity. |
| Trading Partner Legal Entity | This field is displayed if the Recipient From and Recipient To are the same legal entity. |
| Account Type | If Liability or Asset is selected, the report displays intercompany receivables accounts and intercompany payable accounts. If Expense or Revenue is selected, the report displays distribution accounts. |
Reconciliation is the process of ensuring an intercompany transaction is accounted in Receivables for the initiator legal entity and Payables for the recipient legal entity. The Intercompany reconciliation report enables you to check any discrepancies or missing transactions.
Tip: Setting up unique intercompany accounts for each relationship between a transacting and trading legal entity simplifies the reconciliation.
To run the reconciliation report:
Submit the concurrent request Intercompany Reconciliation Data Extract Program.
This program gathers all the transactional data.
Navigate to the Reconciliation tab and select the ID of the concurrent request that was run in step 1.
Choose the template to display the results.
Drill down using the links provided in the report for detailed information.
The following table explains selected parameters of the Intercompany Reconciliation Data Extract Program.
| Parameter | Description |
|---|---|
| Transaction Ledger | The ledger of the initiator organization. |
| Transacting Legal Entity | The legal entity of the initiator organization. |
| Transacting GL Period | The GL period in the transacting ledger for which the report is run. |
| Trading Ledger | The ledger of the recipient organization. |
| Trading Legal Entity | The legal entity of the initiator organization. |
| Trading GL Period | GL period in the trading ledger. |
| Additional Currency | The currency in which the sum of the GL Balances must be displayed. |
| Conversion Type | This field is mandatory if Additional Currency is entered. |
| Conversion Date | If Additional Currency is entered and a conversion data is not entered, the default is the System date. |
Related Topics
Using the Concurrent Manager to Generate Your Custom Output, Oracle XML Publisher User's Guide
Running Reports and Programs, Oracle Applications User's Guide