Use this screen to print historical depreciation expense data for optional books 2-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.
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.
Use the radio buttons 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.
This radio button is selected by default. Select this radio button to choose report parameters by asset ("ownership") account/organization/project for the other books historical depreciation expense data.
If you select this radio button and save the print parameters for this report, "A" will display in the Select Records By column in the Query table.
Select this radio button to choose report parameters by depreciation expense account/organization/project for the other books historical depreciation expense data.
If you select this radio button and save the print parameters for this report, "D" will display in the Select Records By column in the Query table.
Select this radio button to choose report parameters by depreciation expense account allocation code for the other books historical depreciation expense data.
If you select this radio button and save the print parameters for this report, "C" will display in the Select Records By column in the Query table.
Use the radio buttons 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).
This radio button is selected by default. Select this radio button to print a summary report without individual asset/item number data.
If you select this radio button, asset/item numbers are neither available as selection criteria nor as a sort option.
If you select this radio button and save the print parameters for this report, "S" will display in the Report Option column in the Query table.
This radio button is unselected by default. Select this radio button to print a detailed report that includes individual asset/item number data.
If you select this radio button, the Select Asset/Item Numbers group box is enabled, as well as the Asset No/Item No radio button in the Sort by group box.
If you select this radio button and save the print parameters for this report, "D" will display in the Report Option column in the Query table.
Use this drop-down box 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 drop-down box. The drop-down selections display the labels that you assigned to each optional book during initialization in the Fixed Assets Settings screen.
If you save the report parameters for this report, the selected book number will display in the Select Book column in the Query table.
Use the fields in this group box 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 radio button in the Report Option group box.
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," and "To End."
If you save the report parameter selections, the selected range option, as applicable, will be stored in the Query table in the Asset Range Option column.
Enter the beginning asset/item number for the range option or use Lookup to select one. 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 Range Option field, these fields will be inactive.
If you save the report parameter selections, the selected "From" values, as applicable, will be stored in the Query table in the From Asset No and From Item No columns.
Enter the ending asset/item number for the range or use Lookup to select one. 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 Range Option field, these fields will be inactive.
If you save the report parameter selections, the selected "To" values, as applicable, will be stored in the Query table in the To Asset No and To Item No columns.
Use this group box 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 selected the Asset Acct/Org/Proj radio button 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 does not exist or does not 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 selected the Depr Exp Acct/Org/Proj radio button 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 does not exist or does not 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 selected the Depr Exp Acct Alloc Code radio button 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 does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_DEPR_HS table may not be selected.
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," and "To End."
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected range option will be stored in the Query table in the Account Range Option column.
Enter the beginning account number or code in this field, as applicable.
If you selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, enter the beginning account number in this field or use Lookup to select one.
If you selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box, enter the desired depreciation expense account allocation code or select one from the drop-down box. (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 Range Option field, this field will be inactive.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected From value, as applicable, will be stored in the Query table in the From Account column.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box and if you save the report parameter selections, the selected From value, as applicable, will be stored in the Query table in the From Depr Exp Alc Code column.
Enter the ending account number or code in this field, as applicable.
If you selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, enter the beginning account number in this field or use Lookup to select one.
If you selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box, enter the desired depreciation expense account allocation or select one from the drop-down box. (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 Range Option field, this field will be inactive.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected To value, as applicable, will be stored in the Query table in the To Account column.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box and if you save the report parameter selections, the selected To value, as applicable, will be stored in the Query table in the To Depr Exp Alc Code column.
Use the fields in this group box to select records for the report from a range of organizations. The asset organization denotes "ownership" and is required for each Asset Master record.
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," and "To End."
If you save the report parameter selections, the selected range option, as applicable, will be stored in the Query table in the Organization Range Option column.
Enter the beginning asset organization account for the range option, as applicable, or use Lookup to select one. 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 Range Option field, this field will be inactive.
If you save the report parameter selections, the selected "From" value, as applicable, will be stored in the Query table in the From Organization column.
Enter the ending asset organization for the range option, as applicable, or use Lookup to select one. 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 Range Option field, this field will be inactive.
If you save the report parameter selections, the selected "To" value, as applicable, will be stored in the Query table in the To Organization column.
Use this group box to select records for the report from a rang of asset projects. The asset project denotes "ownership" and is optional for each Asset Master record.
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," and "To End."
If you save the report parameter selections, the selected range option, as applicable, will be stored in the Query table in the Project Range Option column.
Enter the beginning asset project for the range option, as applicable, or use Lookup to select one. 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 Range Option field, this field will be inactive.
If you save the report parameter selections, the selected "From" value, as applicable, will be stored in the Query table in the From Project column.
Enter the ending asset account for the range option, as applicable, or use Lookup to select one. 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 Range Option field, this field will be inactive.
If you save the report parameter selections, the selected "To" value, as applicable, will be stored in the Query table in the From Project column.
Use this group box to choose the way the system organizes the data for the report.
This radio button is selected by default. Select this radio button to sort the data in the report by asset account.
If you select this radio button and save the print selection parameters for this report, "A" will display in the Sort By column in the Query table.
This radio button is unselected by default. Select this radio button to sort the data in the report by asset organization.
If you select this radio button and save the print selection parameters for this report, "O" will display in the Sort By column in the Query table.
This radio button is unselected by default. Select this radio button to sort the data in the report by asset account/organization combination.
If you select this radio button and save the print selection parameters for this report, "AO" will display in the Sort By column in the Query table.
This radio button is unselected by default. This radio button is available only if the Detail by Asset radio button is selected in the Report Option group box. Select this radio button to sort the data in the report by asset/item number.
If you select this radio button and save the print selection parameters for this report, "AI" will display in the Sort By column in the Query table.
Select this checkbox if you want a page break in the report each time the selected sort parameter changes. This checkbox is unchecked by default.
For example, if you sort the data by account, select the Page Break checkbox if you want the data for each different account to begin printing on a separate page. If you choose the Asset No/Item No radio button as the sort option, this checkbox will be disabled.
If you select this checkbox and save the print selection parameters for this report, "Y" will display in the Page Break column in the Query table.
Use the options in this group box to control print display preferences for the report.
Select this checkbox to print the other books depreciation history data by accounting period for the selected fiscal year(s). This checkbox is unchecked by default.
If you select this checkbox and save the print selection parameters for this report, "Y" will display in the Period Data column in the Query table.
Select this checkbox to print subtotals by project for the other books depreciation history data. This checkbox is unchecked by default.
If you select this checkbox and save the print selection parameters for this report, "Y" will display in the Show Amounts in Whole Numbers column in the Query table.
Use the options in this group box to control how the numerical data should display on the report.
Select this checkbox to print the depreciation expense account allocation code data in the Depr Exp Acct Alloc Code column. This checkbox is unchecked by default.
You can select this checkbox only if you run a Detail by Asset report.
If you select this checkbox and save the print selection parameters for this report, "Y" will display in the Show Depr Exp Acct Alloc Code column in the Query table.
This checkbox is unselected by default. Select this checkbox 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.
Select this pushbutton to display additional selection parameters for this report.