Using the Fluid Asset Management WorkCenter – Queries Pagelet

The Queries pagelet can include links to Query Manager, public queries, private queries, and actionable operational analytics (such as grids and graphs). Click on any link in the Queries pagelet to display the query or analytics in the transaction area of the WorkCenter.

The system administrator can add queries to this pagelet and determine if an end user can add public queries in Query Manager.

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.

The Pivot Grids group includes links to the following pivot grids:

Field or Control	Description
Acctg Entry not Journal Gen	Displays data in asset accounting entry distribution rows that have not had Journal Generator run on them yet and allows modification of filters and charts.
Asset Acquisition by Category	Displays data in asset acquisition costs as charts based on business unit, book and category and also allows modification of filters and charts.
Asset Depreciation by Category	Displays data in asset depreciation as charts by business unit, book and category and also allows modification of filters and charts.
Asset Retirements by Category	Displays data in asset retirement costs as charts based on business units, books and categories and allows modification of filters and charts.
Asset Cost by Acquisition Code	Displays data in asset costs by acquisition cost as charts based on business units and books and allows modification of filters and charts.

The Queries pagelet can provide access to public queries, private queries, and Pivot Grids.

To set up the WorkCenter Queries pagelet as a system administrator, see Configure Pagelets – Queries Page.