Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

BL29

BL29.1 - Batch Control

Use this form to view, change, and release unreleased batches of invoices and
credit memos. The system assigns the batch number when invoices and credit
memos are added on BL20.1 (Invoice Entry). If you selected the batch control
totals option on the Company form, you must enter control totals and they must
equal the detail added to the batch before releasing the batch.

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.  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 payment codes.

    HOLDCODES  - Used to validate hold codes.  If this is the first time the
                 hold code is
                 referenced, the used flag is set.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer codes.  If this is the first time
                 the customer code is
                 used, the used flag is set on.

    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
                 on the invoice form.

    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 types.  If this is the first time the
                 invoice type is
                 referenced, the used flag is set.

    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.  If this is the first time the
                 reason code is
                 referenced, the used flag is set.

    SALESREP   - Used to validate sales representatives.  If this is the first
                 time the sales representative is referenced, the used flag is
                 set.

    TERITORY   - Used to validate territories.  If this is the first time the
                 territory is
                 referenced, the used flag is set.

    TERMS      - Used to validate terms codes.  If this is the first 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.

    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 Accounts Receivable customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
                 routines.

    ARCUSTGRP  - Used in the Accounts Receivable company 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    - Used in the customer edit routine.

    ARPAYMENT  - Used in the Accounts Receivable customer edit routine.

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

    COLINE     - Used when creating invoice/invoice lines by copying a customer
                 order.

    COLINEUOM  - Used when creating invoice/invoice lines by copying a customer
                 order.

    COMISC     - Used when creating invoice/invoice Lines by copying a customer
                 order.

    CUCONV     - Used in converting monetary amounts between currencies.

    CURELAT    - Used in converting monetary amounts between currencies.

    CUSTDESC   - Used to display Accounts Receivable customer information.

    CUSTORDER  - Used when creating invoice/invoice lines by copying a customer
                 order.

    GLCODES    - Used in the General Ledger account verification routine.

    GLSYSTEM   - Used in the General Ledger account verification routine.

    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 the Intrastate region code.

    ITEMADDON  - Used to trigger automatic creation of add-on charges for
                 specific items when
                 sold in specified states (or all states).  The add-on charge
                 is created at
                 the invoice line level.

    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.

    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 when creating invoice/invoice lines by copying a customer
                 order.

    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 when calculating sales tax for an invoice line.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.

    WHSHIPMENT - Used to store shipment header information.


BL29.2 - Invoice Batch

Use this subform to delete a batch of invoices. Remember that if you delete
an invoice batch, all invoices within the batch are deleted.

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.  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 payment codes.

    HOLDCODES  - Used to validate hold codes.  If this is the first time the
                 hold code is
                 referenced, the used flag is set.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer codes.  If this is the first time
                 the customer code is
                 used, the used flag is set on.

    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
                 on the invoice form.

    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 types.  If this is the first time the
                 invoice type is
                 referenced, the used flag is set.

    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.

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

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.  If this is the first time the
                 reason code is
                 referenced, the used flag is set.

    SALESREP   - Used to validate sales representatives.  If this is the first
                 time the sales representative is referenced, the used flag is
                 set.

    TERITORY   - Used to validate territories.  If this is the first time the
                 territory is
                 referenced, the used flag is set.

    TERMS      - Used to validate terms codes.  If this is the first 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.

    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 Accounts Receivable customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the Accounts Receivable customer edit and update
                 routines.

    ARCUSTGRP  - Used in the Accounts Receivable company 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    - Used in the customer edit routine.

    ARPAYMENT  - Used in the Accounts Receivable customer edit routine.

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

    COLINE     - Used when creating invoice/invoice lines by copying a customer
                 order.

    COLINEUOM  - Used when creating invoice/invoice lines by copying a customer
                 order.

    COMISC     - Used when creating invoice/invoice lines by copying a customer
                 order.

    CUCONV     - Used in converting monetary amounts between currencies.

    CURELAT    - Used in converting monetary amounts between currencies.

    CUSTDESC   - Used to display Accounts Receivable customer information.

    CUSTORDER  - Used to validate customer orders.

    GLCODES    - Used in the General Ledger account verification routine.

    GLSYSTEM   - Used in the General Ledger account verification routine.

    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 the Intrastat region code.

    ITEMADDON  - Used to trigger automatic creation of add-on charges for
                 specific items when
                 sold in specified states (or all states).  The add-on charge
                 is created at
                 the invoice line level.

    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.

    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 when creating invoice/invoice lines by copying a customer
                 order.

    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 when calculating sales tax for an invoice line.

    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