Queries

The Queries group includes links to the following queries:

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.
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.
Assets With Inactive Location	Displays assets that are assigned to locations that are no longer active in PeopleSoft. Inactive locations can impact both physical inventory and maintenance.
Asset Journals in Error	Displays the list AM journals that are in error in GL.
Asset Cost Roll Forward	Displays roll forward asset data to assist with financial statements and tax reporting. The cost activity will be summarized by asset category.
Asset NBV Roll Forward	Displays the breakdown of asset net book value by category.