Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AR42

AR42.1 - Transaction Header

Use AR42.1 (Transaction Header) to create and maintain transaction batch
records. A transaction can be an invoice, credit memo, or debit memo. A batch
is required before you enter transactions in AR42.2 (Transaction Entry) or
AR42.7 (Speed Entry Transaction). 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 AR01.1
(Company), 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.

    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  - Updates the detail payment records.

    ARPROCLEVL - Updates process level used flag.

    ARPYMNTHDR - Updates batch header information for payments.

    ARSUMMARY  - Updates summary record with open item activity amounts.

    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.

    NATBALANCE - National account balance updated upon release.

    TERMS      - Updates terms used flag.

    TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
                 the tax code is used.


    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates tax codes.

    TXTAXTABLE - Used to obtain multiple tax codes.

    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.

    ACCAL      - Used as part of Activity validation.

    ACCALX     - Used as part of Activity validation.

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APCPYVND   - Used as part of vendor validation.

    APHLDINV   - Used as part of vendor validation.

    APVENCLASS - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    APVENMAST  - Used as part of vendor validation.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS - Validates process level exclusion.

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    - Validates currency relationships.

    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.

    GLSYSTEM   - Used as part of general ledger account validation.

    NATACCT    - Used to validate national account customer relationship.

    SYSTEMCODE - Validates the system code updating general ledger and updated
                 the object id.


    TXTAXRATE  - Used in tax calculation logic.


AR42.2 - Transaction Entry

Use AR42.2 (Transaction Entry) 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
AR42.1 (Transaction Batch).

An invoice or debit memo transaction debits the general ledger account for the
receivable code assigned to the transaction batch and credits the general
ledger accounts you assign to the distributions. The total distribution amount
must equal the total transaction amount before you can release the batch.

The net sum of the line items must be equal to the transaction amount you
define for the transaction.

You can use AR42.2 to maintain transactions that were entered in AR42.7 (Speed
Entry Transaction).

Choose the More button to access the Distribution Accounts subform. Use this
subform to define additional information for an invoice distribution.

Choose the Expanded button to access the Invoice Options subform. Use this
subform to override default information for the invoice.

Choose the Totals button to access the Batch Totals subform. Use this subform
to see the control and entry totals for the batch.

Choose the Obligations button to access the Obligations form. Use this
form to review payment obligations associated with the invoice.









Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used in activity commitment status update.

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


    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  - Updates detail payment records.

    ARPYMNTHDR - updates batch header information for payments.

    ARSUMMARY  - Summary records created for transaction activity.

    ARUDISTRIB - Updates user analysis information.

    ARUOIHDR   - Updates user analysis information.

    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.

    INSTDETAIL - Updates the Intrastat detail transaction records.

    INSTHEADER - Updates the Intrastat header transaction records.

    INSTNBR    - Generates a unique Intrastat number any time an Intrastat
                 transaction is added.


    JBOOKHDR   - Used in journal book processing.

    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.

    ACCAL      - Used as part of Activity validation.

    ACCALX     - Used as part of Activity validation.

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APCPYVND   - Used as part of vendor validation.

    APHLDINV   - Used as part of vendor validation.

    APVENCLASS - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    APVENMAST  - Used as part of vendor validation.

    ARADJUST   - Used a part of Billing system edit.

    ARCATEGORY - Validates AR category.

    ARCODE     - Used to validate general ledger accounts receivable code.

    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   - Validates transaction number of duplicates.

    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    - Validates currency relationships.

    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.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTATPROC - Validates the Intrastat statistical procedure code.

    INSTCMDTY  - Validates the Intrastat commodity code.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTNOTC   - Validates the Intrastat nature of transaction code.

    INSTPORTS  - Validates the Intrastat port code.

    INSTREGN   - Validates the Intrastat region code.

    INSTUOM    - Validates the Intrastat unit of measure code.

    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.

    OEINVOICE  - Used to validate Order Entry invoice.

    SYSTEMCODE - Validates the system code updating general ledger and updated
                 the object id.


    TXTAXRATE  - Validates tax rate.


AR42.3 - Batch Totals

Use the Batch Totals subform to review the control and entry totals for the
transaction batch. If you selected the batch control totals option for the
company in AR01.1 (Company), 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.6 - Obligations

