User Tools

Site Tools


assetmanagement:inquiry:inventoryinquiry

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
assetmanagement:inquiry:inventoryinquiry [2017/05/08 21:52] emorenoassetmanagement:inquiry:inventoryinquiry [2020/09/15 21:48] (current) emoreno
Line 5: Line 5:
 //**Asset Management > Inquiry > Inventory Inquiry**// //**Asset Management > Inquiry > Inventory Inquiry**//
  
-<WRAP round intro>This page is used to inquire about inventory and create an inventory report by using queries. You can decide what fieldsconditions, comparison data, and other options should be used to generate the report. This feature allows you to select data based on fields not normally available for selection on other reports.</WRAP>+<WRAP round intro>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. </WRAP>
  
  
 ====Perform an inventory inquiry:==== ====Perform an inventory inquiry:====
  
-Under **Options**:+VCV Under **Options**: 
 +^Field  ^Description ^ 
 +^Report Title|Type a report title that accurately defines the contents of the report. The field can be a maximum of 20 characters.| 
 +^Subtotal on Major Sort Field|Select to create a subtotal for each major sort field or leave blank not to create a subtotal on major sort fields.| 
 +^Subtotal on Dept/Room|Select 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 Field|Select 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.|
  
-●      In the Report Title field, type a report title that accurately defines the contents of the report. The field can be a maximum of 20 characters. 
  
-●      Select the Subtotal on Major Sort Field option to create a subtotal for each major sort field or leave blank not to create a subtotal on major sort fields.+VCV Under **Filter**: 
 +^Column Name|Click {{:images:dropdown.gif|Drop-down Arrow}} to select the column for which you would like to retrieve data.| 
 +^Operator|Click {{:images:dropdown.gif|Drop-down Arrow}} to select the mathematical symbol for the query.| 
 +^Value|Type the data to be compared, or click {{:images:smallpicklist.gif|Ellipsis Icon}} to select from the list based on the **Column Name** field selection.| 
 +VCV Click **+Add** to add a row
  
-●      Select the Subtotal on Dept/Room option to create a subtotal for each department/room number, or leave blank not to create a subtotal by department/room numbers.+VCV Under **Sort**: 
 +^Sort Order|Click {{:images:dropdown.gif|Drop-down Arrow}} to select the order in which columns are sorted for the inquiry.| 
 +^Ascending|Click {{:images:dropdown.gif|Drop-down Arrow}} to select if the inquiry data is to be sorted in ascending or descending order.|
  
-●      Select Page Break on Major Sort Field to set 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.+VCV Click **Retrieve** to view copy of the report[[general:printreport|Review the report.]]
  
- 
- 
-Click **Save**.<WRAP box>**NOTE:</WRAP>  
  
  
 ====Other functions and features:==== ====Other functions and features:====
  
-^{{:tsds:images:trash_delete.gif|}} | ++ Delete a row.|{{page>general:delete_a_row}}++ /*Table row with text link*/  +^{{:images:trash_delete.gif|Trashcan Icon}} |{{page>general:deletearow}}| 
- +^Reset|{{page>general:resetdata}}| 
  
  
assetmanagement/inquiry/inventoryinquiry.1494280321.txt.gz · Last modified: 2017/05/08 16:52 (external edit)