Use the Print Schedule of Accum Depr Activity screen to print the accumulated depreciation account activity from a selected beginning point in time to a selected ending point in time. This report includes the beginning accumulated depreciation balance, additions, disposals, transfers, and the ending balance.
Some Costpoint Fixed Assets reports offer the additional option to print accumulated depreciation data by accumulated depreciation account code. This option is not available for this report. This report is an activity report, often requested by auditors to justify the changes to these accounts, and printing by POA is an effective approach.
On this report, you can print accumulated depreciation data for the G/L Book and all optional books. You can only print this report for one book at a time, however.
You can print a detail report that prints data asset-by-asset or a summary report that rolls all asset data up to accumulated depreciation account/org/proj, as applicable, per the selection parameters. You can also print the data for asset/item numbers, accumulated depreciation accounts, organizations, and/or projects, and fiscal years and periods. You can sort by account, by organization, by project, by account/org, by org/account, or by asset no/item no. You can also use the page break option for all sorts other than by asset/item number.
Because the accumulated depreciation accounts apply only to depreciable records, depreciable records are automatically included in the selection (and you cannot print data for depreciable and/or non-depreciable assets). You can, however, print data for active records, inactive records, and/or disposals.
If you include disposals in the report, you can include data from manual disposal entries
You can also include the values in the Current Pd Depreciation field in Asset Master records in the Accum Depr ending balance because these values are normally included in the accumulated depreciation totals. Use this option to run this report even after depreciation has been calculated, but not posted.
You can capture changes to accumulated depreciation components (FYTD Depreciation and Prior FY Depreciation) made manually in Asset Master records or via global functionality in the Asset Audit Log if you have enabled this function for these fields in the Asset/Template Change Settings screen.
You can include changes to the accumulated depreciation fields as positive or negative values in the Additions column on the report (for both posted and unposted transfers).
This report prints in landscape mode. Because all the data fields already exist in decimal format, you cannot print the data on the report in whole (rounded) numbers.
To remind you that this report may not include the all the transfer data you expect, the system displays the following "soft" warning message under certain circumstances:
Transfer data may be missing from this report because you have not enabled the ability to track transfers of accumulated depreciation account codes in the Asset/Template Change Settings screen.
Because data for this report can be retrieved and computed for historical fiscal years/periods, you can print this report whenever necessary to assist you in reconciling the accumulated depreciation accounts in Costpoint General Ledger to the balances in Costpoint Fixed Assets or in re-creating the activity in your accumulated depreciation accounts.
Use the options 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 without individual asset/item number data.
If this radio button is selected, you cannot select records by asset/item number. In addition, you cannot access the Asset No/Item No radio button or the Page Break checkbox in the Sort By group box.
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 data by individual asset/item number.
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 this drop-down box to select the desired book for which to print accumulated depreciation account activity information. Although you can only select one book at a time, you can print this report for any book.
"G/L Book" is the default for the drop-down box. The drop-down box also includes the labels that you assigned to each optional book during initialization in the Fixed Assets Settings screen, as applicable.
If you save the report parameter selections, the selected book number will be identified in the Query table in the Select Book column.
Use the fields in this group box to select the asset/item number(s) for which to print asset activity data. 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.
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 "All."
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 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 asset/item numbers for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field 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 From Item No columns.
Enter the ending 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 asset/item numbers for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field 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 To Asset No and To Item Number columns.
Use the required fields in this group box to select records for the report from a specified beginning fiscal year and period to an ending fiscal year and period.
The Fiscal Year drop-down boxes display only those fiscal years already set up in the Maintain FA Fiscal Years screen in descending order, beginning with the latest fiscal year. Because the displays in the Fiscal Year drop-down boxes are standard Lookups to the FA_FY_INFO table in Fixed Assets, you may find that you have selected a fiscal year for which accumulated depreciation activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
The Period drop-down boxes display only those accounting periods already set up in the Maintain FA Accounting Periods screen for the fiscal year specified in the corresponding Fiscal Year drop-down box. Because the displays in the Period drop-down boxes are standard Lookups to the FA_PD_INFO table in Fixed Assets, you may find that you have selected a period for which accumulated depreciation activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
Enter the beginning desired fiscal year and period from the drop-down box in each field.
If you save the print parameters for this report, the selected From values will be identified in the Query table in the From Fiscal Year and From Period columns.
Enter the ending desired fiscal year and period from the drop-down box in each field.
If you save the print parameters for this report, the selected To values will be identified in the Query table in the To Fiscal Year and To Period columns.
Use this group box to select records for the report from one asset ("ownership") account, a range of asset ("ownership") accounts, or all asset ("ownership") accounts. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
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 print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Account Range column.
Enter the beginning asset ("ownership") account number in this field or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Account column.
Enter the ending asset ("ownership") account number or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Account column.
Use this group box to select records for the report from one asset ("ownership") organization, a range of asset ("ownership") organizations, or all asset ("ownership") organizations. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
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 print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Organization Range column.
Enter the beginning ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Organization column.
Enter the ending ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Organization column.
Use this group box to select records for the report from one asset ("ownership") project, a range of asset ("ownership") projects, or all asset ("ownership") projects, as applicable. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
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 print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Project Range column.
Enter the beginning ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Project column.
Enter the ending ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which accumulated depreciation activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Project column.
In this group box, you can determine how the system organizes the data for the report and whether you want a page break in the report each time the selected sort parameter changes.
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 accumulated depreciation account.
If you save the print parameters for this report, this sort option will be identified as "A" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by accumulated depreciation organization.
If you save the print parameters for this report, this sort option will be identified as "O" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by accumulated depreciation project.
If you save the print parameters for this report, this sort option will be identified as "P" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by accumulated depreciation account/organization.
If you save the print parameters for this report, this sort option will be identified as "AO" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by accumulated depreciation organization/account.
If you save the print parameters for this report, this sort option will be identified as "OA" in the Sort By column in the Query table.
This radio button is unchecked by default. This radio button is available only if you have 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 save the print parameters for this report, this sort option will be identified as "AI" in the Sort By column in the Query table.
This checkbox is unchecked by default and will be available only if you selected a Detail by Asset report. 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, select the Page Break checkbox if you want the data for each different account to begin printing on a separate page. If you choose Asset No/Item No as 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.
Use the checkboxes in this group box to choose the record status type(s) to include in your report selection criteria. You can include active records, inactive records, and/or disposals. You must select at least one checkbox in this group box.
This checkbox is selected by default. Select this checkbox to include active records in the report selection criteria. If this checkbox is unchecked, the system automatically excludes all active records.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Select Active Records column in the Query table.
Select this checkbox to include inactive records in the report selection criteria. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all inactive records.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Include Inactive Records column in the Query table.
This checkbox is selected by default. Select this checkbox to include disposals in the report selection criteria. If this checkbox is unchecked, the system automatically excludes all disposals.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Include Disposal Records column in the Query table.
Select this pushbutton to display additional selection parameters for this report.