Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

GL65


GL65.1 - Transaction Interface Maintenance

**Form Purpose
Use Transaction Interface Maintenance (GL65.1) to view and maintain journal
entry data you are converting from a non-Lawson environment (a spreadsheet for
example) to the Lawson General Ledger system. This form is used to verify your
information transferred to the Lawson system correctly.

**More Information
To transfer the non-Lawson file to the target machine, use a transfer utility
program (such as the winptxfr or ftp command). When you transfer the
non-Lawson file, you rename the file for use in the Lawson system. For
example, if you are transferring from Excel, use

winptxfr -u filename c:\\Data\\Excel\\excelfilename

where filename represents the Lawson file.

To view the information in this form, use an Import command, such as
(importdb productline GLTRANSREL filename) load the transactions file into the
GLTRANSREL (General Ledger Transaction Interface) file, where filename is the
name you assigned when you transferred the file to the Lawson system. After
you run the Import command, use the Next or Previous form actions to view your
data.

You must associate the transaction information in this form with an
Organization and Account Code. The organization code identifies the Lawson
company and accounting unit where the converted transaction information is
stored. The account code identifies the Lawson account and subaccount where
converted transaction information is stored. Use GL08.1 (Organization
Relationship) to define the organization code and GL09.1 (Account
Relationship) to define the account code.

Run GL165 (Transaction Interface) to load the journal entry transaction
information from this form into GL45.1 (Journal Control).

Run GL265 (Transaction Interface Listing) to list transaction records before
running GL165.




Updated Files

    GLTRANSREL - This file stores the interfaced journal transactions
                 maintained by this program.


    JBOOKHDR   - Used to validate a journal book.


Referenced Files

    CUCONV     - Used to validate exchange rates.

    CURELAT    - Used to validate currency relationships.

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLACCTREL  - Used to validate account relationships.

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

    GLAMOUNTS  -

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

    GLCHARTDTL - Used to validate a detail account.

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

    GLCODES    - Used to validate system codes.

    GLCOMMIT   -

    GLCOMPREL  - Used to validate organization relationships.

    GLINTCO    - Used to validate intercompany relationships.

    GLMASTER   - Used to validate posting accounts.  This file is updated if
                 dynamic account generation is used.

    GLNAMES    - Used to validate accounting units.

    GLSRCCODE  - Used to validate source codes.

    GLSYSTEM   - Used to validate companies.

    GLTRANS    -

    JBKOPCODE  - Used to validate a journal book/operator relationship.

    JBKSYSCODE - Used to validate a journal book/system code relationship.

    MLCALMAP   -

    MLCOLEDGER -

    MLLEDGER   -

    MXCATDEF   - Used to validate an attribute.

    MXOBJCAT   - Used to validate an attribute/object type relationship.

    MXVALIDATE - Used to validate an attribute value.

    SYSTEMCODE -


GL65.3 - Report Currency Entry

**Form Purpose
Use Report Currency Entry (GL65.3) to include report currency amounts with
the transaction.

Note If a report currency name and code does not appear on this form, use
GL10.1 (Company) to define the report currency codes for the company you are
converting transactions to.




Updated Files

    None.


Referenced Files

    GLADDRESS  - Used to update general ledger address information.

    GLCHART    - This file is updated for chart of accounts.

    GLSYSTEM   - This file updates company information.


INVOKED Programs

    IFAC
    ACAC
    ACCL
    IFCU
    IFSG
    IFAU
    SLSE
    SLSU
    IFSC
    IFTR