The Combined Basis Summary reports enable users to manage and reconcile accrual and cash ledgers.
The Combined Basis Summary reports are shown in the table.
| Report Name | Description |
|---|---|
| Combined Basis Reports: Detail Report | The Combined Basis Reports: Detail Report details general ledger actual journal entry lines that have been entered into a general ledger, usually an accrual ledger, and not yet copied to the linked general ledger, normally a cash book, using Oracle Public Sector Financials (International) cash and accruals support functionality. The Detail Report also lists periods for which items have not been posted in the linked ledger. |
| Combined Basis Report: Total Report | This report is available in General Ledger. |
| Combined Basis Reports: Payables Report | The Combined Basis Reports: Payables Report details invoices that have been posted to the accrual ledger but have not been paid and have not been posted to the cash ledger. |
| Combined Basis Reports: AR Generate Data | The Combined Basis Reports: AR Generate Data report details transactions that have been posted to the accrual ledger but have not been posted to the cash ledger. |
Ensure that the following conditions exist for Combined Basis Reports: Detail Report:
The primary and secondary ledger have the same chart of accounts, currency and calendar.
The primary ledger is based on accrual accounting method and its secondary ledger is defined on a different accounting method such as cash.
The secondary ledger data conversion level is journal or subledger only and the posting to the cash ledger option is set to yes.
The primary and secondary ledger must be defined in the GL: Data Access Set profile option with full read access.
Ensure that the following conditions exist for Combined Basis Reports: Payables report and Combined Basis Reports: AR Generate Data reports:
The primary and secondary ledger have the same chart of accounts, currency and calendar.
The primary ledger is based on accrual accounting method and its secondary ledger is defined on a different accounting method such as cash.
The secondary ledger data conversion level is subledger.
You define rules to generate the accounting entries from subledger transaction and the Subledger Accounting Enabled option is set to yes.
The primary and secondary ledger must be defined in the GL: Data Access Set profile option with full read access.
To generate the Combined Basis Reports: Detail Report:
In General Ledger, navigate to the Submit a New Request window.
Select the Single Request radio button.
In the Name field, select Combined Basis Reports: Detail Report.
In the Primary Ledger field, select a primary ledger.
In the Secondary ledger field, select a different secondary ledger or accept the default.
In the Journal Source field, select the journal source or select All to report on all journals.
In the From Account field, select an account number.
In the To Account field, select an account number.
In the From Period field, select the start period.
In the To Period field, select the end period.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit.
To submit another request, click Yes.
To generate the Combined Basis Reports: Payables Report:
In Payables, navigate to the Submit a New Request window.
Select the Single Request radio button.
Place the cursor in the Name field to display the Combined Basis Reports: Payables Report.
In the Primary Ledger field, select a primary ledger.
In the Secondary ledger field, select a different secondary ledger or accept the default.
In the From Account field, select an account number.
In the To Account field, select an account number.
In the From Period field, select the start period.
In the To Period field, select the end period.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit.
To submit another request, click Yes.
To generate the Combined Basis Reports: AR Generate Data report:
In Receivables, navigate to the Submit a New Request window.
Select the Single Request radio button.
Place the cursor in the Name field to display the Combined Basis Reports: AR Generate Data report.
In the Primary Ledger field, select a primary ledger.
In the Secondary ledger field, select a different secondary ledger or accept the default.
In the From field, enter the first general ledger period on which to report.
In the To field, enter the last general ledger period on which to report.
In the From Accounts field, select the first account number.
In the To Accounts field, select the last account number.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit.
To submit another request, click Yes.