Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL95


GL95.1 - Account Analysis



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

    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     -


GL95.2 - Fiscal Year Summary



    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
Account Analysis (GL95.1).




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     -


GL95.3 - Totals



    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

    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     -


GL95.4 - Chart Query



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



**More Information

    After you complete the form and click 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     -


GL95.5 - Periods versus Year to Date



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




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     -


GL95.6 - Year to Date Current Year versus Last Year



    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

    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     -


GL95.7 - Periods Current Year versus Last Year



    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

    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     -


GL95.8 - Year to Date Actual versus Budget



    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

    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     -


GL95.9 - Periods Actual versus Budget



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

    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
    IFOB
    IFSG
    MLRV
    GLCV