Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

BL123


BL123 - Sub-System Update

This program updates the status of invoices and credit memos that have been
printed.  The following updates take place.  Invoices are interfaced into the
Accounts Receivable system.  You run AR560 to update the Accounts Receivable
system.  Secondly, journal entries are created (in detail):
           Sales
           Discounts
           Freight
           Inventory (for returns)
           Miscellaneous charges
           Sales tax
           Cost of Goods Sold
           Accounts receivable

The Order Entry Distribution file is updated and used by BL293 (GL
Distribution Report) to list journal entries created by the system.

Updated Files

    ARCODE     - Used to validate Accounts Receivable codes.  If this is the
                 first time the Accounts Receivable code is
                 referenced, the used flag is set.

    ARIDISTRIB -

    ARIITEM    - Used in the customer edit routine.

    ARITRANS   - Primary updated by this program.  Accounts Receivable invoices
                 are stored in
                 this file.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.  If
                 this is the first
                 time the process level is referenced, the used flag is set.

    CKPOINT    - Used to control program restart logic.

    CUSTEP     -

    EPTYPE     -

    OECOMPANY  - Used to validate the Billing company.

    OEDIST     - Primary file updated by this program.  Billing distribution
                 records are
                 created.

    OEINVCTYPE - Used to validate invoice types.

    OEINVOICE  - Invoice status is updated to Ready To Purge after processing
                 by this program.

    OEINVSGBLK -

    OEPROCLEV  - Used to validate the Billing process level.

    SYSTEMCODE - Used by the General Ledger system edit routine.

    TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
                 the tax code is used.

    TXCOMPANY  - Stores company information and which tax system the company
                 uses. Includes general ledger accounts if they are defined at
                 the company level.

    TXTAXCODE  - Used to validate tax codes.  Also provides General Ledger
                 account for sales
                 tax postings.


Referenced Files

    ACCUSTOMER -

    AGINGCODE  - Used in the Accounts Receivable customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARADJUST   -

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the Accounts Receivable customer edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable customer edit routine.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.

    ARLOCKBOX  - Used in the Accounts Receivable customer edit routine.

    AROIHDR    -

    AROITEMS   - Used in the Accounts Receivable customer edit routine.

    ARPAYMENT  - Used in the Accounts Receivable customer edit routine.

    COCOMP     - Used to store components for a shipment line if the item
                 shipped is a kit.

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTORDER  - Used to print customer order information.

    EPTRANS    -

    FROPTIONS  -

    GLADDRESS  - Used in General Ledger account edit routine.

    GLCHART    - Used in the General Ledger account verification routine.

    GLSYSTEM   - Used in the General Ledger account edit routine.

    ICCATEGORY - Used to obtain inventory account for stock lines.

    ICCOMPANY  - Used to validate the Inventory Control company.

    INSTCTRYCD -

    ITEMLOC    - Used to validate the Inventory Control item location.

    ITEMMAST   - Used to validate Inventory Control item numbers.

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OECOMPREF  -

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OECUSTITEM - Used to store customer item numbers for Inventory Control item
                 numbers.

    OEFRTCODE  - Used to validate freight codes.

    OEINVCLINE - Used to print invoice line information.

    OEINVCMISC - Used to print invoice add-on charge information.

    OEINVCTAX  - Used to print invoice sales tax information.

    OEMISC     - Used to validate add-on charges.

    OEORDDISC  - Used to validate order discount codes.

    OESLSACCT  - Used to obtain sales and cost of goods sold accounts for stock
                 and non-stock
                 invoice lines, and cost of goods offset account for non-stock
                 lines.

    PBBILL     -

    PBHSTHDR   -

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    TXTAXRATE  - Used in the tax code edit routine.

    TXTAXTABLE - Used in the tax code edit routine.

    WFSETUP    -

    WHSHIPCOMP - Used to store the make-to-order kit components to be shipped
                 for this ship line.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.


INVOKED Programs

    BLI1
    IFAC
    ACAC
    ACCL
    IFCU
    IFSG
    IFAU
    SLSE
    SLSU
    IFFC
    IFGT
    GLCC
    IFOB
    IFRS
    IFSC
    SLSB
    PHI3
    SLFD