Use this screen to calculate depreciation expense for future fiscal years/periods for currently owned assets and/or projected purchases, by book. You can select records for inclusion by depreciation expense account allocation code or by specific depreciation expense account/organization/project. You can additionally select one asset/item number, a range of asset/item numbers, or all asset/item numbers for the calculation. The methodology for projected depreciation calculations is the same as for current period depreciation. The same type of validations and data requirements exists for both types of calculations. Please refer to Special Topic FA-4, "Calculate Depreciation," for additional information.
Once calculations have occurred, you can view the results in the Projected Depreciation Expense Inquiry table window. (This screen employs Subquery to display a user-selected subset of the computed data, and no user edits are permitted.)
You can print the results using a variety of selection criteria by running the Print Projected Depreciation Expense Report.
You can also enter estimated future asset purchases in the Maintain Projected Asset Purchases screen and include these in the Compute Projected Depreciation process run from this screen, as desired. In addition, you can enter estimated disposals of currently owned assets in advance of their stated useful life and include these in the Compute Projected Depreciation process run from this screen, as desired.
You can compute projected depreciation at any time. To maximize calculation efficiencies when you have large numbers of assets, books, and/or fiscal years/periods for which future depreciation is to be re-calculated, you can select one of two computation options:
You can clear all previously computed projected depreciation from the permanent table and replace it with entirely new data when a new computation is executed from this screen.
For this option, you should make sure that the Clear all existing data from this table prior to computing checkbox is checked (the default condition).
You can replace only existing table data with new calculation data and/or insert new calculation data that did not previously exist into the permanent table.
If a significant portion of your projected depreciation data was previously computed and the selection criteria for this computation is not significantly different from the previous calculation, this option may reduce the system calculation time.
For this option, you should make sure that the Clear all existing data from this table prior to computing checkbox is unchecked.
If you compute future depreciation for projected purchases, you should first enter estimated future purchases in the Maintain Projected Asset Purchases screen before running this process.
If you plan to compute future depreciation for currently owned assets that will be disposed of in advance of their stated useful life, you should first enter estimated future disposals in the Maintain Projected Asset Disposals screen before running this process.
Use the selections in this group box to choose whether to run the projected depreciation expense computation for currently owned assets, projected asset purchases, or both.
Select this checkbox to compute projected depreciation expense for currently owned assets. This checkbox is selected by default.
If you select this checkbox and save the selection parameters for this process, "Y" will be stored in the Compute for Owned Assets column in the Query table.
Select this checkbox to compute projected depreciation expense for projected purchases. This checkbox is unselected by default. If you compute future depreciation for projected purchases, you should first enter estimated future purchases in the Maintain Projected Asset Purchases screen before running this process.
If you select this checkbox and save the selection parameters for this process, "Y" will be stored in the Compute for Projected Purchases column in the Query table.
Use the options in this group box to choose the depreciation expense selection parameters. You can compute by either depreciation expense account/organization/project parameters OR by depreciation expense account allocation code parameters.
This radio button is selected by default. Select this radio button to select compute parameters by depreciation expense account, depreciation expense organization, and, optionally, depreciation expense project.
If you select this radio button and save the compute parameters for this process, "ID" will be stored in the Select Depr Exp Accts By column in the Query table.
Select this radio button to enable the selection of compute parameters by depreciation expense account allocation code. If you select this radio button, fields in both the Select Depr Exp Organizations group box and the Select Depr Exp Projects group box will be disabled.
If you select this radio button and save the compute parameters for this process, "CD" will be stored in the Select Depr Exp Accts column in the Query table.
Use this group box to select depreciation expense accounts or depreciation expense account allocation codes, as applicable, for the computation.
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 selection parameters for this process, the selected Range Option, as applicable, will be stored in the Query table in the Depr Exp Acct ID Range column or the Depr Exp Acct Codes Range column, as applicable.
Enter, or use Lookup to select, the beginning depreciation expense account or the beginning depreciation expense account allocation code (depending on which radio button you selected in the Select By group box). Because this is a standard Lookup to the ACCT table or the DEPR_EXP_ALLOC_CD table, as applicable, you may find that you have selected accounts or codes for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field is unavailable.
If you save the selection parameters for this process, the selected From value, as applicable, will be stored in the Query table in the Depr Exp Accts From or the Depr Exp Codes From column, as applicable.
Enter, or use Lookup to select, the ending depreciation expense account or the ending depreciation expense account allocation code (depending on which radio button you selected in the Select By group box). Because this is a standard Lookup to the ACCT table or the DEPR_EXP_ALLOC_CD table, as applicable, you may find that you have selected accounts or codes for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field is unavailable.
If you save the selection parameters for this process, the selected To value, as applicable, will be stored in the Query table in the Depr Exp Accts To or the Depr Exp Codes To column, as applicable.
Use the fields in this group box to select organizations for the computation.
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 selection parameters for this process, the selected Range Option, as applicable, will be stored in the Query table in the Depr Exp Organizations Range column.
Enter, or use Lookup to select, the beginning organization. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field is unavailable.
If you save the selection parameters for this process, the selected From value, as applicable, will be stored in the Query table in the Depr Exp Organizations From column.
Enter, or use Lookup to select, the ending organization. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field is unavailable.
If you save the selection parameters for this process, the selected To value, as applicable, will be stored in the Query table in the Depr Exp Organizations To column.
Use this group box to select projects for the computation.
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 selection parameters for this process, the selected Range Option, as applicable, will be stored in the Query table in the Depr Exp Projects Range column.
Enter, or use Lookup to select, the beginning project. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for 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 selection parameters for this process, the selected From value, as applicable, will be stored in the Query table in the Depr Exp Projects From column.
Enter, or use Lookup to select, the ending project. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset data does not exist or does not meet your selection criteria. In this event, the assets you expect to compute projected depreciation for 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 selection parameters for this process, the selected To value, as applicable, will be stored in the Query table in the Depr Exp Projects To column.
Use this group box to select the future fiscal years for the projected depreciation computation.
The fiscal years available for selection include only those fiscal years already set up in the Maintain FA Fiscal Years screen. If you need to compute projected depreciation for future fiscal years that are not displayed in the drop-down box, you must exit this screen and establish the additional fiscal years and period data in the Maintain FA Fiscal Years and Maintain FA Accounting Periods screens.
Select from the drop-down box the beginning future fiscal year for which projected depreciation should be computed. The available fiscal years display in descending order, beginning with the latest fiscal year from the Maintain FA Fiscal Years screen
If you save the selection parameters for this process, the selected From value, as applicable, will be stored in the Query table in the Project FY From column.
Select from the drop-down box the ending future fiscal year for which projected depreciation should be computed. The available fiscal years display in descending order, beginning with the latest fiscal year from the Maintain FA Fiscal Years screen.
If you save the selection parameters for this process, the selected To value, as applicable, will be stored in the Query table in the Project FY To column.
Select this checkbox to include currently owned assets for which disposals are anticipated in advance of their stated useful life.
If you select this checkbox and save the selection parameters for this process, "Y" will display in the Include Projected Disposals column in the Query table.
Use the fields in this group box to select asset/item numbers for the computation. If you enter a specific asset number, you must also enter a corresponding item number before you can run the computation.
The default range option for this field is "All." You can accept the displayed default 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," and are standard throughout Costpoint.
If you save the selection parameters for this process, the selected Range Option, as applicable, will be stored in the Query table in the Asset/Item Range column.
Enter, or use Lookup to select, the beginning asset and item numbers for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers that do not meet your other selection criteria. In this event, the assets you expect to compute projected depreciation for 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 selection parameters for this process, the selected From value, as applicable, will be stored in the Query table in the Asset No From and Item No From columns.
Enter, or use Lookup to select, the ending asset and item number(s) for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers that do not meet your other selection criteria. In this event, the assets you expect to compute projected depreciation for 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 selection parameters for this process, the selected To value, as applicable, will be stored in the Query table in the Asset No To and Item No To columns.
Use the checkboxes in this group box to select each book for which you want to compute projected depreciation expense. Checkboxes for books that have not been set up in the Fixed Assets Settings screen are not available for selection.
Select this checkbox to compute projected depreciation for the General Ledger book. This checkbox is selected by default.
If you select this checkbox and save the selection parameters for this process, "Y" will display in the Select Book 1 column in the Query table.
Select this checkbox to compute projected depreciation for this book. This checkbox is unchecked by default. The system displays the label that you assigned to this optional book during initialization in the Fixed Assets Settings screen, as applicable. If you have not established this book in the Fixed Assets Settings screen, this checkbox and its label will be grayed out.
If you select this checkbox and save the selection parameters for this process, "Y" will display in the Select Book 2 column in the Query table.
Please refer to the documentation for the Book 2 (or your label) field.
Use the checkbox in this group box to maximize calculation efficiencies if you have large numbers of assets, books, and/or fiscal years/periods for which future depreciation is to be re-calculated.
To maximize calculation efficiencies when you have large numbers of assets, books, and/or fiscal years/periods for which future depreciation is to be re-calculated, you can select one of two computation options:
You can clear all previously computed projected depreciation from the permanent table and replace it with entirely new data when a new computation is executed from this screen.
For this option, you should make sure that this checkbox is checked (the default condition).
You can replace only existing table data with new calculation data and/or insert new calculation data that did not previously exist into the permanent table.
If a significant portion of your projected depreciation data was previously computed and the selection criteria for this computation is not significantly different from the previous calculation, this option may reduce the system calculation time.
For this option, make sure that this checkbox is unchecked. Specifically, use this checkbox to control the rules by which the system selects Asset Master records for re-computations if the calculations have previously been performed:
At time of calculation, if the value in the Current Pd Depreciation field (in the G/L Book Info and/or Other Book Info subtasks of the Maintain Asset Master Info screen) is equal to "0," the system will re-compute projected depreciation expense for the applicable book(s).
At time of calculation, if the value in the Current Pd Depreciation field (in the G/L Book Info and/or Other Book Info subtasks of the Maintain Asset Master Info screen) is NOT equal to "0"), the system will honor the existing value and will not re-compute projected depreciation expense for the applicable book(s).
Select this button on the toolbar to initiate the depreciation calculation process.
The system computes all eligible records and does not stop the process if there are errors. The system automatically creates and prints an error report when the compute process is complete. (You cannot view this report with Preview.)
"No errors found" will display on the report if no errors are encountered during the computation.
If you cannot compute depreciation because of specific circumstances, the error report will display the specific error message along with the asset/item(s) to which it applies, as follows:
"Unable to count number of fiscal years from depr start date to current period."
The system generates this message if there is a database error. Check with your database administrator to resolve this type of error.
"There is no fiscal year setup which contains this depreciation start date."
The system generates this message when there is insufficient data to perform the calculation. In this circumstance, you can add the missing fiscal year data or edit the depreciation start date, as appropriate.
"A problem exists with depr yr no and fiscal year setup being referenced."
The system generates this message when fiscal year sequence numbers are missing or skipped in the numerical order. Contact Deltek Technical Support for assistance on how to correct this condition.
Once you have corrected the error condition, you can compute depreciation again for the error records, as desired.
The Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table stores the results of the computation performed from this screen.
You can use the Projected Depreciation Expense Inquiry screen to view the data from this table after computation.
You can print the data from this table by running the Print Projected Depreciation Expense Report using a variety of selection criteria.