User Tools

Site Tools


Sidebar

Table of Contents

assetmanagement:inquiry:inventoryinquiry

Inventory Inquiry - BAM5000

Asset Management > Inquiry > Inventory Inquiry

This page is used to generate inventory inquiries by using selected fields to include specific conditions, comparison data, and other options to create an inventory report.

Perform an inventory inquiry:

❏ Under Options:

Field Description
Report TitleType a report title that accurately defines the contents of the report. The field can be a maximum of 20 characters.
Subtotal on Major Sort FieldSelect to create a subtotal for each major sort field or leave blank not to create a subtotal on major sort fields.
Subtotal on Dept/RoomSelect to create a subtotal for each department/room number, or leave blank not to create a subtotal by department/room numbers.
Page Break on Major Sort FieldSelect to set a page break after listing the assets of each major sort field (e.g., buses, department, room), or leave blank to ignore page breaks and print a continuous listing.

❏ Under Filter:

Column NameClick Drop-down Arrow to select the column for which you would like to retrieve data.
OperatorClick Drop-down Arrow to select the mathematical symbol for the query.
ValueType the data to be compared, or click Ellipsis Icon to select from the list based on the Column Name field selection.

❏ Click +Add to add a row.

❏ Under Sort:

Sort OrderClick Drop-down Arrow to select the order in which columns are sorted for the inquiry.
AscendingClick Drop-down Arrow to select if the inquiry data is to be sorted in ascending or descending order.

❏ Click Retrieve to view a copy of the report. Review the report.

Other functions and features:

Trashcan Icon

Click to delete a row. The row is shaded red to indicate that it will be deleted when the record is saved.

Click Save.

Reset

Click to reset all previously selected options to the default.

assetmanagement/inquiry/inventoryinquiry.txt · Last modified: 2020/09/15 21:48 by emoreno