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

List

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

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.
  3. Specify this information:
    Object Type

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

    • Accounts (ACCNT)

    • Accounting Units (ACCTU)

    List

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

    Sort By Attribute tab

    Specify or select the attributes you want to include in 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.

  4. After adding the new list, you automatically navigate back to List (MX10.1). Use this form to define the attribute list.
  5. Specify this information:
    Attribute

    Select the attribute or attributes to include in the template.

    Value range

    For each attribute that you select, specify 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 specify any alphanumeric character to specify 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 respecify 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).
  6. To view the list members, click the Preview button and open Accounting Unit List (GL21.1). You must do this or do a batch update using List Member Build (MX123) if you are going to do dynamic account generation.