- OracleApps Epicenter - http://www.oracleappshub.com -

R12 : AP Trail Balance

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 .

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.

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".

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:

Similar Post

6 Comments (Open | Close)

6 Comments To "R12 : AP Trail Balance"

#1 Comment By Solid_Snake On May 6, 2008 @ 3:11 pm

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 Comment By Sanjit Anand On May 6, 2008 @ 4:21 pm

thanks cerroi for nice words.

Could you share some more thoughts on this with others

#3 Comment By Solid_Snake On May 7, 2008 @ 2:17 pm

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

#4 Pingback By Sub Ledger Accounting – Technical perspective | OracleApps Epicenter On October 9, 2008 @ 1:27 am

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

#5 Comment By Biju Nair On March 16, 2009 @ 9:59 am

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 Comment By SUHAIL On August 20, 2009 @ 1:27 am

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

Thank you.