Cash Requirements Report - Instructions

Use the Cash Requirements Report to list all invoices within a specified age range to analyze cash amounts needed to pay those invoices.  For example, if you want to see invoices whose due date is between today and 30 days from now, enter a  range of 0-30 as the From and To in Column one of the report parameters.  Age ranges are based on the system date.

• Use this report instead of the Open Invoice Report to get a quick view of what is due in the next 30 days (or other range) by choosing to Print Totals Only.  Just one dollar figure shows under each range column.  

• For more information about running reports, see Print View.

• At the Report Writer window, you can change the selection and sort options for the report.  For more information, refer to the Report Writer Overview.

Directions:

To see directions for...

• Opening the Cash Requirements Report, click More.

   

  1.  Click Fund Accounting from the Menu Bar.

  2.  Click Reporting.

  3.  Click Cash Requirements Report.
  
  Or, use the keyboard shortcut:  [ALT] [u] [r] [r].

   

  Cash Requirements Report Window Example:

  

   

• Choosing the Selections at the Prompt Window, click More.

   

  Cash Requirements Report Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  Columns 1-5	Each line represents a different age column to print on the report. Notes:  You must enter the From and To ranges in all columns. If you are only interested in one range, enter the From and To range in Column 1 and accept the system defaults for the remaining columns. System defaults for columns are:  0-30, 31-60, 61-90, 91-120, 121-150. The ranges entered automatically display the next time this report is run.
  From	Enter the beginning Age range for this column.   Note:   From must be higher than the previous To number.
  To	Enter the ending Age range for this column.
  Print Totals Only	To print totals only and no invoice detail under the appropriate age columns, click to select this box.   Tip:  The vendor names and vendor numbers whose invoices are included in the totals print across the top of the report. To print the invoice detail as well as, the totals, de-select this box.
  	To generate the report, click Continue or press [ENTER]. Keyboard shortcut: [ALT + o]
  	To escape from the print routine, click Cancel. Keyboard shortcut: [ALT + c]

   

  After clicking Continue, the following window displays:

  

   

  Cash Requirements Report Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  Report Writer	Review the Report Writer prompts and make changes, if applicable. Note:  For more information, refer to the Report Writer Overview.
  Printer	Displays the default printer number.  For more information, see Printing Options. Keyboard shortcut: [ALT + p]
  	To generate the report, click OK or press [ENTER]. Keyboard shortcut: [ALT + o]
  	To escape from the print routine, click Cancel. Keyboard shortcut: [ALT + c]

   

• Report Sample(s), click More.

   

  To see an example of the report, click Cash Requirements Report Sample.