Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BL20


BL20.1 - Invoice Entry

**Form Purpose
Use Invoice Entry (BL20.1) 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.

In addition, you can choose the Copy button on this form to create copies of
unreleased invoices with changed header information. For example, if you
invoice at more than one process level, choose the Copy button and change the
process level to create a new invoice for a different process level.

**Processing Effect
Corrected invoices are recreated the next time OE129 (Daily Shipment Journal)
is run.

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




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.

    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.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    BLOEIUF    -

    BLOILUF    -

    CBBANKINST - Used to validate the payment code.

    COCOMP     -

    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.

    COSGBLK    -

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTEP     -

    CUSTORDER  - Used to validate customer orders.

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    HOLDCODES  - Used to validate the hold code.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICHISTORY  -

    ICLOCATION - Used to validate the inventory control location.

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to validate the Inventory Control item location.

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    MXLISTHDR  -

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEAUDIT    -

    OECOLUF    -

    OECORUF    -

    OECUSTCODE - Used to validate customer codes.

    OEFRTCODE  - Used to validate freight codes.

    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 -

    OEMETHOD   -

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

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

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    OESOURCE   -

    ORDERTYPE  - Used to validate order types.

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SALESREP   - Used to validate sales representatives.

    SHIPTO     - Used to validate ship-to numbers.

    SOHDETAIL  -

    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.

    TXTAXTRAN  -

    WHDEMAND   -

    WHDEMNDHDR -

    WORDER     -


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.

    ACCATSUMX  -

    ACCUSTOMER -

    AGINGCODE  - Used in the customer edit routine.

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE - Used in the vendor edit routine.

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARADJUST   - Used in the customer 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.

    ARCUSTTOTS - Used in the customer edit routine.

    ARITRANS   - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

    AROIHDR    - Used in the customer edit routine.

    AROITEMS   - 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.

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     - Used for currency editing.

    CURELAT    -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    -

    FROPTIONS  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    - Used in the General Ledger edit routines.

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   - Used in the General Ledger edit routines.

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

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

    ITEMGROUP  -

    ITEMMAST   - Used to validate the inventory control item.

    ITEMSRC    -

    ITEMSUB    -

    ITEMUPC    -

    KITITEM    -

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    MSDSACK    -

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECOMPANY  - Used to validate the Billing company.

    OECOMPREF  -

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OECUSTITEM -

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

    OEORDDISC  -

    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.

    OEROUTE    -

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

    OPERATOR   -

    PBBILL     -

    PBHSTHDR   -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  - Used in the tax code edit routine.

    WFSETUP    -

    WHPROCTYPE -

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.

    WHSHIPMENT - Used to store shipment header information.

    WHSHLAUD   -


BL20.2 - Invoice Options

**Form Purpose
Use Invoice Options (BL20.2) to enter and update freight information
regarding the freight shipment for this invoice.




Updated Files

    None.


Referenced Files

    BLUSRFLDEF -

    OEINVCCOMM -

    OEINVCMISC -


BL20.3 - Invoice Add-On Charges

**Form Purpose
Use Invoice Add-On Charges (BL20.3) 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.

    ADDRDATA   -

    ARCODE     - Used to validate Accounts Receivable codes.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    BLOEIUF    -

    BLOILUF    -

    CBBANKINST - Used to validate the payment code.

    COCOMP     -

    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.

    COSGBLK    -

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTEP     -

    CUSTORDER  - Used to validate customer orders.

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    HOLDCODES  - Used to validate the hold code.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICHISTORY  -

    ICLOCATION - Used to validate the inventory control location.

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to validate the Inventory Control item location.

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    MXLISTHDR  -

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEAUDIT    -

    OECOLUF    -

    OECORUF    -

    OECUSTCODE - Used to validate customer codes.

    OEFRTCODE  - Used to validate freight codes.

    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 -

    OEMETHOD   -

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

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

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    OESOURCE   -

    ORDERTYPE  - Used to validate order types.

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SALESREP   - Used to validate sales representatives.

    SHIPTO     - Used to validate ship-to numbers.

    SOHDETAIL  -

    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.

    TXTAXTRAN  -

    WHDEMAND   -

    WHDEMNDHDR -

    WORDER     -


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.

    ACCATSUMX  -

    ACCUSTOMER -

    AGINGCODE  - Used in the customer edit routine.

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE - Used in the vendor edit routine.

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARADJUST   - Used in the customer 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.

    ARCUSTTOTS - Used in the customer edit routine.

    ARITRANS   - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

    AROIHDR    - Used in the customer edit routine.

    AROITEMS   - 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.

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     - Used for currency editing.

    CURELAT    -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    -

    FROPTIONS  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    - Used in the General Ledger edit routines.

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   - Used in the General Ledger edit routines.

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

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

    ITEMGROUP  -

    ITEMMAST   - Used to validate the inventory control item.

    ITEMSRC    -

    ITEMSUB    -

    ITEMUPC    -

    KITITEM    -

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    MSDSACK    -

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECOMPANY  - Used to validate the Billing company.

    OECOMPREF  -

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OECUSTITEM -

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

    OEORDDISC  -

    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.

    OEROUTE    -

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

    OPERATOR   -

    PBBILL     -

    PBHSTHDR   -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  - Used in the tax code edit routine.

    WFSETUP    -

    WHPROCTYPE -

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.

    WHSHIPMENT - Used to store shipment header information.

    WHSHLAUD   -


BL20.4 - Line Options

**Form Purpose
Use Line Options (BL20.4) to define invoice options at the line level, such
as sales representatives, discounts, tax, and reference information.




Updated Files

    TXCODEMAST -


Referenced Files

    BLUSRFLDEF -

    TXTAXCODE  -

    TXTAXRATE  -

    TXTAXTABLE -


BL20.5 - Tax Inquiry

**Form Purpose
Use Tax Inquiry (BL20.5) to view tax information for the invoice header.




Updated Files

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    APACCRCODE -

    CUCONV     -

    CURELAT    -

    GLSYSTEM   -

    OECOMPANY  -

    OEINVCLINE -

    OEINVCMISC -

    OEINVCTYPE -

    OEINVOICE  -

    OEPROCLEV  -

    SHIPTO     -

    TXTAXRATE  -


BL20.6 - Line Tax Inquiry

**Form Purpose
Use Line Tax Inquiry (BL20.6) to view tax information for the invoice line.




Updated Files

    CUSTEP     -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    AGINGCODE  -

    APACCRCODE -

    ARCOMP     -

    ARCUSTFLDS -

    ARCUSTGRP  -

    ARCUSTOMER -

    ARCUSTTOTS -

    ARLOCKBOX  -

    ARPAYMENT  -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    EPTRANS    -

    GLSYSTEM   -

    INSTCTRYCD -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEINVCLINE -

    OEINVCTYPE -

    OEINVOICE  -

    OEPROCLEV  -

    SHIPTO     -

    STATICCUST -

    TXTAXRATE  -

    WFSETUP    -


INVOKED Programs

    ACAC
    ACCL
    ACTA
    API4
    IFAC
    IFAU
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    ACSB
    API3
    BLI1
    BLI2
    BLI3
    ICCP
    ICI1
    ICI4
    IFRS
    IFSC
    POCP
    POIF
    POIH
    POI6
    POI4
    POI7
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    POIJ
    POI1
    POIM
    SLSS