|
|
References
The following steps should be taken in performing period-end processing for Oracle Receivables.
1. Complete All Transactions for the Period Being Closed
Ensure that all transactions like Invoicing, Credits, Adjustments, Receipts, Reversals and Lock Box Processing have been entered for the period being closed.
2. Reconcile Transaction Activity for the Period
Reconcile the transaction activity before posting to the General Ledger using SLA. This is to ensure that transactions are balanced and all items eligible for posting are reflected on the Sales Journal. Run the following reports for the same accounting period date range
|
Seq
|
Report
|
Purpose
|
Known Issues
|
|
1
|
Transaction Register
|
Shows transactions (i.e. invoices, debit memos, credit memos, deposits, guarantees and chargebacks) which were entered and completed in specified period.
|
Note 729051.1 R12 Why Do AR Reports like Account Status Report' or 'Transaction Register' or Aging Reports Not Show Secondary Ledger Currency In the Parameter List of Values?
Note 845008.1 Transaction Register Errors with "ORA-06503: PL/SQL: Function returned without value" When Reporting Level is Ledger
|
|
2
|
Sales Journal by Customer Report and the Sales Journal by GL Account Report
|
Enables the review of all transactions for the specified period by account type (i.e. receivables, revenue, freight, tax)
The total on the Sales Journal by GL Account should equal the total of items eligible for posting as listed on the Transaction Register. If any discrepancies are evident, research the customer balances to find out which balance does not tally, using the Sales Journal by Customer report.
|
Note 1069117.1 SALES JOURNAL BY CUSTOMER REPORT FAILS WITH REP-1401
Note 805645.1 R12: Sales Journal by GL Account Report (XML) replaces RDF report 'Sales Journal by GL Account'
Note 1106283.1 ARSJGLARPT Sales Journal by GL Account Report (XML) Takes Several Hours to Complete
Note 958727.1 AR Reconciliation Report Shows Wrong Sales Journal Entries After Upgrade To 12.1.1
|
|
3
|
Journal Entries Report
|
-
Enables the review and analysis of accounting entries in the Receivables subledger, as accounted by SLA
-
Also lists in detail, transactions that have been accounted with error, and all entries that could not be transferred to the general ledger
|
Note 1132626.1 AR Journal Entries Report Not Showing Credit Memo Refunds
Note 983063.1 SLA: How to Troubleshoot XML Performance Issues in the Account Analysis & Note 560990.1Journal Entries Report Completes With Warning XML Page Cannot be Displayed
Note 881050.1How Does Journal Entries Report Pick Up Data from AR/XLA Tables?
|
By using the following formula, ensure that the Transaction Register matches the Sales Journal:
Transaction Register (Items eligible for posting) + (2 * Credit Memo Total) = Sales Journal (Debits plus Credits)
E.g. $100 + (2 * $20) = Debits $120 + Credits $20
($120 Debits - $20 Credits)
Important :
-
The Transaction Register total for any credits must be adjusted, as they are negative on the Transaction Register and positive on the Sales Journal.
-
Ensure that the monthly transaction total is accurate and that no distribution issues exist.
-
In Journal Entries Report, to avoid duplication with subledger journal entries, general ledger journal entries imported from Subledger Accounting are not included in the report.
3. Reconcile Outstanding Customer Balances
Reconcile the outstanding customer balances at the beginning of a specified period with the ending balance for the same period, using the following formula, known as the Roll Forward Formula:
Period-End Balance = Outstanding Balance at Start of Period + Transactions + Adjustments + Invoice Exceptions + Applied Receipts + Unapplied Receipts
The following list represents the various components that affect a customer's balance and the reports, which can be run and reviewed to reconcile these components:
|
Component
|
Report
|
|
Beginning Balance
|
Aging reports
|
|
Transactions
|
Transaction Register
|
|
Adjustments
|
Adjustment Register
|
|
Exceptions
|
Invoice Exceptions Report
|
|
Applied Receipts
|
Applied Receipts Register (Identify payments received from customers)
|
|
Unapplied Receipts
|
Unapplied and Unresolved Receipts Register (identify payments received from customers)
|
|
Ending Balance
|
Aging report (as of the last day of the accounting period)
|
Important: Invoice Exceptions Report can be used to adjust the Transaction Register for any transactions, which are not open in Receivables, and therefore do not show up in the aging reports.
4. Review and Reconcile Receipts
Ensure that Oracle Receivables receipts balance by running the following reports
|
Report
|
Purpose
|
Known Issue
|
|
Unapplied Receipts Register
|
Provide detail information about customers on-account and unapplied payment for specified date range.
Includes both cash and miscellaneous receipts
|
Note 313074.1 Reports Error: APP-FND Errors in Unresolved And Unapplied Receipts Register
|
|
Receipts Journal Report
|
Displays details of receipts that appear in the Journal Entries Report which shows the receipt numbers that contribute to a particular GL account
|
Note 1220113.1 Displays Receipts Twice One For Unapp And One For Cash Distribution
Note 1077001.1 Receipt Journal Report Errors when Run as Output type PDF
Note 737453.1, Receipts Report: Receipt Register Report Known Issues And Patches
|
|
Receipt Register
|
The total of the Receipts Journal report should equal the total of all the receipts in the Receipt Register for the same GL date range. Both display invoice related receipts and miscellaneous receipts.
|
Note 393682.1 Unable to Reconcile Receipt Register to Receipt Journal Enhancement 5567693 is still pending.
Bug 7423482 Receipt Register and Receipt Journal do not show on-account
activity deemed functionality.
Bug 7589198 Receipt Register does not match Receipt journal deemed functionality (similar to Bug 7423482).
|
5. Reconcile Receipts to Bank Statement Activity for the Period
Important: The Create Accounting process must be re-run for any miscellaneous accounting entries generated from the bank reconciliation, for transfer to the General Ledger.
6. Post to the General Ledger
-
Prior to posting to the General Ledger, the Receipts Journal Report and Sales Journal display the transactions that would be posted to the General Ledger (provided the posting process was run for the same GL date range).
-
The posting process for Oracle Receivables involves a single step:
Create Accounting
This process can be submitted from the transactions screen to account for a specific receivables transaction or from the SRS screen to account for all receivables transactions. The accounting is done at the ledger level and the program has the ability to transfer and import into the General Ledger based on the parameters specified.
If Create Accounting is submitted with Mode = 'Final' and Transfer to General Ledger = 'No', the entries will have to be transferred separately.
7. Reconcile the General Ledger Transfer Process
-
The Create Accounting program produces the Subledger Accounting Program report which shows the subledger journal entries created for successful accounting events.
-
Compare this report to the Journal Entries Report (run in Posted status mode) and verify that they match. Use the same General Ledger date ranges for the Journal Entries Report and the Create Accounting program.
-
After transactions and receipts have been transferred to the GL tables, Account balances for transactions and receipts can be reconciled by generating the Sales Journal by GL Account Report, the Receipts Journal Report (in 'transaction' mode) and the Journal Entries Report for posted items.
The account totals in the Sales and Receipt journals should match the corresponding account balances in the Journal Entries Report.
Important: The 'Detail by Account' version of the Journal Entries Report may be the most useful for reconciliation in this case.
8. Reconcile the Journal Import Process
-
Create Accounting program submits Journal Import automatically when launched in Mode = 'Final' and Transfer to GL = 'Yes'.
-
Reconcile the Journal Import by manually reviewing the transactions in the Subledger Accounting Program Report, and comparing them with the Journal Entries Report output.
9. Close the Current Oracle Receivables Period
Close the current period in Oracle Receivables using the Open/Close Accounting Periods window.
Important: Where there are multiple operating units within the same ledger all operating units must be ready to close at the same time. All of the operating units that share a ledger also share the same period statuses. When you update the period statuses to 'Open' in one operating unit, that period is opened for all operating units within the ledger.
10. Review Reports and Reconciling AR and GL balances
|
Seq
|
Report
|
Purpose
|
Known Issues
|
|
1
|
Subledger Period Close Exceptions Report
|
The Subledger Period Close Exceptions Report lists all the accounting events and journal entries that fail period close validation. It is automatically submitted by General Ledger when closing a GL period if there are unprocessed accounting events or un-transferred journal entries.
|
Note 793598.1 How to use Subledger Period close Exception Report
Note 736361.1 Report shows Unprocessed Cash and Misc Receipts which are already processed
Note 1233033.1 How to close period when there are incomplete transactions
|
|
2
|
Third Party Balances Report
|
Displays balance and account activity information for Suppliers and Customers. The balances in this report can be compared with the General Ledger balances for the same control accounts to reconcile.
|
Note 951527.1 Third Party Balances Report Retrieves No Data For Receivables.
Note 1150295.1Third Party Balances Report Is Missing Some Items Even The Setup Has Been Done For Control
Note 601774.1Third Party Balance Report not showing Transaction Numbers
|
|
3
|
Reconcile Posted Journal Entries
|
After running the GL posting process in General Ledger, for the transactions, which were transferred in FINAL mode and with Post in GL being set to NO, run the Journal Entries Report (with Posted = Y ) to help reconcile the posted journals.
|
|
|
4
|
Review the Unposted Items Report
|
The output will consist of all items not posted to the General Ledger for the specified GL date range.
|
Note 793257.1 Which Transactions Are Printed On the Unposted Items Report
Note 559245.1 R12: Unable To Run The Unposted Items
|
|
5
|
Review Account Analysis Report
|
It only includes journal entries transferred to and posted to the General Ledger.Review this report and compare it with the Third Party balances report.
Note: To avoid duplication with subledger journal entries, General Ledger journal entries imported from Subledger Accounting are not included in the report.
|
Note 1130633.1 XLAAARPT Account Analysis Report Does Not Enforce Flexfield Segment Security Rules
Note 1189046.1 Subledger Account Analysis Report Fails To Complete Due To High Vol Data.
|
|
6
|
AR to GL Reconciliation Report
|
Compares the account balances in Receivables to those in General Ledger and highlights journal sources where discrepancies might exist.
|
Note 799753.1 AR to GL Reconciliation Report Shows Difference When There Is Cross Currency Receipt Application and Multiple Ledgers Data
|
11. Open the Next Oracle Receivables Period
Open the next period in Oracle Receivables using the Open/Close Accounting Periods window.
12. Logging a Service Request
-
Please create a service request and upload the report which is having the issue.
-
If there are items listed in Unposted Item report then provide report output as well as the output of Subledger period Close Exception Report and Period Closing diagnostics
-
If the Transactions/Receipts/Adjustment causing the error could be identified, then please provide diagnostics using the following Diagnostic catalogs to identify the correct diagnostic to use:
13. Patch Information
Please review Note 1307206.1, EBS: R12 Receivables Rollup Patch Collection February 2011 for additional information on the latest rollup patch available.
14. Community Discussions
Still have questions? Use the live My Oracle Support Receivables Community window below, to search for similar discussions or start a new discussion on this subject.
|