Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

GL20


GL20.1 - Accounting Units-Accounts

Use Accounting Units-Accounts(GL20.1) to define and maintain an accounting
unit for a general ledger company. An accounting unit represents a division,
department, business center, region, store, and so on, depending on your
organizational structure. There are two types of accounting units: Posting and
Summary. Note: You must define a summary accounting unit(s) before posting
accounting units.

Posting accounting units are the lowest level of a general ledger company
structure and are used to create journal entry transactions. Posting
accounting units consist of detail accounts. Detail accounts are used to group
and separate information within the accounting unit. When you create journal
entries, totals are summarized for each detail account within the accounting
unit, creating one total for each posting accounting unit. Each posting
accounting unit total is then summarized for its summary accounting unit.

Summary accounting units consist of posting accounting units. Like a summary
account contains detail accounts. Summary accounting units store consolidated
information from lower level posting accounting units are used for analysis
and summarized reporting.

Define accounting units from the top of your company organizational ladder to
the bottom. This will help you assign the correct level address to each
accounting unit. Define all summary accounting units before defining the
lower-level posting accounting units.

This program contains the following buttons to define your accounting unit
structure.

* Use the Main form tab to define general information about the accounting
unit, including the accounting unit type.

* Use the Levels form tab to define the level address of the accounting unit.
The level address identifies the location of the accounting unit in the
company structure. The levels you define for each company in the Hierarchy
form tab in Company (GL10.1) determine how you define accounting units for
the company. You can also use this form tab to move an accounting unit or an
accounting unit and all of its subordinates by assign a new level address to
an existing accounting unit and then running Level Reorganization (GL120).

* Use the Address form tab to define optional address and communication
information.

* Use the User Fields form tab to define additional information, which can be
used in the Report Writer system.

After you define the accounting unit, use the buttons on the Main form tab to
define additional information, as follows:

Choose the Attributes button to open GL20.7 (Attributes). Use this subform to
assign attribute values to the accounting unit. (You can optionally assign an
attribute template in GL20.1) If you identified the attribute as required in
MX00.3 (Associate Attribute to Object), you must assign attribute values. A
message displays if values are not assigned to attribute fields that are
required. (Note: You can also use MX500 (Attribute Value Population) to assign
attribute values to the accounting unit based on an accounting unit list.)

Choose the Accounts button to open GL20.2 (Posting Accounts). Use this subform
to select the detail accounts used for summarizing and posting information
within the accounting unit. If you use the dynamic account assignment feature
(assigned to a summary account in GL00.5 or a detail account in GL00.4), you
do not need to select accounts manually in this subform. An asterisk displays
next to the button if accounts are  selected.

Choose the System A/U button to open GL20.6 (System Accounting Units). Use the
subform to select the balance sheet accounting unit.

Optional Reports
----------------
Run GL220 (Accounting Unit Listing) to all accounting units defined for a
company.
Run GL221 (Posting Accounts Listing) to list all the posting accounts for
specific accounting units.
Run GL222 (Posting Accounts Listing by Account) to list accounting units for
specific accounts.

Updated Files

    AUMXVALUE  - Stores all the additional user-defined accounting unit
                 attributes maintained by this program.


    GLADDRESS  - Stores the accounting unit address maintained by this program.

    GLAUDIT    - Stores an accounting unit's new variable level when maintained
                 by this program.


    GLNAMES    - Stores the accounting unit definition maintained by this
                 program.


    MXLISTMBR  - Used to validate for the existence of the accounting unit
                 within an accounting unit list.


    MXOBJCAT   - This file is updated with an accounting unit's attribute usage
                 count.



Referenced Files

    GLCGCPY    - Used to validate the existence of the company within a company
                 group.


    GLCHART    - Used to validate the existence of the chart name.

    GLCHARTDTL -

    GLMASTER   - Used to validate the existence of a posting account for the
                 accounting unit.


    GLSYSTEM   - Used to validate the existence of a company.

    GLZONE     - Used to validate the existence of the zone associated to the
                 accounting unit.


    INSTCTRYCD - Used to validate intrastat country codes.

    MXCATDEF   - Used to validate the existence of an attribute.

    MXLISTDTL  - Used to determine if a changed accounting unit attribute is
                 associated to a accounting unit list parameter.


    MXLISTMBR  - Used to validate for the existence of the accounting unit
                 within an accounting unit list.


    MXTMPLDTL  - Used to apply template values to the accounting unit
                 attributes.



