Oracle-Developer.com Forums

[vj.jain]

The Accrual Reconciliation Report has been replaced with 3 new reports:


AP and PO Accrual Reconciliation Report

The purpose of this report is to show all Oracle Payables (AP) and Oracle Purchasing (PO) transactions where the AP transactions are matched to PO (could be receipt as well). The AP and PO Accrual Reconciliation Report provides a transactional breakdown of each accrual account with a net balance not equal to zero in a summarized or full transaction details version. In summarized mode, for each accrual account, only the distribution information and PO, AP, WO (Write-Off) and Total Balances are displayed. For detailed mode, the individual transaction details for each distribution are also shown.

You can also see the age of the distribution on this report. Age of the distribution is calculated based on the value of a system profile "CST: Age in Days". If this profile is set to "Last Receipt Date", then age is calculated based on the date of the latest receipt transaction corresponding to this distribution. If the profile is set to "Last Activity Date" then age is calculated based on date of the latest invoice or receipt transaction corresponding to this distribution.

The report is first grouped by accrual account, then by aging bucket and then by purchase order distribution ID. Aging bucket is calculated depending on user specified value of "Aging period days" while submitting the report. Transactions are grouped according to their age into aging buckets

Usually this report is run in conjunction with the Summary Accrual Reconciliation Report as part of your period end accrual reconciliation process. See: Overview of Receipt Accounting,

Summary Accrual Reconciliation Report

The Summary Accrual Reconciliation Report can be used to analyze the balance of the Accounts Payable (AP) accrual accounts. You can accrue both expense and inventory purchases as you receive them. When this happens, you temporarily record an accounts payable liability to your Expense or Inventory AP accrual accounts. When Oracle Payables creates the accounting for the matched and approved invoice, Oracle Payables clears the AP accrual accounts and records the liability from the supplier site. See: Overview of Receipt Accounting.

The Accrual Reconciliation Report helps you monitor potential problems with purchasing and receiving activities that can affect the accuracy of your A/P accrual accounts. It displays the balance of each accrual account as well as partial representation of source of the balance


Miscellaneous Accrual Reconciliation Report

The purpose of this report is to show all inventory and AP (not matched to PO) transactions that have hit the accrual accounts. Transactions are grouped by accrual code. The report can be run either in summary where only the distribution information and balance is shown or in detail where all the transaction that make up a particular distribution are shown as well.

Usually this report is run in conjunction with the Summary Accrual Reconciliation Report as part of your period end accrual reconciliation process. See: Overview of Receipt Accounting,