Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR42


AR42.1 - Transaction Header

**Form Purpose
Use Transaction Header (AR42.1) to create and maintain transaction batch
records. A transaction can be an invoice, credit memo, or debit memo.

**More Information
A batch is required before you enter transactions in Transaction Entry
(AR42.2) or Speed Entry Transaction (AR42.7). Physical transaction forms are
not created. AR42.2 and AR42.7 create system records that typically reference
actual transaction documents.

A transaction batch groups transactions for control totals and provides
default information for all transactions in the batch. A batch record
eliminates the need to type redundant information on every transaction record.
If you selected the batch control totals option for the company in Company
(AR01), control totals must match entry totals before you can release a batch.





Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ADDRDATA   -

    ARAPPLIED  - Application records created for Bills of Exchange processing.

    ARCODE     - Updates used flag.

    ARCOMP     - Updates company record with last open item batch number used.

    ARCUSTOMER - Company customer record updated upon release.

    ARCUSTPER  - Used to validate customer transaction period record.

    ARDISTRIB  - Creates distribution records for open items.

    ARDRAFTS   - Creates Bills of Exchange records for select open item records.

    ARITEM     - Creates temporary open item line item records, deleted upon
                 release.

    AROIHDR    - Creates open item header records for invoices, debit memos and
                 credit memos.

    AROITEMS   - Creates open item records for invoices, debit memos, and
                 credit memos.

    AROPIVOT   -

    AROPTR     - Updates operator code used flag.

    ARPAYMENT  -

    ARPROCLEVL - Updates process level used flag.

    ARPYMNTHDR -

    ARSUMMARY  - Updates summary record with open item activity amounts.

    ARUSERSORT -

    ARXIND     -

    BLINVHDR   - Creates header records for open item header records.

    CBBANKENT  - Used as part of cash ledger validation.

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE - Used as part of cash code validation.

    CUSTDESC   - Customer description record balance updated upon release.

    GLCOMMIT   -

    GLCOMMITX  -

    MXLISTHDR  -

    NATBALANCE - National account balance updated upon release.

    TERMS      - Updates terms used flag.

    TXCODEMAST -

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates tax codes.

    TXTAXTABLE -

    TXTAXTRAN  - Creates tax transaction records for distribution taxable
                 distribution lines.


Referenced Files

    ACACCTCAT  - Used as part of Activity validation.

    ACACTGRP   - Used as part of Activity validation.

    ACACTIVITY - Used as part of Activity validation.

    ACCATSUMX  -

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS - Validates process level exclusion.

    ARITEM     - Creates temporary open item line item records, deleted upon
                 release.

    ARMAP      -

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    GLADDRESS  - Validates general ledger company information.

    GLCHART    - Used as part of general ledger account validation.

    GLCODES    - Used to validate system control.

    GLNAMES    -

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTCTRYCD -

    NATACCT    - Used to validate national account customer relationship.

    SYSTEMCODE -

    TXTAXRATE  -


AR42.2 - Transaction Entry

**Form Purpose
Use Transaction Entry (AR42.2) to enter transactions (invoices, credit memos,
and debit memos). A physical transaction form is not created. AR42.2 creates a
system record that references an actual document.

Before you enter a transaction on this form, the batch must be defined in
Transaction Batch (AR42.1).

