Generating the Additional Reports

Users can generate the Additional Reports using the steps outlined in this topic.

To generate the report:

  1. Click Main Menu > Additional Reports.
  2. Set the filters for the report, and click Confirm under each field to save the setting. Note that most drop-down fields are searchable, show a maximum of 10 results at a time, and do not allow special characters. The following list contains the comprehensive list of filter fields, but each report type will only have a sub-set of these filters.
    • Reports: If the report category has more than one report, select the required report.
    • System: List of all of the systems configured for the application. Note that you can only select one system for the Analytical Controls reports. Additionally, for GL Balance Reports, this list only contains the systems that have parallel currency enabled.
    • FY Variant: List of all fiscal year variants for the selected System.
    • Lease Area: List of all of the lease areas available in the selected System.
    • Business Unit: List of all of the business units in the selected Lease Area and System.
    • Company Code: List of all of the company codes available in the selected Lease Area, Business Unit, FY Variant, and System.
    • Currency: Select the currency in which the GL Balance report should be generated. Note that if this field appears in the filters, it must be set.

      Note: If the list is empty, then there is no currency common to all Company Codes selected.

    • Vendor: List of all vendors available for the selected System and Company Code.
    • Contract Currency: Select in which contract currency the Analytical Controls report should be generated.

      Note: To find the list of specific contracts used in the report for the selected currency, navigate to the contract Landing Page and filter by contract currency.

    • Lease Department: List of all of the lease departments available in the selected Company Code.
    • Lease Group: List of all lease groups available in the selected Lease Department.
    • Functional Area: List of all functional areas available in the selected System.
    • Lease Type: List of all lease types.
    • Profit Center:List of all profit centers available in the selected Company Code.
    • Cost Center: List of all cost centers available in the selected Company Code.
    • Contract Status: Select whether the report should include contracts in specific statuses, or all statuses.
    • Activation Group Status: Select whether the report should include activation groups in specific statuses, or all statuses.
    • Business Area: List of all business areas available in the selected Company Code.
    • Accounting Standard: List of all the accounting standards (by ID) available for the selected Company Code. (To also display the Accounting Standard Type, contact your system administrator.) Note that for certain reports (listed in the table above), only the new accounting standards are supported.
    • Classification: List of all the classification types available for the selected Accounting Standard.
    • Use one of the following open fields to enter specific IDs (up to a maximum of 50 comma-separated IDs), if required. If the field is empty, the application returns all objects that match the other filter fields.
      • MLA ID
      • Contract ID
      • Lease Component ID
      • Activation Group ID
      • Unit ID
    • Asset Class: List of the Internal Asset Classes available for the selected Company Code.
    • Analysis Type: Set the Analysis Type to Vertical to calculate percentages of transactions or line items against a certain total base of the same year, or Horizontal to calculate the percentage change against the previous year. Note that if horizontal analysis is selected, percentages in the first year of the report are zero because there is no previous year within the selected range to compare against.
    • From Year and To Year: Select the starting and ending year for the Analytical Controls reports (up to a maximum range of five years). Note that if the selected range is less than five years, the report will still contain column headers for the other years.
    • Category: Specify whether the report should compare against months, quarters, or years.
      • Month of Year and Quarter of Year: Depending on the selected Category, specify the specific month or quarter to compare against in the report.
    • Year Start: Select the starting year for the Activity Analysis or Local GAAP reports.
      • Period Start: Specify the specific month-day for selected Year Start.
    • Year End: Select the last year for the Activity Analysis or Local GAAP reports. Note that the Local GAAP report can only be generated up to a maximum span of 12 months
      • Period End: Specify the specific month-day for the selected Year End.
    • As of: Select the start date for the Contract Expiration reports. Specify the date range (up to a maximum range of 12 months) for the report using one of the following options:
      • Specify the Number of Months and/or Number of Days to include in the report. The End Date field is automatically updated.
      • Specify the exact End Date.
    • As At Date: Select at which date the Data Quality Integrity report should be generated.
    • Fiscal Year: Select the year for which the report should be generated.
      • From Period and To Period: For the GL Balance report, select the range of periods (for the selected fiscal year) for which the report should be generated. Note that the report can only be generated to a maximum of three periods.
    • Account Type: List of account types (e.g., Balance Sheet or P&L) that can be selected for the GL Balance Report.
    • Accounts: List of all configured GL accounts, based on the selected Account Type.
    • Contract Phase: Select whether the report should include all contracts, or only those in a specific contract phase.
    • Posting Status: The application calculates the balances for the GL Balance Report based on posted transactions. Specify whether all transactions should be included, or only those with a specific posting status.

    Note: If the fields do not show any options, it means that there are no valid options based on the other filters set.

  3. If required, modify the Report Format of the generated report. This can be set to either the standard XLS format, or a CSV format with limited formatting.

    Note: In the CSV Report Format, large numbers may be displayed in scientific format. In this case, change the cell format to "Number" to display the full number.

  4. Optionally, click Save Filter to save the current filter settings. You can have a maximum of 25 saved filters at one time in each of the Activity Analysis, Contract Expiration, GL Balance, and Financial Reports (i.e. if the Financial Reports are enabled, 100 filters can be saved at one time).
    • To use a previously saved filter, click Use Saved Filter and select the required filter.
    • To update a saved filter, re-save a filter with the same name as the saved filter.
  5. Click Generate. Wait for the report to be generated in the "Reports" section. Note that if there are any mandatory fields that are empty, they will be highlighted in red.
    • To view information about the report generation, click .
    • To delete the report, click .
  6. To view the report, export the report by clicking .
    • Note that the report will indicate if certain contracts were excluded from the calculations (e.g., no exchange rate was found for the conversion from the contract currency to the selected report currency).
    • For files with an XLS report format, use Save As to resave the file as an Excel 97-2003 Workbook .xls file (instead of the generated html file).
  7. If required, click above the Reports section to delete all generated reports. This button deletes all scheduled and manual reports that you have previously generated.

See also:  

Nakisa Lease Administration 2022.R2-SP1 © 2023

 

 

Nakisa Inc. All rights reserved worldwide.