Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL99


GL99.1 - Organization Query

**Form Purpose
Use Organization Query (GL99.1) to view organization hierarchy for the
company and account selected in GL95.1 (Account Analysis).

**More Information
After you complete the form and press 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 by common library; not referenced in this program.

    RWFORMAT   - Used to validate the format name.

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


Referenced Files

    CMPUTE     - Used to validate a compute statement.

    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 a chart.

    GLCHARTDTL - Used to access detail accounts.

    GLCHARTSUM - Used to access summary accounts.

    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 a Report Writer dictionary name.

    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.


GL99.2 - Periods vs. YTD

**Form Purpose
Use Periods vs. YTD (GL99.2) to view the period range and year-to-date
amounts for specific accounts.

**More Information
Choose the Cur,Last button to view current and last year amounts for specific
accounts you selected in GL99.1.

Choose the Act,But button to view actual and budget amounts for specific
accounts you selected in GL99.1.

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




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

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


GL99.3 - YTD Current Year vs. Last Year

**Form Purpose
Use YTD Current Year vs. Last Year (GL99.3) to view current year-to-date and
previous year amounts.

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

Choose the Act,Bud button to view actual and budget amounts for a specific
account.

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




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

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

    GLCHART    - Used to validate a chart.

    GLCHARTDTL - Used to access detail accounts.

    GLCHARTSUM - Used to access summary accounts.

    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 by this program.

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

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


GL99.4 - Periods Current Year vs. Last Year

**Form Purpose
Use Periods Current Year vs. Last Year (GL99.4) to view the current year
period amounts and previous year amounts.

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




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


GL99.5 - YTD Actual vs. Budget

**Form Purpose
Use YTD Actual vs. Budget (GL99.5) to view the actual year-to-date and the
budget amounts.

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


GL99.6 - Periods Actual vs. Budget

**Form Purpose
Use Periods Actual vs. Budget (GL99.6) to view actual and budget period
amounts.

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




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 access summary accounts.

    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.


INVOKED Programs

    GLAC
    GLBL
    IFUP
    GLRV
    GLVW
    IFSG
    MLRV