Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs 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.
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. They 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. To assign an address, enter or
select
an address code.


NOTE  You must define a summary accounting unit(s) before posting accounting
units.


IMPORTANT  The address fields are dynamic. The address values you are
able to edit and view are determined by the address data that is needed in
your geographical location.





Updated Files

    ADDRDATA   -

    AUMXVALUE  -

    GLADDRESS  -

    GLAUDIT    -

    GLNAMES    -

    MXLISTMBR  -

    MXOBJCAT   -


Referenced Files

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLMASTER   -

    GLSYSTEM   -

    GLZONE     -

    INSTCTRYCD -

    MXCATDEF   -

    MXLISTDTL  -

    MXLISTMBR  -

    MXTMPLDTL  -


GL20.2 - Posting Accounts



Use Posting Accounts (GL20.2) 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.


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

    ADDRDATA   -

    ADMASTER   -

    CUAMOUNT   -

    GLACCTVLD  -

    GLMASTER   -


Referenced Files

    ACACCTCAT  -

    ADAMOUNTSX -

    ADCOMPANY  -

    CUAMOUNT   -

    CUCODES    -

    FBDETAIL   -

    GLACCTVLD  -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLNAMES    -

    GLSYSTEM   -

    GLUNITS    -

    GLZONE     -

    INSTCTRYCD -

    MLGROUP    -

    TRCODES    -


GL20.4 - Mass Add Accounts



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





Updated Files

    ADDRDATA   -

    ADMASTER   -

    GLACCTVLD  -

    GLMASTER   -


Referenced Files

    CUCODES    -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLNAMES    -

    GLSYSTEM   -

    GLZONE     -

    INSTCTRYCD -


GL20.5 - Values By Attribute



Use Values By Attribute (GL20.5) to assign attribute values from one
user-defined attribute to all accounting units. You can only select
user-defined
attribute values for the Accounting Unit (ACCTU) object type attributes
defined
in Attributes (MX00.1).
Unlike Attributes (GL20.7), all accounting units display for a company
and you can include attribute values from only one attribute.





Updated Files

    AUMXVALUE  -

    MXOBJCAT   -


Referenced Files

    GLCGCPY    -

    GLNAMES    -

    MXCATDEF   -

    MXELEMENT  -

    MXVALIDATE -


GL20.6 - System Accounting Units



Use System Accounting Units (GL20.6) to select the accounting units
associated with the system accounts defined using System Accounts (GL00.7).
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.



**Processing Effect

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

    ADDRDATA   -

    GLSYSTEM   -


Referenced Files

    GLADDRESS  -

    GLCHART    -

    GLNAMES    -

    INSTCTRYCD -


GL20.7 - Attributes



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


IMPORTANT  Effective date values cannot be used in lists. To make an
effective date value the value to be used in a list, run Accounting Unit Attr
Value Update For Effective Date (MX135) for the effective date and accounting
unit address level. All values assigned for that effective date display as
the attribute value on GL20.7.





Updated Files

    ADDRDATA   -

    AUMXVALDT  -

    AUMXVALUE  -

    MXOBJCAT   -


Referenced Files

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLNAMES    -

    GLSYSTEM   -

    INSTCTRYCD -

    MXCATDEF   -

    MXELEMENT  -

    MXTMPLDTL  -

    MXTMPLEFDT -

    MXTMPLHDR  -

    MXTMPLHEDT -

    MXVALIDATE -


GL20.8 - Attribute Value Effective Date



Use Attribute Value Effective Date (GL20.8) to assign attribute values
with effective dates to an accounting unit attribute. Only user-defined
attributes
defined for the Accounting Unit (ACCTU) object type on Attribute (MX00.1)
display.
You can use an effective date template defined on Attribute Value Effective
Date Template (MX06.1) to add values with effective dates. Use a template
to quickly and consistently assign new attribute values and effective dates.
If a value exists for an attribute and effective date, any template value
for the same attribute and effective date is ignored. A template does not
replace existing values.
Once you have added the form with a template, the template disappears
from the Copy from Template field, the attribute values added by the template
display on the form, and you can modify them or add more values manually.
If you do not use a template, you can add the values and dates manually.


IMPORTANT  Effective date values cannot be used in attribute
lists. To make an effective date value the value to be used in a list, run
Accounting Unit Attr Value Update For Effective Date (MX135) for the effective
date. and accounting unit address level. All values assigned for that
effective
date display as the attribute value on Attributes (GL20.7).




Updated Files

    ADDRDATA   -

    AUMXVALDT  -

    MXOBJCAT   -


Referenced Files

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLNAMES    -

    GLSYSTEM   -

    INSTCTRYCD -

    MXCATDEF   -

    MXELEMENT  -

    MXTMPLEFDT -

    MXTMPLHEDT -

    MXVALIDATE -


GL20.9 - Values By Attribute Effective Date



Use Values By Attribute Effective Date (GL20.9) to assign an attribute
value to any company and accounting unit for a specified effective date.

Type an effective date in the Effective Date field and type a value
for any company and accounting unit.

You must access this form from Attributes (GL20.1) via Attribute Value
Effective Date (GL20.7). To select another attribute for which you want to
assign effective date values, you must return to GL20.1.


IMPORTANT  Effective date values cannot be used in attribute
lists. For an effective date value to be used in a list, you must run
Accounting
Unit Attr Value Update For Effective Date (MX135) for the effective date.
All values assigned for that effective date display as the attribute values
on Attributes (GL20.7).




Updated Files

    AUMXVALDT  -

    MXOBJCAT   -


Referenced Files

    GLNAMES    -

    MXCATDEF   -

    MXELEMENT  -

    MXVALIDATE -


INVOKED Programs

    IFCU
    IFAC
    ACAC
    ACTA
    API4
    IFLU
    IFOB
    IFUP
    IFSG
    SLSE
    SLSU