PRINT SCHEDULE OF ACCUMULATED DEPR ACTIVITY REPORT

Use this screen, the Print Schedule of Accumulated Depr Activity Report to print the asset accumulated depreciation account 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.

Accumulated Depreciation account and organization are required data for each depreciable Asset Master record and are assigned to assets via the accumulated depreciation account code. When you set up accumulated depreciation account codes, project and reference number data are always optional. The POAs assigned for use in accumulated depreciation account codes follow normal Costpoint rules regarding validations, links, and so on, and there are no specific Fixed Assets rules regarding the type of the POA's that can be set up for accumulated depreciation account codes and ultimately assigned to an Asset Master record.

Although you can include projects in the setup of accumulated depreciation account codes, this rarely happens in practice. The accumulated depreciation accounts (assigned to Asset Master records via the accumulated depreciation account code) are charged when depreciation, disposals, and transfers are posted to the General Ledger (debits or credits, as applicable).

Some Costpoint Fixed Assets reports offer the additional option to print accumulated depreciation data by accumulated depreciation account code. This option is not available for this report. This report is an activity report, often requested by auditors to justify changes to these accounts, and printing by POA is an effective approach.

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 accumulated depreciation 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, accumulated depreciation accounts, organizations, and/or projects, and for one or a range of fiscal years and periods. Sort options are by account, by organization, by project, by account/organization, by organization/account, or by asset no/item no. You can also use the page break option for all sorts other than by asset/item number.

Because the accumulated depreciation accounts apply only to depreciable records, depreciable records are automatically included in the selection (and you cannot print data for non-depreciable assets). You can, however, print data for active records, inactive records, and/or disposals. If you include disposals in the report, you can include data from manual disposal entries.

You can capture changes to accumulated depreciation components (FYTD Depreciation and Prior FY Depreciation) made manually in Asset Master records or via global functionality in the Asset Audit Log if you have enabled this function for these fields on the Configure Asset/Template Change Settings screen.

You can also include changes to the accumulated depreciation fields as positive or negative values in the Additions column on the report (for both posted and unposted transfers).

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 the following "soft" warning message under certain circumstances that informs you that transfer data may be missing from the report because you have not enabled the ability to track transfers accumulated depreciation account codes 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 accumulated depreciation accounts in Costpoint General Ledger to the balances in Costpoint Fixed Assets or in re-creating the activity in your accumulated depreciation 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 following fields for accounting and item numbers to select the asset/item number(s) for which to print asset activity data. The fields in this group box 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.

Option

Select a 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.

Because this is a standard Lookup 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.

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.

Because this is a standard Lookup 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.

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

Time Periods

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

The Fiscal Year field Lookup displays only 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 display only 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 corresponding Fiscal Year and Period field.

End

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

Accum Depr Accounts

Use the following fields for accounts to select records for the report from one accumulated depreciation account, a range of accumulated depreciation accounts, or all accumulated depreciation accounts.

Accumulated Depreciation account and organization data is required in each depreciable Asset Master record and is entered onto Asset Master records using the Accumulated Depreciation Account Codes. These codes, which are established on the Manage Accumulated Depreciation Account Codes screen in Fixed Assets Controls, are saved combinations of account and organization, as well as optional project, Reference 1 and Reference 2 values.

Option

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

Start

Enter, or click to select, the beginning accumulated depreciation account number in this field from the G/L Account table.

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

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

End

Enter, or click to select, the ending accumulated depreciation account number in this field from the G/L Account table.

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

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

Accum Depr Organizations

Use the following fields for organizations to select records for the report from one accumulated depreciation organization, a range of accumulated depreciation organizations, or all accumulated depreciation organizations.

Accumulated depreciation account and organization data is required in each depreciable Asset Master record and is entered onto Asset Master records using the Accumulated Depreciation Account Codes. These codes, which are established on the Manage Accumulated Depreciation Account Codes screen in Fixed Assets Controls, are saved combinations of account and organization, as well as optional project, Reference 1 and Reference 2 values.

Option

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

Start

Enter, or click to select, the beginning accumulated depreciation organization in this field.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset activity data do not exist or which do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

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

End

Enter, or click to select, the ending accumulated depreciation organization in this field.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset activity data do not exist or which do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

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

Accum Depr Projects

Use the following fields for projects to select records for the report from one accumulated depreciation project, a range of accumulated depreciation projects, or all accumulated depreciation projects, as applicable.

Accumulated depreciation account and organization data is required in each depreciable Asset Master record and is entered onto Asset Master records using the Accumulated Depreciation Account Codes. These codes, which are established on the Manage Accumulated Depreciation Account Codes screen in Fixed Assets Controls, are saved combinations of account and organization, as well as optional project, Reference 1 and Reference 2 values.

Option

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

Start

Enter, or click to select, the beginning accumulated depreciation project in this field, as applicable.

Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset activity data do not exist or which do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

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

End

Enter, or click to select, the ending accumulated depreciation project in this field, as applicable.

Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset activity data do not exist or which do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.

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 accumulated depreciation activity information.

Although you can only select one book at a time, you can print this report for any book. Also 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.

Include Disposal Entry Types

Use this group box to specify whether you want to include data for manually entered disposals on the report. In order to select this option, the Disposal check box in the Select Record Status group box must already be selected.

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.

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. If this check box is selected but the Manual check box in the Include Disposal Entry Types group box is cleared, only posted disposals will appear in the report and manually entered disposals will be left off of the report.

Include Changes to Accumulated Depreciation 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 Accum Depr 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 on 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 capture 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 in 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. For example, if you have selected to sort the data by accumulated depreciation account, select the Page Break check box if you want the data for each different accumulated depreciation account to begin printing on a separate page.

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 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 accumulated depreciation account, select the Page Break check box if you want the data for each different accumulated depreciation 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 be available only if you select Detail by Asset in the Report Option group box.