PRINT ASSET BOOK VALUE REPORT

Use this screen to print asset book value data for each book in Costpoint Fixed Assets, including the G/L book and any additional books set up for use on the Configure Fixed Assets Settings screen. This report always includes active, depreciable records, but you can create asset book value reports with different data by including or excluding inactive records, non-depreciable records, and/or disposals.

The report displays total cost, accumulated depreciation, and book value data, as well as an option to print a column that displays the percentage of the asset that has already been depreciated. In addition, you can choose whether to include or exclude the current period depreciation amount in the displayed accumulated depreciation value. Five different sort options (asset account, asset account/organization, organization, organization/asset account, and asset/item number) are also available to organize the data differently.

This report, Print Asset Book Value Report, provides a current "snapshot" of book value data at the time you run the report and can be printed at any time. Because you cannot print data from previous periods in this report, you should retain this report to use when performing G/L reconciliations.

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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

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 in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in 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 in 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.

Option

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

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.

Option

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

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

Book

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.

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.

Option

Start

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

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.

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

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.

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

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

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.

1st Sort

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

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.