Line items for Mixed type transactions must have mixed signed line amounts.
If the alternative transaction type on AR42.2 is C (Credit Memo), D (Debit
Memo), or I (Invoice), then the sum of the positive amounts and the negative
amounts on Line Item Entry (AR42.8) must be a positive amount and equal to the
Trans Amount field on AR42.2.




Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used in activity commitment status update.

    ADDRDATA   -

    ARAPPLIED  - Application records created for Bills of Exchange open items
                 upon release.

    ARARHUF    -

    ARCODE     - Used to validate general ledger accounts receivable code.

    ARCOMMENT  - Deletes all comments for the transaction when a transaction is
                 deleted.

    ARCOMP     - Updates company record with last open item batch number used.

    ARCUSTOMER - Used to validate customer.

    ARCUSTPER  - Used to validate customer transaction period record.

    ARDISPUTE  - Deletes all dispute records for the transaction when an
                 transaction is deleted.

    ARDISTRIB  - Validates tax point distribution status.

    ARDRAFTS   - Creates Bills of Exchange records for select open item records.

    ARITEM     - Creates temporary open item line item records, deleted upon
                 release.

    AROIHDR    - Used to validate open item header record.

    AROITEMS   - Used to validate invoice, credit memo, or debit memo.

    AROPIVOT   -

    ARPAYMENT  -

    ARPYMNTHDR -

    ARSUMMARY  - Summary records created for transaction activity.

    ARUDISTRIB -

    ARUOIHDR   -

    ARUSERSORT -

    ARXIND     -

    BLINVHDR   - Validates open item header file for manually created open
                 items.

    CBBANKENT  - Used as part of cash ledger validation.

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE - Used as part of cash code validation.

    CUSTDESC   - Validates customer description record.

    GLCOMMIT   -

    GLCOMMITX  -

    JBOOKHDR   - Used in journal book processing.

    MXLISTHDR  -

    NATBALANCE - National account balance updated upon release.

    SALESREP   - Updates used flag.

    TERMS      - Validates terms information.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates tax codes.

    TXTAXTABLE - Validates tax table transaction records.

    TXTAXTRAN  - Creates tax transaction records for distribution taxable
                 distribution lines.


Referenced Files

    ACACCTCAT  - Used as part of Activity validation.

    ACACTGRP   - Used as part of Activity validation.

    ACACTIVITY - Used as part of Activity validation.

    ACCATSUMX  -

    ACCUSTOMER -

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    ARADJUST   -

    ARCATEGORY - Validates AR category.

    ARCOMMENT  - Deletes all comments for the transaction when a transaction is
                 deleted.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS - Validates process level exclusion.

    ARDISPUTE  - Deletes all dispute records for the transaction when an
                 transaction is deleted.

    ARITRANS   -

    ARMAP      -

    ARPROCLEVL - Used to validate process level.

    ARREASON   - Validates reason code record.

    BILLTO     - Validates customer bill to address record.

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    FOBCODE    -

    FROPTIONS  -

    GLADDRESS  - Validates general ledger company information.

    GLCHART    - Used as part of general ledger account validation.

    GLCODES    - Used to validate system control.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLNAMES    -

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    JBKOPCODE  - Used in journal book processing.

    JBKSYSCODE - Used in journal book processing.

    NATACCT    - Used to validate national account customer relationship.

    OECOMPANY  - Used to validate Order Entry company.

    OECOMPREF  -

    OEINVOICE  - Used to validate Order Entry invoice.

    PBBILL     -

    PBHSTHDR   -

    SYSTEMCODE -

    TXTAXRATE  - Validates tax rate.


AR42.3 - Batch Totals

**Form Purpose
Use Batch Totals (AR42.3) to view the control and entry totals for the
transaction batch. If you selected the batch control totals option for the
company in Company (AR01), the control totals must match the entry totals
before you can release a batch.




Updated Files

    None.


Referenced Files

    BLINVHDR   - Validates open item header file for manually created open
                 items.


AR42.5 - Distributions

**Form Purpose
Use Distributions (AR42.5) to override default information for a transaction
distribution.




Updated Files

    None.


Referenced Files

    INSTCMDTY  -


AR42.6 - Obligations

**Form Purpose
Use Obligations (AR42.6) to maintain obligation information. A single
transaction can be divided into multiple obligations with unique due dates.
You cannot change the total amount of the open item, only redistribute it
among unique obligations. You can assign a different terms code to the
transaction and the program will automatically recalculate the obligation
information.

Note If applications exist, you cannot change the obligation.




Updated Files

    ADDRDATA   -

    ARAPPLIED  - Application records created for Bills of Exchange open items
                 upon release.

    ARARHUF    -

    ARCOMP     - Updates company record with last open item batch number used.

    ARCUSTOMER - Used to validate customer.

    ARCUSTPER  - Used to validate customer transaction period record.

    ARDISTRIB  - Creates distribution records for open items.

    ARDRAFTS   - Creates Bills of Exchange records for select open item records.

    AROIHDR    - Used to validate open item header record.

    AROITEMS   - Creates open item header records for invoices, debit memos,
                 and credit memos.

    AROPIVOT   -

    ARPAYMENT  -

    ARPYMNTHDR -

    ARXIND     -

    CBBANKENT  - Used as part of cash ledger validation.

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE - Used as part of cash code validation.

    CUSTDESC   - Validates customer description record.

    MXLISTHDR  -

    NATBALANCE - National account balance updated upon release.

    TERMS      - Used flag updated.


