Contents of the Print Schedule of Accumulated DEPR Activity Report Screen

Use the fields and options to configure the Print Schedule of Accumulated DEPR Activity Report 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.

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.

Field Description
Option

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

Field Description
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.

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

Field Description
Option

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

Field Description
Option

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

Field Description
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.

Field Description
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.

Field Description
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.

Field Description
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.

Note: 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.
Field Description
1st Sort

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

  • Accum Depr Acct — Select this option to sort the report by accumulated depreciation account.
  • Accum Depr Org — Select this option to sort the report by accumulated depreciation organization.
  • Accum Depr Proj — Select this option to sort the report by accumulated depreciation project.
  • A/D Account/Org — Select this option to sort the report by accumulated depreciation account/organization.
  • A/D Org/Account — Select this option to sort the report by accumulated depreciation organization/account.
  • Asset No/Item No — Select this option to sort the report by asset/item number. Account and/or organization data will not print on the report for this sort option and thePage Break check box is also unavailable. This sort option is available only if you select Detail by Asset in the Report Option group box.
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.

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