Use AR42.6 (Obligations) 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. Maintaining individual payment obligations of an invoice, debit
memo, or credit memo has no effect on discount amounts or discount dates.

Note: If applications exist, you cannot change the obligation.

Updated Files

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


    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  - Maintains detail payment records.

    ARPYMNTHDR - Maintains payment 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   - Validates customer description record.

    NATBALANCE - National account balance updated upon release.

    REVERSEDTL - Used to validate reverse application record.

    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.

    ARPROCLEVL - Used to validate process level.

    ARREASON   - Validates reason code.

    ARSAPPLIED - Temporary application record created.

    BILLTO     - Validates bill to information.

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    - Validates currency relationships.

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    GLADDRESS  - Validates general ledger company information.

    GLCHART    - Used as part of general ledger account validation.

    GLINTCO    - Validates intercompany relationships.

    GLSYSTEM   - Used as part of general ledger account validation.

    NATACCT    - Used to validate national account customer relationship.

    REVERSEDTL - Used to validate reverse application record.

    SALESREP   - Validates sales rep information.


AR42.7 - Speed Entry Transaction

Use AR42.7 (Speed Entry Transaction) for speed entry of transactions. Before
you enter transactions in AR42.7, the transaction batch must be defined in
AR42.1 (Transaction Header).

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



Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ARAPPLIED  - Application records created for bills of exchange open items
                 upon release.


    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTOMER - Used to validate customer.

    ARCUSTPER  - Updates period balances upon release.

    ARDISTRIB  - Creates distribution records for open items.

    ARDRAFTS   - Creates bills of exchange records for select open items upon
                 release.


    ARITEM     - Primary record created. Temporary record until release creates
                 open item record.


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


    AROITEMS   - Primary record created upon release.

    AROPIVOT   -

    ARPAYMENT  - Updates payment information.

    ARPYMNTHDR - Creates payment header records.

    ARSUMMARY  - Summary records updated for transaction activity.

    ARUDISTRIB - Updates user analysis information.

    BLINVHDR   - Creates header records for open item header records.

    CBBANKENT  - Validates bank. Sets the used flag to Yes.

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE - Validates the cash code. Sets the used flag to Yes.

    CUSTDESC   - Validates customer description record.

    JBOOKHDR   -

    NATBALANCE - National account balance updated upon release.

    TERMS      - Used flag updated.

    TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
                 the tax code is used.


    TXCOMPANY  - Used to obtain tax information for company.

    TXTAXCODE  - Used in tax calculation.

    TXTAXTABLE - Used to obtain multiple tax codes.

    TXTAXTRAN  - Creates tax transaction records for 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.

    ACCAL      - Used as part of Activity validation.

    ACCALX     - Used as part of activity validation.

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APCPYVND   - Used as part of vendor validation.

    APHLDINV   - Used as part of vendor validation.

    APVENCLASS - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    APVENMAST  - Used as part of vendor validation.

    ARADJUST   - Used as part of Billing system edit.

    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 - Validates process level inclusion.

    ARITRANS   - Validates transaction number for duplicates.

    ARPROCLEVL - Used to validate process level.

    ARREASON   - Validates reason code record.

    CBUSER     - Determines user access to cash ledger.

    CBUSRCLASS - Determines user access to cash ledger.

    CUCONV     - Used as part of currency validation.

    CURELAT    - Validates currency relationships.

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    GLADDRESS  - Part of company validation.

    GLCHART    - Part of company validation.

    GLSYSTEM   - Used as part of general ledger account validation.

    JBKOPCODE  -

    JBKSYSCODE -

    NATACCT    - Validates national account relationships.

    OECOMPANY  - Used to validate Order Entry company.

    OEINVOICE  - Used to validate Order Entry invoice.

    SYSTEMCODE - Validates the system code updating general ledger and updated
                 the object id.


    TXTAXRATE  - Used in tax calculation logic.


AR42.8 - Line Item Entry

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

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

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




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     - Obtains a currency exchange rate.

    CURELAT    - Validates currency relationships.

    CUSTDESC   - Validates customer description record.

    GLSYSTEM   - Validates part of company information.


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    IFSC
    SLSS