Assets > Asset Query

Asset Query

You use this program to view details of assets held on file.

This program can be run at any time.

The information shown is up to date as at the last time the Asset Depreciation Calculation program was run in update mode.

If you are new to this query, then the following information will help you achieve the best results:

  • If you know the asset code, then you can enter it directly and press the Tab or Enter key to view the information.

    If you do not know the asset code, then you can use the browse function to locate the asset.

  • You can personalize this query in a number of ways. These include:

    • setting preferences that affect what information is displayed (see Asset Entries Selection).
    • configuring property sheets (e.g. the section headed Asset Details). This includes being able to sequence items by dragging them up or down, to show important items first
    • configuring the Asset Entries and Asset Transactions listviews. This includes being able to sequence columns by dragging them left or right, sorting columns and changing column widths
    • configuring the layout of the panes on the screen, including hiding or displaying panes

Toolbar and menu

Field Description
Sequence  
Asset Select this to view assets in asset number sequence.
Description Select this to view assets in asset description sequence.
Group Select this to view assets in asset group sequence.
Location Select this to view assets in asset location sequence.
Branch Select this to view assets in asset branch sequence.
Asset Indicate the code of the asset to query.
Find Select this to use the Key Search program to locate items according to extensive search criteria.
Play Select this to view any multimedia object that has been assigned to the asset.
Edit Select this to use the Multimedia program to maintain multimedia objects for the asset.
Notepad Select this to use the Admin Notepad Editor (Rich Text) program to add rich format text to the asset.

Asset Details

Field Description
Asset information

This corresponds to the information entered against the asset in the Asset Details pane of the Assets program.

The Asset quantity is entered using the Asset Acquisition program.
Previous This indicates the previous asset branch and location which are displayed if you used the Asset Transfer program to transfer the asset to a different location/branch.
Original values

This displays the original values entered against the asset using the Asset Acquisition program.

The Start depreciation date is calculated according to the Purchase date entered or the Start depreciation period and Start depreciation year when you are using 13 Accounting periods (Company Setup).
User defined fields These are entered in the Asset Details pane of the Assets program.
Alternate valuation flags This indicates the alternate valuation depreciation books which exist against the asset. These are selected in the Assets program.
Disposal This indicates the disposal details for the asset (see Asset Disposal).

Purchasing Details

The information in this pane corresponds to the purchasing details entered against the asset. See Purchasing Details.

Asset Transactions

This listview displays details of all transactions posted against the asset using the Asset Transactions program.

Depreciation Books

Only details for the alternate depreciation books you selected to keep for the asset can be displayed (Assets).

Field Description
Book 1 Indicate the first depreciation book for which to display the details.
Book 2 Indicate the first depreciation book for which to display the details.
Go Select this to display the details of the depreciation books you selected.

Depreciation Book Details

The following information is included in this pane for the selected depreciation book:

Field Description
Depreciation details

The information in this pane corresponds to the details entered in the Assets program for the selected depreciation book.

The Reason for revaluation code is displayed if the asset was revalued - see Asset Revaluation.
Depreciation values

  • Cost/Cash price

    This indicates the current cost value of the asset. This is changed by acquisitions processed (see Asset Acquisition).

  • Current value

    This indicates the total cost/cash price less total depreciation to date.
Tax additional information Refer to Tax Details.

Asset Entries

This listview displays details of entries posted against the asset.

[Note]

Only the entries you selected to include are displayed (see Asset Entries Selection).
Column Description
Entry type

This indicates the source of the entry. Entry types include:

  • Depreciation - see Asset Depreciation Calculation.
  • Depr Adj - see Asset Depreciation Adjustment.
  • Catch-up Depr - this is calculated and added per your selection at the Options on addition option (Assets Register Setup)
  • Asset Adjustment - e.g. change of EUL - see Asset Depreciation Adjustment and Asset Depreciation Adjustment Recalc.
  • Revaluation - see Asset Revaluation.
  • Revaluation depreciation - see Asset Revaluation.
  • Transfer - see Asset Transfer.
  • Inter co transfer
  • Addition (initial)- see Asset Acquisition.
  • Addition to existing asset - see Asset Acquisition.
  • Disposal (final) - see Asset Disposal.
  • Disposal (partial) - see Asset Disposal.
  • Disposal (Asset count) - indicates that an asset disposal was processed from the Asset Count Confirm program.
  • Asset Count Adjustment - indicates that the asset quantity was changed when the Update function of the Asset Count Confirm program was run.

  • Addition (Asset count) - indicates that an asset acquisition was processed from the Asset Count Confirm program.

  • Asset Split (this is not available in the current version of the software).
  • Change

Asset History

This listview displays the historical values for the asset for each year and period within each year.

Column Description
Depreciation value This indicates the depreciation values for Basis for Depreciation types Year and Life of asset (Assets Register Setup).
Depreciation addition This indicates the depreciation values for Basis for depreciation type Period (Assets Register Setup).

Asset Entries Selection

This enables you to indicate options that will determine the level of detail to view within the Asset Entries pane for each depreciation book.

Field Description
Refresh Select this to redisplay the information in the Asset Entries pane to reflect changes you made to the selections in this pane.

This function is only enabled when you make a change to the asset entries selections.
Autoload Values These options enable you to indicate how you want to save the selections made in this pane.

You can choose to set all selections as they were when you last ran the program (i.e. Load Previous Form Values) or save your selections in the pane as your default preferences for all companies, or for the current company only (i.e. Save Form Values as Default or Save Form Values for this Company).

If you have saved form values for the company or as the default, then you can remove these settings and restore them to the form's default preference selections.
Year selection Indicate the financial year(s) for which to display asset entries for the depreciation books.
Period selection Indicate the period(s), within the selected years, for which to display asset entries for the depreciation books.
Date selection Indicate the dates, within the period(s) and year(s) indicated, for which to display asset entries for the depreciation books.
Include Select the type of asset entries to include in the Asset Entries listview when querying a depreciation book.

The following entry types can be selected/deselected:

  • Depreciation
  • Depreciation Adjustments
  • Revaluations
  • Transfers
  • Additions
  • Disposals
  • Changes
  • Count

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.