Using the Reports Menu Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

Whether you use Supply Chain, Financials, or Sourcing and Contract Management, a robust set of reporting capabilities is available. The system contains predefined reports, as well as a custom report writer for creating your own report definitions. The system maintains completed reports in a common location (My Archived Reports) so that you can view or print them when needed.

The reporting feature is available from the Reports menu.

Note: Financials - General Ledger also contains a Financial Reports capability from which you can create financial reports in various formats.

Before you start, it is important to know this:
Reports that you output in .pdf are OCR enabled. This means that you can use the .pdf search
to locate information in a long report. This feature is extremely handy when you have a very large report,
and wish to locate a single piece of data
.

Access to Reports

Your ability to create, run, and view reports depends on whether a Report Profile is assigned to your User ID; and if so, which Report Profile. A Report Profile limits the reports that a user can access, so that not all users at a site may be authorized for all reports. If you need access to reports, see your site's system administrator.

My Report Definitions

My Report Definitions (Figure 1) contains the list of custom report definitions that you, or a person at your site have created.
(For instructions on creating custom reports, see Creating Custom Reports.) You can run and print reports from the My Report Definitions list.

 

Figure 1 - A List of Materials Management Reports in My Report Definitions

The user ID of the person who owns the report is in the Owner column. If the report is available for others (besides the owner) to use, Yes appears in the Shared Report column.

The Menu next to each report on the list contains various actions:

My Archived Reports

My Archived Reports (Figure 2) contains the list of reports that have run since the last time the list was purged. The Menu next to each report lets you view (and print) or delete the report.

 

Figure 2 - My Archived Reports

To view and print reports in My Archived Reports:

  1. From the main Contents, select Reports > My Archived Reports.
    The system displays a list of the reports that you have run. (See Figure 2.)
    If a report is still running, the message "Print standard report running" appears on the list in front of the report.
  1. Click View Report (or select Menu > View Report) to see your report.
    Adobe Acrobat Reader opens, showing your report.
  2. Click the printer icon on the Adobe Acrobat Reader toolbar (or select File > Print) to print your report.
    The Print Dialog box appears.
  1. To close Adobe Acrobat Reader, click the X in the upper right-hand corner.

To delete a report from My Archived Reports:

  1. From the main Contents, select Reports > My Archived Reports.
    The system displays a list of the reports that you have run. (See Figure 2.)
  2. Locate the report that you wish to delete. Select Menu > Delete.
    The system asks you to verify that you wish to delete the report.
  3. Click Delete.
    The report disappears from the list.

Report Definitions

Report Definitions (Figure 3) contains report definitions in the system. You can edit or change these report definitions as though they were defined at your site. The Menu for each report definition is the same as the Menu for My Report Definitions.

 

Figure 3 - Report Definitions

Browse Report Dictionary

The Report Dictionary (Figure 4) contains all the Report Objects and Report Fields that you can use in creating or editing report definitions. The lists are in alphabetical order and are sortable.

Figure 4 - Browse Report Dictionary Panel

Quick View of Popular Reports

Following Browse Report Dictionary in the Reports main menu is a list of several popular reports. The list is different for Materials Management, Accounts Payable, and General Ledger.

Purging Obsolete Archived Reports

The system provides the ability to purge old reports from the Archived Reports list. The administrator at your site may wish to run a weekly purge of the Archived Reports list so that it doesn't become unwieldy. If you need access to reports on the list for an indefinite period of time, you may wish to speak to your administrator.

Setting the Reporting Year and Period

The year and period for running reports is set on the Organization Edit panel.

  1. From the main Contents, select Tables > Organization.
  2. On the Organizations list, locate the organization and click the edit icon .
    The Organization panel appears.
  3. In the right-hand column, locate the fields Reporting Year and Reporting Period. Enter the year and period for which you wish reports.
  4. Click Submit. The system Returns you to the Organizations list.

Note: You must have the proper authorizations set in your user profile to edit the organization record.