Contents of the Print Asset/Template Change History Report Screen

Use the fields and options to configure the Print Asset/Template Change History Report screen from the Accounting 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.

Select By Option

Select Data Type

Use the options in this group box to print asset change history or template change history. This report automatically prints data for each selected asset/item number (within the parameters of your other selection criteria).

Field	Description
Asset Change History	Select this option to print asset change history on the report. If you select this option, you cannot select or sort by template/revision number.
Template Change History	Select this option to print template change history on the report. If you select this option, you cannot select or sort by asset/item number.

Selection Ranges

Asset/Item Numbers

Use the following fields to select the asset/item number(s) for which to print change history data. These fields are available only if you have selected the Asset Change History option in the Select Data Type group box.

If you enter an asset number, you must also enter a corresponding item number.

Field	Description
Option	Select a range option from the drop-down list. The available options are: All One Range From Beginning To End
Start—Asset No/Item No	Enter, or click to select, the beginning asset/item number for the range Option. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset number that does not meet your other selection criteria. If you select All or From Beginning in the Option field, these fields will be inactive.
End—Asset No/Item No	Enter, or click to select, the ending asset/item number for the range Option. Because this is a standard Lookup to the ASSET table, you may find that you have selected an item number that does not meet your other selection criteria. If you select All, One, or To End in the Option field, these fields will be inactive.

Template/Revision Numbers

Use the following fields to select the template/revision number(s) for which to print change history data. These fields are available only if you have selected the Template Change History option in the Select Data Type group box.

Note: The Template No field on the Manage Asset Template Information screen, together with the optional Rev No field, supplies the unique identifier for an Asset Template record. A revision number is not required when you set up asset templates. If you have a created a template number for which an associated revision number has also been created as part of the identifier, however, then you must enter the revision number along with the template number to ensure that the proper records will be included in the selection criteria.

Field	Description
Option	Select a range option from the drop-down list. The available options are: All One Range From Beginning To End
Start—Template No/Rev	Enter, or click to select, the beginning template/revision identifier in this field. If you select All or From Beginning in the Option field, this field will be inactive.
End—Template No/Rev	Enter, or click to select, the ending template/revision identifier in this field. If you select All, One, or To End in the Option field, this field will be inactive.

Transaction Time Periods

Use the fields in this group box to select change records for the report.

The Fiscal Year field Lookup display only those fiscal years already set up on the Manage Fiscal Years screen in Costpoint General Ledger. (Fiscal years set up in the General Ledger should always match those set up in Costpoint Fixed Assets on the Manage Fixed Assets Fiscal Years screen.) Because the display in the Fiscal Year field Lookup is a standard lookup to the Fiscal Year table, you may find that you have selected a fiscal year for which historical change data do not exist or do not meet your other selection criteria.

The Period field Lookup display only those accounting periods already set up on the Manage Accounting Periods screen in Costpoint General Ledger for the fiscal year specified in the Fiscal Year field. (Accounting periods set up in Costpoint General Ledger should always match those set up in Costpoint Fixed Assets on the Manage Fixed Assets Accounting Periods screen). Because the display in the Period field is a standard lookup to the Accounting Period (ACCTING_PD) table, you may find that you have selected a period for which historical change data do not exist or do not meet your other selection criteria.

Field	Description
Option	Select a range option from the drop-down list. The available options are: All One Range From Beginning To End
Start—Fiscal Year/Period	Enter, or click to select, the beginning desired fiscal year and period in each field. If you select All or From Beginning in the Option field, these fields will be inactive.
End—Fiscal Year/Period	Enter, or click to select, the ending desired fiscal year and period in each field. If you select All, One, or To End in the Option field, these fields will be inactive.

Change Dates

Use the following fields to select the change dates for which to print change history data. The change date is the date at which changed data is saved in the ASSET_AUDIT_LOG table and/or the FA_TMPLT_AUDIT_LOG table, as applicable.

Field	Description
Option	Select the range option from the drop-down list. The available options are: All One Range From Beginning To End
Start	Enter, or click to select, the beginning change date for the selected range option. If you select All or From Beginning in the Option field, this field will be inactive.
End	Enter, or click to select, the ending change date for the selected range option. If you select All, One, or To End in the Option field, this field will be inactive.

Database Column and User-Defined Label

Use the Database Column and User-Defined Label fields to print change history for database fields excluding the user-defined fields OR for user-defined fields on the report. The following describes how the single-selection Database Column and User-Defined Label fields function:

• You can specify a single database column name in either field either by data entry or by using Lookup.
• If you leave both fields blank, all database column data will automatically print on the report (excluding user-defined data and within the confines of the other selection criteria).
• If the User-Defined Label field is left blank and you specify a column name in the Database Column field (other than "User-Defined Text Fields," "User-Defined Date Fields," "User-Defined Amount Fields," or "User-Defined Validated Text"), data for the specified column will print on the report.
• If you select or enter "User-Defined Text Fields," " User-Defined Date Fields," "User-Defined Amount Fields," or "User-Defined Validated Text" in the Database Column field (these "columns" will also be included as selections during the Lookup AND if you do not enter a specific UDF label in the User-Defined Label field, all data for the user-defined field type will automatically be selected (within the confines of the other selection criteria).
• To print UDF data for a specific user-defined label, you must select or enter "User-Defined Text Fields," "User-Defined Date Fields," " User-Defined Amount Fields," or "User-Defined Validated Text" in the Database Column field (these "columns" will also be included as selections during the Lookup) AND you must also specify the label in the User-Defined Label data field.
• The User-Defined Label field is disabled if the data entered in the Database Column field is NOT one of the following: "User-Defined Text Fields," "User-Defined Date Fields," "User-Defined Amount Fields," or "User-Defined Validated Text."

User ID

Use this field to print change history for a single user ID or for all user IDs on the report. The following describes how the single-selection User ID field functions:

• You can specify data for a single user ID when you enter a value or click to select a user ID.
• If you leave this field blank, data for ALL USERS (that meet the other specified selection parameters) will be printed on the report.
• If you select the Asset Change History option in the Select Data Type group box, Lookup will access the ASSET_AUDIT_LOG table.
• If you select the Template Change History option in the Select Data Type group box, Lookup will access the FA_TMPLT_AUDIT_LOG.

Options

Select Record Status

Use the check boxes in this group box to choose the record status type(s) to include in your report. You can include active records, inactive records, and/or disposals. You must select at least one check box in this group box.

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.

Select Depr Status

Use this group box to choose the depreciation status type(s) to include in your report. You can include depreciable records or non-depreciable records. You must select at least one check box in this group box.

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.

Sort By

Use the options in this group box to determine how the system organizes the data for the report.

Field	Description
1st Sort	Select a sort option from the drop-down list. The available options are: Asset/Item No: Select this option to sort the report by asset/item number. This option is available only if you selected the Asset Change History option in the Select Data Type group box. Template/Rev No: Select this option to sort the report by template/revision number. This option is available only if you selected the Template Change History option in the Select Data Type group box. Change Date: Select this option to sort the report by change date. User ID: Select this option to sort the report by user ID. Database Column Name: Select this option to sort the report by database column name. User-Defined Label: Select this option to sort the report by user-defined label. Fiscal Year/Period: Select this option to sort the report by fiscal year/period.
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 you select to sort the data by Change Date, select the Page Break check box if you want the data for each change date to begin printing on a separate page