PRINT DEPRECIATION COMPONENT INFORMATION BY BOOK REPORT

Use this report to print a snapshot of depreciation-related values in Asset Master records on a real-time basis, as the data currently exists, at any time. You can select one or more specific column values to print on the report (up to a maximum of eight) and select the column position on the page for the following data:

You can print data for all books, but you can select data only for a single book at a time. Data for each book displays on a different report page. You can print a summary report or a detail report that prints data asset-by-asset. You can print the data for any range of depreciation expense account allocation codes, asset/item numbers, asset accounts, organizations, and/or projects and/or depreciation expense accounts, organizations, and/or projects.

Use additional selection criteria to print project subtotals and to include the current period depreciation expense amount in the total displayed in the accumulated depreciation column. If you print a detail report, you can also print the Accumulated Depreciation Account Codes on the report. Sort options include by account, by organization, by account/organization, by accumulated depreciation account code, or by asset/item number. You can also use a page break option for all sorts other than by asset/item number.

You can also print data for active records, inactive records, disposals, depreciable records, and/or non-depreciable records. (For non-depreciable records, only the Total Cost column values are applicable.)

This report is designed to emulate spreadsheets that print depreciation component data in an easy-to-read format using side-by-side columns. You can print it only on legal-sized paper.

You can print this report at any time. Depreciation–related component data prints on a "real-time" basis exactly as the data exists in your Asset Master records at the time you run the report.

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.

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.

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.

Option

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.

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.

Option

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.

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.

Option

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.

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.

Option

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.

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.

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

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.

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.

Prior FY Depr — If you select this value, the system will display the Prior FY Depreciation amount from Asset Master records on the report for the selected book. If the Prior FY Depreciation value is zero, "0.00" will display on the report.

If you select the G/L Book, the report prints the value from the Prior FY Depreciation field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Prior FY Depreciation 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 Prior FY Depreciation 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) Prior FY Depreciation column of the Manage Asset Other Books Information screen.

FYTD Depr — If you select this value, the system will display the FYTD Depreciation amount from Asset Master records on the report for the selected book. If the FYTD depreciation value is zero, "0.00" will display on the report.

If you select G/L Book, the report prints the value from the FYTD Depreciation field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the FYTD Depreciation 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 FYTD Depreciation 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) FYTD Depreciation column of the Manage Asset Other Books Information screen.

Current Pd Depr — If you select this value, the system will display the Current Pd Depreciation amount from Asset Master records on the report for the selected book. If the Current Pd Depreciation value is zero, "0.00" will display on the report.

If you select G/L Book, the report prints the value from the Current Pd Depreciation field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Curr Pd Depreciation 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 Current Pd Depreciation 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) Current Pd Depreciation column of the Manage Asset Other Books Information screen.

Accum Depr — If you select this value, the system will display the Accumulated Depreciation amount from Asset Master records on the report for the selected book. If the Accumulated Depreciation value is zero, "0.00" will display on the report.

If you select the Include Current Pd Depr Exp Amt in Accum Depr Column check box in the Accumulated Depreciation Total Option group box, the total amounts displayed on the report for accumulated depreciation will be identical to those displayed in the corresponding Asset Master record.

If the Include Current Pd Depr Exp Amt in Accum Depr Column check box is clear, the accumulated depreciation total will include 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.

If you select G/L Book, the report prints the value from the Accum Depreciation field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Accum Depreciation 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 Accum Depreciation 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) Accum Depreciation column of the Manage Asset Other Books Information screen.

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

If you select the Include Current Pd Depr Exp Amt in Accum Depr Column check box in the Accumulated Depreciation Total Option group box, the total amounts displayed on the report for book value will be identical to those displayed in the corresponding Asset Master record.

If you select G/L Book, the report prints the value from the Book Value field in the G/L Book Info tab of the Manage Asset Master Information screen. The same value also displays in the Book Value 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 Book Value 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) Book Value column of the Manage Asset Other Books Information screen.

None — If you select this option for the column, the system will suppress the display of this column. Neither the header nor "0.00" will display on the report. The system displays the space occupied by the column position as blanks.

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.

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.

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

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.

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.

1st Sort

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

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.