Receivables & Cash Operations Panoramas

Business Scenarios

• List of Transactions against which Credit Memo was applied

• What are all of the transactions that have Credit Memos applied against them?

• Who is the Customer that received the issued Credit Memo?

• When did this happen and what was the amount?
  
  

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 table of 8 columns, with the ability to export the result set into a file
• Additional columns are available for users to add to the report
• 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

• Provides Customer Account information related to the Invoice delivery method of email or print options

• What is the preference for the Customer Account when it comes to invoice delivery, printed copy that can be delivered by the department or the auto-generated copy that will be automatically emailed to the Customer?

• What is the latest physical address for the Customer I am looking to Invoice?

• Who is the point of contact at this Customer and do we have their contact information, such as email or phone number?
  
  

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
• Additional columns are available for users to add to the report
• 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

• List of Incoming Payments, applied and unapplied for both Receivables and Non-Receivables transactions
• How can I look up if a Payment was received for the outstanding Invoice?
• Customer claims they sent out the payment, I still see an open Invoice, where can I check of the Payment has arrived?
• I found the received Payment, now I can claim it against the open Invoice with the appropriate supporting documentation
  

Data Selection and View Options

• Use these parameters to filter for the data you want to see
• 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
• Additional columns are available for users to add to the report
• 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

• Provides subledger detail transactions to assist with credit card reconciliation

• What are all of the transactions for the credit card account?

• We are a Merchant, how can we view all of activity during the particular time period?

• I am interested in a specific activity for my Financial Unit, can I see the information that way?
  

Data Selection and View Options

• Use these parameters to filter for the data you want to see
• 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
• Additional columns are available for users to add to the report
• 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

• Detailed information of non-standard Receipts

• What are all of the Transactions that hit each subledger for my Project?

• What Transactions hit the GL directly?

• 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 a default table with the ability to export the result set into a file
• Additional columns are available for users to add to the report
• 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

• Provides visibility into Unpaid Invoice Balances along with the duration for which they’ve been outstanding

• Report can be filtered by Financial Unit and can be detailed or summary

• What are the Customers that have not paid us?

• How long are the outstanding bills due?

• What is the best way to gain an insight on who owes us how much and are they current or past due, and if so by how far the past due date?
  
  

Data Selection and View Options

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

Report Views

• Results display in a default table with subtotal by Project
• Additional columns are available for users to add to the report
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
• Report can be run as Summary per Financial Unit or as Detailed

Business Scenarios

• Translates Invoice number from Oracle to SPARCM and vice versa, and links payments to Invoices

• What is the Sponsored Project Invoice equivalent in OFC?

• For the Award on the Contract, what are the outstanding Invoices in OFC?

• I have the Oracle Invoice, what is that equivalent in SPARCM?
  
  

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
• Additional columns are available for users to add to the report
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules