Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AR21

AR21.1 - Cash MICR Assignment

Use AR21.1 (Cash MICR Assignment) to enter cash using the MICR (Magnetic Ink
Character Recognition) number of the payment. The system searches for a MICR
customer cross reference defined in AR13.1 (MICR Customer) to assign the
payment to a customer. If no cross reference is defined, the payment is added
unassigned. You can use AR28.1 (Unassigned Cash), or any of the other AR21
cash entry forms or AR28 cash assignment forms to assign the payment  later.

You can use AR29.2 (Payment Transfer to Non-AR) to transfer a released,
unassigned payment to a non-accounts receivable status.

Payments you enter on this form debit the general ledger account defined for
the cash code assigned to the cash batch in AR20.1 (Cash Batch) and credit the
 received not applied account assigned to the cash batch in AR20.1 (Cash
Batch)  or the process level in AR02.1 (Process Level).

Choose the Totals button to display totals for the batch.

Before you can enter cash on this form, the batch must be defined in AR20.1
(Cash Batch).

Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ARADJUST   - Adjust amounts are changed when payments are deleted.

    ARAPPLIED  - Applied amounts are changed when payments are deleted.

    ARCUSTOMER - Updates customer balance, last payment date and last payment
                 amount.


    ARCUSTPER  - Updates customer period information upon release.

    ARDISTRIB  - Distributions are deleted when payments are deleted.

    AROITEMS   - Applied amounts are changed when payments are deleted.

    AROPIVOT   -

    ARPAYMENT  - Payments added, changed and deleted.

    ARPYMNTHDR - Validates batch numbers; updated during payments adds,
                 changes, deletes, and release.


    ARREMIT    - Deletes records when payments are deleted.

    ARSADJUST  - Temporary cash application adjustment record created.

    ARSAPPLIED - Temporary cash application record created.

    ARSUMMARY  - Updates payment activity amounts upon payment release.

    ARUDISTRIB - Updates user analysis information.

    ARUPMNTHDR - Updates user analysis information.

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

    CBBANKINST - Validates the payment code. Sets the used flag to Yes.

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

    CBCPYCASH  - Validates the cash code for the company. Sets the used flag to
                 Yes.


    CBDISTRIB  - Generates cash ledger distributions for the payments entered.

    CBTRANS    - Generates cash ledger transaction records for the payments
                 entered.


    CUSTDESC   - Updates customer group balance.

    NATBALANCE - Updates national account balance.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates the tax code.

    TXTAXTABLE - Validates the tax table.

    TXTAXTRAN  - Creates tax transaction records upon release.


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.

    ARCODE     - Validates the AR code.

    ARCOMP     - Validates the AR company.

    ARCUSTGRP  - Validates the AR customer group.

    ARMICRCUST - Assigns customer number if MICR number record exists.

    AROIHDR    - Accesses the invoice header record when detail records are
                 being processed.


    ARPROCLEVL - Finds AR code from payment process level.

    ARREMIT    - Deletes records when payments are deleted.

    ARSADJUST  - Temporary cash application adjustment record created.

    CBADJUST   - Used in cash ledger processing.

    CBBALANCE  - Used in cash ledger processing.

    CBSTATEMNT - Used in cash ledger processing.

    CBSTMTDTL  - Used in cash ledger processing.

    CBUSER     - Determines user access to cash ledger.

    CBUSRCLASS - Determines user access to cash ledger.

    CUCONV     - Obtains a currency exchange rate.

    CURELAT    - Validates currency relationships.

    CUSTORDER  - Part of workflow validation logic.

    GLADDRESS  - Validates part of company information.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Verifies general ledger dates.

    GLSYSTEM   - Validates general ledger company information.

    NATACCT    - Validates the national account relationship.

    OECOMPANY  - Part of workflow validation logic.

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


    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.2 - Cash Customer, Transaction Assignment

Use AR21.2 (Cash Customer Transaction Assignment) to enter cash using the
customer or an invoice number associated with the payment. If you leave the
customer number field blank and type an invoice or debit memo number, the
system defaults the customer number. You can type both a customer and invoice
or debit memo number to store the invoice or debit memo number for reference.

Payments you enter on this form debit the general ledger account defined for
the cash code assigned to the cash batch in AR20 (Cash Batch) and credit the
received not applied or prepayment account assigned to the cash batch in AR20
(Cash Batch) or to the process level in AR02.1 (Process Level).

Use the PrePay button to access a subform to add prepayment information for a
payment. Use the Remit button to access a subform to enter transactions
referenced on the payment's remittance advice. Use the Totals button to
display totals for the batch.

Before you can enter cash on this form, the batch must be defined in AR20.1
(Cash Batch) and must be unreleased.

Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ARADJUST   - Deletes adjustment record if payment is deleted.

    ARAPPLIED  - Deletes applied records if payment is deleted.

    ARCUSTOMER - Updates customer balance, last payment amount and date, period
                 paid.


    ARCUSTPER  - Updates customer period totals for payments entered.

    ARDISTRIB  - Creates distribution records for cash, received not applied,
                 and additional charges amount. Deletes records if payment is
                 deleted.


    AROITEMS   - Updated by changing application information if payment deleted.


    AROPIVOT   -

    ARPAYMENT  - Primary file updated by program. Payments are added, changed,
                 or deleted.


    ARPREPAY   - A prepayment record may be added for a payment record.

    ARPYMNTHDR - Validates batch numbers; this is updated during payments adds,
                 changes, deletes, and release.


    ARREMIT    - Deletes records when payments are deleted.

    ARSADJUST  - Temporary cash application adjustment record created.

    ARSAPPLIED - Temporary cash application record created.

    ARSUMMARY  - Updates payment activity amounts upon payment release.

    ARUDISTRIB - Updates user analysis information.

    ARUPMNTHDR - Updates user analysis information.

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

    CBBANKINST - Validates the payment code. Sets the used flag to Yes.

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

    CBCPYCASH  - Validates the cash code for the company. Sets the used flag to
                 Yes.


    CBDISTRIB  - Generates cash ledger distributions for the payments entered.

    CBTRANS    - Generates cash ledger transaction records for the payments
                 entered.


    CUSTDESC   - Updates customer group balance.

    NATBALANCE - Updates national account balance.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates the tax code.

    TXTAXTABLE - Validates tax table.

    TXTAXTRAN  - Creates tax transaction records upon release.


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.

    ARCODE     - Validates the AR code.

    ARCOMP     - Validates the AR company.

    ARCUSTGRP  - Validates the AR customer group.

    AROIHDR    - Accesses the invoice header record when detail records are
                 being processed.


    ARPROCLEVL - Finds the AR code from payment process level.

    ARSADJUST  - Temporary cash application adjustment record created.

    CBADJUST   - Used in cash ledger processing.

    CBBALANCE  - Used in cash ledger processing.

    CBSTATEMNT - Used in cash ledger processing.

    CBSTMTDTL  - Used in cash ledger processing.

    CBUSER     - Determines user access to cash ledger.

    CBUSRCLASS - Determines user access to cash ledger.

    CUCONV     - Obtains a currency exchange rate.

    CURELAT    - Validates currency relationships.

    CUSTORDER  - Part of workflow validation logic.

    GLADDRESS  - Used as part of company validation.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Verifies general ledger dates.

    GLSYSTEM   - Validates general ledger company information.

    NATACCT    - Validates the national account relationship.

    OECOMPANY  - Part of workflow validation logic.

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


    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.3 - Cash Non-AR

Use AR21.3 (Cash Non-AR) to enter cash not associated with an accounts
receivable customer. The total distribution amount must equal the payment
amount before you can release the payment. Non-accounts receivable payments
debit the general ledger account defined for the cash code assigned to the
cash batch in AR20 (Cash Batch) and credit (or may debit) the general ledger
account(s) you assign to the payment on this form.

Choose the More button to access the Expanded Distribution subform to enter
units or tax information for a payment distribution.

Choose the Totals button to display totals for the batch.

Before you can enter cash on this form, the batch must be defined in AR20.1
(Cash Batch).




Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ARADJUST   - Deletes adjust records if payment is deleted.

    ARAPPLIED  - Deletes applied records if payment is deleted.

    ARCUSTOMER - Updates customer balance, last payment amount and date, period
                 paid.


    ARCUSTPER  - Updates customer period totals for payments entered.

    ARDISTRIB  - Creates distribution records for cash, received not applied,
                 and additional charges amount. Deletes records if payment is
                 deleted.


    AROITEMS   - Updated by changing application information if payment deleted.


    AROPIVOT   -

    ARPAYMENT  - Primary file updated by program. Payments are added, changed,
                 or deleted.


    ARPYMNTHDR - Validates batch numbers; this is updated during payments adds,
                 changes,
                 deletes, and release.


    ARREMIT    - Deletes records when payments are deleted.

    ARSADJUST  - Temporary cash application adjustment record created.

    ARSAPPLIED - Temporary cash application record created.

    ARSUMMARY  - Updates payment activity amounts upon payment release.

    ARUDISTRIB - Updates user analysis information.

    ARUPMNTHDR - Updates user analysis information.

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

    CBBANKINST - Validates the payment code. Sets the used flag to Yes.

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

    CBCPYCASH  - Validates the cash code for the company. Sets the used flag to
                 Yes.


    CBDISTRIB  - Cash ledger distributions will be generated for the payments
                 entered.


    CBTRANS    - Generates cash ledger transaction records for the payments
                 entered.


    CUSTDESC   - Updates the customer group balance.

    NATBALANCE - Updates the national account balance.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates the tax code.

    TXTAXTABLE - Validates the tax table.

    TXTAXTRAN  - Creates tax transaction records upon release.


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 - Validates accrual code.

    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.

    ARCODE     - Validates the AR code.

    ARCOMP     - Validates the AR company.

    ARCUSTGRP  - Validates the AR customer group.

    AROIHDR    - Accesses the invoice header record when detail records are
                 being processed.


    ARPROCLEVL - Finds AR-Code from payment process level.

    ARREMIT    - Deletes records when payments are deleted.

    ARSADJUST  - Temporary cash application adjustment record created.

    CBADJUST   - Used in cash ledger processing.

    CBBALANCE  - Used in cash ledger processing.

    CBSTATEMNT - Used in cash ledger processing.

    CBSTMTDTL  - Used in cash ledger processing.

    CBUSER     - Determines user access to cash ledger.

    CBUSRCLASS - Determines user access to cash ledger.

    CUCONV     - Obtains a currency exchange rate.

    CURELAT    - Validates currency relationships.

    CUSTORDER  - Part of workflow validation logic.

    GLADDRESS  - Validates part of company information.

    GLCHART    - Validates the chart number of the GL company.

    GLCODES    - Verifies general ledger dates.

    GLINTCO    - Validates intercompany relationships.

    GLSYSTEM   - Used in GL company validation.

    NATACCT    - Validates national account relationships.

    OECOMPANY  - Part of workflow validation logic.

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


    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.4 - Cash Remittance

