EZ-Access to Lists

Sage 50 allows you to preview lists of records and transactions to screen. With each list you can add a record or transaction, edit an existing record or transaction, find information, perform a task, print a report, or make modifications to the fields and their order.

You can customize your list in many ways. Any changes you make will be saved specifically for you, and all users can have different settings depending on their access rights to the company data. In addition, if you have several companies, you can have different settings for each list for each company.

You can add fields to a list by following these steps.

  1. Display the list you want to customize.
  2. Select the Settings button in the toolbar. This will open the Settings window. On the right is a list of the fields that are currently displayed. On the left is a list of other fields that you can select.
  3. Click a field from the list to the left to select it.
  4. Click Add. This will move that field to the right.
  5. Repeat these steps to add further fields.
  6. Click OK. when you are done.

You can remove fields from the list by following these steps.

  1. Display the list you want to remove fields from.
  2. Click the Settings button in the toolbar. This will open the Settings window. To the right is a list of fields currently displayed; to the left is a list of fields that can be added.
  3. Click the field you want to remove from the list on the right to select it.
  4. Click Remove. This will remove it from the list and move it to the list on the left.
  5. Repeat these steps to remove other fields.
  6. Click OK when you are done.

To change the order in which records sort, either ascending or descending, and the field on which they will sort, simply click the field label that you want to use for sorting. This will bring up an arrow triangle, pointing up, showing that records are now sorted by this field in an ascending order, that is, from a to z. Click the field label again to change the sort order to descending, from z to a.

  • You can rearrange the fields from left to right in two ways:

    • Simply click a field label, holding the mouse button down, and drag the field to the new spot.
    • Click the Settings button and use the Move Up and Move Down buttons to move the fields on the list to the right up and down. Click OK. when you are done rearranging the fields in this way.

  • To change the order in which records sort, either ascending or descending, and the field on which they will sort, simply click the field label that you want to use for sorting. This will bring up an arrow triangle, pointing up, showing that records are now sorted by this field in an ascending order, that is, from a to z. Click the field label again to change the sort order to descending, from z to a.

You can resize a column by following these steps:

  1. Place the cursor over the vertical bar in the heading to the right of the field you want to widen or make thinner. The cursor will change to a double-vertical bar with arrows at each end.
  2. Click and hold the left mouse button.
  3. Drag the vertical bar to the right or left to modify the width of the field.

To add a record or transaction to the list

  1. Select the list you want to add a record or transaction to.
  2. Click the New button. This will open the associated window for the list.
  3. Enter the data on the Maintenance or Task window.
  4. Save the new record or transaction. It will be added to this list.

Note: You can also open the Maintain or Task window by right-clicking the mouse and selecting to Add.

  1. Highlight the transaction you want to copy.
  2. Click the Copy button.
  3. The new transaction will open in the transaction screen.
  4. Edit the transaction as necessary.
  5. Click Save.

Note: You can also select a transaction in the list and right-click to choose to copy it.

To edit a record in the list

  1. Highlight the record or transaction you want to edit.
  2. Click the Open button in the toolbar. This will open the Maintain or Task window with the data of the record or task.
  3. Make the change in the Maintain or Task window.
  4. Save the changes.

Note: You can also open a record or task simply by double-clicking it in the list.

Use the search features to find information on a list. For transactions, such as sales invoices, you can search by Date Range, Status, and/or a particular piece of information. For records, you can search for a particular piece of information.

  1. Select a Date Range and/or Status, if necessary.
  2. Use the Search For field to enter a piece of information about the transaction.
  3. Select the field that this piece of information applies to in the field to the right.
  4. Click Search.
  5. All transactions that have that value in the specified field will be displayed on the grid. All others will disappear. To refresh the list with all transactions, click the Clear button.

Note: This field is not case sensitive. Typing land, for instance, will call up values with land, Land, and LAND for the field specified.

Tip: You can do searches for multiple items also. For instance, you want to find all invoices with an ID between 10200 and 10299. You can type 102 in the Search For field and select Invoice ID. Then click Search. All invoices with 102 as part of the Invoice ID will appear.

  1. Enter the piece of information you are looking for in the Search For field.
  2. Select the type of information from the field to the right.
  3. Click Search.
  4. All records that have that value in the specified field will be displayed on the grid. All others will disappear. To refresh the list with all records, click the Clear button.

Note: This field is not case sensitive. Typing land, for instance, will call up values with land, Land, and LAND for the field specified.

Tip: You can do searches for multiple items also. For instance, you want to find all invoices with an ID between 10200 and 10299. You can type 102 in the Search For field and select Invoice ID. Then click Search. All invoices with 102 as part of the Invoice ID will appear.

  • To print a list

    1. Select the list you want to print.
    2. Click the Print button in the toolbar.
    3. Make your print selections and click Print.

  • To send the list in an email

    1. Display the list you want to email.
    2. Click the Send to button to display a drop-down list of options.
    3. Select the Email option.
    4. Make any selections and click Email.

  • To export the list to Microsoft Excel

    1. Display the list you want to export.
    2. Select Send To in the toolbar.
    3. Select Excel.
    4. Make your selections and click OK.

  • To convert your list to a PDF file

    1. Display the list you want to convert.
    2. Click the Send To button in the toolbar.
    3. Select PDF.
    4. Make your selections and click OK.
    5. Specify where you want to save the list and what its name should be. Then click Save.

A list of the most commonly-used reports for the current list appears in the pane on the left. To view one of these reports, simply click the report name.