PRINT SEQUENTIAL OTHER BOOKS DEPRECIATION HISTORY RPT
Use this screen to print historical depreciation expense data for optional books 2 to 10 for any closed fiscal year/period. This data is automatically written to the Other Books Depreciation History table when you run the Close Fixed Assets Accounting Period process. Disposal data, depreciation adjustment data associated with disposals, and transfer data are also written to this table during the Close process.
Location
You can print a summary report or a detail report that prints data asset-by-asset. You can print data for all optional books, but only for a single book at a time. You can print data for a range of items (including just one) or all items, including asset/item numbers, asset accounts, organizations, and/or projects and/or fiscal years/periods. Use additional selection criteria to print project subtotals, to print data by accounting period, and to display amounts as whole numbers. Sort options include by account, by organization, by account/org, or by asset no/item no. You can use the page break option for sorts other than by asset/item number.
This report is designed to print historical depreciation data in an easy-to-read spreadsheet format using side-by-side columns. As such, you can print it only on legal-sized paper. Eleven data columns can print per report page using the full decimal values from the Other Books Depreciation History table. If you print the values in whole (rounded) numbers for the report, however, 14 data columns can print per report page.
You can print this report at any time. Historical data for previously closed periods is captured and stored in the Other Books Depreciation History table. As a result, historical depreciation data can be retrieved at will.
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 define the selection parameters by which the other books historical depreciation expense data should be reported. You can select records by asset ("ownership") account/organization/project, by depreciation expense account/organization/ project, or by depreciation expense account allocation code.
Asset Account/Organization/Project
This option is selected by default. Select this option to choose report parameters by asset ("ownership") account/organization/project for the other books historical depreciation expense data.
Depr Exp Account/Organization/Project
Select this option to choose report parameters by depreciation expense account/organization/project for the other books historical depreciation expense data.
Depr Exp Account Allocation Code
Select this option to choose report parameters by depreciation expense account allocation code for the other books historical depreciation expense data.
Report Type
Use the options in this group box to choose 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
This option is selected by default. Select this option to print a summary report without individual asset/item number data.
If you select this option, asset/item numbers are neither available as selection criteria nor as a sort option.
Detail by Asset
Select this option to print a detailed report that includes individual asset/item number data.
If you select this option, the Asset/Item Number group box is enabled, and you can select the Asset No/Item No option in the 1st Sort drop-down list.
Selection Ranges
Asset/Item Number
Use the following fields to select a range of asset/item numbers for the report. If you enter a specific asset number, you must also enter a corresponding item number. The fields in this group box are available only if you have selected the Detail by Asset option in the Report Type group box.
Option
The default selection for this drop-down list is All. 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 asset/item number for the range option. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset and/or item number from the Lookup that does not meet your other selection criteria.
If you select All or From Beginning in the Option field, these fields will be inactive.
End
Enter, or click to select, the ending asset/item number for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset and/or item number from the Lookup that does not meet your other selection criteria.
If you select All, One, or To End in the Option field, these fields will be inactive.
Closed Time Periods
Use the following fields to select records for the report from a specified beginning fiscal year and period to an ending fiscal year and period.
You can only select values in the Fiscal Year fields those that are already set up on the Manage Fixed Assets Fiscal Years screen. Because the display in the Fiscal Year fields is a standard Lookup to the FA_FY_INFO table in Fixed Assets, you may find that you have selected a fiscal year for which historical depreciation expense data for other books do not exist.
The Period fields display only those accounting periods already set up on the Manage Fixed Assets Accounting Periods screen for the fiscal year specified in the Fiscal Year field. Because the display in the Period field is a standard Lookup to the FA_PD_INFO table, you may find that you have selected a period for which historical depreciation expense data for other books do not exist.
Option
You cannot edit this field.
Start
Enter, or click to select, the beginning desired fiscal year and period in each field.
End
Enter, or click to select, the ending desired fiscal year and period from the drop-down lists in each field.
Accounts or Codes
Use the following fields to select records for the report from one asset account or code, a range of, or all asset accounts or codes, as applicable. The asset "ownership" account and depreciation expense account (linked via the depreciation expense account allocation code) are each required for all Asset Master records.
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, you will select the desired asset ("ownership") account(s). Because the standard Lookup for the account is to the ACCT table, you may find that you have selected an account from the lookup for which other books depreciation history data do not exist or meet your other selection criteria. In this event, the data you expect to retrieve from the FA_DEPR_HS table may not be selected.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, you will select the desired depreciation expense account(s). Because the standard Lookup for the account is to the ACCT table, you may find that you have selected an account from the lookup for which other books depreciation history data do not exist or meet your other selection criteria. In this event, the data you expect to retrieve from the FA_DEPR_HS table may not be selected.
-
If you have select the Depr Exp Account Allocation Code option in the Select Records By group box, you will select the desired depreciation expense account allocation code(s), which contain the depreciation expense account/org/proj data. Because the standard lookup for the account is to the DEPR_EXP_ALLOC_CD table, you may find that you have selected a code from the lookup for which other books depreciation history data do not exist or meet your other selection criteria. In this event, the data you expect to retrieve from the FA_DEPR_HS table may not be selected.
Option
The default option for this field is All. You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning account number or code in this field, as applicable.
-
If you select either the Asset Account/Organization/Project or the Depr Exp Account/Organization/Project option in the Select Records By group box, enter, or click to select, the beginning account number in this field.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, enter, or click to select, the desired depreciation expense account allocation code. (The system will select other books depreciation history data within the parameters of your other selection criteria for the account(s) that you linked with your depreciation expense account allocation code(s) during initialization.)
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 number or code in this field, as applicable.
-
If you select either the Asset Account/Organization/Project or the Depr Exp Account/Organization/Project option in the Select Records By group box, enter, or click to select, the ending account number in this field.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, enter, or click to select, the desired depreciation expense account allocation code. (The system will select other books depreciation history data within the parameters of your other selection criteria for the account(s) that you linked with your depreciation expense account allocation code(s) during initialization.)
If you select All, One, or To End in the Option field, this field will be inactive.
Organizations
Use the following fields to select records for the report from a range of organizations. The asset organization denotes "ownership" and is required for each Asset Master record.
Option
The default option for this field is All. You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down list. Options available are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning asset organization account for the range option, as applicable. Because this is a standard Lookup to the ORG table, you may find that you have selected an asset organization that does not meet your other selection criteria.
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 organization for the range option, as applicable. Because this is a standard Lookup to the ORG table, you may find that you have selected an asset organization that does not meet your other selection criteria.
If you select All, One, or To End in the Option field, this field will be inactive.
Projects
Use the following fields to select records for the report from a range of asset projects. The asset project denotes "ownership" and is optional for each Asset Master record.
Option
The default option for this field is All. You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down list. Options available are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning asset project for the range option, as applicable. Because this is a standard Lookup to the PROJ table, you may find that you have selected an asset project that does not meet your other selection criteria.
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 project for the range option, as applicable. Because this is a standard Lookup to the PROJ table, you may find that you have selected an asset project that does not meet your other selection criteria.
If you select All, One, or To End in the Option field, this field will be inactive.
Book No
Use this field to select the desired optional book for which to print depreciation component information. Although you can select only one book at a time, you can print this report for any book other than the G/L Book.
There is no default selection for this field. The lookup in this field displays the labels that you assigned to each optional book during initialization on the Configure Fixed Assets Settings screen.
Option
You cannot edit this field.
Start
Enter, or click to select, the desired book.
Options
Print
Use the options in this group box to control print display preferences for the report.
Period Data
Select this check box to print the other books depreciation history data by accounting period for the selected fiscal year(s).
Depreciation Expense Acct Alloc Codes
Select this check box to print the depreciation expense account allocation code data in the Depr Exp Acct Alloc Code column.
You can select this check box only if you run a Detail by Asset report.
Project Subtotals
Select this check box to print subtotals by project for the other books depreciation history data.
Amounts as Whole Numbers
Select this check box to print depreciation expense amounts on the report in whole numbers, without decimals.
If you display dollars in whole numbers only, data for 13 accounting periods plus a total column (14 total columns) can display on a single report page. If you have more than 13 periods in your fiscal year, the additional columns will print on a second report page.
Do not select this check box if you want the report to display amounts in dollars and cents. If you select this option, data for only 11 columns can print on the first report page (because columns are wider to accommodate the decimals), and additional data will print on a second report page.
Sort By
Use this group box to choose the way the system organizes the data for the report.
1st Sort
Select the sort option from the drop-down list. The available options are:
-
Account — This options is selected by default. Select this to sort the data in the report by asset account.
-
Organization — Select this to sort data in the report by asset organization.
-
Account/Org — Select this to sort data in the report by asset account/organization combination.
-
Asset No/Item No — This option is available only if you select the Detail by Asset option in the Report Type group box. Select this option to sort the data in the report by asset/item number.
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 sort the data by account, select the Page Break check box if you want the data for each different account to begin printing on a separate page. If you choose the Asset No/Item No as the sort option, this check box will be disabled.