...
...
Lists Tutorial
Include Page | ||||
---|---|---|---|---|
|
About Lists
IMOS makes many objects and transactions available to you on lists and summaries. You can open all the lists to which you have access from the IMOS7 menu. The Reports list is on the menu, and the rest are on the Lists submenu in alphabetical order within module groupings. You can also access the lists from the module centers.
On most IMOS lists, you can modify the contents and format of a list in the following ways:
- Create a report
- Import and export data
- Filter list data
- Create and use different IMOS - List Views.
- Search columns quickly with IMOS - Quick Search. Click and then click Quick Search. Once enabled for a list, it stays enabled whenever you log in.
- Select columns to display
- Rearrange column sequence and width
- Filter columns
- Sort columns
Anchor | ||||
---|---|---|---|---|
|
Creating a Report
To create a report of the data displayed, do one of the following:
- Click .
- Right-click a column heading and click Show Report.
Anchor | ||||
---|---|---|---|---|
|
Importing and Exporting Data
To import or export the data that is currently displayed, click and then click one of the following:
...
Anchor | ||||
---|---|---|---|---|
|
Filtering List Data
Anchor | ||||
---|---|---|---|---|
|
Filtering by Selecting
Some lists have filters at the top that you can select from:
Click the filter and select a value:
Dates
Date selection lists can include the following:
- Relative times, such as This Week, From Last Week on, Last Quarter, etc.
- Custom, where you can enter a custom date or date range:
- Use Fiscal Calendar check box (at the end of the list), to use the fiscal year.
- Specific dates , where you can either type a date or click the calendar and select a date.
Anchor | ||||
---|---|---|---|---|
|
Filtering with Logical Operations
Some lists have filters on the right, where you can use logical operations to filter particular columns in the list.
...
To close the filters, click .
Using Quick Search
Similar to filtering, you can perform a IMOS - Quick Search of items in a list, with a Search field in each column.
Click and then click Quick Search.
Anchor | ||||
---|---|---|---|---|
|
Selecting Columns to Display
Select the columns you want to see in a list, so that those you do not need are out of the way.
- Right-click a column heading and click Select Columns.
- In Select Columns:
- Select check boxes for the columns you want to see.
- Clear any selected check boxes for columns you do not want to see.
- Click OK.
Anchor | ||||
---|---|---|---|---|
|
Rearranging Column Sequence and Width
- Change the sequence of columns, so you can most easily see those you work with most, and you can still access those you need less frequently: Click a column heading and drag the column to where you want it.
- Change the width of a column: Place your pointer at the right end of the column heading. When the pointer becomes a double-headed arrow, drag it to move the split line.
Anchor | ||||
---|---|---|---|---|
|
Filtering Columns
Filter the columns to exclude the data you do not need to work with. The filter values for a column include the values that remain after other column filters have been applied.
Note: Quick Search must be disabled to do this.
- To filter a column, right-click its heading and click Filter Values.
- In the Column Filter:
- Select check boxes for the values you want to see.
- Clear any selected check boxes for values you do not want to see.
- Select or clear the Select All check box to select all or none; you can then select or clear individual check boxes.
- Click OK.
Clearing Filters
- To clear a filter, right-click the column heading and click Clear Filter.
- To clear all filters, right-click any column heading and select Clear All Filters.
Anchor | ||||
---|---|---|---|---|
|
Sorting Columns
Sort columns, so that you can see the data in the sequence you need to work with. To sort a column:
...
An arrow in the sorted column points in the direction of the sort.
Excerpt | ||
---|---|---|
| ||
As with any other list, you can sort, filter, do a Quick Search, and create custom Views. You can also use logical operations to filter particular columns in the list. |