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
ADMASTER -
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.
ADAMOUNTSX -
ADCOMPANY -
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.
GLCHART - Used to retrieve the chart name.
GLNAMES - Used to validate the existence of the system accounting units.
GL20.7 - Attributes
**Form purpose
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.
**Decision/impact
You can assign one of two types of templates to the accounting units. A
template is a group of attribute values for an object type. You can use a
template to quickly and consistently assign new attribute values. A template
does not replace existing values.
- You can use an attribute value template defined on Attribute Template
(MX05.1) to add values that are not date-dependent. In an attribute value
template, an attribute can be assigned only one value. If you assign an
attribute value template to an accounting unit, the values for each affected
attribute display on this form. The template name disappears from the Use
Attribute Value Template field and you can modify the template values or add
new values on this form.
- You can use an effective date template defined on Attribute Value
Effective Date Template (MX06.1) to add values with effective dates. In an
attribute value effective date template, an attribute can be assigned multiple
values with multiple effective dates. If you assign this type of template, an
asterisk displays next to the Eff Date button of the affected attributes.
Choose this button to display the values and effective dates assigned by the
template. You can modify the values and dates, as long as you do not assign
the same effective date to multiple values of the same attribute.
If you do not assign a template, you can type a value for any of the
attributes using GL20.7, or you can choose the Eff Date button to open
Attribute Value Effective Date (GL20.8) to assign one or more values and
effective dates to an attribute.
Choose the By Attribute button to open Values by Attribute (GL20.5). Use this
subform to assign attribute values for one Lawson-defined attribute to any
company and accounting unit.
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
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
**Form purpose
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.
**Decision/impact
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.
Choose the By Attribute Date button to open Values By Attribute Effective
Date (GL20.9) and assign an attribute value and effective date to any company
and accounting unit.
**More help
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
AUMXVALDT -
MXOBJCAT -
Referenced Files
GLADDRESS -
GLCGCPY -
GLCHART -
GLNAMES -
GLSYSTEM -
MXCATDEF -
MXELEMENT -
MXTMPLEFDT -
MXTMPLHEDT -
MXVALIDATE -
GL20.9 - Values By Attribute Effective Date
**Form purpose
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
IFSG
IFLU
IFOB
|
