PRINT SCHEDULE OF ASSET ACTIVITY REPORT

Use this screen, the Print Schedule of Asset Activity Report to print the asset "ownership" account cost activity from a selected beginning up to an ending point in time. This report includes the beginning cost balance, additions, disposals, transfers, and the ending balance.

Asset "ownership" account and organization are required data for each Asset Master record. Project and reference number data is always optional. Ownership project/organization/account (POA) combination assignments follow normal Costpoint rules regarding validations, links, and so on, and there are no specific Fixed Assets rules regarding the type of G/L ownership data that can be assigned to an Asset Master record. Company-owned equipment usually is owned by asset balance sheet accounts. Government property is often owned by a project (as well as the account/organization). Expensed items that fall below a company's stated capitalization threshold but for which tracking is desired are often owned by a G/L expense account such as "Small Equipment Not Capitalized," and so on.

Although you can print cost data for the G/L Book and all optional books, you can print the data for only one book at a time.

You can print a detail report that prints data asset-by-asset or a summary report that rolls all asset data up to account/organization/project, as applicable, per the selection parameters. You can also print the data for a range of (including one), or all, asset/item numbers, asset accounts, organizations, and/or projects, and for one or a range of fiscal years and periods. Sort options are by ownership account, by ownership organization, by ownership project, by ownership account/organization, by ownership organization/account, or by asset/item number. You can also use the page break option for all sorts other than by asset/item number.

You can print data for depreciable and/or non-depreciable assets, and active records, inactive records, and/or disposals. If you include disposals in the report, you must also choose whether or not to include data from manual disposal entries.

You can capture changes to asset cost components (unit price, sales tax, and so on) made manually in Asset Master records or via global functionality in the Asset Audit Log if you have enabled this function for the cost fields on the Configure Asset/Template Change Settings screen (in the Asset/Template Field/Column Names subtask).

You can also include changes to the cost fields as positive or negative values in the Additions column on the report.

This report prints in landscape mode. Because all the fields already exist in decimal format, you cannot print the data on the report in whole (rounded) numbers.

To remind you that this report may not include all the transfer data you expect, the system displays a "soft" warning message which tells that transfer data may be missing from this report because you have not enabled the ability to track transfers of asset "ownership" accounts, organizations and/or projects on the Configure Asset/Template Change Settings screen.

Because data for this report can be retrieved and computed for historical fiscal years/periods, you can print this report whenever necessary to assist you in reconciling the asset cost accounts in Costpoint General Ledger to the balances in Costpoint Fixed Assets or in re-creating the activity in your asset accounts.

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

Asset/Item Number

Use the fields for asset/item numbers to select the asset/item number(s) for which to print asset activity data. The fields are available only if you have selected the Detail by Asset option in the Report Option group box.

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

Because the following fields use standard Lookups to the ASSET table, you may find that you have selected asset/item numbers for which asset activity data do not exist or do not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.

Option

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

Start

Enter, or click to select, the beginning asset/item number for the 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 asset/item number for the range option.

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

Time Periods

Use the fields for time periods to select records for the report from a specified beginning up to an ending fiscal year and period.

The Fiscal Year field Lookup only displays those fiscal years already set up on the Manage Fixed Assets Fiscal Years screen in descending order, beginning with the latest fiscal year. Because the Fiscal Year fields use standard Lookups to the FA_FY_INFO table in Fixed Assets, you may find that you have selected a fiscal year for which asset activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

The Period field Lookup only displays those accounting periods already set up on the Manage Fixed Assets Accounting Periods screen for the fiscal year specified in the corresponding Fiscal Year field. Because the Period fields use standard Lookups to the FA_PD_INFO table in Fixed Assets, you may find that you have selected a period for which asset activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

Start

Enter, or click to select, the beginning Fiscal Year and Period in each field.

End

Enter, or click to select, the ending Fiscal Year and Period in each field.

Asset Accounts

Use the fields for asset accounts to select records for the report from one asset ("ownership") account, a range of asset ("ownership") accounts, or all asset ("ownership") accounts.

Because the following fields use standard Lookup to the ACCT table, you may find that you have selected accounts for which asset activity data does not exist or that does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

Account and organization asset "ownership" data is required in each Asset Master record. Project "ownership" data is optional.

Option

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

Start

