Use this screen to view monthly depreciation expense activity for your optional books, as applicable, for any prior closed fiscal year(s) and period(s). In the header of this screen, you can select a general subset of records to view, including the asset/item number, and the fiscal year, accounting period, and subperiod.
The system posts depreciation to the General Ledger only for Book 1, the G/L Book. The details of the posted transactions are stored in the FA_POSTING_DETL table, where they can be printed from the Print Posted Transactions Detail screen. The system never posts depreciation to the G/L for any books other than for Book 1, the G/L Book.
Monthly depreciation expense activity for your optional books, which is not "posted" to the G/L, is now written directly to and is automatically stored in the FA_DEPR_HS table when you run the Close Fixed Assets Acctng Pd process. Disposal data, depreciation adjustment data associated with disposals, and transfer data are also written to this table during the Close process.
You can use this inquiry screen to access the historical data retained in this table.
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 automatically 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 automatically display in the screen header fields, and the columns will not be visible in the table window.
Use the Subquery button on the toolbar 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 historic depreciation activity for your other books at any time in this screen after you have closed one or more Fixed Assets periods for which you have computed (or manually entered) depreciation. Data loaded into the table window for the inquiry is cleared when you exit from the screen and new data is loaded for viewing when you select different inquiry parameters.
Enter, or use Lookup to select, the asset number for which you wish to view depreciation history.
This field is optional. If you leave this field blank and you do not use Subquery, all asset/item numbers from the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the ASSET table. As a result, the asset numbers from which to choose during the lookup will be limited to those assets for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup." Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Enter, or use Lookup to select, the item number for which you wish to view depreciation history.
This field is optional. If you leave this field blank and you do not use Subquery, data for all asset/item numbers from the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the ASSET table. As a result, the item numbers from which to choose during the lookup will be limited to those assets for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup."
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Enter, or use the drop-down box to select, the fiscal year for which you wish to view depreciation history. This drop-down box displays only those fiscal years already set up in the Maintain FA Fiscal Years screen in descending order, beginning with the most future fiscal year.
Because this is a standard drop-down display from the FA_FY_INFO table, you may find that you have selected a fiscal year for which data does not exist in the Other Books Depreciation History table (FA_DEPR_HIS).
This field is optional. If you leave this field blank and you do not use Subquery, data for all fiscal years from the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Enter, or use the drop-down box to select, the accounting period for which you wish to view depreciation history. This drop-down box displays only those periods already set up for the fiscal year specified in the Fiscal Year field.
Because this is a standard drop-down display from the FA_PD_INFO table, you may find that you have selected a period for which data does not exist in the Other Books Depreciation History table (FA_DEPR_HIS).
This field is optional. If you leave this field blank and you do not use Subquery, data for all periods from the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Enter, or use Lookup to select, the book number for which you wish to view depreciation history.
This field is optional. If you leave this field blank and you do not use Subquery, data for all books from the Other Books Depreciation History table, within the confines of your other selection parameters, will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the FA_SETTINGS table. As a result, the book numbers from which to choose during the lookup will be limited to those books for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup."
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Asset "ownership" data is required entry in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen for all property records. Account and organization are always required, but projects and reference numbers are optional. The account/org/proj/ref1/ref2 data that you assign to an asset specifies "ownership" and can include company-owned balance sheet or expense accounts, projects, and so on.
This field is optional. If you leave this field blank and you do not use Subquery, data for all accounts found in the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the ACCT table. As a result, the accounts from which to choose during the Lookup will be limited to those accounts for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup." Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Asset "ownership" data is required entry in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen for all property records. Account and organization are always required, but projects and reference numbers are optional. The account/org/proj/ref1/ref2 data that you assign to an asset specifies "ownership" and can include company-owned balance sheet or expense accounts, projects, and so on.
This field is optional. If you leave this field blank and you do not use Subquery, data for all organizations found in the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the ORG table. As a result, the organizations from which to choose during the lookup will be limited to those organizations for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup."
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Asset "ownership" data is required entry in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen for all property records. Account and organization are always required, but projects and reference numbers are optional. The account/org/proj/ref1/ref2 data that you assign to an asset specifies "ownership" and can include company-owned balance sheet or expense accounts, projects, and so on.
This field is optional. If you leave this field blank and you do not use Subquery, data for all projects found in the Other Books Depreciation History table (within the confines of your other selection parameters) will display in the table window.
Lookup at this field retrieves information from the FA_DEPR_HIS table instead of the PROJ table. As a result, the projects from which to choose during the lookup will be limited to those projects for which historical depreciation expense data for your optional books already resides in the FA_DEPR_HIS table. If no data exists in the table, the system displays this message: "Nothing found in Lookup."
Use Subquery to select a more specific subset of data. If you use Subquery, you will not need to enter any data in the header fields in this screen as selection criteria.
Please refer to the preceding documentation regarding the relationship between column data in the table window and field data in the screen header. The columns in the table window are non-editable.
This column displays the asset number associated with the depreciation expense history amount(s) for your other books, as applicable, for the time period identified in the row.
This column displays the item number associated with the depreciation expense history amount(s) for your other books, as applicable, for the time period identified in the row.
This column displays the short description for the asset/item number associated with the depreciation expense history amount(s) for your other books, as applicable, for the time period identified in the row.
This column displays the fiscal year associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the accounting period associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the book number associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the asset account associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the asset organization associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the optional asset project associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the optional asset reference 1 designator associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the optional asset reference 2 designator associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
This column displays the transaction type associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
The transaction types can be identified as follows:
DEPR — Depreciation Expense
DISP — Disposal
DADJ — Depreciation Adjustment in Conjunction with a Disposal
TRF — Transfer of Accumulated Depreciation
This column displays the transaction amount associated with the depreciation expense history amount(s) for your other books, as applicable, for the asset/item number identified in the row.
The system stores data viewed in this screen in the Other Books Depreciation History table (FA_DEPR_HS). Monthly depreciation expense data for each optional book (other than the G/L Book) is written to this table each time you perform the Close Fixed Assets Acctng Period process. Disposal data, depreciation adjustment data associated with disposals, and transfer data are also written to this table during the Close process.
You can print the data from this table using the Print Sequential Other Bks Depr History screen.
Lookups and drop-down boxes, as applicable, access the following tables:
ACCT (Account)
ORG (Organization)
PROJ (Project)
ASSET (Asset)
FA_FY_INFO (Fixed Assets FY Info)
FA_PD_INFO (Fixed Assets Accounting Period Info)
FA_BOOK_SETTINGS (Fixed Assets Book Settings)