Free Oracle Magazine Profit:The Executive's Guide to Oracle Applications

Enter your e-mail address to receive notifications when there are new posts

Profit Magazine: 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

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

Posted in Oracle Payable, R12 | Email This Post Email This Post | Print This Post Print This Post

3 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

Leave a Comment

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