Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

BL20

BL20.1 - Invoice Entry

Shipment-related invoices are created within the Order Entry system by running
OE129 (Daily Shipment Journal) for orders that have been shipped to the
customer.

Use this form to manually enter and update invoices, billing  adjustments, and
credit memos. To correct an invoice from a shipment, use this form to change
information such as price, comments, or freight charges. If there are fields
on the shipment related invoice that cannot be changed, you can delete the
invoice and update the order in the Order Entry system to reflect the correct
information. After you correct the order, you can create corrected invoices
the next time you run OE129.

After you define the invoice, use the buttons on this form, BL20.1 (Invoice
Entry), to define additional information, as follows:

If you want to add details to help with the processing of the invoice, you can
choose the Invoice Opts Button.

If you must invoice at more than one process level or want to create copies of
unreleased invoices or credit memos with other changed header information, you
can choose the Copy button. For example, to create a new invoice for a
different process level, you can inquire on an unreleased invoice or credit
memo, choose the Copy button, and change the process level.


Updated Files

    ACCOMMIT   - Stores commitments not yet posted to the general ledger and
                 keeps commitment balances.


    ACCOMMITX  - Stores commitments not yet posted to the general ledgers and
                 keeps commitment detail.


    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.

    CBBANKINST - Used to validate the payment code.

    HOLDCODES  - Used to validate the hold code.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer codes.

    OEINVCCOMM - Used to store comments associated with an invoice or its line
                 items.


    OEINVCDTL  - Used to store lot/serial information for an invoice line for
                 subsequent printing


    OEINVCLINE - Used to store all information for an invoice line.

    OEINVCMISC - Used to store all information for an add-on charge attached to
                 an invoice or
                 invoice line.


    OEINVCTAX  - Used to store tax amounts calculated when the invoice is
                 released.


    OEINVCTYPE - Used to validate invoice type.

    OEINVCUOM  - Used to store invoice line pricing information when the line
                 has been priced
                 via multiple units of measure.


    OEINVHDR   - Invoice Batch Header file.  Created when an invoice is added,
                 if it does not
                 already exist.  Batch totals are updated as invoices are added
                 for the batch.



    OEINVOICE  - Stores all information for an invoice.

    OEINVSGBLK - Stores user analysis values for processing through the
                 Strategic Ledger system.


    OEMISC     - Used to validate the Billing add-on charge code.

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    SALESREP   - Used to validate sales representatives.

    TERITORY   - Used to validate territories.

    TERMS      - Used to validate Accounts Receivable terms.

    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.

    TXTAXTABLE - Used in the tax code edit routine.


Referenced Files

    ACACCTCAT  - Used in the Activity Management edit routines.

    ACACTGRP   - Used in the Activity Management edit routines.

    ACACTIVITY - Used to validate the Activity Management activity
                 code.


    ACCAL      - Used in the Activity Management edit routines.

    ACCALX     - Used in the Activity Management edit routines.

    AGINGCODE  - Used in the customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the customer edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable company edit routine.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

    AROIHDR    - Used in the customer edit routine.

    ARPAYMENT  - Used in the customer edit routine.

    BILLTO     - Used to validate the customer bill to entered on the
                 order.


    COLINE     - Used to verify customer order line information.


    COLINEUOM  - Used to verify order line multiple pricing units of
                 measure.


    COMISC     - Used to verify order and order line add-on
                 charges.


    CUCONV     - Used for currency editing.

    CURELAT    - Used to validate currency relationships.

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTORDER  - Used to validate customer orders.

    GLCODES    - Used in the General Ledger edit routines.

    GLSYSTEM   - Used in the General Ledger edit routines.

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the inventory control location.

    INSTCTRYCD - Used to validate the Intrastat country code.

    INSTREGN   - Used to validate the Intrastat region code.

    ITEMADDON  - Used in the order line edit routine.  Automatically adds
                 add-on charges to an order when an item is ordered.


    ITEMLOC    - Used to validate the Inventory Control item location.

    ITEMMAST   - Used to validate the inventory control item.

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECREDCARD - Used to validate credit card types.

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OEDISCOUNT - Used to validate discount codes and provide discount
                 information for the pricing routine.


    OEFRTCODE  - Used to validate freight codes.

    OEORDCMNT  - Used to store order comments related to customer order(s) or
                 customer order line(s).


    OEPLCLASS  - Used to store sales class pricing parameters for price list,
                 promotion, and contract.


    OEPLITEM   - Used to store item pricing parameters for price list,
                 promotion, and contract.


    OEPRCLIST  - Used to store default pricing parameters for price list,
                 promotion, and contract.


    OESLSACCT  - Used to obtain invoice line accounts for inventoried and
                 non-stock line
                 types.


    OPERATOR   -

    ORDERTYPE  - Used to validate order types.

    SHIPTO     - Used to validate ship-to numbers.

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    SYSTEMCODE - Used by the General Ledger system edit routine.

    TXTAXRATE  - Used in the tax code edit routine.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.


    WHSHIPMENT - Used to store shipment header information.


