|
List of assets by business unit and transaction date which do not meet the state capitalization threshold of $1,000 |
Non Capitalized Assets |
|
Query provides an audit tool for in-service asset descriptions containing the symbols ' or '' |
Audit Description field symbol '' |
|
To create a list of agency assets with cost that shows the last time they were inventoried (one row per asset) |
Asset Inventory Information |
|
To find all comments (historical) for a specified asset |
Comments by Asset |
|
To find asset physical inventory history |
Asset Inventory History |
|
To find controllable adds for a specified date range. |
Controllable Additions |
|
To find controllable disposals/transfers for a specified date range. |
Controllable Retirements |
|
To find current inservice assets, current location and cost |
In service assets w/cost |
|
To find current net book value, depreciation values, and coding string for in service assets by business unit |
In service asset net book value |
|
To find detailed asset information used to support the negative cost of CO-59 reporting |
AM CO-59 - All Cost NEG Detail |
|
To find detailed asset information used to support the positive cost of CO-59 reporting |
AM CO-59 - all Cost POS Detail |
|
To find In Service assets |
In service assets by location |
|
To find in-service assets for a fiscal year and fiscal period |
In service assets by FY/Acct Per |
|
To find Non-Capitalized Asset Expenditures, by Account (54150). Reflects 9.1 upgrade |
Non-cap Asset Expenditures |
|
To find summary asset information used to support the negative cost for the CO-59 report |
AM CO-59 - all Assets Cost NEG |
|
To find summary asset information used to support the negative depreciation for the CO-59 report |
AM CO-59 - all Assets Depreciation NEG |
|
To find summary asset information used to support the positive cost for the CO-59 report |
AM CO-59 - all Assets Cost POS |
|
To find summary asset information used to support the positive depreciation for the CO-59 report |
AM CO-59 - all Assets Depreciation POS |
|
To find the most recent comment for in-service assets by business unit |
Asset comments by BU |
|
To fined assets and descriptions by location |
Assets w/ description by location |
|
To fins assets with duplicate serial numbers |
Assets with Duplicate Serial Numbers |
|
To provide list of all in-service assets where the category and profile do not match. |
Category/Profile Mismatch |
|
To reconcile AP Asset Vouchers with AM asset detail transaction information |
Reconcile Voucher/Asset ID |
