Defining an Automatic List

An automatic list is a group of accounts or accounting units that have common attribute values. You can use automatic lists to select a collection of accounts or accounting units for reporting or inquiry. Use this procedure to create an automatic list. You can also create a manual list. Defining a Manual List

Attributes must exist before you can use them in a list. You should also assign values to any accounting unit or account that will become a member of the list.

To define an automatic attribute list

  1. Access List (MX10.1).
  2. Click the New List button to access Define List (MX10.2) where you will define header information for the new list. Use the following guidelines to enter field values:
    Object Type

    An attribute list must be associated with an object type. For General Ledger, you can assign the following object types:

    • Accounts (ACCNT)

    • Accounting Units (ACCTU)

    List

    Type a name and description for the new list you want to define.

    Sort By Attribute tab

    Type or select the attributes you want to use to sort the list. You can only select from the attributes defined for the object type.

    Audit tab

    Use the Audit tab to display the user identification of the person that created the list, the date it was last changed, and when the list was updated last.

  3. After adding the new list, you automatically navigate back to List (MX10.1). Use this form to define the attribute list. Use the following guidelines:
    Attribute

    Select the attribute or attributes to include in the list.

    Value range

    For each attribute that you select, enter a value range.

    Or Group

    If you leave this field blank, the relationship between the attributes is an AND relationship, meaning that an account or accounting unit will belong to the list if it satisfies all the attribute values. You can type any alphanumeric character to indicate an OR relationship, meaning that an account or accounting unit will belong to the list if it satisfies any of the attribute values. See Or Group Logic Tables.

    Note: If you need to change the Or Group field value, you must first delete the attribute line, then re-enter it with the new Or Group value.
    Note: As long as the list remains automatic, it gets updated each time that you click the Preview button, use it on a Report Writer report, or use it on Account Analysis (GL95.1).
  4. To view the accounting unit list members, click the Preview button and open Accounting Unit List (GL21.1). To view the account list members, click the Preview button and open Query Account List Members (GL22.1). You must do this or do a batch update using List Member Build (MX123) if you are going to do dynamic account generation.