Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL95


GL95.1 - Account Analysis

**Form Purpose
Use Account Analysis (GL95.1) to view a wide range of account information for
a company based on specific account and period criteria.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting account information.

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate accounting unit lists.

    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 list.

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

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

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

    ULPOST     - Used to access last posting date and time.


GL95.2 - Fiscal Year Summary

**Form Purpose
Use Fiscal Year Summary (GL95.2) to view the annual current and last year and
year-to-date period amounts or units based on the parameters you select in
GL95.1 (Account Analysis).




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting 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 by common library; not referenced in this program.

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

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


GL95.3 - Totals

**Form Purpose
Use Totals (GL95.3) to view current fiscal year and last fiscal year
beginning balances, period range totals, and ending balances.

Choose the Annual button to view the annual current and last year and year to
date amounts or units.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting  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 by common library; not referenced in this program.

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

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


GL95.4 - Chart Query

**Form Purpose
Use Chart Query (GL95.4) to view specific chart information. Any information
you select overrides the information you selected in GL95.1 (Account
Analysis).

**More Information
After you complete the form and select OK, the Periods vs. Year to Date
subform appears. Use this subform to view period and year-to-date chart
amounts for the year and period you selected in GL95.1 (Account Analysis). In
this subform, you can view additional detail.




Updated Files

    RATOTALS   - Used to store total amounts.

    RWFORMAT   - Used to build a format for use by this program.

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


Referenced Files

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

    CUCODES    - Used to validate currency codes.

    FBCONTROL  -

    FBDETAIL   - Used to access posting account period budget balances.

    FBHEADER   - Used to validate budgets.

    FBTRANS    -

    GLADDRESS  - Used to validate companies.

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting 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.

    RWDICT     - Used to validate data dictionary items.

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

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

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

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


GL95.5 - Periods vs. YTD

**Form Purpose
Use Periods vs. YTD (GL95.5) to view period and year-to-date chart amounts
for the year and period selected in GL95.4 (Chart Query).




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate a budget.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting account information.

    GLNAMES    - Used to access accounting unit information.

    GLSYSTEM   - Used to access company information.

    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 access level, account, or subaccount groups.

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

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

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


GL95.6 - YTD Current Year vs. Last Year

**Form Purpose
Use YTD Current Year vs. Last Year (GL95.6) to view year-to-date amounts for
the current year and the prior year.

**More Information
Choose the Period button to view current and last year amounts for a specific
period.

Choose the Act,Bud button to view year to date and budget amounts for a
specific chart of accounts.

Choose the CSV Export button to create a comma separated value (.csv) file.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate a budget.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access detail account information.

    GLCHARTSUM - Used to access summary account information.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access posting account information.

    GLNAMES    - Used to access accounting unit information.

    GLSYSTEM   - Used to access company information.

    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 access level, account, or subaccount groups.

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

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

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


GL95.7 - Periods Current Year vs. Last Year

**Form Purpose
Use Periods Current Year vs. Last Year (GL95.7) to view period amounts for
the current year and the prior year.

**More Information
Choose the CSV Export button to create a comma separated value (.csv) file.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate a budget.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access a detail account.

    GLCHARTSUM - Used to access a summary account.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access a posting account.

    GLNAMES    - Used to access an accounting unit.

    GLSYSTEM   - Used to access a company.

    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 access level, account, or subaccount groups.

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

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

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


GL95.8 - YTD Actual vs. Budget

**Form Purpose
Use YTD Actual vs. Budget (GL95.8) to view year-to-date and budget amounts
for a specific chart of accounts.

**More Information
Choose the Period button to view current and last year amounts for a specific
period.

Choose the CSV Export button to create a comma separated value (.csv) file.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate a budget.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access a detail account.

    GLCHARTSUM - Used to access a summary account.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access a posting account.

    GLNAMES    - Used to access an accounting unit.

    GLSYSTEM   - Used to access a company.

    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 access level, account, or subaccount groups.

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

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

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


GL95.9 - Periods Actual vs. Budget

**Form Purpose
Use Periods Actual vs. Budget (GL95.9) to view period range actual and budget
totals for a specific chart of accounts.

**Processing Effect
Choose the CSV Export button to create a comma separated value (.csv) file.




Updated Files

    RATOTALS   - Used to store total amounts.

    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 access posting account period budget balances.

    FBHEADER   - Used to validate a budget.

    FBTRANS    -

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

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

    GLCHART    - Used to validate the chart.

    GLCHARTDTL - Used to access a detail account.

    GLCHARTSUM - Used to access a summary account.

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   - Used to validate a company group.

    GLMASTER   - Used to access a posting account.

    GLNAMES    - Used to access an accounting unit.

    GLSYSTEM   - Used to access a company.

    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 access level, account, or subaccount groups.

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

    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
    GLCV