Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

R12 : AP Trail Balance

Posted on April 20th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

double-arrow Background

Once the entries have been made and before any report are extracted from the accounts, a trail balance is drawn up.This is standard accounting practice. This is just what it says it is - a try at balancing the figure before the profit is worked out and the balance sheet drawn up. By rule of thumb,If the double entry is correct, ie all debit entry for every credit entry and viceversa, then the total of debit balance and total of the credit balances equal .

double-arrow In release 12:

o 11i Trial Balance is known as the Open Account Balances Listing report in R12
o It runs based on the Open Account Balances Listing Definition that you define.
o You can define the Listing Definition at a Ledger or Ledger Set level

It runs based on the Open Account Balances Listing Definition that you define then select as a parameter when you submit the Open Account Balances Listing report.

Trail Balance

As a prerequisite, you must run the Open Account Balances Data Manager and select the Open Account Balances Listing Definition in the parameter labeled "Trial Balance Definition".

2

Now , you can define the Listing Definition at a Ledger or Ledger Set level such that when you run the report, you can view open liability balances for operating units belonging to a given ledger or ledgers within a ledger set as shown below:

3

double-arrow Similar Post

Related Posts

Posted in Oracle Payable, R12 | 6 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
6 Responses
  1. Solid_Snake Says:

    This article solved my issue, but it is necessary to Create or Update Open Account Balances Listing Definitions as follow:
    Payables Responsibility > Setup > Accounting Setups > Subledger Accounting
    Setups > Open Account Balances Listing Definitions

  2. Sanjit Anand Says:

    thanks cerroi for nice words.

    Could you share some more thoughts on this with others

  3. Solid_Snake Says:

    Ok Sanjit, I will be glad to share, I’m a new user of your site

  4. Sub Ledger Accounting - Technical perspective | OracleApps Epicenter Says:

    […] Run an Open Account Balances Listing, check out old post […]

  5. Biju Nair Says:

    The Open Account Balances Listing report does not show the details even though I pass “Yes” to the parameter “Show Transaction Detail”. I am not sure if I am missing some setup or am I required to run any other concurrent program? please advise.

  6. SUHAIL Says:

    Can some one pls explain what the orignal amount and remaining amount mean in the report output for open account balances report.

    Thank you.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.