BL20.3 - Invoice Add On Charges

Use this subform to attach add-on charges to an invoice.  Define add-on
charges using BL09.1 (Add-on Charges).

Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ARCODE     - Used to validate Accounts Receivable codes.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    CBBANKINST - Used to validate the payment code.

    HOLDCODES  - Used to validate the hold code.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer codes.

    OEINVCCOMM - Used to store comments associated with an invoice or its line
                 items.


    OEINVCDTL  - Used to store lot/serial information for an invoice line for
                 subsequent printing


    OEINVCLINE - Used to store all information for an invoice line.

    OEINVCMISC - Used to store all information for an add-on charge attached to
                 an invoice or
                 invoice line.


    OEINVCTAX  - Used to store tax amounts calculated when the invoice is
                 released.


    OEINVCTYPE - Used to validate invoice type.

    OEINVCUOM  - Used to store invoice line pricing information when the line
                 has been priced
                 via multiple units of measure.


    OEINVHDR   - Invoice Batch Header file.  Created when an invoice is added,
                 if it does not
                 already exist.  Batch totals are updated as invoices are added
                 for the batch.



    OEINVOICE  - Stores all information for an invoice.

    OEINVSGBLK - Stores user analysis values processed through the Strategic
                 Ledger system.


    OEMISC     - Used to validate the Billing add-on charge code.

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    SALESREP   - Used to validate sales representatives.

    TERITORY   - Used to validate territories.

    TERMS      - Used to validate Accounts Receivable terms.

    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.

    TXTAXTABLE - Used in the tax code edit routine.


Referenced Files

    ACACCTCAT  - Used in the Activity Management edit routines.

    ACACTGRP   - Used in the Activity Management edit routines.

    ACACTIVITY - Used to validate the Activity Management activity
                 code.


    ACCAL      - Used in the Activity Management edit routines.

    ACCALX     - Used in the Activity Management edit routines.

    AGINGCODE  - Used in the customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the customer edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable company edit routine.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

    AROIHDR    - Used in the customer edit routine.

    ARPAYMENT  - Used in the customer edit routine.

    BILLTO     - Used to validate the customer bill to entered on the
                 order.


    COLINE     - Used to verify customer order line information.


    COLINEUOM  - Used to verify order line multiple pricing units of
                 measure.


    COMISC     - Used to verify order and order line add-on
                 charges.


    CUCONV     - Used for currency editing.

    CURELAT    - Used to validate currency relationships.

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTORDER  - Used to validate customer orders.

    GLCODES    - Used in the General Ledger edit routines.

    GLSYSTEM   - Used in the General Ledger edit routines.

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the inventory control location.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTREGN   - Validates Intrastat region code.

    ITEMADDON  - Used in the order line edit routine.  Automatically adds
                 add-on charges to an order when an item is ordered.


    ITEMLOC    - Used to validate the Inventory Control item location.

    ITEMMAST   - Used to validate the inventory control item.

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECREDCARD - Used to validate credit card types.

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OEDISCOUNT - Used to validate discount codes and provide discount
                 information for the pricing routine.


    OEFRTCODE  - Used to validate freight codes.

    OEORDCMNT  - Used to store order comments related to customer order(s) or
                 customer order line(s).


    OEPLCLASS  - Used to store sales class pricing parameters for price list,
                 promotion, and contract.


    OEPLITEM   - Used to store item pricing parameters for price list,
                 promotion, and contract.


    OEPRCLIST  - Used to store default pricing parameters for price list,
                 promotion, and contract.


    OESLSACCT  - Used to obtain invoice line accounts for inventoried and
                 non-stock line
                 types.


    OPERATOR   -

    ORDERTYPE  - Used to validate order types.

    SHIPTO     - Used to validate ship-to numbers.

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    SYSTEMCODE - Used by the General Ledger system edit routine.

    TXTAXRATE  - Used in the tax code edit routine.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.


    WHSHIPMENT - Used to store shipment header information.


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFOB
    IFRS
    SLSS