Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

EE520

EE520 - Expense Interface

Run EE520 (Expense Interface) to interface employee expense and expense
distribution information from a desktop application or a non-Lawson system to
the Lawson Employee Expense system. The program also updates the Lawson
Accounts Payable system for released (open) status expenses that you
interface.

After the appropriate expense information has been loaded into the interface
files, run EE520 to edit the information for completeness and accuracy,
create new expense and expense distribution records in the Lawson Employee
Expense system, and purge the corresponding records from the interface files.

You can use EE52 (Expense Update) to maintain expense and distribution
information in the expense interface files before you run EE520 or after you
run EE520 to correct records that did not interface.

You can maintain unreleased expense records in EE20.2 (Expense Entry) after
you interface them.


Updated Files

    ACCOMMIT   - Creates activity commitments detail.

    ACCOMMITX  - Creates the activity commitments transactions.

    APDISTRIB  - Creates accounts payable distribution if the expense is a
                 released status.

    APHLDINV   - Creates records of vendors, invoices, and payments that are on
                 hold.

    APINVOICE  - Creates accounts payable invoice if the expense or advance is
                 a released status.

    APMONITOR  - Creates monitor record.

    APPAYMENT  - Creates accounts payable payment record if expense or advance
                 is released status.

    APUAVAL    - Updates user analysis information.

    APVENBAL   - Increases the purchase amount, current balance, and
                 potentially the high balance when the advance or expense is
                 released.

    CBBANKINST - Validates payment code and updates used flag.

    CBCASHCODE - Validates cash code and updates used flag.

    CBCPYCASH  - Validates company cash and updates used flag.

    CKPOINT    - Used to store restart information.

    EEADVANCE  - Creates advance record.

    EECDISTRIB - Deletes conversion distribution record.

    EECEXPENSE - Deletes conversion expense record.

    EEDISTRIB  - Creates employee expense distribution records.

    EEEXPENSE  - Creates expense record.

    EEMATCHING - Creates and updates employee matching records.

    EEUAVAL    - Updates user analysis information.

    JBOOKHDR   - Used to validate system control journal books for a company.

    TXCODEMAST - Validates tax code master.

    TXCOMPANY  - Validates tax company.

    TXTAXCODE  - Validates tax code.

    TXTAXTABLE - Validates the tax table.

    TXTAXTRAN  - Creates tax transactions where applicable.


Referenced Files

    ACACCTCAT  - Validates the activity account category.

    ACACTGRP   - Validates the activity group.

    ACACTIVITY - Validates the activity.

    ACCAL      - Validates the activity calendar information.

    ACCALX     - Validates activity detailed calendar information.

    APACCRCODE - Validates invoice accrual code.

    APAPPROVAL - Not used; see employee expense approval file.

    APCOMPANY  - Validates the activity account category.

    APCPYVND   - Lookup file for default codes on the advance or expense.

    APHOLDCODE - Validates hold code.

    APPAYGROUP - Validates pay group.

    APPROCLEV  - Validates and defaults process level information.

    APVENCLASS - Validates vendor (employee) class.

    APVENGROUP - Validates vendor group.

    APVENLOC   - Validates vendor (employee) location.

    APVENMAST  - Validates the vendor master.

    CBUSER     - Validates user can access cash code.

    CBUSRCLASS - Validates all users for cash code.

    CUCONV     - Used for currency calculations.

    CURELAT    - Validates currency relationship.

    EEAPPROVAL - Validates whether expense or advance needs approval.

    EECATEGORY - Validates expense category.

    EEUACATEG  - Maintains user analysis information.

    GLADDRESS  - Validates and displays company information.

    GLCHART    - Validates general ledger accounts.

    GLCODES    - Validates posting date availability.

    GLINTCO    - Validates intercompany relationship.

    GLSYSTEM   - Validates general ledger company.

    JBKOPCODE  - Used to validate the operator's access to the system control
                 journal books.

    JBKSYSCODE - Used to validate that system journal books can be applied to
                 the general ledger system.

    SYSTEMCODE - Validates the system code updating general ledger and updates
                 the object ID.

    TXTAXRATE  - Retrieve tax rate based on tax code and date.

    WFSETUP    -


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    SLSS