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
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
|
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:
|
| Start |
Enter, or click
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
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
|
| End |
Enter, or click
|
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:
|
| Start |
Enter, or click
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
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:
|
| Start |
Enter, or click
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
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:
|
| Start |
Enter, or click
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
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.
| Field | Description |
|---|---|
| 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. Note: This check box will be available only if you select
Detail by Asset in the
Report Option group box.
|
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.