VIEW ASSET CHANGE HISTORY

Use this screen to view asset change history data stored in the ASSET_AUDIT_LOG table.

To store change data in the ASSET_AUDIT_LOG table, you must run the Configure Asset/Template Change Settings screen. You must also access the Asset/Template Field/Column Names subtask from that screen to select check boxes on a field-by-field basis for Asset Master records. Each check box that you select signifies that you want to capture data for that field for an Asset Master record each time you make a change to that data, regardless of the screen in which the change was made.

The ASSET_AUDIT_LOG table holds audit history data that is created when you make changes in any of the following screens:

• Manage Asset Master Information (main screen and all tabs and subtasks)

• Manage Asset Description Information

• Manage Asset Purchase Information

• Manage Asset Cost Information

• Manage Asset Location Information

• Manage Asset Account Information

• Manage Asset General Ledger Book Information

• Manage Asset Other Books Information

• Manage Asset Disposal Information

• Manage Asset Government Information

• Manage Asset User-Defined Information

• Manage Asset Master Global Changes

• Manage Asset Master User-Defined Global Changes

In the header of this inquiry screen, you can select a general subset of records to view, including the asset/item number, entry date, entry user ID, English column name, and user-defined label name.

Data displays in the table window when you select the Execute button on the toolbar.

Use Query to choose more specific selection criteria or enter selection criteria in the screen fields. Data in the table window is non-editable.

You can view asset change history data at any time on this screen once the asset change history data has been written to the ASSET_AUDIT_LOG.

Location

Additional Information on the Header fields

Asset No

Enter, or click to select, the desired asset number of the data you want to view.

This field is optional. If you leave this field blank and you do not use Query, all asset/item numbers from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which change history data do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET_AUDIT_LOG table may not be selected.

The Asset No field is one of several key fields in the Asset Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Asset No column will not display in the table window.

Change Date

Enter, or click to select,  the desired change history entry date for the data you want to view in this field. Lookup is not available at this field.

If you leave this field blank and you do not use Query, all change history entry dates, within the confines of your other selection parameters, will display in the table window.

The Change Date field is one of several key fields in the table. If you enter data in this field and you click the Execute button on the toolbar, the Change Date column will not display in the table window.

English Column Name

Enter, or click to select, the desired English column name of the data you want to view.

This field is optional. If you leave this field blank and you do not use Query, all English column names from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Asset Audit Log table and will therefore display only English column names for which change history data has been written to the Asset Audit Log table (ASSET_AUDIT_LOG). If no data exists in the table, the system displays a message that tells you that nothing was found in Lookup.

The English Column Name field is one of several key fields in the Asset Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the English Column Name column will not display in the table window.

Use the rules outlined in the Additional Information on the Header Fields section to make your desired selection in this field.

Item No

Enter, or click to select, the desired item number of the data you want to view.

This field is optional. If you leave this field blank and you do not use Query, all asset/item numbers from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which change history data do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET_AUDIT_LOG table may not be selected.

The Item No field is one of several key fields in the Asset Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Item No column will not display in the table window.

Entry User ID

Enter, or click to select, the desired user ID for the data you want to view.

This field is optional. If you leave this field blank and you do not use Query, all entry user IDs from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Asset Audit Log table, and will therefore display only entry user IDs for which change history data has been written to the Asset Audit Log table (ASSET_AUDIT_LOG). If no data exists in the table, the system displays a message that tells you that nothing was found in Lookup.

The Entry User ID field is one of several key fields in the Asset Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Entry User ID column will not display in the table window.

User-Defined Label

Enter, or click to select, the desired user-defined label of the data you want to view. This field is optional.

If you leave this field blank and you do not use Query, all user-defined labels from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Asset Audit Log table, and will therefore only display user-defined labels for which change history data has been written to the Asset Audit Log table (ASSET_AUDIT_LOG). If no data exists in the table, the system displays a message that tells you that nothing was found in Lookup.

