Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BL141


BL141 - Base List Worksheet Update

**Form Purpose
Run Base List Worksheet Update (BL141) to take released worksheet price bases
and update these work bases into an existing base or create a new base. The
worksheet price base effective date must be greater than the system date and
the worksheet price must not be zero to allow updating the base.

**Processing Effect
The worksheet(s) processed by this program continue to remain on file and can
be reprinted.

**More Information
Unwanted worksheets can be purged by running BL340 (Base List Worksheet
Purge).




Updated Files

    CKPOINT    - Used to control program restart logic.

    OEBASE     - Item price base records are created and updated by this
                 program.

    OEBPAUDIT  - Audits of changes to base records are stored in this file.

    OEWKSHEET  - Worksheet parameters direct the update of the base records.
                 Status is updated.


Referenced Files

    APCOMPANY  - Used in the vendor Master edit routine.

    APVENGROUP - Used in the vendor Master edit routine.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate inventory locations.

    ITEMMAST   - Used to validate item numbers.

    OECOMPANY  - Used to validate the Billing company.

    OEWKPRICE  - Stores worksheet prices by item.  Source for new prices being
                 updated into
                 the item price base.


INVOKED Programs

    API4
    ACAC
    ACCL
    ACTA
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU