Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR21


AR21.1 - Cash MICR Assignment

**Form Purpose
Use Cash MICR Assignment (AR21.1) to enter cash using the MICR (Magnetic Ink
Character Recognition) number of the payment.

**Processing Effect
The system searches for a MICR customer cross reference defined in MICR
Customer (AR13) to assign the payment to a customer. If no cross reference is
defined, the payment is added unassigned. You can use Unassigned Cash
(AR28.1), or one of the other Cash Entry (AR21) or Cash Assignment (AR28)
forms to assign the payment later.

You can use Payment Transfer to Non-AR (AR29.2) 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 Cash Batch (AR20) and credit the
received not applied account assigned to the cash batch in Cash Batch (AR20)
or the process level in.

**More Information
Click the Totals link to view totals for the batch.

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




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    ARADJUST   - Adjust amounts are changed when payments are deleted.

    ARAPMUF    -

    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 -

    ARUPMNTHDR -

    ARXIND     -

    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.

    GLCOMMIT   -

    GLCOMMITX  -

    MXLISTHDR  -

    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  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - 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 -

    CBSTMTDTL  -

    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  -

    GLADDRESS  - Validates part of company information.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Verifies general ledger dates.

    GLNAMES    -

    GLSYSTEM   - Validates general ledger company information.

    INSTCTRYCD -

    NATACCT    - Validates the national account relationship.

    OECOMPANY  -

    SYSTEMCODE -

    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.2 - Cash Customer, Transaction Assignment

**Form Purpose
Use Cash Customer, Transaction Assignment (AR21.2) 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.

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

**More Information
Use the PrePay link to access a subform to add prepayment information for a
payment. Use the Remit link to access a subform to enter transactions
referenced on the payment's remittance advice. Use the Totals link to view
totals for the batch.

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




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    ARADJUST   - Deletes adjustment record if payment is deleted.

    ARAPMUF    -

    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 -

    ARUPMNTHDR -

    ARXIND     -

    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.

    GLCOMMIT   -

    GLCOMMITX  -

    MXLISTHDR  -

    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  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - 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 -

    CBSTMTDTL  -

    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  -

    GLADDRESS  - Used as part of company validation.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Verifies general ledger dates.

    GLNAMES    -

    GLSYSTEM   - Validates general ledger company information.

    INSTCTRYCD -

    NATACCT    - Validates the national account relationship.

    OECOMPANY  -

    SYSTEMCODE -

    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.3 - Cash Non-AR

**Form Purpose
Use Cash Non-AR (AR21.3) 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.

**Processing Effect
Non-accounts receivable payments debit the general ledger account defined for
the cash code assigned to the cash batch in Cash Batch (AR20) and credit (or
may debit) the general ledger account(s) you assign to the payment on this
form.

**More Information
Click the More link to access the Expanded Distribution subform to enter
units or tax information for a payment distribution.

Click the Totals link to view totals for the batch.

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




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    ARADJUST   - Deletes adjust records if payment is deleted.

    ARAPMUF    -

    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 -

    ARUPMNTHDR -

    ARXIND     -

    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.

    GLCOMMIT   -

    GLCOMMITX  -

    MXLISTHDR  -

    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  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    APACCRCODE - Validates accrual code.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - 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 -

    CBSTMTDTL  -

    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  -

    GLADDRESS  - Validates part of company information.

    GLCHART    - Validates the chart number of the GL company.

    GLCODES    - Verifies general ledger dates.

    GLINTCO    - Validates intercompany relationships.

    GLNAMES    - Used in GL company validation.

    GLSYSTEM   - Used in GL company validation.

    INSTCTRYCD -

    NATACCT    - Validates national account relationships.

    OECOMPANY  -

    SYSTEMCODE -

    TXTAXRATE  - Validates the tax rate.

    WFSETUP    -


AR21.4 - Cash Remittance

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

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

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




Updated Files

    ARAPMUF    -

    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     -

    CURELAT    -

    CUSTDESC   -

    GLSYSTEM   -

    NATACCT    -


AR21.5 - Cash Remittance

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




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     -

    ARCUSTOMER -

    AROIHDR    -

    ARPYMNTHDR - Validates the batch header.

    NATACCT    -


AR21.6 - More

**Form Purpose
Use More (AR21.6) to enter prepayment information for a payment. Prepayment
may be referenced to be auto applied to an invoice via AR129 Automatic
Prepayment Apply, with reference to a purchase order number, to a Lawson's
Order Entry order number, or to a specified invoice number.




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.

    COSGBLK    -

    OEINVSGBLK -


Referenced Files

    ARCODE     - Validates the prepayment code entered.

    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTOMER -

    AROIHDR    -

    AROITEMS   -

    CUSTORDER  -

    OEINVOICE  -


AR21.7 - Totals

**Form Purpose
Use Totals (AR21.7) to view cash batch totals, including control totals,
entry totals, and the difference between the control and entry totals for a
cash batch.

**More Information
If you selected batch control totals for the company in Company (AR01),
control totals must match entry totals before you can release a batch. You can
adjust the control totals, if needed, in Cash Batch (AR20.1) 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.


AR21.9 - Payment User Fields

**Form Purpose
Use Payment User Fields (AR21.9) to enter user-defined data defined in
Company (AR01.1). This information is for reference only.




Updated Files

    None.


Referenced Files

    ARUSRFLDEF -


INVOKED Programs

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