Queries

The Queries group level includes these links to transaction areas:

Field or Control	Description
PO/ AM Reconciliation	Displays a purchase order or receiver related asset, that is not an asset in AM yet.
AP/AM Reconciliation	Displays a voucher related asset, that is not an asset in AM yet.
PC/AM Reconciliation	Displays a project related asset, that is not an asset in AM yet.
Incomplete Procurement Group	Displays pre-interface transactions already existing in the pre-AM table longer than the number of days entered as the procurement group is incomplete.
Asset with Inactive Chartfield	Displays assets with inactive chartfields based on the date entered.
Pending Depreciation Close	Displays assets that need depreciation close run on them for the period based on a given As of Date.
Lease Expiration	Displays leases that will expire within the days entered. Note: This query searches for expired leases in the Asset Management tables only, it does not search the Lease Administration tables.
Fully Depr Asset – End Depr Dt	Displays fully depreciated assets based on the date entered and the asset’s end depreciation date.
Asset Scan History	Displays the entire scan history for assets, by business unit.
Asset Scan History – Most Recent	Displays the most recent scan history for assets, by business unit.