GL20.2 - Posting Accounts

Use GL20.2 (Posting Accounts) to select the detail accounts that are valid for
 the accounting unit. If the Exist field displays Yes, then the account is
valid for the accounting unit.

To select individual accounts, select the Add line action next to each account
you want to select, and then choose the Change form action.

To select a page of accounts, select the Add form action, and then page down
to display additional accounts for selection.

To copy selected accounts from another accounting unit, choose the Mass Add
button to open the Mass Add Accounts subform.

To unselect individual accounts, select the Delete line action next to each
account you want to unselect, and then choose the Change form action.

Note: If you use the dynamic account assignment feature by assigning
accounting unit lists to summary or detail accounts in the associated chart of
accounts, you do not need to select accounts manually in this subform.

Updated Files

    CUAMOUNT   - Used to validate the existence of a non-base currency for the
                 posting account.


    GLACCTVLD  - Used to validate the existence of the posting account
                 restriction to a system.


    GLMASTER   - Used to store the posting account definition maintained by
                 this program.



Referenced Files

    ACACCTCAT  - Used to validate the existence of an account category.

    CUAMOUNT   - Used to validate the existence of a non-base currency for the
                 posting account.


    CUCODES    - Used to validate the existence of the currency code.

    FBDETAIL   - Used to validate the existence of the posting account's budget.


    GLACCTVLD  - Used to validate the existence of the posting account
                 restriction to a system.


    GLADDRESS  - This file is accessed by a common routine used by this
                 program.  This file is not used by this program.


    GLAMOUNTS  - Used to validate the existence of a period posting against the
                 posting account.


    GLCHART    - Used to retrieve the chart name.

    GLCHARTDTL - Used to display the available detail accounts which can be
                 assigned to the accounting unit.


    GLCHARTSUM - This file is accessed by a common routine used by this
                 program.  This file is not used by this program.


    GLNAMES    - Used to validate the existence of the accounting unit.

    GLSYSTEM   - Used to validate the existence of the company.

    GLUNITS    - Used to validate the existence of a units posting against the
                 posting account.


    GLZONE     - Used to validate the existence of a zone for the accounting
                 unit.


    MLGROUP    -

    TRCODES    - Used to validate the existence of the translation code.


GL20.4 - Mass Add Accounts

Use GL20.4 (Mass Add Accounts) to copy selected accounts from another
accounting unit or from a chart of accounts.

Updated Files

    GLACCTVLD  - This file is used to validate accounting unit, account, and
                 subsystem information.


    GLMASTER   - This file stores the posting accounts mass added by this
                 program.



Referenced Files

    CUCODES    - Used to validate the existence of a currency code.

    GLADDRESS  - This file is accessed by a common routine used by this
                 program.  This file is not used by the program.


    GLCHART    - Used to retrieve the chart name.

    GLCHARTDTL - Used to determine the detail accounts to be mass added to the
                 accounting unit's posting account list.


    GLNAMES    - Used to validate the existence of the accounting unit.

    GLSYSTEM   - Used to validate the existence of the company.

    GLZONE     - Used to validate the existence of the accounting unit's zone.


GL20.5 - Values By Attribute

Use GL20.5 (Values by Attribute) to assign attribute values from one
user-defined attribute to all accounting units. You can only select
user-defined attribute values for the ACCTU (Accounting Unit) object type
attributes defined in MX00.1 (Attributes).

Unlike GL20.7 (Attributes), all accounting units display for a company and
you can include attribute values from only one attribute.

Updated Files

    AUMXVALUE  - This file stores the user-defined accounting unit attribute
                 values maintained by this program.


    MXOBJCAT   - This file is updated with the accounting unit attribute usage
                 count.



