WEBVTT Kind: captions Language: en 00:00:01.200 --> 00:00:04.880 Using lists. 00:00:04.880 --> 00:00:12.720 This video shows you how to select list  items, sort and add columns, set row spacing,  00:00:12.720 --> 00:00:27.440 open lists in Windows, search the list, filter the  list, use the scrollable view, select list items. 00:00:27.440 --> 00:00:38.400 First, we will open a list. the  sales ledger customers list. 00:00:38.400 --> 00:00:45.600 We will unpin the menu to make more room. 00:00:45.600 --> 00:00:50.240 Now we will select some items in the list. 00:00:52.560 --> 00:01:01.280 We can select multiple items in a  list by using control and click. 00:01:01.280 --> 00:01:10.240 Notice that the number of selected  items and their totals are displayed. 00:01:10.240 --> 00:01:19.120 The toolbar shows actions we can use with a list.  We will view orders for the selected customers. 00:01:23.440 --> 00:01:32.720 We can see orders for the three customers. 00:01:32.720 --> 00:01:40.960 We can swap or invert the items we have selected. 00:01:40.960 --> 00:01:46.480 We will clear the selection. 00:01:46.480 --> 00:01:58.080 Sort and add columns. We can sort  the list by clicking a column. 00:01:58.080 --> 00:02:04.960 Clicking again will change the order. 00:02:04.960 --> 00:02:09.920 Next, we will add a column to the list. 00:02:09.920 --> 00:02:15.040 We will right click in the list to show the menu. 00:02:18.800 --> 00:02:25.520 We will add the column is over credit limit. 00:02:25.520 --> 00:02:31.680 The is over credit limit column has been added. 00:02:31.680 --> 00:02:38.400 We can also resize column widths. 00:02:43.040 --> 00:02:47.920 set row spacing. 00:02:47.920 --> 00:02:55.840 We can change the lists row  spacing to see more items. 00:02:55.840 --> 00:03:02.720 We will open preferences. 00:03:02.720 --> 00:03:06.400 We will set the row spacing to be narrow. 00:03:09.600 --> 00:03:14.800 We can now see more items. 00:03:14.800 --> 00:03:20.080 Open lists in Windows. 00:03:20.080 --> 00:03:24.880 We will write click the suppliers list. 00:03:24.880 --> 00:03:32.800 We will select open in new window. 00:03:32.800 --> 00:03:35.280 We can switch between windows. 00:03:42.160 --> 00:03:51.920 We will open another list in a window. 00:03:51.920 --> 00:03:59.440 We can look at the two lists side by side. 00:04:05.760 --> 00:04:14.240 This makes it easier to work with multiple lists. 00:04:14.240 --> 00:04:22.480 Search the list. We will  search the list for Smith. 00:04:25.760 --> 00:04:32.320 The results show customer  accounts containing Smith. 00:04:32.320 --> 00:04:39.120 We will clear the search. 00:04:39.120 --> 00:04:47.840 Filter the list. We will select filters. 00:04:47.840 --> 00:04:50.640 We will add a new filter. 00:04:52.400 --> 00:05:00.320 We will enter a name for the filter. 00:05:00.320 --> 00:05:03.280 We will make the filter public so anyone can edit  00:05:03.280 --> 00:05:15.360 it. We will set up the filter to show  customers with balances over 10,000. 00:05:23.840 --> 00:05:33.280 When we save the filter, it  is kept with our company data. 00:05:33.280 --> 00:05:38.720 We will try out our new filter. 00:05:42.320 --> 00:05:50.320 So, the list now only shows customers  with a balance of 10,000 or more. 00:05:50.320 --> 00:06:06.560 We will update the filter to only show  customers over their credit limit. 00:06:08.880 --> 00:06:17.840 So this will only show customers  where is over credit limit is true. 00:06:17.840 --> 00:06:20.320 So the filter now shows customers with a balance  00:06:20.320 --> 00:06:26.880 of 10,000 or more and who are  also over their credit limit. 00:06:26.880 --> 00:06:34.480 Use the scrollable view. We  will open the sales orders list. 00:06:36.480 --> 00:06:44.480 By default, lists used a paged  view which shows all your data. 00:06:44.480 --> 00:06:54.400 We can see there are about  5,000 items in this list. 00:06:54.400 --> 00:07:01.680 In page view, items that you select are  not remembered when you move from the page. 00:07:08.000 --> 00:07:14.240 Next, we will look at the scrollable view. 00:07:14.240 --> 00:07:21.440 In scrollable view, only the  first 1,000 items are displayed. 00:07:21.440 --> 00:07:29.040 We can scroll through the list. 00:07:29.040 --> 00:07:31.120 We will use a filter on this list. 00:07:36.720 --> 00:07:52.160 In scrollable view, selected items are  remembered when we move around the list. 00:07:52.160 --> 00:07:57.840 We will take this selection  and export it to Excel. 00:08:02.880 --> 00:08:15.920 The selected items are now in Excel. 00:08:15.920 --> 00:08:19.280 Thanks for watching. If you have any feedback,  00:08:19.280 --> 00:08:25.040 please email us at Sage200TechnicalAuthors@sage.com.