General Settings - Reporting

In This Topic...

The General Settings - Reporting page is used for managing the automatic generation of reports.

  1. Open the appropriate Billing Entity. For instructions on finding and opening a billing entity, see the section on Managing Billing Entities.
  2. In the Billing Entity Menu, select Reporting. The General Settings - Reporting screen opens.

  3. The panels and fields are described below. Fields marked with a red asterisk * are required.

    The Reports panel lists all report configurations. Each configuration entry defines a single report, the schedule for generation, output format, and any additional settings depending on the report type.

    Tip: By default, only Active configurations are displayed.  Clear the filter in the Status column to view all configurations.

    Click Add to create a new report configuration, or click a link in the Name column to view an existing configuration. The Report window opens. See Managing Reports for more information.

    Configurations cannot be deleted, but they can be deactivated.  This leaves them in the system, but the associated reports will not be generated. To deactivate configurations, check all boxes for the configurations to be deactivated, then click Deactivate. All selected configurations are deactivated. If the Scheduled Reports list is still defaulted to only show active configurations, they are removed from the list.

Managing Reports

  1. In the General Settings - Reporting panel, click a link in the Name column to view an existing configuration, or click Add to add a new report configuration. The Report window opens.

  2. Complete the necessary information. Fields marked with a red asterisk * are required.

    Name

    Enter the name of the report configuration.

    Code

    Enter a unique code.

    Description

    Enter a description for the configuration.

    Report

    Select the report to be generated. The following options are available.

     
    • Aged Receivables (Detailed)

     
    • Aged Receivables (Summary)

     
    • Earnings

     
    • Invoices

     
    • Receipts

    Currency

    Select a currency to restrict the results to that currency. This field is required for Earnings reports. If a currency is selected, the report will include a Total line summing up the values.

    The Schedule panel defines when the report will be generated.

    Generate at Period End

    If the system is configured to use Fiscal Years and Periods, this option will generate the report at the end of each period. If this option is unchecked, the schedule can be configured manually.

    Frequency

    This field is available when Generate at Period End is unchecked. Select how often the report will be generated.
    • Monthly

    The report will be generated on a specific day of each month, and will automatically include data for the last month.  This displays the Generate Report On field below.
    • Weekly

    The report will be generated on a specific day of the week, and will automatically include data for the last week.  This displays the Day of Week field below.
    • Daily

    The report will be generated each day, including all data for that day up to the time the report is generated.

    Generate Report On

    This field is available when Monthly is selected for the Frequency. Select when in the month the report will be generated.
    • Day of Month

    The report will be generated on a specific day of each month. This displays the Day of Month field below.
    • Last Day of Month

    The report will be generated on the last day of each month.

    Day of Month

    This field is available when Monthly is selected for the Frequency and Day of Month is selected for Generate Report On. Enter the day of each month to generate the report. If a certain month ends before the chosen day, the report will generate on the last day of that month.

    Day of Week

    This field is available when Weekly is selected for the Frequency. Select the day of the week to generate the report.

    The Report Rules panel is available for Earnings reports when set to Generate at Period End.  Check the Post at Period End option to post the report when the report is generated.

    Select the Output Format for the report, either as an Excel file or PDF.

  3. Select an action.

    Click Add & New to save the configuration and clear the form for a new entry.

    Click Add & Close to save the configuration and return to the General Settings - Reporting page.

    Click Close to delete the current configuration and return to the General Settings - Reporting page.

    Active

    Marks the report configuration as active and available for use. If unchecked, the configuration remains in the system, but the associated reports will not be generated.

    Created By

    Identifies the date and time the configuration was created and the user who created it.

    Last Modified By

    Identifies the last date and time the configuration was changed and the user who made the changes.