Use this report to print a "real-time" snapshot of comparative Asset Master depreciation-related values for one book, a range of books, or all books. You can select up to 14 different types of depreciation data from the G/L Book Info and Other Books Info Asset Master screens to compare in side-by-side columns for each book.
You can print a detail report that prints data asset-by-asset for all data selection fields, or a summary report.
If you select a summary report, you can compare the following values:
Total Cost
Salvage Value
Amount to Depreciate
Prior FY Depreciation
FYTD Depreciation
Current Pd Depreciation
Accum Depreciation
Book Value
If you select a detail report (asset-by-asset data), you can compare values from the list above as well as the following six additional values:
Auto Calc (Y/N)
Depr Method Code
Depr Start Date
Current Depr Year
Days/Pds Remaining
Amt Taken PYTD
You can print the data for a range of (including one), or all, asset/item numbers, asset ("ownership") accounts, organizations, and/or projects. Use additional selection criteria to print project subtotals and to include the current period depreciation expense amount in the totals displayed when the selected field is either the Accum Depr or the Book Value column. You can sort by account, by organization, by account/org, or by asset/item no. You can also use a page break option for all sorts other than by asset/item number.
The report prints data only for depreciable assets, but you can also print data for Active records, Inactive records, and/or Disposals.
This report is designed to emulate spreadsheets that print comparative data in an easy-to-read format using side-by-side columns in landscape mode on regular-sized paper (8½ x 11). You can print the data for six books on a single page. If you use additional optional books, the additional book columns will print on a second report page.
Because the majority of options for the report already exist in decimal format, you cannot print the data values on the report in whole (rounded) numbers.
You can print this report at any time. Comparative depreciation-related data prints on a "real-time" basis exactly as the data exists in your Asset Master records at the time you run the report.
Use the radio buttons in this group box to specify 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 that does not include individual asset/item number data. The following data will not be available for comparison if you select a summary report:
Auto Calc (Y/N)
Depr Method Code
Depr Start Date
Current Depr Year
Days/Pds Remaining
Amt Taken PYTD
If you select this radio button and save the print parameters for this report, "S" will be inserted into the Report Option column in the Query table.
Select this radio button to print a detailed report that includes individual asset/item number data.
If you select this radio button and save the print parameters for this report, "D" will be inserted into the Report Option column in the Query table.
Use the options in this group box to select the books for which data will be printed on the report. You can select any number of books for the report. Data for up to six books can print on the first report page. If you use additional books, the additional book columns will be printed on a second report page.
You must select at least one checkbox in this group box. Although this report is designed as a comparative report, which implies at least two sets of data (each for a different book), note that you can print the selected data for a single book.
This checkbox is selected by default.
Select this checkbox to print data for the General Ledger book for the selected depreciation-related field.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the G/L Book column in the Query table.
Select this checkbox to print data for this book for the selected depreciation-related field. This checkbox is unchecked by default.
This checkbox is disabled if the book has not been set up in the Fixed Assets Settings screen. If the book is already established in the Fixed Assets Settings screen, the book name that you assigned during setup automatically displays in place of the generic "Book 2" label.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Book 2 (or your label) column in the Query table.
Please refer to the documentation for the Book 2 (or your label) checkbox.
Select the desired Asset Master depreciation-related field(s) for which to print data on the report in this group box.
You must select at least one checkbox. No checkbox is selected by default. You can select as many checkboxes as desired, but each field will print on a new report page.
Select this checkbox to print comparative cost data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Total Cost field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Total Cost Amt column of the Maintain Asset Cost Info screen and in the G/L Book Total Cost column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Total Cost column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Total Cost column of the Maintain Asset Other Books Info screen and in the Total Cost Amt column of the Maintain Asset Cost Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Total Cost column in the Query table.
Select this checkbox to print comparative salvage value data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Salvage Value field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Salvage Value column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Salvage Value column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Salvage Value column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Salvage Value column in the Query table.
Select this checkbox to print comparative amount to depreciate data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Amount to Depreciate field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Amt to Depreciate column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Amount to Depreciate column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Amt to Depreciate column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Amt to Depreciate column in the Query table.
Select this checkbox to print comparative fiscal year-to-date depreciation data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the FYTD Depreciation field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book FYTD Depreciation column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the FYTD Depreciation column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) FYTD Depreciation column of the Maintain Asset Other Books Info screen
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the FYTD Depreciation column in the Query table.
Select this checkbox to print comparative prior fiscal year depreciation data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Prior FY Depreciation field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Prior FY Depreciation column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Prior FY Depreciation column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Prior FY Depreciation column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Prior FY Depr column in the Query table.
Select this checkbox to print comparative current period depreciation data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Current Pd Depreciation field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Current Pd Depreciation column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Current Pd Depreciation column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Current Pd Depreciation column of the Maintain Asset Other Books Info screen
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Current Pd Depr column in the Query table.
Select this checkbox to print comparative cost data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Accum Depreciation field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Accum Depreciation column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Accum Depreciation column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Accum Depreciation column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Accum Depr column in the Query table.
Select this checkbox to print comparative book value for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Book Value field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Book Value column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Book Value column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Book Value column of the Maintain Asset Other Books Info screen.
If you selected this checkbox and save the print parameters for this report, "Y" will be inserted into the Book Value column in the Query table.
Select this checkbox to print comparative auto calc flag data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the data from the Auto Calculate Depreciation checkbox in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Auto Calc column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the data from the Auto Calc Depr (Y/N) column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same data also displays in the Book x (or your label) Auto Calc column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Auto Calc Y/N column in the Query table.
Select this checkbox to print comparative depreciation method code data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the data from the Depr Method Code field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Depr Method Code column of the Maintain Asset G/L Book screen.
If you have selected checkboxes for optional books 2-10, the report prints the data from the Depr Mthd Code field in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same data also displays in the Book x (or your label) Depr Method Code column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Depr Method Code column in the Query table.
Select this checkbox to print comparative depreciation start date data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the data from the Depr Start Date field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Depr Start Date column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the data from the Depr Start Date column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same data also displays in the Book x (or your label) Depr Start Date column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Depr Start Date column in the Query table.
Select this checkbox to print comparative current depreciation year data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the data from the Curr Depr Yr field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same data also displays in the G/L Book Curr Depr Yr column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the data from the Current Depr Year column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same data also displays in the Book x (or your label) Curr Depr Yr column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Current Pd Depr column in the Query table.
Select this checkbox to print comparative days/periods remaining data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the data from the Days/Pds Remaining field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Days/Pds Remaining column of the Maintain Asset Cost Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the data from the Days/Pds Remaining column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same data also displays in the Book x (or your label) Days/Pds Remaining column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Days/Pds Rem column in the Query table.
Select this checkbox to print comparative amount taken purchase year-to-date data for the selected book(s).
If you have selected the G/L Book checkbox, the report prints the value from the Amt Taken Purchase YTD field in the G/L Book Info subtasks of the Maintain Asset Master Info screen. The same value also displays in the G/L Book Amt Taken Purchase YTD column of the Maintain Asset G/L Book Info screen.
If you have selected checkboxes for optional books 2-10, the report prints the value from the Amount Taken Purchase YTD column in the Other Books Info subtask of the Maintain Asset Master Info screen, as applicable. For each applicable book, the same value also displays in the Book x (or your label) Amt Taken Purchase YTD column of the Maintain Asset Other Books Info screen.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Amt Taken PYTD column in the Query table.
Use the fields in this group box to select the asset/item number(s) for which to print comparative depreciation-related book data. The fields in this group box are available only if you selected the Detail by Asset radio button in the Report Option group box.
If you enter an asset number, you must also enter a corresponding item number.
Use this drop-down box to select a range option. Options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "Range."
If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset/Item Number Range Option column.
Enter the beginning asset/item number for the range option or use Lookup to select one. 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 does 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 Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected From values, as applicable, will be identified in the Query table in the From Asset No and To Asset Number columns.
Enter the ending asset/item number for the Range Option or use Lookup to select one. 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 does 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 Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected To values, as applicable, will be identified in the Query table in the From Item No and To Item Number columns.
In this group box, you can select the way the system organizes the data for the report. Note, however, that 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.)
This radio button is selected by default. Select this radio button to sort the report by asset ("ownership") account.
If you select this radio button and save the print parameters for this report, "A" will be inserted into the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") organization.
If you select this radio button and save the print parameters for this report, "O" will be inserted into the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") account/organization.
If you select this radio button and save the print parameters for this report, "AO" will be inserted into the Sort By column in the Query table.
This radio button is unchecked by default. This radio button is available only if you selected the Detail by Asset radio button in the Report Option group box.
Select this radio button 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 checkbox is also unavailable.
If you select this radio button and save the print parameters for this report, "AI" will be inserted into the Sort By column in the Query table.
Use this group box to select page break and project total options.
This checkbox is unchecked by default. Select this checkbox 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 checkbox if you want the data for each different account to begin printing on a separate page. If you choose the Asset/Item No radio button for the sort option, this checkbox is disabled.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Page Break column in the Query table.
This checkbox is unchecked by default. Select this checkbox to print subtotals by project for the posted depreciation expense data.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Project Subtotals column in the Query table.
This checkbox is selected by default. If you want to include current period depreciation in the Accum Depreciation value displayed on the report, leave this checkbox selected.
If you clear this checkbox, 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 total.
Select this checkbox to obtain useful values from the report whenever you run the report, both before and after you have computed depreciation.
Select this pushbutton to display additional selection parameters for this report.