The Fixed Asset Balance Summary (FABALSQ) displays Fixed Asset (FA) balances at the Fixed Asset Number level. The Fixed Asset Ledger records are summarized by Fiscal Year into Year To Date (YTD) amounts for FA Value, Accumulated Depreciation, and Net Book Value. The amount on the ledger record is interpreted based on the Posting Code, Event Category and whether or not the Fiscal Year of the ledger record is prior to the displayed record.
At least two of the following search criteria must be provided when searching for records on this page:
Fiscal Year (This field must be populated if the Accounting Period is populated)
Fixed Asset Number
Fund
Department
Fixed Asset Type
BSA Code
The page does not allow the use of wildcard values, special characters (>, < etc) or multiple values separated by a comma (,) in any of the search fields.
The page displays the following fields as output:
|
Name |
Description |
|
Opening Balance of Asset Value (OPBL) |
Opening Balance of Asset Value (OPBL) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for the OPBL Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F002 and M001 for all Event Categories). Opening Balance of Asset Value is the total of these postings for all Fiscal Years/ periods prior to the Fiscal Year/ Period queried upon. |
|
Opening Balance of Accumulated Depreciation (OPDP) |
Opening Balance of Accumulated Depreciation (OPDP) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for the OPDP Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F040 and M003 for all Event Categories). Opening Balance of Accumulated Depreciation is the total of these postings for all Fiscal Years/ periods prior to the Fiscal Year/ Period queried upon. |
|
Addition During Year (CYAD) |
Additions During Year (CYAD) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for CYAD Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F020, M001 for FA, FIS, FB, FIA, or FIB Event Categories). Addition during the Year is the total of these postings for the Fiscal Year/ Period queried upon. |
|
Modifications During Year (CYMD) |
Modification During Year (CYMD) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for CYMD Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F002, M001 for FI, FD, FS, or FAIS Event Categories). Modification during the Year is the total of these postings for the Fiscal Year/ Period queried upon. |
|
Depreciation During Year (CYDP) |
Depreciation During Year (CYDP) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for CYDP Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F040, M003 for all Event Categories). Depreciation during the Year is the total of these postings for the Fiscal Year/ Period queried upon. |
|
Closing Balance of Asset Value (CLBL) |
Closing Balance of Asset Value (CLBL) derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for the CLBL Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F002 and M001 for all Event Categories). Closing Balance of Asset Value is the total of these postings for all Fiscal Years/ periods up until the Fiscal Year/ Period queried upon.. |
|
Closing Accumulated Depreciation (CLDP) |
Closing Accumulated Depreciation (CLDP) is derived by summing up Ledger Amounts for records with Posting Code, Event Category combinations that are registered for CLDP Balance Summarization Code on the FA Balance Summarization Code Crosswalk table. (In the delivered data, this is posting codes F040, M003 for all Event Categories). Closing Accumulated Depreciation is the total of these postings for all Fiscal Year/ Period until the Fiscal Year/ Period queried upon. |
|
Net Book Value (NBV) |
Net Book Value (NBV) is derived as the difference between Closing Balance of Asset Value and Closing Accumulated Depreciation. |
The Fixed Asset Component Balance Summary link transitions you to the Fixed Asset Component Balance Summary (FACBALSQ) page, which displays FA balances at the FA Component level.