Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL99


GL99.1 - Organization Query



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



**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 Account Analysis (GL95.1). In
this subform, you can view additional detail.




Updated Files

    ADDRDATA   -

    RATOTALS   -

    RWFORMAT   -

    ULTOTALS   -


Referenced Files

    CMPUTE     -

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTHDR  -

    MXLISTMBR  -

    MXOBJCAT   -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWDICT     -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


GL99.2 - Periods versus Year to Date



    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

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


GL99.3 - Year to Date Current Year versus Last Year



    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

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


GL99.4 - Periods Current Year versus Last Year



    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

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


GL99.5 - Year to Date Actual versus Budget



    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

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


GL99.6 - Periods Actual versus Budget



    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

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUCODES    -

    FBCONTROL  -

    FBDETAIL   -

    FBHEADER   -

    FBTRANS    -

    GLADDRESS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


INVOKED Programs

    GLAC
    GLBL
    IFUP
    GLRV
    GLVW
    IFOB
    IFSG
    MLRV