Global Ledger standard application reports and lists

Global Ledger information for reporting is located throughout the navigation menus. In addition, you can create a report from any list.

This table contains the standard application reports and lists for Global Ledger. To find the reports, use the menu search. Search for the Report name unless a name is specified in the Menu name column.

Report name Description Menu name
Account Analysis. Click the link in Analyze Accounts. View account information by reporting basis for a specific period or range. Additional report parameters are available based on finance enterprise group dimensions. Each listed account includes a summary of activity, and a beginning and ending balance for the specified period or range. Drill down into hierarchy of summary accounts and view totals and transactions of any summary or posting account. n/a
Accounting entity View all accounting entities and identify the reporting basis to which the accounting entity is assigned. Reporting Basis For Entity
Accounting entity Payables and Receivables Use to reconcile inter entity balances. An inter entity dimension must be defined on the inter entity relations.

Panes:

  • Accounting Entity: Shows the accounting entities.
  • Chart Account: Shows the associated inter entity payable and receivable accounts for the selected entity.
  • Finance Totals: Lists the entities to pay or receive amounts to the entity that is selected in the Accounting Entity pane.
  • Transaction list: Shows the journal entries that are included in the balance from the Finance Totals pane.

Tabs:

  • Inter Entity Payables And Receivables: Excludes close ledgers.
  • All Inter Entity Payables And Receivables: Contains all ledgers.
  • Totals: Contains two lists of General Ledger Total records that are restricted to the records for inter-entity receivables and inter-entity payable accounts. Use these lists to compare the records to reconcile the account balances.
  • Inter Entity View: A card view of accounting entities. Select a card for an accounting entity to show the associated inter entity payables balances and the related transactions.

    Shows the associated inter entity receivables balances and the related transactions.

 n/a
Average Daily Balance View and query the calculated daily balances, aggregates, and averages for all reporting bases that are enabled for average daily balance. Average Daily Balance Report
Basis Gain Loss Revalue or translate a reporting basis. Verify that the chart of accounts used by the reporting basis has designated currency gain and loss accounts.

Use this report to view the offsetting transactions that were created in the currency gain and loss accounts.

n/a
Close Report View the status of year close for a reporting basis and basis year for each close of the year. Changes to Global Ledger Total records because the last close are listed and retained earnings changes are separately listed. Basis Close Report
Commitments And Encumbrances Report View all commitments and encumbrances records created from various subsystems. The information displayed in this report are the records from GL Commit Document, GL Commit, and GL Commit History business classes. It is only available when there are commitment records. n/a
Compare Analysis View current period to previous period by beginning balance, period balance, and ending balance for functional amount measure.

For more information, see Pivot analysis reports.

 n/a
Department Payables And Receivables View necessary information to analyze the department payables and receivables accounts. n/a
Finance Transaction Detail View internal transaction detail information. For example, a released or posted transaction on a journal has an internal status of History. In addition, a unique Journalize Group ID is automatically assigned to all journals. Both the transaction amount and the functional amount of transactions are displayed. n/a
Finance Transactions View all the transactions for all accounting entities in a finance enterprise group in a single list. You can locate the transactions by filtering on multiple fields or by entering search criteria on the Search tab. You can print the results of your search, export the search results to CSV, or create a report with your search criteria.
Note:  If you post all released journals, then you can validate them on these reports:
  • Commitments And Encumbrance Report
  • Totals
  • Account Analysis
 n/a
Ledger View the user-defined ledger and identify the reporting bases to which the ledger is assigned. Reporting Basis For Ledger
Period Over Period Analysis View current period and YTD period over previous period and YTD prior period for functional amount measure.

For more information, see Pivot analysis reports.

 n/a
Reporting Basis View a sequential list of journals for a reporting basis. The list is created when the Assign Journal Reference Number action is run. Select Processing > Reporting Basis > Reporting Basis. Select the Assign Journal Reference Number action in the reporting basis definition. The report functionality depends on your configuration. Journal Reference Report
Reporting Basis View the results of the year-end journals. Select a basis and use the search criteria to filter records. Year End Journal Results
Totals View transaction amounts by ledger, accounting entity, and account. Use the Search tab to filter on encumbrances and commitments. The amounts are listed in the accounting entity functional currencies and all of the reporting currencies. The primary ledger column shows the source ledger of an adjustment transaction. For example, the primary ledger column for a close or currency ledger transaction shows the ledger where the adjusted transaction originated. n/a
Variance Analysis View current period to previous period with variance and current year to previous year with variance.

For more information, see Pivot analysis reports.

 n/a
Zone Payables And Receivables View all transactions to and from the zones and the base zone. This report addresses both the Entity/Accounting Unit and Finance Dimension 1, if zoned. The report provides the necessary information to analyze the inter-zone payables and receivables accounts. n/a