|
|
GL20.1 - Accounting Units-Accounts
**Form Purpose
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.
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
**Form Purpose
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
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
**Form Purpose
Use Mass Add Accounts (GL20.4) 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
**Form Purpose
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 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 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
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.
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.
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
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
|
