Management Reports Viewer Instructions

Use the Management Reports to print or view financial reports such as income statements, balance sheets and other financial reports.  The reports are specifically tailored to your facility during the installation of the General Ledger.  Any report generated during the Management Reports Viewer can be saved as a Microsoft® Excel, Microsoft Word or text file for further manipulation.  You can build additional reports at any time using the Management Reports Designer.

Tips:

 

Directions:

To open:

1.  Click Reporting from the menu.

2.  Click Management Reports Viewer.

Note
:  You may also be able to access the General Ledger menu while in another INVISION application.  To activate the General Ledger menu in another module, the G/L Application Control must be set up for the module during installation.

 

Management Reports Window Example:

 

Management Reports Prompt Options

 

Report Settings

Period

To specify the period for the report, click the period in the drop-down list.  (predefined)

Summary Level

Default Summary Level

Enter the summary level for the detail lines in the report, or to print the level that was designed for the report, click to check the Default Summary Level box.  (2.0 numeric)

Tip:  You can construct financial statements so that totals and subtotals have a higher summary level than the regular detail lines.  This allows you to print a summary version of a report, which excludes the detail lines from printing but provides the totals of those detail lines.

Example:  Assume that the detail lines for a report are defined as summary level 1, the subtotals are summary level 2, and the totals are summary level 3.

  • To print all subtotals and totals, enter summary level 2, which prints levels 2 and 3, but excludes the detail (Level 1).

  • To print all the detail and totals, enter summary level 1.

  • To print the default level defined for the report, click to select the default summery level box below.

Max Additional Lines

To include additional blank lines between subtotals and totals, enter the maximum number of lines to include.  
Tip:  Including additional lines can improve the legibility of the report.

Print Bands

To print a colored band on every other line as well as on the heading of the report (similar to green bar printer paper), click to select the check box.  

Or, to omit color bands on the pages, leave this box unchecked.

Trim reports / fit to page

Trim reports will print the reports in 1 of 3 fixed widths that are 78, 132, or 224 characters regardless of how many characters are actually used, which may result in blank space on the right side of the page.  Fit to Page finds the maximum column width of the report and uses that as the full width, fitting it to the page.  

To trim reports, click to select the box.  

Or, to fit the report to the width of the page, leave this box unchecked.

Element Ranges
From/To

To limit the report to a range of account number elements, enter the from and to values (inclusive).  (format varies)

Tip:  The list of elements varies among facilities.

Choose Reports

Report Type

To specify the report type, click one of the following options in the drop-down list:

  • Single Report:  Print only the report that you select from the report list.

  • All Monthly Reports:  Print all reports defined with the M(onthly) report cycle.

  • All Quarterly Reports:  Print all reports defined with the Q(uarterly) report cycle.

  • All Yearly Reports:  Print all reports defined with the Y(early) report cycle.

  • Use Report Code:  Print all reports for the entered report code.  The report cycle groups reports together according to their run cycle - monthly, quarterly, or yearly, allowing you to group reports together that you frequently print at the same time.  If you select report code, then you will enter a report code below.

Report Code

The report code groups reports together that you frequently print at the same time.  To specify that you want to print a group of reports for a report code, select Use Report Code as the report type and then enter the defined report code here.  (up to 6 characters)

Report List

If you specified that you want to print a Single Report in the report type field, click to highlight the desired report in the report list.  

Or, to add or remove reports from the report list, click to select or de-select the desired check boxes.

To add all reports to the report list, click Add .  

To remove all reports from the report list, click Remove .

Tips:  

  • This report list varies among installations and reflects the Management Reports designed for your organization.

  • Report number is active only when you specify single report for the report type.

To create an Microsoft Excel spreadsheet from the report.  This can be handy if you want to further manipulate the report data.

1.  From the menu, click Save Excel .

2.  Follow the normal Windows® save procedure:

    • At the Save In field, navigate to the desired location.

    • At the File Name field, enter a file name.

    • Click Save .

To create a Microsoft Word document from the report.  This can be handy if you want to change the heading or print a financial report on letterhead.

1.  From the menu, click Save Word .

2.  Follow the normal Windows® save procedure:

    • At the Save In field, navigate to the desired location.

    • At the File Name field, enter a file name.

    • Click Save.

Tip:  If you have selected multiple reports and you select to Save as Word file, you will have the option to include a page break between reports.

You can freeze the data on a report by saving it to a file.  This function is useful when archiving important data or when exporting the data to another program.

1.  Click Save As Text.

2.  Follow the normal Windows™ save procedure:

  • Navigate to the appropriate location.

  • Type a new file name, if desired.

  • Click Save.

Choose a printing option:

  • To print to the Print View window, click  Print View.  For more information, see Printing Options.  From the Print View window, you can save the report information as a Microsoft Excel or Word file or as a text file.

  • To generate the selected reports in the report list, click Print Selected.  Keyboard shortcut:  [ALT + p]

  • To print all reports listed on the Report List, click Print All Listed.  Tip:  You may find this handy if you have a list of reports for a specific report code.

  • To escape from the print routine, click Cancel.  Keyboard shortcut:  [ALT + c]

 

Other Reports