Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL97


GL97.1 - Accounts



    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

    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     -


GL97.2 - Year to Date Current Year versus Last Year



    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
Transaction Analysis (GL90.1).
    Choose the totals button to view the current fiscal year and last fiscal
year beginning balance, period range total, and ending balance.




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     -


GL97.3 - Periods Current Year versus Last Year



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



**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
Transaction Analysis (GL90.1).
    Choose the totals button to view the current fiscal year and last fiscal
year beginning balances, period range totals, and ending balances.




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     -


GL97.4 - Year to Date Actual versus Budget



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




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     -


GL97.5 - Periods Actual versus Budget



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




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     -


GL97.6 - Year to Date Account Currencies



    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

    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     -


GL97.7 - Periods Account Currencies



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




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     -


GL97.8 - Fiscal Year Summary



    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

    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     -


GL97.9 - Totals



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




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