Contents of the Print Sequential Other Books Depreciation History RPT Screen

Use the fields and options to configure the Print Sequential Other Books Depreciation History RPT screen.

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.

Note: For the G/L Book, posted data is automatically written to the FA_POSTING_DETL table when you run the Post Fixed Assets Journal process. You can print this data from the Print Sequential Posted Depreciation History Report screen.

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

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

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

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

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

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

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

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

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

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

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