Use this toolkit to re-compute the Fiscal Year To Date depreciation values in your Asset Master records based on entries in the Fixed Assets Posting Detail table for the G/L Book and the Fixed Assets Depreciation History table for all other books. The data that can be changed using this toolkit may significantly affect the calculation of depreciation. Very few users should need to run this toolkit.
This is a basic toolkit, by which data can be changed in your Asset Master records. Lookups are not available and validations are not performed.
Select the Subtract Computed FYTD Amt from Prior FYTD Amt checkbox to have the system re-compute the Prior Fiscal Year to Date depreciation amounts by subtracting the computed FYTD amount from the Prior Fiscal Year to Date values. In most situations, you should leave this checkbox selected.
You should only run this toolkit under very specific circumstances. If, for example, you closed the last period in your fiscal year prematurely or if you closed the last period in your fiscal year before you had added all the periods in that fiscal year, you will need to run this toolkit to restore the fiscal year/prior fiscal year inception to date balances before you can go forward. (You will also need to run a script to re-set the correct fiscal year/period/subperiod data in the Posting Settings screen in this circumstance.)
If you use fiscal year basis depreciation methods, you should also use the Verify/Update Computation Data screen to verify and update the corresponding data in the Curr Depr Yr and Days/Pds Remaining fields in your Asset Master records. (If the close of the last period in your fiscal year occurred prematurely, the data in the Curr Depr Yr and Days/Pds Remaining fields was also updated prematurely for assets that use fiscal-year-based depreciation methods.)
You should run this toolkit only to remedy the specific situation outlined in the Summary.
Use this group box to specify the fiscal year for which this toolkit will compute and update fiscal year/prior fiscal year inception-to-date balances in your Asset Master records.
Enter the fiscal year for which this toolkit will compute and update fiscal year/prior fiscal year inception-to-date balances in your Asset Master records.
Use this group box to re-compute the Prior Fiscal Year to Date depreciation amounts by subtracting the computed FYTD depreciation amounts from the Prior Fiscal Year inception-to-date depreciation values.
The default option for this checkbox is selected. In most situations, you should leave this checkbox selected.
If you leave this checkbox selected, the system will re-compute the Prior Fiscal Year to Date depreciation amounts by subtracting the computed FYTD depreciation amounts from the Prior Fiscal Year inception-to-date depreciation values.
Use this group box to select the book for which values should be computed and updated.
The default option for this radio button is selected. Choose this radio button to compute and update the FYTD depreciation amounts (and the Prior Fiscal Year inception-to date-depreciation values if you selected Subtract Computed FYTD Amt from Prior FYTD Amt checkbox) for the General Ledger Book.
The default option for this radio button is unselected. Choose this radio button to compute and update the FYTD depreciation amounts (and the Prior Fiscal Year inception to date depreciation values if the Subtract Computed FYTD Amt from Prior FYTD Amt checkbox is selected) for Book 2.
Please refer to the preceding documentation for the Book 2 radio button.
Select this pushbutton to begin the compute/update process.
Select this pushbutton to close this utility without processing.
During the compute/update process, the system automatically displays the number of Asset Master records read in this non-editable field.
During the compute/update process, the system automatically displays the number of Asset Master records updated in this non-editable field.
The number of records in the Rows Read and Rows Updated fields should match when the compute/update process is complete.
At the conclusion of the compute/update process, the system displays the following message:
Complete without errors. Rows updated: ____
The number of updated rows that display in this message should also match the value displayed in the Rows Updated field.
This toolkit reads data in the Fixed Assets Posting Detail table (FA_POSTING_DETL) for the G/L Book and the Fixed Assets Depreciation History table (FA_DEPR_HS) for all other books to re-create the FYTD values in Asset Master records.
The system reads data in the ASSET (Asset) table for the G/L Book and the ASSET_OTH_BK_DEPR (Asset Other Books Depreciation) table for all other books to calculate Prior FY depreciation values (if so enabled by the checkbox).
The systems updates data in the ASSET (Asset) table for the G/L Book and the ASSET_OTH_BK_DEPR (Asset Other Books Depreciation) table for all other books, as applicable.