Contents of the Print Depreciation Component Information By Book Report Screen

Use the fields and options to configure the Print Depreciation Component Information By Book 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.

Select By Option

Select Records By

Use the options in this group box to specify how the depreciation component values should be selected. You can select records by asset ("ownership") account/organization/project, by accumulated depreciation account/organization/project, or by accumulated depreciation account code.

Field	Description
Asset Account/Organization/Project	Select this option to choose depreciation component values by asset ("ownership") account/organization/project.
Accum Depr Account/Organization/Project	Select this option to choose depreciation component values by accumulated depreciation account/organization/project.
Accum Depr Account Code	Select this option to choose posted depreciation expense data by accumulated depreciation account code.

Selection Ranges

Accounts or Codes

Your selection in the Select Records By group box determines the selection criteria that you can enter for accounts or codes.

• If you select Asset Account/Organization/Project option in the Select Records By group box, select data for the asset "ownership" account, as applicable.
• If you select the Accum Depr Account/Organization/Project option in the Select Records By group box, select data for the accumulated depreciation account, as applicable.
• If you select the Accum Depr Account Code option in the Select Records By group box, select data for the accumulated depreciation account code, as applicable.

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 account or code that relates to your selections in the Select Records By group box and Option field. Because this is a standard Lookup to the ACCT or ACCUM_DEPR_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, 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 account or code that relates to your selections in the Select Records By group box and Option field. Because this is a standard Lookup to the ACCT or ACCUM_DEPR_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, may not be selected. If you select All, One, or To End in the Option field, this field will be inactive.

Organizations

Your selection in the Select Records By group box determines the selection criteria that you can enter in this group box.

• If you select the Asset Account/Organization/Project option in the Select Records By group box, provide selection data for the asset "ownership" organization, as applicable.
• If you select the Accum Depr Account/Organization/Project option in the Select Records By group box, provide selection data for the accumulated depreciation organization, as applicable.
• If you select the Accum Depr Account Code option in the Select Records By group box, the following fields for organization are disabled.

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 organization that relates to your selection in the Select Records By group box and Option field. Because this is a standard Lookup to the ORG table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, 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 organization that relates to your selection in the Select Records By group box and Option field. Because this is a standard Lookup to the ORG table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected. If you select All, One or To End in the Option field, this field will be inactive.

Projects

Your selection in the Select Records By group box determines the selection criteria that you can enter for projects.

• If you select the Asset Account/Organization/Project option in the Select Records By group box, provide selection data for the asset "ownership" project, as applicable.
• If you select the Accum Depr Account/Organization/Project option in the Select Records By group box, provide selection data for the accumulated depreciation project, as applicable.
• If you select the Accum Depr Account Code in the Select Records By group box, the following fields for projects are disabled.

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 project that relates to your selection in the Select Records By group box and Option field. Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, 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 project that relates to your selection in the Select Records By group and Option field. Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected. If you select All, One, or To End in the Option field, this field will be inactive.

Asset/Item Numbers

Use the following fields to select the asset/item number(s) for which to print depreciation component values. These fields are only available 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 your selected range option. Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which the specified data do not exist or asset records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET or ASSET_OTH_BK_DEPR table, as applicable, 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 your selected range option. Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which the specified data do not exist or asset records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET or ASSET_OTH_BK_DEPR table, as applicable, may not be selected. If you select All, One, or To End in the Option field, this field will be inactive.

Book No

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

Aside from G/L Book, included options 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 or detailed report.

Field	Description
Summary	Select this option to specify a summary report that omits individual asset/item number data.
Detail by Asset	Select this option to specify a detailed report that prints data for each asset/item number (within the parameters of your selection criteria).

Select Record Status

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

Field	Description
Active Records	Select this check box to include active records in your print selection criteria.
Inactive Records	Select this check box to include inactive records in your print selection criteria.
Disposals	Select this check box to include disposals in your print selection criteria.

Select Depreciation Status

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

Field	Description
Depreciable Records	Select this check box to include depreciable records in your print selection criteria.
Non-Depreciable Records	Select this check box to include non-depreciable records in your print selection criteria.

Show

Use the drop-down list in this group box to select which type of data should display on the report along with its column position.

There are eight drop-down lists available, each of which corresponds to a column position on the report. You can choose one of nine options to display on the report in each column, as noted below.

• Total Cost: If you select this value, the system will display the Total Cost amount from Asset Master records on the report for the selected book. If the Total Cost amount is zero, "0.00" will display on the report.

  If you select G/L Book, the report prints the value from the Total Cost field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the G/L Book Total Cost Amt column of the Manage Asset Cost Information screen and in the G/L Book Total Cost column of the Manage Asset General Ledger Book Information screen.

  If you select optional books 2 to 10, the report prints the value from the Total Cost column in the Other Books Info subtask of the Manage Asset Master Information screen, as applicable. For each applicable book, the same value also displays in the Book (or your label) Total Cost column of the Manage Asset Other Books Information screen and in the Total Cost Amt column of the Manage Asset Cost Information screen.