Referenced Files

    ARCODE     - Used to validate general ledger accounts receivable code.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS - Validates process level exclusion.

    ARPMTRVDTL -

    ARPROCLEVL - Used to validate process level.

    ARREASON   -

    ARSAPPLIED -

    ARTRNRVDTL -

    ARTRNRVHDR -

    BILLTO     -

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    GLADDRESS  - Validates general ledger company information.

    GLCHART    - Used as part of general ledger account validation.

    GLINTCO    -

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTCTRYCD -

    NATACCT    - Used to validate national account customer relationship.

    SALESREP   -


AR42.7 - Speed Entry Transaction

**Form Purpose
Use Speed Entry Transaction (AR42.7) to speed enter transactions. Before you
enter transactions in AR42.7, the transaction batch must be defined in
Transaction Header (AR42.1).

**More Information
To maintain transactions before they are released, use Transaction Entry
(AR42.2). Transactions entered here can be also be defined as line item
transactions in Line Item Entry (AR42.8).




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    ARAPPLIED  -

    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTOMER - Used to validate customer.

    ARCUSTPER  -

    ARDISTRIB  - Creates distribution records for open items.

    ARDRAFTS   -

    ARITEM     -

    AROIHDR    - Creates open item header records for invoices, debit memos,
                 and credit memos.

    AROITEMS   -

    AROPIVOT   -

    ARPAYMENT  -

    ARPYMNTHDR -

    ARSUMMARY  -

    ARUDISTRIB -

    ARUSERSORT -

    ARXIND     -

    BLINVHDR   - Creates header records for open item header records.

    CBBANKENT  -

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE -

    CUSTDESC   - Validates customer description record.

    GLCOMMIT   -

    GLCOMMITX  -

    JBOOKHDR   -

    MXLISTHDR  -

    NATBALANCE -

    TERMS      - Used flag updated.

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    TXTAXTRAN  -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    ACCUSTOMER -

    APACCRCODE -

    APCOMPANY  -

    APVENGROUP -

    ARADJUST   -

    ARCATEGORY - Used to default general ledger account for open item
                 distributions.

    ARCODE     - Used to validate general ledger accounts receivable code.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS -

    ARITEM     -

    ARITRANS   -

    ARMAP      -

    ARPROCLEVL - Used to validate process level.

    ARREASON   - Validates reason code record.

    CBUSER     -

    CBUSRCLASS -

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    FROPTIONS  -

    GLADDRESS  -

    GLCHART    -

    GLNAMES    -

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    NATACCT    -

    OECOMPANY  - Used to validate Order Entry company.

    OECOMPREF  -

    OEINVOICE  - Used to validate Order Entry invoice.

    PBBILL     -

    PBHSTHDR   -

    SYSTEMCODE -

    TXTAXRATE  -


AR42.8 - Line Item Entry

**Form Purpose
Use Line Item Entry (AR42.8) to enter line item details on transactions.
Transactions must be entered on Transaction Entry (AR42.2) or Transaction
Speed Entry (AR42.7). Non-Lawson transactions can be interfaced through
Transaction Interface (AR560). Transactions must be unreleased before you can
add line item detail.

**More Information
Line items for Mixed type transactions must have mixed signed line amounts.
If the alternative transaction type on Transaction Entry (AR42.2) is C (Credit
Memo), D (Debit Memo), or I (Invoice), then the sum of the positive amounts
and the negative amounts on AR42.8 must be a positive amount and equal to the
Trans Amount field on AR42.2.

Once the batch is released, the line items become individual obligations. Use
Obligations (AR42.6) to maintain individual obligations.

You apply payments to line items entered here in Line Item Application
(AR30.4).




Updated Files

    ARITEM     - Creates temporary open item line item records, deleted upon
                 release.

    TERMS      - Used flag updated.


Referenced Files

    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTGRP  - Used to validate customer group.

    AROIHDR    - Used to validate open item header record.

    AROITEMS   - Used to validate invoice, credit memo, or debit memo.

    BLINVHDR   - Validates open item header file for manually created open
                 items.

    CUCONV     -

    CURELAT    -

    CUSTDESC   - Validates customer description record.

    GLSYSTEM   -


INVOKED Programs

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