Use this screen to view the results of the calculation process run from the Compute Projected Depreciation screen. In the header of this screen, you can select a general subset of records to view, including the book number, the depreciation expense account and organization, and the fiscal year and accounting period.
Data displays in the table window when you select the Execute button on the toolbar. Once data displays in the table window, the Match button is enabled on the toolbar. If you select the Match button and then select the Execute button, the fields from the first row display in the screen header fields. Alternately, if you highlight a specific row in the table window, select the Match button, and then select the Execute button, the fields from the highlighted row will display in the screen header fields, and the columns will not be visible in the table window.
Use Subquery to choose more specific selection criteria or enter selection criteria in the screen fields. Data in the table window is non-editable.
You can view the results of computed projected depreciation at any time in this screen after you have run the Compute Projected Depreciation process. Data loaded into the table window remains until a new calculation is run. You should, therefore, always run the calculation from the Compute Projected Depreciation screen before viewing and printing data to be sure that you are accessing the most current data.
In the Compute Projected Depreciation screen you had the option to compute future depreciation for currently owned assets and/or projected asset purchases. If you chose to compute future depreciation for projected purchases, you should first enter estimated future purchases in the Maintain Projected Asset Purchases screen before running this process.
In the Compute Projected Depreciation screen you also had the option to compute future depreciation for currently owned assets that will be disposed of in advance of their stated useful life. If you selected the Currently Owned Assets checkbox, you should first enter estimated future disposals in the Maintain Projected Asset Disposals screen before running this process.
Select general parameters using the fields in the header of this screen, or use Subquery to select a more specific subset. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
If you do not enter data in this field or in any other header field in this screen, and you do not use Subquery, all available data will display in the table window.
Enter, or use Lookup to select, the book number of the data you want to view.
This field is optional. If you leave this field blank and you do not use Subquery, data for all books from the Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table will display in the table window, within the confines of your other selection parameters.
Lookup at this field displays information only for the books for which data has been written to the Projected Depreciation Expense table (FA_PRJTD_DEPR_EXP). If no data exists in the table, the system displays this message, "Nothing found in Lookup."
Enter, or use Lookup to select, the depreciation expense account of the data you want to view.
This field is optional. If you leave this field blank and you do not use Subquery, data for all depreciation expense accounts from the Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table will display in the table window, within the confines of your other selection parameters.
Lookup at this field displays information only for the accounts for which data has been written to the Projected Depreciation Expense table (FA_PRJTD_DEPR_EXP). If no data exists in the table, the system displays this message, "Nothing found in Lookup."
Enter, or use Lookup to select, the depreciation expense organization that you want to view.
This field is optional. If you leave this field blank and you do not use Subquery, data for all depreciation expense organizations from the Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table will display in the table window, within the confines of your other selection parameters.
Lookup at this field displays information only for the accounts for which data has been written to the Projected Depreciation Expense table (FA_PRJTD_DEPR_EXP). If no data exists in the table, the system displays this message, "Nothing found in Lookup."
Enter, or use the drop-down box to select, the fiscal year of data that you want to view.
This field is optional. If you leave this field blank and you do not use Subquery, data for all fiscal years from the Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table will display in the table window, within the confines of your other selection parameters.
The drop-down box displays only those fiscal years already set up in the Maintain FA Fiscal Years screen for which projected depreciation expense calculations have been performed and for which there is data in the Projected Depreciation Expense table (FA_PRJTD_DEPR_EXP). The available fiscal years display in descending order, beginning with the latest fiscal year from the Maintain FA Fiscal Years screen. If no data exists in the table, blanks display when you select the drop-down box.
Enter, or use the drop-down box to select, the accounting period that you want to view.
This field is optional. If you leave this field blank and you do not use Subquery, data for all accounting periods from the Projected Depreciation Expense (FA_PRJTD_DEPR_EXP) table will display in the table window, within the confines of your other selection parameters.
The drop-down box displays only those periods already set up for the specified fiscal year in the Maintain FA Accounting Periods screen. If no data exists in the table, blanks display when you select the drop-down box.
Please refer to the preceding documentation regarding the relationship between column data display in the table window and field data display in the screen header. The columns in the table window are non-editable.
This field displays the book number for which projected depreciation expense has been computed.
This field displays the depreciation expense account for which projected depreciation expense has been computed.
This field displays the depreciation expense organization for which projected depreciation expense has been computed.
This field displays the fiscal year for which projected depreciation expense has been computed.
This field displays the accounting period for which projected depreciation expense has been computed.
This field displays the depreciation expense project, if applicable, for which projected depreciation expense has been computed.
This field displays the depreciation expense account allocation code for which projected depreciation expense has been computed.
This field displays the projected depreciation expense amount computed by Costpoint.
This field displays the asset number for which projected depreciation expense has been computed.
This field displays the item number for which projected depreciation expense has been computed.
This field displays the short description of the asset/item number for which projected depreciation expense has been computed.
This field displays the asset ("ownership") account of the asset/item number for which projected depreciation expense has been computed.
This field displays the asset ("ownership") organization of the asset/item number for which projected depreciation expense has been computed.
This field displays the asset ("ownership") project, if applicable, of the asset/item number for which projected depreciation expense has been computed.
This field displays the required description entered for the projected purchase in the Maintain Projected Asset Purchases screen.
Data displays in this column only if you entered future asset purchases in the Maintain Projected Asset Purchases screen AND you included projected purchases in the computation when you ran the Compute Projected Depreciation process. Data entry and subsequent calculations for future purchases are optional features within the Projections functionality.
This field displays the required asset ("ownership") account entered for the projected purchase in the Maintain Projected Asset Purchases screen.
Data displays in this column only if you entered future asset purchases in the Maintain Projected Asset Purchases screen AND you included projected purchases in the computation when you ran the Compute Projected Depreciation process. Data entry and subsequent calculations for future purchases are optional features within the Projections functionality.
This field displays the required asset ("ownership") organization entered for the projected purchase in the Maintain Projected Asset Purchases screen.
Data displays in this column only if you entered future asset purchases in the Maintain Projected Asset Purchases screen AND you included projected purchases in the computation when you ran the Compute Projected Depreciation process. Data entry and subsequent calculations for future purchases are optional features within the Projections functionality.
This field displays the required asset ("ownership") project, if applicable, entered for the projected purchase in the Maintain Projected Asset Purchases screen.
Data displays in this column only if you entered future asset purchases in the Maintain Projected Asset Purchases screen AND you included projected purchases in the computation when you ran the Compute Projected Depreciation process. Data entry and subsequent calculations for future purchases are optional features within the Projections functionality.
This field displays, as applicable, the projected disposal fiscal year for this asset in advance of its stated useful life. You must have first entered this data in the Maintain Projected Asset Disposals screen before running the Compute Projected Depreciation process.
This field displays, as applicable, the projected disposal accounting period associated with the projected disposal fiscal year for this asset in advance of its stated useful life. You must have first entered this data in the Maintain Projected Asset Disposals screen before running the Compute Projected Depreciation process.
This field displays the total projected depreciation expense amount for all records selected for the current inquiry.
The system stores data viewed in this screen in the Projected Depreciation Expense table (FA_PRJTD_DEPR_EXP). This table stores the results of the computation performed from the Compute Projected Depreciation screen. You can print the data from this table by running the Print Projected Depreciation Expense Report using a variety of selection criteria.