Defining ledgers

A ledger is a summary of Strategic Ledger data. Strategic Ledger transactions are posted and summarized to a ledger based on the criteria defined in a ledger and the period end dates defined for the Strategic Ledger calendar included in the ledger.

A ledger can include a company or company group, a chart, company and accounting unit, or account and subaccount combinations (GL), user analysis values (SL), as well as attributes and values (MX).

You can define and use multiple ledgers, and you can also organize each ledger to accommodate different reporting needs.

Before you can define a strategic ledger, you must complete each Lawson Application's processing cycle where you have included the user analyses.

Follow these steps to define a ledger:

  1. Access Strategic Ledger (SL50.1).
  2. In the Ledger field, specify a ledger and a description that you want to define or maintain. Each page of the form acts like a filter that limits the transactions that are included in the ledger. Consider these form pages.
  3. Use the Basic page to assign a calendar, select optional general ledger data, and identify the currency that you will include in the transactions. Transactions are summarized based on the period end dates defined for the Strategic Ledger calendar. Use these guidelines to specify the field values:
    Calendar

    Specify or select the calendar that you will include in the ledger. The calendar identifies the posting periods.

    Org Dimension

    (Optional) Select the Organization Dimension that you will include in the ledger.

    Acct Dimension

    (Optional) Select the Accounts Dimension that you will include in the ledger.

    Amount Type

    (Optional) Select the currency type that you will include in the ledger. The default setting is Base, which includes transactions associated with the company base currency, report currency one, and report currency two.

    Currency

    (Optional) Select the currency code that you will include in the ledger. For example, if you select USD (US Dollars), then the ledger will only include transaction amounts with that currency code associated. You can select the company base, Report Currency One, or Report Currency Two code.

    If you leave this field blank, then all the transactions associated with all currency codes are included.

    Create Drills

    The Create Drills field determines if drill data file records are created for the ledger.

  4. Use the Ledger Segments page to select the user analysis fields, attributes, and general ledger company and accounting unit or account and subaccount that you want to include in the ledger. For example, if you select Company AcctUnit in the GL field, then the transactions are included for all accounting units defined for the company you selected in the Basic form tab.
    User Analysis

    Select the user analysis that you will include in the ledger.

    Attribute

    (Optional) Select the attribute that you will include in the ledger. You can select attributes defined as SLTRN attributes.

    GL

    (Optional) Select the General Ledger information that you are associating with the ledger. You can select to include the Company and Accounting Unit(s) or the Account(s) and Subaccount(s).

    If you select Company and Accounting Unit(s), then you must select a company or company group on the Basic tab.

    If you select Account(s) and Subaccount(s), then you must select a chart of account on the Basic tab.

  5. Use the Selects page to identify a specific user analysis or an attribute range to include in the ledger. The user analysis fields or attribute that you select in this form tab do not have to match the user analysis fields or attributes that you select in the Ledger Segments form tab.
    User Analysis

    You can specify or select the user analysis that you will include specific values for in the ledger. Select the specific user analysis values in the Value Range field.

    If you select a user analysis, then leave the Attribute field blank.

    Attribute

    You can specify or select the attribute that you want to include specific values for in the ledger. Select the specific attribute values in the Value Range field.

    If you select an attribute, then leave the User Analysis field blank.

    Value Range

    You can include a specific range of user analysis or attribute values in the ledger. Specify or select the beginning value in this field.

    If you only want to include the value that you define in this field, then leave the Through Value field blank.

    To include all user analysis or attribute values, use the Ledger Segments form tab.

    Or Group

    This field defines an AND/OR condition between the attributes. This determines if the attributes are grouped or treated individually.

    If you leave this field blank, then AND is set as default, which connects two statements with an AND condition. You can specify 1 to indicate OR, which defines an OR condition.

  6. Select Add to add the ledger.
    Note: You can use Strategic Ledger Delete (SL350) to delete a ledger.
Related topics