Referenced Files

    GLCGCPY    - This file is used to determine which attribute fields are
                 available to apply values to.


    GLNAMES    - Used to validate the existence of the accounting unit.

    MXCATDEF   - Used to retrieve the attribute description.

    MXELEMENT  - Used to edit the data type of the attribute value.

    MXVALIDATE - Used to edit the values assigned to attributes.


GL20.6 - System Accounting Units

**Form purpose
Use GL20.6 (System Accounting Units) to select the accounting units associated
with the system accounts defined using System Accounts (GL00.7).

**Prerequisites
The accounting units you enter must already be defined.

**Required fields
Balance Sheet is a required field.

**Decision/Impact
If all your system accounts come from the balance sheet section of the chart
of  accounts, you need to enter an accounting unit only in the Balance Sheet
field.

If any of you system accounts come from the income statement section of the
chart of accounts, you must enter accounting units in both the Balance Sheet
field and the Income Statement field.

**More help
The retained earnings and undistributed retained earnings system accounts are
always balance sheet accounts.  Consequently, the General Ledger system always
uses the balance sheet accounting unit when processing transactions that
involve these two accounts.

The other system accounts (error suspense, currency gain, currency
translation, report currency  adjustment and  auto adjustment) can be either
balance sheet accounts or income statement accounts. When processing
transactions that involve these system accounts, the General Ledger system
uses the balance sheet accounting unit for balance sheet system accounts, and
the income statement accounting unit for income statement system accounts.

Updated Files

    GLSYSTEM   - This file is updated with system accounts maintained by this
                 program.



Referenced Files

    GLADDRESS  - This file is accessed by a common routine used by this
                 program.  This file is not used by this program.


    GLAMOUNTS  - Used to validate postings made against the system accounts.

    GLCHART    - Used to retrieve the chart name.

    GLMASTER   - Used to validate the existence of the posting account.

    GLNAMES    - Used to validate the existence of the system accounting units.


GL20.7 - Attributes

Use GL20.7 (Attributes) to assign attribute values to an accounting unit.
Only user-defined attributes defined for the Accounting Unit (ACCTU) object
type in MX00.1 (Attributes) display.

You can assign a template to the accounting units. The template is a group of
attribute values for an object type. You can use a template to quickly and
consistently assign attribute values. The template is defined in MX05.1
(Attribute Template).

Choose the By Attribute button to open GL20.5 (Values by Attribute). Use this
subform to assign attribute values from one Lawson-defined attribute to all
accounting units for a company.

Updated Files

    AUMXVALDT  -

    AUMXVALUE  - Used to store the accounting unit attribute values maintained
                 by this program.


    MXOBJCAT   - Used to store the accounting unit attribute usage counts.


Referenced Files

    GLADDRESS  - This file is accessed by a common routine used by this
                 program.  This file is not used by the program.


    GLCGCPY    - Used to determine which accounting unit attributes to display
                 for value input.


    GLCHART    - Used to retrieve the chart name.

    GLNAMES    - Used to validate the existence of the accounting unit.

    GLSYSTEM   - Used to validate the existence of the company.

    MXCATDEF   - Used to validate the existence of the accounting unit
                 attribute.


    MXELEMENT  - Used to validate the data type of accounting unit attribute
                 values maintained by this program.


    MXTMPLDTL  - Used to create accounting unit attribute values.

    MXTMPLEFDT -

    MXTMPLHDR  - Used to validate the existence of the matrix template.

    MXTMPLHEDT -

    MXVALIDATE - Used to validate the accounting unit attribute values.


GL20.8 - Attribute Value Effective Date

Updated Files

    AUMXVALDT  -

    MXOBJCAT   -


Referenced Files

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLNAMES    -

    GLSYSTEM   -

    MXCATDEF   -

    MXELEMENT  -

    MXTMPLEFDT -

    MXTMPLHEDT -

    MXVALIDATE -


GL20.9 - Values By Attribute Effective Date

Updated Files

    AUMXVALDT  -

    MXOBJCAT   -


Referenced Files

    GLNAMES    -

    MXCATDEF   -

    MXELEMENT  -

    MXVALIDATE -


INVOKED Programs

    IFCU
    IFSG
    IFLU
    IFOB