Enter, or click to select, the beginning asset ("ownership") account number in this field from the G/L Account table.

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 ("ownership") account number from the G/L Account table.

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

Asset Organizations

Use the fields for asset organizations to select records for the report from one asset ("ownership") organization, a range of asset ("ownership") organizations, or all asset ("ownership") organizations.

Because the following fields use standard Lookups to the ORG_ACCT table, you may find that you have selected organizations for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

Account and organization asset "ownership" data is required in each Asset Master record. Project "ownership" data is optional.

Option

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

Start

Enter, or click to select, the beginning ("ownership") organization in this field.

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

End

Enter, or click to select, the ending ("ownership") organization in this field.

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

Asset Projects

Use the fields for asset project to select records for the report from one asset ("ownership") project, a range of asset ("ownership") projects, or all asset ("ownership") projects, as applicable.

Because the following fields use standard lookups to the PROJ table, you may find that you have selected projects for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

Account and organization asset "ownership" data is required in each Asset Master record. Project "ownership" data is optional.

Option

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

Start

Enter, or click to select, the beginning ("ownership") project in this field, as applicable.

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

End

Enter, or click to select, the ending ("ownership") project in this field, as applicable.

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

Book

Enter, or click to select, the book for which to print asset activity information. Although you can only select one book at a time, you can print this report for any book.

Included in the Lookup are the labels that you assigned to each optional book during initialization on the Configure Fixed Assets Settings screen, as applicable.

Options

Report Option

Use the options in this group box to specify either a summary report that omits individual asset/item number data or a detailed report that prints data for each asset/item number (within the parameters of your selection criteria).

Summary

Select this option to print a summary report without individual asset/item number data.

If you select this option, you cannot select records by asset/item number. In addition, you cannot access the Asset No/Item No sort option or the Page Break check box in the Sort By group box.

Detail by Asset

Select this option to print a detailed report that includes data by individual asset/item number.

Select Record Status

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

Active

Select this check box to include active records in the report selection criteria. If this check box is clear, the system excludes all active records.

Inactive

Select this check box to include inactive records in the report selection criteria. If this check box is clear, the system excludes all inactive records.

Disposal

Select this check box to include disposals in the report selection criteria. If this check box is clear, the system excludes all disposals.

Include Disposal Entry Types

Use this group box to specify whether you want to include data for manually entered disposals on the report.

Manual

Select this check box to include data for manually entered disposals ("MANUAL") on the report. The system automatically includes data for system-generated disposals ("SYSTEM") on the report when the Disposal check box is selected in the Select Record Status group box.

Select Depreciation Status

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

Depreciable

Select this check box to include depreciable records in the report selection criteria. If this check box is clear, the system excludes all depreciable records.

Non-Depreciable

Select this check box to include non-depreciable records in the report selection criteria. If this check box is clear, the system automatically excludes all non-depreciable records.

Include Changes to Cost Components

Use the check box in this group box to specify whether you want the system to include changes to cost elements in the Additions column on the report.

Show Changes to Cost Elements in Additions Column

Select this check box if you want to include captured change data for changes made to Asset Master cost elements in the Additions column on the report.

In order to capture change data, you must first select the Asset Master Records check box on the Configure Asset/Template Change Settings screen.

On that same screen, you must also first select the desired fields/columns in the Asset/Template Field/Column Names subtask BEFORE you make changes to Asset Master records. Each check box that you select in that subtask 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).

Relative to this check box, you should select the Unit Price Amt, Sales Tax Amt, Shipping/Handling Amt, Transportation Amt, and/or Other Cost Amt rows in the Asset/Template Field/Column Names subtask. Doing so will enable you to trap change data made to any of the cost element fields in Asset Master records. (Once the change details have been captured, you can view change data from the Asset Audit Log on the View Asset Change History screen or print reports from the Asset Audit Log via the Print Asset/Template Change History Report screen.)

Sort By

In this group box, you can determine how the system organizes the data for the report and whether you want a page break in the report each time the selected sort parameter changes.

However, the report always prints in the same format, regardless of the sort option you select. The sort option determines how data should be ordered within this format.

1st Sort

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

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 choose to sort the data by account, select the Page Break check box if you want the data for each different account to begin printing on a separate page. If you choose Asset No/Item No as the sort option, this check box is disabled.

This check box will only be available if you select Detail by Asset in the Report Option group box.