Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL97


GL97.1 - Accounts

**Form Purpose
Use Accounts (GL97.1) to view account period and year to date totals.

**More Information
Choose the Cur,Last button to view the current year and last year to date
account amounts.

Choose the Act,Bud button to view actual and budget amounts. You can only use
this function if you selected a budget number in GL95.1

Choose the Currency button to view the year to date company base currency
balance and the year to date account currency balance.

Choose the AcctUnit button to view accounting unit period and year to date
totals.

Choose the Company button to view company period and year to date totals.

Choose the Trans button to view account balances and detail.

Choose the Totals button to view the current fiscal year and last year
beginning balance, period range total, and ending balance.




Updated Files

    RATOTALS   - Used by common library; not referenced by this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve ranges of levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.2 - YTD Current Year vs. Last Year

**Form Purpose
Use YTD Current Year vs. Last Year (GL97.2) to view current and last year to
date amounts for a specific set of accounts.

**More Information
Choose the Period button to view the current year account period amount and
the last year account period amount.

Choose the AcctUnit button to view the current year to date and last year
amounts for accounting units.

Choose the Company button to view the current year to date and last year to
date amounts for a company.

Choose the Trans button to view account balances and detail in GL90.1
(Transaction Analysis).

Choose the totals button to view the current fiscal year and last fiscal year
beginning balance, period range total, and ending balance.




Updated Files

    RATOTALS   - Used in common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve ranges of levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.3 - Periods Current Year vs. Last Year

**Form Purpose
Use Periods Current Year vs. Last Year (GL97.3) to view the current year and
last year period amounts for the accounts you selected in GL95.1 (Account
Analysis).

**More Information
Choose the AcctUnit button to view period and year to date totals for
accounting units.

Choose the Company button to view company period and year to date totals.

Choose the Trans button to view account balances and detail in GL90.1
(Transaction Analysis).

Choose the totals button to view the current fiscal year and last fiscal year
beginning balances, period range totals, and ending balances.




Updated Files

    RATOTALS   - Used by common library; not referenced by this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve ranges of levels, account, and subaccount
                 groups.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.4 - YTD Actual vs. Budget

**Form Purpose
Use YTD Actual vs. Budget (GL97.4) to view actual and budget account amounts.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings account.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve ranges of levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.5 - Periods Actual vs. Budget

**Form Purpose
Use Periods Actual vs. Budget (GL97.5) to view actual and budget amounts in a
period range.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve ranges of levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.6 - YTD Account Currencies

**Form Purpose
Use YTD Account Currencies (GL97.6) to view the company year-to-date base
currency balance and the account year-to-date currency balance.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.7 - Periods Account Currencies

**Form Purpose
Use Periods Account Currencies (GL97.7) to view the period company base
currency amount and the account base currency amount.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.8 - Fiscal Year Summary

**Form Purpose
Use Fiscal Year Summary (GL97.8) to view all year to date period balances for
the company base currency and the account currency.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


GL97.9 - Totals

**Form Purpose
Use Totals (GL97.9) to view the beginning balance, period range balance, and
ending balance for specific account currencies.




Updated Files

    RATOTALS   - Used by common library; not referenced in this program.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.


Referenced Files

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to validate accounts.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate address information.

    GLCGCPY    - Used to access companies associated with a company group.

    GLCHART    - Used to validate undistributed retained earnings accounts.

    GLCHARTDTL - Used to display the account description.

    GLCHARTSUM - Used to validate summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to display account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate an accounting unit list.

    MXLISTMBR  - Used to access accounting units associated with an accounting
                 unit list.

    MXVIEWDTL  - Used to access accounting unit view detail.

    MXVIEWHDR  - Used to validate an accounting unit view.

    RWGRPDET   - Used to retrieve levels, accounts, and subaccounts.

    RWHEADER   - Used to validate level, account, and subaccount groups.

    RWROWDET   - Used by common library; not referenced in this program.

    ULPOST     - Used to access the last posting date and time.


INVOKED Programs

    GLAC
    GLBL
    IFUP
    GLRV
    IFSG
    MLRV