How To Implement Open Account Balances Listing (OABL) Report for Receivables [ID 849539.1] | |||||
| |||||
修改时间 11-JUN-2010 类型 HOWTO 状态 PUBLISHED |
Applies to:
Oracle Receivables - Version: 12.0.0 to 12.1.2 - Release: 12 to 12.1Information in this document applies to any platform.
XLATBRPT Open Account Balances Listing
Goal
The Open Account Balances Listing (OABL) provides details of subledger transactions contributing to outstanding balances of General Ledger accounts.This document explains the behavior. of OABL, how to implement it in Receivables, the various formats available, how business flows impact the output generated by the report and the difference between OABL and Aging Reports.
Solution
Overview
The Open Account Balances listing displays the actual accounted amounts and does not include encumbrance or budgetary amounts in General Ledger. This report displays information that originates from subledger journal entries only. Journal entries created manually in General Ledger or created outside of Subledger Accounting are not included.
The Open Account Balances Listing relies on the Applied-to accounting attributes, which support the business flow feature, to determine how an applied transaction affects the outstanding balance of a source transaction. Using the Applied-to attributes, the report calculates the outstanding balance of the source transactions. The report displays only transactions with non-zero outstanding balances.
Impact of Business Flows
Receivables does not use business flows for the “Standard Accrual” Subledger Accounting Method (SLAM). Hence Subledger Accounting trial balance table is not populated with Applied-to transaction attributes. In the absence of Applied-to transaction details, the report does not relate applied receipts to the source transactions and displays transactions and related receipts as separate transaction entities. This results in both transactions and partially or fully applied receipts being displayed with remaining amount same as original amount. But the total amount outstanding under each customer will show correct balance (i.e. net of Invoice amount and Receipt amount). Hence when using the Subledger Accounting Method “Standard Accrual” it is recommended to use “Group By Third Party, Summary” template, which does not show transaction details and shows only the summarized customer outstanding balance by GL account.
The following screenshot shows sample output when Business flows are not in use :
Receivables uses business flows when the Subledger Accounting Method is “Multi Fund Accounts Receivables – Accounting Method” or “Multi Fund Accounts Receivables – Balancing Method” or customized SLAM with business flows enabled. In this case, the Open Account Balances Listing report output displays transaction details and the applied receipts under “Applied Transactions” section. Remaining amount of transaction shown is actual amount due on the transaction. Transactions applied fully against receipts and with zero outstanding balance are not shown.
The following screenshot shows sample output when Business Flows are in use :
Set-up Steps
To enable Open Account Balances Listing in the Receivables Application, the following set-up needs to be completed:
- Login to Receivables Application responsibility
Navigate to: Accounting Setups > Sub Ledger Accounting Setup > Post Accounting Programs - Register the program code as follows:
- Program Code: OPEN_ACCT_BAL_DATA_MGR_222 (222 is the Application ID for Receivables)
- Program Name: Open Account Balances Receivables Data Manager
- Assignment Code: ORACLE RECEIVABLES
- Assignment Name: Oracle Receivables Standard
- Assign the accounting class (e.g. Receivable) assignments for which the trial balance should be populated by clicking on Accounting Class Assignments. We can assign new Accounting Class Codes by adding a new record in Accounting Class Assignments screen.
Notice different assignments like Receivables (to display REC Account of Transactions), On-Account Cash, Unidentified Cash, Unapplied Cash, Cash (to display Receipts of various statutes).
Similarly more assignments can be added.
After the above is completed, when the Open Account Balances Data Manager is spawned during rebuild (any update on Open Account Balances Listing Definition launches Data Manager) or during ‘Transfer to General Ledger’ run from Receivables application, the SLA trial balance table will be populated with records having accounting class codes assigned in the above setup for Receivables application.
Open Account Balances Data Manager can also be launched from the Concurrent Requests window.
Navigate to: View > Requests
If the Open Account Balances Data Manager or Open Account Balances Listing concurrent requests are not found in the Concurrent Requests window then these requests have to be added to the request group attached to the Receivables responsibility as shown in the below screenshot:
- Login to System Administrator responsibility
Navigate to: Security > Responsibility > Request
Note:
The above setup has to be explicitly performed for Receivables or any other non-Payable applications so that Trial balance can be rebuilt according to the accounting class codes specified for that application. The trial balance will not be rebuilt if this setup is missing.
After the application of Patch 7320079, Open Account Balances Listing can be rebuilt for applications other than Payables and for accounting class codes as specified in the accounting class assignments for such application provided the above setup is made.
After the application of Patch 7109823, the above setup for Payables will be done by default.
Open Account Balances Listing vs. AR Aging Report
Receivables Aging Report provides the aging information of outstanding customer balances as of a specific date. The report segregates customer outstanding balances into user defined aging buckets. Open Account Balances Listing report provides information of customer outstanding balances but does not perform. aging of the same.
Available Report Formats
The report can be viewed in detail or summary mode through the following four seeded templates:
- Open Account AP Balances Listing - Group by Account, Detail
This template groups the output by General Ledger account. For each account, the report shows the General Ledger balance and the transactions (grouped by third party) that contribute to the balance of that account.
- Open Account AP Balances Listing - Group by Account, Summary
This template groups and summarizes the output by General Ledger account. Always use this layout for the reconciliation purpose.
- Open Account AP Balances Listing - Group by Third Party, Detail
This template groups output by third party. For each third party, the report displays the General Ledger accounts and transactions with outstanding balances. For the Group by Third Party templates, General Ledger account balances are not displayed because General Ledger does not track individual balances for third parties, only the net balances of an account.
- Open Account AP Balances Listing - Group by Third Party, Summary
This template groups the output by third party with one row summarizing each account. No transactions are displayed. For each third party, one row is displayed for every General Ledger account having an outstanding balance.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/86584/viewspace-683680/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/86584/viewspace-683680/