• Salvage Value: If you select this value, the system will display the Salvage Value amount from Asset Master records on the report for the selected book. If the Salvage Value amount is zero, "0.00" will display on the report.

  If you select G/L Book, the report prints the value from the Value field (in the Salvage group box) in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Value field (in the Salvage group box) of the Manage Asset General Ledger Book Information screen.

  If you select optional books 2 to 10, the report prints the value from the Salvage Value field in the Other Books Info subtask of the Manage Asset Master Information screen, as applicable. For each applicable book, the same value also displays in the Book (or your label) Salvage Value column of the Manage Asset Other Books Information screen.

• Amount to Depr: If you select this value, the system will display the Amount to Depreciate amount from Asset Master records on the report for the selected book. If the Amount to Depreciate value is zero, "0.00" will display on the report.

  If you select G/L Book, the report prints the value from the Amount to Depreciate field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Amt to Depreciate field of the Manage Asset General Ledger Book Information screen.

  If you select optional books 2 to 10, the report prints the value from the Amt To Depreciate column in the Other Books Info subtask of the Manage Asset Master Information screen, as applicable. For each applicable book, the same value also displays in the Book (or your label) Amt to Depreciate column of the Manage Asset Other Books Information screen.

Field	Description
Col 1	Select an option from the drop-down list to select a field to display in the first column on the report. To display total blanks in this column, select None.
Col 2	Select an option from the drop-down list to select a field to display in the second column on the report. To display total blanks in this column, select None.
Col 3	Select an option from the drop-down list to select a field to display in the third column on the report. To display total blanks in this column, select None.
Col 4	Select an option from the drop-down list to select a field to display in the fourth column on the report. To display total blanks in this column, select None.
Col 5	Select an option from the drop-down list to select a field to display in the fifth column on the report. To display total blanks in this column, select None.
Col 6	Select an option from the drop-down list to select a field to display in the sixth column on the report. To display total blanks in this column, select None.
Col 7	Select an option from the drop-down list to select a field to display in the seventh column on the report. To display total blanks in this column, select None.
Col 8	Select an option from the drop-down list to select a field to display in the eighth column on the report. To display total blanks in this column, select None.

Accumulated Depreciation Total Option

Use the check box in this group box to include current period depreciation amounts in the accumulated depreciation totals.

Field

Description

Include Current Pd Depr Exp Amt in Accum Depr Column

Select this check box to obtain useful values from the report whenever you run it, both before and after you have computed depreciation. If you leave this check box clear, the Accum Depr column will display only the total of the fiscal year-to-date and depreciation for all prior fiscal years. In this circumstance, any current period depreciation already computed will be excluded from the system-computed total accumulated depreciation total and the system-computed book value total. As a result, the total amounts displayed on the report for accumulated depreciation and book value will be different from those displayed in the corresponding Asset Master record. If you want to include current period depreciation in the accumulated depreciation value displayed on the report, select this check box. In this circumstance, the total amounts displayed on the report for accumulated depreciation and book value will be identical to those displayed in the corresponding Asset Master record.

Print

Use the check box in this group box to print accumulated depreciation account code data on the report.

Field	Description
Accum Depreciation Acct Codes	This check box is available for use only if you have selected the Detail by Asset option in the Report Option group box. Select this check box to print the Accum Depr Acct Code column. If this check box is clear, the system will not print this data on the report.

Sort By

In this group box, you can choose how the system organizes the data for the report.

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.

Use the check boxes in this group box to select page break and project total options.

Field	Description
1st Sort	Select the primary sort option from the drop-down list. The available options are: Accounts: Select this option to sort the report by asset ("ownership") account. Organization: Select this option to sort the report by asset ("ownership") organization. Account/Organization: Select this option to sort the report by asset ("ownership") account/organization. Accum Depr Acct Code: This option is available only if you select the Detail by Asset option in the Report Option group box. Select this option to sort the report by accumulated depreciation account code. Asset/Item No: This option is available only if you select the Detail by Asset option in the Report Option group box. 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 the Page Break check box is also unavailable.
Print Project Totals	This check box is available only if you select the Detail by Asset option in the Report Option group box. Select this check box to print subtotals by project for the posted depreciation expense data.
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 have selected to sort the data by account, you should select the Page Break check box if you want the data for each different account to begin printing on a separate page. This check box is available only if you select the Detail by Asset option in the Report Option group box. If you choose Asset /Item No as the sort option, this check box is disabled. If you want to use most of the same report selection parameters but want to run a slightly different report, you can use Copy Record to copy the parameters and make minor changes to them without changing your saved parameters. To use Copy Record, open the record you want to duplicate through Query (F11), select the record that you want to duplicate, and then go to the Line menu and select Copy Record (or press CTRL+E). The system makes a copy of the parameters, which you can edit and save as desired.