Contents of the Print Asset Book Value Report Screen

Use the fields and options to configure the Print Asset Book Value Report screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Asset Accounts

Use the following fields to select records for the report from a range of asset ("ownership") accounts. Account and organization asset "ownership" data is required in each Asset Master record. Project "ownership" data is optional.

When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes may modify which records from the selected asset account range are actually included in the report.

Field Description
Option

Select the asset account range option from the drop-down list. The options available are:

  • All
  • One
  • Range
  • From Beginning
  • To End

If you have a large number of asset accounts, you may want to select a different option aside from All.

Start

Enter, or click to select, the beginning asset account number in this field from the asset accounts already associated with your property records. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected accounts for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, may not be selected.

If you select All or From Beginning in the Option field, this field will be inactive.

End

Enter, or click to select, the ending asset account number from the asset accounts already associated with your property records. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected accounts for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, may not be selected.

If you select All, One, or To End in the Option field, this field will be inactive.

Organizations

Use the following fields to select records for the report from a range of asset ("ownership") organizations. Account and organization asset "ownership" data is required in each Asset Master record. Project "ownership" data is optional.

When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes, you may have also modified which records from the selected organization range are actually included in the report.

Field Description
Option

Select the range option from the drop-down list. The options available are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning asset organization number in this field.

Because the standard Lookup for the organization is to the ORG_ACCT table, you may find that you have selected organizations for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, may not be selected.

If you select All or From Beginning in the Option field, this field will be inactive.

End

Enter, or click to select, the ending organization number in this field.

Because the standard Lookup for the organization is to the ORG_ACCT table, you may find that you have selected organizations for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select All, One, or To End in the Option field, this field will be inactive.

Book

Field Description
Start

To print data for a book, enter or click to select a book. The system also displays the labels that you assigned to each optional book in the Lookup during initialization on the Configure Fixed Assets Settings screen, as applicable.

You can print data for only one book at a time.

Asset/Item Numbers

Use the following fields to select asset/item numbers for the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report. When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes, you may have also modified which records from the selected asset/item number range are actually included in the report.

Field Description
Option

Select a range option from the drop-down list. The options available are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select,  the beginning asset/item number for the range.

Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which book value data do not exist or records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK table, as applicable, may not be selected.

If you select All or From Beginning in the Option field, these fields will be inactive.

End

Enter, or click to select, the ending asset/item number for the range.

Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which book value data do not exist or records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK table, as applicable, may not be selected.

If you select All, One, or To End in the Option field, these fields will be inactive.

Options

Select Record Status

Use this group box to choose the record status type(s) to include in your print selection criteria. You can print data for active records, inactive records, and/or disposals. You must select at least one check box in this group box. The actual selection of records from this screen may be modified by your selection of asset/item number, asset account number, organization, record-added dates, and/or acquisition fiscal year/period ranges.

Field Description
Active Records

Select this check box to include active records in your print selection criteria.

Inactive Records

Select this check box to include inactive records in your print selection criteria.

Disposals

Select this check box to include disposals in your print selection criteria.

Note: You can enter disposals for active records on the Manage Disposal Transactions screens. Once the disposal is posted to the General Ledger, the system automatically changes the record's status from Active to Disposal. In the rare circumstance that you need to enter disposal data for historical asset records, you can use the Disp Info tab of the Manage Asset Master Information screen or the Manage Asset Disposal Information screen.

Select Depreciation Status

Use this group box to choose the depreciation status type(s) to include in your print selection criteria. You can print data for depreciable records or non-depreciable records. You must select at least one check box in this group box. The actual selection of records from this screen may be modified by your selection of asset/item number, asset account number, organization, project, and/or property type ranges.

Field Description
Depreciable Records

Select this check box to include depreciable records in your print selection criteria.

Non-Depreciable Records

Select this check box to include non-depreciable records in your print selection criteria.

Include

Field Description
Current Pd Depreciation in Accum Depr Column

Select this check box to include or exclude the current period depreciation amount in/from the displayed accumulated depreciation value on the report.

Show

Field Description
Percent Depreciated Column

Select this check box to print a column on the report that displays the percentage of the asset that has already been depreciated. The system calculates this value by dividing accumulated depreciation by the total cost and prints it as a percentage in the % Depreciated column.

Sort By

In this group box, you can choose to sort the report by asset account, asset account/ organization, organization, organization/asset account, or asset/item number. You can sort by only one category at a time. Reports are always sorted by asset/item number within the primary sort category you select.

Field Description
1st Sort

Select the primary sort to use in the report from the drop-down list. The available options are:

  • Asset Account: Select this option to sort the report by asset account ("ownership" account, such as balance sheet, project, and so on). When you print the report using this sort option, the asset account number and name print in the header of the report. For each different asset account, data will be sorted by asset/item number in ascending order.
  • Asset Account/Organization: Select this option to sort the report first by asset account number and then by organization number. For each different organization, data will be sorted by asset/item number in ascending order.
  • Organization: Select this option to sort the report by organization. When you print the report using this sort option, the organization number and description print in the header of the report. For each different organization, data will be sorted by asset/item number in ascending order.
  • Organization/Asset Account: Select this option to sort the report first by organization and then by asset account number. For each different asset account, data will be sorted by asset/item number in ascending order.
  • Asset/Item Number: Select this option to sort the report by asset/item number. If you select this, the Page Break check box is disabled.
Page Break

Select this check box if you want a page break each time the selected sort parameter changes. For example, if the information is sorted by Asset Account, select the Page Break check box if you want data for each different asset account to begin printing on a separate page. If you choose Asset/Item Number as the sort option, this check box will be disabled.

Print Totals by Asset No

Select this check box to print totals by asset number for the Total Cost, Accum Depreciation, and Book Value columns.

This check box is available only if you select the Asset/Item Number sort option. If you select this check box and the Asset/Item Number sort option, the report prints data for each asset/item number, but also displays totals for all items associated with each asset number. This option provides standard component reporting as an alternative to other system reports in Costpoint Fixed Assets.

Note: If you want to use most of the same report selection parameters but want to run a slightly different report, you can use Copy Record to copy the parameters and make minor changes to them without changing your saved parameters. To use Copy Record, open the record you want to duplicate through Query (F11), select the line that you want to duplicate, and then go to the Line menu and select Copy Record (or press CTRL+E). The system makes a copy of the parameters, which you can edit and save as desired.