Third-Party Control Account Balances Report

This topic includes details about how you use the Third-Party Balances Report.

Overview

You can use the Third-Party Control Account Balances Report to review subledger accounting third-party control account balances and activity for suppliers and customers.

Here is a screenshot of the Third-Party Control Account Balances Report.

The screenshot shows an example of the Third-Party Control Account Balances Report.

Key Insights

You can view these information in the Third-Party Control Account Balances Report:

  • Third-party balances for subledger accounting third-party control accounts.

  • Subledger journal entry lines that add up to the total period activity for each control account, third party, and third-party site.

  • Third party and third-party site information.

  • User transaction identifiers for the associated entries.

Report Parameters

Let's look at the parameters of the Third-Party Control Account Balances Report.

Name

Description

Journal Source

Select from a list of enabled journal sources mapped to an accounting generating subledger application.

Ledger

Select a ledger.

You must have access to the ledger either directly through a GL Data Access Set or through a:

  • Business unit

  • Asset book

  • Payroll security assignment

From Accounting Period

Indicate the beginning period for the report data.

To Accounting Period

Indicate the ending period for the report data.

Third-Party Type

Select the type of third party defined for the subledger application for the journal source. Values are Customer, Supplier, and All.

Third-Party Name

Select a customer or supplier based on the third party type.

Third-Party Site

Select a third-party site for the supplier or customer identified by third-party name.

From Third-Party Number

Indicate the beginning of the range of customer or supplier numbers based on the third party type.

To Third-Party Number

Indicate the ending of the range of customer or supplier numbers greater than or equal to the From value.

Include User Transaction Identifier

Specify whether the user transaction identifiers are included in the report data.

Account Filter

Enter the filtering conditions on the account. You can select all segments for the selected ledger and define conditions including account value ranges.

Frequently Asked Questions

These are some frequently asked questions about the Third-Party Control Account Balances Report.

FAQ

Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report when you want to review subledger accounting third-party control account balances and activity for suppliers and customers.

What type of report is this?

Oracle Business Intelligence Publisher