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
If you install Purchasing and Oracle Payables, you can run this report. If you accrue expense purchases on receipt, you can reconcile your expense AP accrual account using this report. If you accrue expense purchases at period end and you do not perform inventory receipts, no information will be available to report.
Attention: Most commercial installations accrue expense receipts at period end because this information is not required as the receipt occurs. If you accrue expense purchases on receipt, you have more entries to reconcile in the AP accrual accounts.
In the Submit Requests window, select AP and PO Accrual Reconciliation Report in the Name field.
Select the operating unit for the report.
Enter your title for the report.
Parameter to specify how to sort the data at the distribution level (independent of summarization parameter)
Valid Values: Item, Age in Days, Total Balance, Vendor, PO Number (default).
The number of days by which to group transactions sorted in descending order. (For example, if age group days is 60 which translates into 10 groupings for your transactions, then all distributions whose age in days is less than 60 days from the current date are in group 10. If the age in days is greater than 60 days, but less than 120, then they will be in group 9.).
Lower limit of item range to consider for this report.
Upper limit of item range to consider for this report.
Lower limit of vendor range to consider for this report.
Upper limit of vendor range to consider for this report.
Lower limit of distribution balance to display.
Upper limit of distribution balance to display.
Lower limit of balancing segment range to consider for this report.
Upper limit of balancing segment range to consider for this report.