Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL90


GL90.1 - Transaction Analysis

**Form Purpose
Use Transaction Analysis (GL90.1) to view transactions for a posting account,
view transaction amounts and detail, track transaction attributes by source
code, mark posted transactions as reconciled, and view transaction totals.

The journal entry status displays. Unreleased indicates the journal entry has
not been released and changes can be made. Released indicates the journal
entry is released and changes cannot be made. History indicates the journal is
released and posted.




Updated Files

    ADDRDATA   -


Referenced Files

    CUAMOUNT   - This file is updated with a posting account period balance.

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

    GLAMOUNTS  - Used to access a posting account period balance.

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

    GLCHARTDTL - Used to access a detail account description.

    GLCONTROL  - Used to access journal entry information.

    GLMASTER   - Used to access posting account information.

    GLNAMES    - Used to access accounting unit information.

    GLSYSTEM   - Used to access company information.

    GLTRANS    - Used to access journal entry transactions.

    GLUNITS    - Used to access posting account period unit balances.

    INSTCTRYCD -


GL90.2 - Transaction Totals

**Form Purpose
Use Transaction Totals (GL90.2) to view transaction totals for the account
number you selected on the main form.

After you select the transaction type and status, the number of transactions
and total amount display.




Updated Files

    ADDRDATA   -


Referenced Files

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

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

    GLCONTROL  - Used to access journal entry information.

    GLMASTER   - Used to access posting account information.

    GLSYSTEM   - Used to access company information.

    GLTRANS    - Used to access journal entry transaction information.

    INSTCTRYCD -


GL90.3 - Filter

**Form Purpose
Use Filter (GL90.3) to select specific criteria that limits the transactions
that display. The Enable Filter field lets you enable and disable specific
criteria.

For example, you can view unreleased transactions that have a Base currency,
in GL, with a journal book assigned to it.




Updated Files

    ADDRDATA   -


Referenced Files

    ACACTIVITY - Used to access activity description.

    CUCODES    - Used to access currency code information.

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

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

    GLSYSTEM   - Used to access company information.

    INSTCTRYCD -

    SYSTEMCODE - Used to validate system code.


GL90.4 - Reconcile Transactions

**Form Purpose
Use Reconcile Transactions (GL90.4) to mark posted transactions as reconciled
for audit purposes.

Mark transactions as reconciled when both records in different systems are
the same. This indicates you are typically finished with the transaction.




Updated Files

    ADDRDATA   -

    GLTRANS    - This file is updated with a transaction's reconciliation code
                 maintained by this program.



Referenced Files

    CUAMOUNT   - This file is updated with a posting account period balance.

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

    GLAMOUNTS  - Used to access a posting account period balances.

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

    GLCODES    - Used to access system code information.

    GLMASTER   - Used to access posting account information.

    GLNAMES    - Used to validate the existence of accounting units.

    GLSYSTEM   - Used to access company information.

    GLUNITS    - Used to access posting account period unit balances.

    INSTCTRYCD -


GL90.5 - Nulls

**Form Purpose
Use Transaction Currency Analysis (GL90.5) to view the currency code
transaction count, the total transaction amount and the total units for each
transaction currency when Transaction Currency is selected on the Filter
(GL90.3).




Updated Files

    ADDRDATA   -


Referenced Files

    GLADDRESS  -

    GLCHART    -

    GLCONTROL  -

    GLMASTER   -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -


GL90.6 - Compare Transaction Analysis

Updated Files

    ADDRDATA   -

    RATOTALS   -

    ULTOTALS   -


Referenced Files

    CUAMOUNT   -

    CUCODES    -

    FBDETAIL   -

    FBHEADER   -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCGCPY    -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCOMMITX  -

    GLCONTROL  -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  -

    MXLISTMBR  -

    MXVIEWDTL  -

    MXVIEWHDR  -

    RWGRPDET   -

    RWHEADER   -

    RWROWDET   -

    ULPOST     -


INVOKED Programs

    IFCU
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFLU
    IFOB
    IFAU
    IFSG
    SLSE
    SLSU
    GLAC
    GLBL
    IFUP
    GLRV
    MLRV