Internal Controls & Accounting Panorama

Business Scenarios

Viewing Journal Batch/Journal Entry details similar to what was available in MyJournals tool

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  
  
  

Business Scenarios

View period activity for a specific period of time for Account Code and Project when data is filtered for a Financial Unit or Fund

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  
  

Business Scenarios

View Fund totals by Balance, Net Period Activity, and across the fiscal year, and subtotaled by Financial Unit

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  
  
  

Business Scenarios

View Approval Group Members by Name and User ID (sys18 ID)

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  
  

Business Scenarios:

• General Ledger Balances may be used to view your balances for a single to multiple Accounting Period for a given FinU or Fund or Account etc

• What is the balance on an Account or FinU or Project including all transactions that hit the GL and all other subledgers

• General Ledger Transaction Detail is a single space where users can view transactions that hit all ledgers: the General Ledger and each Subledger (PPM, Payables, Receivables, Cash Mgmt.)

• What are the transactions that hit subledger for my Fin Unit or for my Project?

• What are the transactions that hit GL directly?

• If something hit the General Ledger, where did this come from?

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results

Report Views

Results display in 2 tables:

1. General Ledger Balances table is displayed with 15 columns representing Beginning balance, Period Net Activity, Ending Balance with all chart of string segment values
   

   Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

2. General Ledger Detail Transactions table displays results with 22 columns

Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

View subledger transactions for Journal Entries

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

• To find the Journal Status

• Where the Journal is routed to and who will be approving

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  
  

Consolidated Balance Sheet report for level 2 Account types

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

Consolidated Revenue and Expense report for level 2 Account types

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

Summary Trial Balance report for all Entity and Period with filter for specific Entity

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

Summary Trial Balance report for a specific Financial Unit and Period

Data Selection and View Options

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
  
  

Report Views

• Results display in a default table with the ability to export the result set into a file
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules