PURGE OTHER BOOKS DEPRECIATION HISTORY

Use this screen to delete depreciation activity for your optional other books, as applicable, for any prior closed fiscal year(s) and period(s) from the Other Books Depr History (FA_DEPR_HS) table. Because depreciation for other books is never posted to the General Leger, the system writes and stores the monthly depreciation expense for other books in the Other Books Depreciation History table when you run the Close Fixed Assets Accounting Period process. The data stored in the FA_DEPR_HS table includes the asset/item number, fiscal year/period/ subperiod, and the depreciation expense for each book.

Additional records are added to the Other Books Depr History table each accounting period when you run the Close Fixed Assets Accounting Period process. As a result, this table can potentially contain a very large number of records.

Once data is written to the Other Books Depr History table, you can view the data on the View Other Books Depreciation History screen. You can also print the depreciation history from this table when you run the process on the Print Sequential Other Books Depreciation History Rpt screen.

To prevent the accidental deletion of data, we recommend that you restrict user access to this screen. You cannot perform the Close Fixed Assets Accounting Period process while this purge is in process.

This purge deletes data only from the Other Books Depr History (FA_DEPR_HS) table.

Because this purge routine permanently deletes table data, you should first verify that you do not need to retain this data in the system for future audits or for historical reference purposes. As a precaution, you should always perform a reliable backup.

Following your company procedures, first identify which fiscal years, periods, and asset/item numbers should be included in the selection parameters. Although you can run this process at any time, you should normally run this process to clear out unneeded history and free up database space.

Before beginning the purge process, the system checks the status of all accounting periods within the range selected for the purge. If any period from the selected range is not closed, the system displays a warning message. It tells you that not all accounting periods within the selected range have been closed. And then, it will ask you if you want to continue with the purge process or not.

Although you can continue with the purge process in this circumstance, we recommend that you investigate before proceeding. Transactions should normally be purged only for closed accounting periods.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Select Ranges

Transaction Time Periods

Use the following fields to select the time period(s) from which to purge depreciation history for your optional books.

You cannot purge other book's depreciation history data for the "current" Fiscal Year and period, which display on the Configure Posting Settings screen. You must select the Fiscal Year and period for a time period before the current period data indicated on the Configure Posting Settings screen.

Options

Select the range option from the drop-down list. The available options are:

The Fiscal Year field Lookup displays only those fiscal years already set up on the Manage Fiscal Years screen in Costpoint General Ledger. Fiscal years in Costpoint General Ledger should always match those set up in Costpoint Fixed Assets on the Manage Fixed Assets Fiscal Years screen. Because the display in the Fiscal Year field Lookup is a standard Lookup to the Fiscal Year table, you may find that you have selected a fiscal year for which data does not exist in the FA_DEPR_HS table or does not meet your other selection criteria. In this event, the data you expect to purge may not be selected.

The Period field Lookup displays only those accounting periods already set up in Costpoint General Ledger's Manage Accounting Periods screen for the fiscal year specified in the Fiscal Year field. Accounting periods set up in Costpoint General Ledger should always match those set up in Costpoint Fixed Assets on the Manage Fixed Assets Accounting Periods screen. Because the display in the Period field Lookup is a standard Lookup to the ACCTING_PD table, you may find that you have selected a period for which data does not exist in the FA_DEPR_HS table or does not meet your other selection criteria. In this event, the data you expect to purge may not be selected.

Start—Fiscal Year/Period

Enter, or click to select, the beginning fiscal year and period for the selected range Option.

If you select All or From Beginning in the Option field, these fields will be inactive.

End—Fiscal Year/Period

Enter, or click to select, the ending fiscal year and period for the selected range Option.

If you select All, One, or To End in the Option field, these fields will be inactive.

Asset/Item Numbers

Use the following fields to select the asset/item number(s) from which to purge depreciation history for your optional books.

If you enter an asset number, you must also enter a corresponding item number.

Options

Select the range option from the drop-down list. The available options are:

Start—Asset No/Item No

Enter, or click to select, the beginning asset/item number for the selected range Option. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset number for which data do not exist in the Other Books Depreciation History table (FA_DEPR_HS).

If you select All or From Beginning in the Option field, these fields will be inactive.

End—Asset No/Item No

Enter, or click to select, the ending asset/item number for the selected range Option. Because this is a standard Lookup to the ASSET table, you may find that you have selected an item number for which data does not exist in the Other Books Depreciation History table (FA_DEPR_HS).

If you select All, One, or To End in the range Option field, these fields will be inactive.

Options

Purge with open accounting periods

Select this check box to continue the purge process even if there is an accounting period in your selection that is open.

Purge F/A Other Books Depreciation History Report

Click the drop-down and select Purge F/A Other Books Depreciation History Report to print the list of records for deletion.

Purge F/A Other Books Depreciation History (with the Action/Gears Icon)

Click the drop-down and select Purge F/A Other Books Depreciation History to begin the purge process.

Print/Purge F/A Other Books Depreciation History (Under the Action/Gears Icon)

Click this command to print the list of records for deletion. The purge process will follow immediately after printing without the opportunity to review the report.