Consolidated Transaction Reports

The reconciliation/transaction reports display the list of transactions that were triggered to be posted from Nakisa Lease Administration. These reports can help you to reconcile the data posted from the application with the actual data in the ERP.

To generate a report, you must set the applicable filters, and generate the Excel report.

The following reports are available: 

  • Asset Capitalization Report: This report lists all of the important information related to asset capitalization documents posted from Nakisa Lease Administration. These documents are posted at the inception of the lease.
  • Asset Depreciation Report: This report lists all of the important information related to asset depreciation documents posted from Nakisa Lease Administration. Note that if deprecation amounts are calculated in the ERP, they are not included in the report.
  • Asset Retirement Report: This report lists all of the important information related to asset retirement documents posted from Nakisa Lease Administration. Asset retirement is triggered from the application when user creates events such as casualty or early termination of the lease.
  • Interest Accrual Report: This report lists all of the important information related to interest accrual documents posted from Nakisa Lease Administration.
  • Rent Accrual Report: This report lists all of the important information related to rent and payment accrual documents posted from Nakisa Lease Administration.
  • Liability Adjustment Report: This report lists all of the important information related to liability adjustment documents posted from Nakisa Lease Administration. Liability adjustments are posted when there is a casualty, lease reassessment, or modification event.
  • Liability Obligation Report: This report lists all of the important information related to liability obligation documents posted from Nakisa Lease Administration. These documents are posted at the inception of the lease.
  • Charge Report: This report lists all of the (one time) charge documents posted from Nakisa Lease Administration. These documents are posted during the operation of the lease.
  • Ledger Closing Document Report: This report lists the posted ledger closing documents from Nakisa Lease Administration. Ledger closing documents are closing liability balance clearing entries that are incurred when the activation group status is set to "Closed".

To generate a consolidated transaction report:

  1. Click Main Menu > Compliance Reports > Consolidated Transaction Reports.
  2. Set the filters for the report. Note that these drop-down fields do not allow special characters. The following list contains the comprehensive list of filter fields available.
    • Selected Reports: Select one or more report to generate at once. If you select "All" or more than one report, all of the relevant transactions are included in one report.
    • System: List of all of the systems (SAP ERPs or standalone) configured in the application.
    • Lease Area: List of all of the lease areas available across all systems.
    • Business Unit: List of all the business units available in the previously selected filters.
    • Company Codes: List of all of the company codes available in the previously selected filters.
    • Lease Department: List of all departments available in the previously selected filters.
    • Lease Group: List of all lease groups available for the previously selected filters.
    • 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.)
    • Classification: List of all classification types available for the selected Accounting Standards.
    • Vendor: List of all vendors available for the selected System and Company Codes.
    • Asset Class: List of Internal Asset Classes available for the selected Company Codes.
    • Contract ID: To generate a report for a specific contract, enter the contract IDs in this field (up to a maximum of 50 comma-separated IDs in one report). Leave the field empty to extract data for all contracts.
    • Purchase Order Number: To generate a report for a specific purchase order, enter the reference number in this field.
    • Transaction Status: Generate reports for transactions that are in a specific status.
    • Lease Type: List of all lease types.
    • Cost Center ID: Enter any single Cost Center ID for which you would like to extract for the report. Leave the field empty to extract data for all cost centers.
    • Profit Center ID: Enter any single Profit Center ID for which you would like to extract for the report. Leave the field empty to extract data for all profit centers.
    • Business Area ID: Enter any single Business Area ID for which you would like to extract for the report. Leave the field empty to extract data for all business areas.
    • Functional Area ID: Enter any single Functional Area ID for which you would like to extract for the report. Leave the field empty to extract data for all functional areas.
    • Depreciation Area: List of unique depreciation areas available under the selected System. Note that this only filters depreciation areas for Asset Depreciation posting documents (and does not filter any other posting documents).
    • Date Range Type: Select the type of date range displayed:
      • "Fiscal Year Period": Select the Year, Period Start, and Period End dates used to generate the Transaction Report.
      • "Posting Date": Export the transactions with Posting Dates that are in the range defined by Start Date and End Date.
      • "Transaction Entry Date": Export the transactions that were executed (e.g., when a scheduled job was run) in the range defined by Start Date and End Date.
    • Additional Date Range Type: If this filter is enabled in the Nakisa AdminConsole, transactions can be further filtered by an additional date range type: "Document Date" or "Transaction Entry Date".
      • For the selected date range type, export transactions in the range defined by Start Date and End Date.
  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 the Consolidated Transaction Reports.
    • 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.
    • To stop and delete the report while it is generating, click .
  6. To view the transaction report, export the report by clicking .
    • 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).
    • To delete the report, click .
  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.