PRINT ASSET LOCATION REPORT

Use this report to print location information for one, a range of, or all asset/item numbers. You can choose to include inactive records, disposals, and/or non-depreciable records for the asset/item number(s) selected.

You can select a primary sort on the following location-related fields: Location Group, City, State/Province, County, Country, Location 1 Code, Location 2 Code, or Location 3 Code. For each primary sort, records display in ascending asset/item number order. For all sort selections except Asset/Item No, you can also enable a page break each time the selected sort parameter changes.

Because you are not required to use the Loc Info tab on the Manage Asset Master Information screen or the Manage Asset Location Information screen, some of your assets may not have any location information associated with them. Assets for which you have entered no location information will not be included in this report.

The Asset Location Report provides a current "snapshot" of location data at the time you run the report and can be printed at any time.

Because all location fields for an Asset Master record are optional in Costpoint Fixed Assets, this report is not considered an essential part of the system audit trail. You may want to print this report before you make location changes, however, because the history for previous location data is not automatically retained without user intervention. Two options are available to retain previous location data:

You must also select the Asset Master Records check box in the Write Change Details to Audit Log for group box (on the Configure Asset/Template Change Settings screen) to indicate if you want the system to write change details to an audit log for location changes made to Asset Master records. You must also choose the specific asset master location fields for which you want the system to capture the change details.

Location

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

Use the fields in this group box 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 make selections in any of the check boxes in the Select Record Status or Select Depreciation Status group boxes, it may also modify which assets are actually included in the report.

Asset/Item Numbers

Option

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

Start

Enter, or click to select, the beginning asset and item numbers 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 location data do not exist or asset records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table 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 and item number(s) for the range.

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

Options

Select Record Status

Use this group box to include active, inactive records, and/or disposals. You must select at least one check box. Select as many check boxes as needed.

Active Records

Select this check box to include active records in your print selection criteria. This check box is selected by default.

Inactive Records

Select this check box to include inactive records within the range of records selected for the report. If this check box is clear, the system automatically excludes all inactive records. Asset Master records can be assigned an Inactive status on the Manage Asset Master Information screen.

Disposals

Select this check box to include disposals within the range of records selected for the report. If this check box is clear, the system automatically excludes all disposals.

You can enter disposals for active records on the Manage Disposal Transactions screen. Once the disposal is posted to the General Ledger, the system automatically changes the record's status from Active to Disposal.

Select Depreciation Status

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 within the range of records selected for the report. If this check box is clear, the system automatically excludes all non-depreciable records. Asset Master records can be assigned a Non-Depreciable status on the Manage Asset Master Information screen.

Sort By

In this group box, you can select the sort option for the report. You can sort by only one category at a time. Records will be printed in ascending asset/item number order within the primary sort category. Location data prints in the same format, regardless of the selected sort option.

1st Sort

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

You can optionally assign labels for Locations 1, 2, and/or 3 on the Manage Asset Master Field Labels screen. The user-defined labels for these fields automatically display as labels and as column descriptions in the report. If you have not defined labels, "Location1," "Location2," and "Location3," as applicable, will automatically display as column headers in the report.

Page Break

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

If you want to use most of the same report selection parameters but want to run a slightly different report, you can use the Copy Record function to duplicate the parameters and make minor changes to them without changing your saved parameters. To use Copy Record, open the record to be copied, and then click Line » Copy Record or press CTRL+E. The system makes a copy of the parameters, which you can edit and save as desired. You need to indicate a Parameter ID and Description for the new record.