How To Reconcile Accrual Reconciliation Report And GL [ID 414169.1]

How To Reconcile Accrual Reconciliation Report And GL [ID 414169.1]
		Modified 20-JUL-2009     Type HOWTO     Status PUBLISHED

In this Document
  Goal
  Solution
  References

---

 

 

Applies to:

Oracle Purchasing - Version: 11.5.10 to 11.5.10.4
Information in this document applies to any platform.

Goal

What general  steps should be followed to reconcile the Accrual Reconciliation Report and GL Inventory AP Accrual Account. Accrual Reconciliation Report only captures on line Accrual Transactions ie Transactions with accrue_on_receipt_flag = 'Y' in both po_line_locations_all and po_distributions_all. ARR is not used to reconcile Period End Accruals.

Solution

Action Plan to follow in reconciling Accrual Reconciliation Report with GL in 11.5.10

Let us assume you are trying to reconcile Jun-06 Period

1)Submit output of Diagnostics: Apps Check from Purchasing Responsibility.
Run for Oracle Purchasing

2) Check File version of POXACREC.rdf.  Make sure version is reasonably close to the latest version available. Please refer to Note 427771.1 for the latest patches.

 

3)The Accrual reconciliation report requires the transactions to be transfered to the General Ledger interface and then run journak inport to ensure the report balances to your general ledger.
.
For Payables, you need to create journal entries for the invoices. For
Purchasing, all transactions are automatically transferred to the General
Ledger interface.
For Inventory and Work in Process, you must first
perform a GL transfer or period close for transactions to be sent to GL_Interface and imported to GL
4)
Run the following query and provide the results in Excel format:
SQL> select * from gl_interface
where user_je_source_name = 'Purchasing'
and user_je_category_name = 'Receiving'
and accounting_date between '01-JUN-06' and '30-JUN-06';

5) If rows are returned by the above query, you will need to import and post
these records in GL.


6) Submit the Accrual Reconciliation Rebuild with the following parameters:

Full AP Classification: Yes
GL Dates From: <first day of your JUN-06 period>
To: <last day of your JUN-06 period>


7) Submit the Accrual Reconciliation Report with the following parameters:

Sort By : Item+
GL Dates From : <first day of your JUN-06 period>
To : <last day of your JUN-06 period>
Items From :
To :
Vendors From :
To :
Include All Transactions : No
Transaction Amount Tolerance : 0
Transaction Quantity Tolerance : 0
Include Written Off Transactions : NO
Aging Number of Days :


8) Identify each of the Accrual accounts contained in the Accrual Reconcil
iation Report just run.


9) 
Review  information (screen prints, draft reconciliation ) showing the
amount in GL that one is comparing the report with, showing that there is a
discrepancy.

10) Run the Account Analysis Report in GL with the following parameters. Run
the report separately for each account identified in step #7 above, then upload
each of the output files:

Type: Source Item
Currency: USD
Balance Type: Actual
Starting Period: JUN-06
Ending Period: JUN-06
Flexfield From: <accrual account>
Flexfield To: <same accrual account>
Order By: Source


11) Adjust the Account balances of the Account Analysis Report
to reconcile balances in Accrual Reconciliation Report:

ACCOUNT ANALYSIS REPORT:
==========================
Total Debits: XXXXXXX
Total Credits: XXXXXXX
Difference: DDDDDDD Credit if cr>db

Deduct (or Add) from difference above, Transactions(Sources) that will not be picked up by Accrual Reconciliation Report to get the Adjusted Total
For Example:
SOURCE DEBITS CREDIT NET DIFFERENCE
======== ====== ======= ================
Manual Journal XXXXXX XXXXXX DDDDDDD
Assets XXXXX DDDDDDD



10)If Accrual write Offs appear in the Accrual Reconciliation Report but not in Acount Analysis
Report the balance will have to be deducted from the Analysis Report

References

NOTE:427771.1 - 11.5.10 Accrual Reconciliation Report - Latest Fixes as of April 2, 2009

---

Related Products Oracle E-Business Suite > Procurement > Procurement > Oracle Purchasing