Use AR21.4 (Cash Remittance) to enter cash including information referenced
on the payment's remittance advice. The remittance information you enter on
this form will be processed by AR130 (Automatic Cash Application).

Payments you enter on this form debit the general ledger account defined for
the cash code assigned to the cash batch in AR20 (Cash Batch) and credit the
received not applied or prepayment account assigned to the cash batch in AR20
(Cash Batch) or to the process level in AR02.1 (Process Level).

Before you can enter cash on this form, the batch must be defined in AR20.1
(Cash Batch).




Updated Files

    ARPAYMENT  - Primary file updated by program. Payments added or changed.

    ARPYMNTHDR - Validates the payment batch. Updates last log sequence when
                 payment added.


    ARREMIT    - Remit records added, changed, or deleted.


Referenced Files

    ARCODE     - Validates AR code.

    ARCOMP     - Validates the AR company.

    ARCUSTGRP  - Validates the AR customer group.

    ARCUSTOMER - Validates the AR customer.

    AROIHDR    - Assigns customer from obligation record if customer is left
                 blank.


    CBSTMTDTL  -

    CUCONV     - Obtains a currency exchange rate.

    CURELAT    - Validates currency relationships.

    CUSTDESC   -

    GLSYSTEM   - Validates part of company information.

    NATACCT    - Used to validate national account relationship.


AR21.5 - Cash Remittance

After you enter cash in AR21.2 (Cash Customer Invoice Assignment), use the
Cash Remittance subform to enter information referenced on the payment's
remittance advice. The remittance information you enter on this form will be
processed by AR130 (Automatic Cash Application).


Updated Files

    ARPAYMENT  - Validates payment record. The remit sequence is updated.

    ARREMIT    - Primary file updated by program. Remit records are added,
                 changed, or deleted.



Referenced Files

    ARCOMP     - Used to validate company.

    ARCUSTOMER - Used to validate customer.

    AROIHDR    - Used to validate transaction header.

    ARPYMNTHDR - Validates the batch header.

    NATACCT    - Used to validate national account relationship.


AR21.6 - Prepayment

After you enter cash in AR21.2 (Cash Customer Invoice Assignment), use the
Prepayment subform to enter prepayment information for a payment.


Updated Files

    ARPAYMENT  - Validates payment record. The payment's AR code is changed to
                 the prepay code entered on the screen, the prepay flag is set
                 to 1, and the remit sequence is set to zeros.


    ARPREPAY   - Primary file updated by program. Prepay records are added,
                 changed, or deleted.


    ARPYMNTHDR - Validates the batch header record.


Referenced Files

    ARCODE     - Validates the prepayment code entered.

    ARCOMP     - Validates Accounts Receivable company file.


AR21.7 - Totals

Use the Totals subform to display cash batch totals, including control
totals, entry totals, and the difference between the control and entry totals
for a cash batch. If you selected batch control totals for the company in
AR01.1 (Company), control totals must match entry totals before you can
release a batch. You can adjust the control totals, if needed, in AR20.1 (Cash
Batch) or AR24.1 (Cash Batch Release).


Updated Files

    None.


Referenced Files

    ARCOMP     - Validates the AR company record.

    ARCUSTGRP  - Validates the AR customer group.

    ARPYMNTHDR - Accesses the payment batch total amounts.


INVOKED Programs

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