Summary

The Query Manager is a powerful and flexible reporting tool used to create and/or run user-defined reports.

The Query Manager feature has two steps; create a report template using the Reporting Tools palette (FA> Reporting Tools> Query Manager), and then generate the report using the Reports palette (FA >Reports> Query Manager).

Step by Step

1Open the Fixed Asset Query Manager window (FA Reports Query Manager).

• TheQuery Managerwindow allows you to build a report that includes a broad range of user-defined information.

2Select a report template from the General Tab.

• Select a Query Manager template name in theReport Namedrop-down menu.
  • Query Manager templates are created and maintained in theQuery Manager Maintenancewindow (FA Reporting Tools Query ManagerCreateicon).
• ThePrint ToandOrientationfields will automatically populate with the information associated with the selected Report Name.

3Print the report or adjust the filter settings.

• TheAsset,Status/Location,Transaction,AccountandMiscellaneoustabs will automatically populate with the filter information designated when the selected report template was created. This allows you to create a report template with detailed filters and then quickly run the report at any point in the future.
• You can override each of the automatically populated filter fields each time you run the report.

4Filter the report with the Asset Tab.

• TheAssettab allows you to filter the transactions that will be used in the calculation of the debit and credit fields by specific asset information.
  • Click theAsset Typedrop-down menu to limit the report to only Regular Assets, only Mass Assets, or All assets.
  • Click theAsset FromandAsset Tofield search buttonsto open the Fixed Asset Selection window. Here you can filter the transactions that will be included in the debit and credit fields by a selected range of assets.
  • Enter dollar amounts in thePrice FromandPrice Tofields to filter the transactions that will be included in the debit and credit fields.
    • The dollar amount associated with the Price From and Price To fields is maintained in the Fixed Asset Maintenance window (FA Maintenance Fixed Asset General tabOriginal Costfield).
  • Select a depreciation configuration in theDepreciatesdrop-down menu.
    • The depreciation configuration is maintained in the Fixed Asset Maintenance window (FA Maintenance Fixed Asset General tabDepreciationfield).
  • Enter purchase dates in thePurchase FromandPurchase Tofields.
    • The purchase dates are maintained in the Fixed Asset Maintenance window (FA Maintenance Fixed Asset General tabDate Purchasedfield).
  • Enter disposal dates in theDisposal FromandDisposal Tofields.
    • The disposal dates can be viewed in the Fixed Asset Maintenance window (FA Maintenance Fixed Asset General tabDate Disposedfield).
    • Disposal dates are determined by the Effective Date field in the Dispose Assets window (FA DisposalsEffective Datefield).
  • Click theClassfield search buttonto filter the transactions that will be included in the debit and credit fields by the selected class code.
    • Class codes are created and maintained in the Class Code Maintenance window (FA MaintenanceClass).

5Filter the report with the Status/Location Tab.

• TheStatus/Locationtab allows you to filter the transactions that will be used in the calculation of the debit and credit fields by asset status and location.
  • Select one or more asset statuses in theStatusfield to filter the transactions that will be included in the debit and credit fields. The status of an asset can be viewed in the Asset Maintenance window (FA Maintenance Fixed Asset Maintenance General tabStatusfield).
  • Select one or more asset locations in theLocationfield to filter the transactions that will be included in the debit and credit fields. The location of an asset can be viewed in the Asset Maintenance window (FA Maintenance Fixed Asset Maintenance General tabLocationfield).

6Filter the report with the Transaction Tab.

• TheTransactiontab allows you to filter the transactions that will be used in the calculation of the debit and credit fields by transaction type and date.
  • Select eachTransaction Typefield to filter the transactions that will be included in the debit and credit fields. The transaction type of an asset transaction can be viewed in the Asset Maintenance window (FA Maintenance Fixed Asset Maintenance Transaction tabTransactioncolumn).
    • If you want to report on an asset’s original cost, you should select Install and Original Cost Adjustments because those are the only two processes that affect the original cost field.
    • If you want to report on Depreciation or Accumulated depreciation, you would select Depreciation and Depreciation Adjustment.
  • Select eachAction Typethat should be included in the report.
  • Enter a date range in theDate FromandDate Tofields to filter the debit and credit fields by transaction over a date range.
    • If you are reporting on all activity since the installation of the asset you would want to leave this date range blank.
  • Check theInclude Uncommittedtoggle to include uncommitted transactions in the debit and credit fields.

7Filter the report with the Account Tab.

• TheAccounttab allows you to filter the transactions that will be used in the calculation of the debit and credit fields by general ledger account.
  • Select the account types to include in the report in theTypefield. All transactions that affected the general ledger accounts attached to those account types will be pulled into the report.
    • The general ledger accounts attached to an asset can be viewed in FA Maintenance Fixed Asset Maintenance Accounts tab. If you change the general ledger accounts attached to these account types, the historic data that will be pulled into the report will not be affected. The filter selects transactions to be included in the report based on the account type, not the specific general ledger account attached to the account type.
    • If you have split the account type to distribute transaction amounts to multiple general ledger accounts, the transaction portion divided to each GL account will be included in the report.
  • If you want to filter the transactions by a specific general ledger account, or range of accounts, click theAccount FromandAccount Tofield search buttons to filter the report by a range of general ledger accounts. This will open a list of general ledger accounts to select from.
  • Check theInclude accounts without transactionstoggle to include those accounts in the report.

8Filter the report with the Miscellaneous Tab.

• TheMiscellaneoustab allows you to filter the transactions that will be included in the calculation of the debit and credit fields by user-defined fields.
  • Miscellaneous field labels are set up using the Miscellaneous Field Labels window (SS Utilities Miscellaneous Field Labels).

9Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
• Click the Schedule iconnext to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and clickSUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.