PRINT ASSET/TEMPLATE CHANGE HISTORY REPORT
Use this report to print change data stored in the audit history tables for Asset Master records and/or Asset Template records.
To store change data in the Asset Change Audit Log (ASSET_AUDIT_LOG) table and/or the Template Change Audit Log (FA_TMPLT_AUDIT_LOG) table (as applicable), you must use the Configure Asset/Template Change Settings screen to indicate whether you generally want to capture Asset Master changes and/or Asset Template changes. Then you must access the Asset/Template Field/Column Names subtask of that screen to select check boxes on a field-by-field basis for Asset Master and/or Asset Template records, as applicable. Each check box that you select signifies that you want to capture data for that field for an Asset Master and/or Asset Template record each time you make a change to that data, regardless of the screen in which the change was made.
Provided that selection has occurred as described, the ASSET_AUDIT_LOG table holds audit history data that is created when you make changes in any of the following screens:
The FA_TMPLT_AUDIT_LOG table holds audit history data that is created when you make changes in any of the following screens:
You can print Asset Master record changes stored in the ASSET_AUDIT_LOG table or you can print Asset Template record changes stored in the FA_TMPLT_AUDIT_LOG. You must run each type of print (Asset or Template) separately from this screen. In addition, for the selected data print type (Asset or Template), you can print history data either for changes to the user-defined fields only or for changes to the database fields only (excluding the user-defined fields).
You must first select the Asset Change History or the Template Change History data type for the report.
-
If you select Asset Change History data type, you must also select asset/item numbers for the report.
-
If you select Template Change History data type, you must also select template/revision numbers for the report.
You must also print change history related to user-defined fields or for database fields excluding the user-defined fields. Depending on this decision, use Lookup to choose either the database column name or the User-Defined Label, as applicable.
Regardless of the data type selected for the report, you can also select a user ID and a range of change dates and/or fiscal years/periods.
You can also print data for active records, inactive records, disposals, depreciable records, and/or non-depreciable records.
Sort options for the change history include the following:
You can select the Page Break check box for many of these sort options.
You can print this report at any time. The system incrementally stores additional change history data per your selections on the Configure Asset/Template Change Settings screen; the table data is not replaced. You can delete the change data only by running the Purge Asset/Template Change History process.
Change history data prints on the report based on your selection parameters and the data that resides in the ASSET_AUDIT_LOG table and/or the FA_TMPLT_AUDIT_LOG table (as applicable) at the time you run the report.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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