The User-Defined Label field is one of several key fields in the Asset Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the User-Defined Label column will not display in the table window.

Use the rules outlined in the Additional Information on the Header Fields section to make your desired selection in this field.

Table Window

Please refer to the preceding documentation regarding the relationship between column data displayed in the table window and field data displayed in the screen header. The columns in the table window are non-editable.

Asset No

This column, as applicable, displays the asset number for the change history data that you have selected to view.

Item No

This column, as applicable, displays the item number for the change history data that you have selected to view.

Change Date

This column, as applicable, displays the change history entry date for the change history data that you have selected to view.

Entry User ID

This column, as applicable, displays the entry user ID for the change history data that you have selected to view.

English Column Name

This column, as applicable, displays the English column name for the change history data that you have selected to view.

User-Defined Label

This column, as applicable, displays the user-defined label for the change history data that you have selected to view.

Original Column Value

This column displays the original (old) data prior to the change made to the records that you have selected to view.

New Column Value

This column displays the revised (new) data after the change was made to the records you have selected to view.

JE Reqd

This column displays the Journal Entry Required indicator flag for the records you have selected to view.

You can have the system automatically generate transfer entries for posting to the General Ledger when you make changes to the asset ("ownership") account, organization, and project fields AND/OR the Accumulated Depreciation Account Code fields in an Asset Master record. You can enable this capability on the Configure Asset/Template Change Settings screen.

• If Y displays in this column, this signifies that there is a transfer entry in the Asset Audit Log table that has not yet been posted to the General Ledger.

• If N displays in this column, this signifies that the row was not and is not now eligible for a transfer entry.

• If P displays in this column, this signifies that a transfer entry has already been posted to the General Ledger. If transfer data has already been posted, data will also display in the Posting Fiscal Year, Posting Period, and Posting Subperiod columns in this table window.

Fiscal Year

This column displays the fiscal year in which the change history data was saved in the Asset Audit Log, for the records that you selected to view.

Period

This column displays the accounting period in which the change history data was saved in the Asset Audit Log, for the records that you selected to view.

Subperiod

This column displays the accounting subperiod in which the change history data was saved in the Asset Audit Log, for the records that you selected to view.

Posting Seq No

In the event of a system failure during a posting, or if an entry for the asset is currently being posted, the entry's posting sequence number will display in this non-editable column for the row.

Identical posting sequence numbers are assigned to all entries posted in a specific session. A sequence number displays only for entries that were unsuccessfully posted or if the system is in the process of posting the entry. The sequence number will no longer display after the entry has been successfully posted for the asset.

Posting Fiscal Year

You can have the system automatically generate transfer entries for posting to the General Ledger when you make changes to the asset ("ownership") account, organization, and project fields AND/OR the Accumulated Depreciation Account Code fields in an Asset Master record. You can enable this capability on the Configure Asset/Template Change Settings screen.

After a transfer entry is posted, this column displays the fiscal year in which the transfer entry was posted to the General Ledger. In this circumstance, P also displays in the JE Reqd column in this table window.

Posting Period

You can have the system automatically generate transfer entries for posting to the General Ledger when you make changes to the asset ("ownership") account, organization, and project fields AND/OR the Accumulated Depreciation Account Code fields in an Asset Master record. You can enable this capability on the Configure Asset/Template Change Settings screen.

After a transfer entry is posted, this column displays the accounting period in which the transfer entry was posted to the General Ledger. In this circumstance, P also displays in the JE Reqd column in this table window.

Posting Subperiod

You can have the system automatically generate transfer entries for posting to the General Ledger when you make changes to the asset ("ownership") account, organization, and project fields AND/OR the Accumulated Depreciation Account Code fields in an Asset Master record. You can enable this capability on the Configure Asset/Template Change Settings screen.

After a transfer entry is posted, this column displays the accounting subperiod in which the transfer entry was posted to the General Ledger. In this circumstance, P also displays in the JE Reqd column in this table window.