Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BL123


BL123 - Subsystem Update

**Form Purpose
Run Sub-System Update (BL123) to update the status of invoices and credit
memos that have been printed.

**Processing Effect
The following updates take place. Invoices are interfaced into the Accounts
Receivable application. You run AR560 to update the Accounts Receivable
application. 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 application.




Updated Files

    ADDRDATA   -

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

    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     -

    JBOOKHDR   -

    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.

    TERMS      - Used to validate Terms Code.  If this is the firs time the
                 Terms Code is
                 referenced, the used flag is set.

    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.

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

    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.

    CUCONV     -

    CURELAT    -

    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.

    JBKOPCODE  -

    JBKSYSCODE -

    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

    ARLL
    ACAC
    ACCL
    ACTA
    API4
    IFAC
    IFAU
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    IFRS
    IFSC
    BLI1
    IFFC
    IFGT
    GLCC
    SLSB
    SLSS
    IFJR
    SLFD