Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR30


AR30.1 - Entry and Application

**Form Purpose
Use Entry and Application (AR30.1) to enter and apply cash.




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    ARADJUST   - Updated with adjust records for the open item in use.

    ARAPMUF    -

    ARAPPLIED  - Update with applied records for open items in use.

    ARCOMP     - Update with last chargeback number used.

    ARCUSTOMER - Updates last payment information and updates customer
                 balances. File also used to validate customer record.

    ARCUSTPER  - Updates customer period totals for transactions processed.

    ARDISTRIB  - Creates distribution records upon release of payment batch.

    AROIHDR    - Updates applied amount of open item header.

    AROITEMS   - Updated with application and adjustment amounts. Status is
                 changed.

    AROPIVOT   -

    AROPTR     -

    ARPAYMENT  - Updated for amount of payment applied to an invoice or updated
                 by new payment added via program. Status may also be updated.

    ARPROCLEVL - Accesses the process level account unit, and update used flag.

    ARPYMNTHDR - Updated for payment sequence and batch control totals. GL Date
                 is used for application GL date based on company option.

    ARREASON   - Determines the reason code type, chargeback type, and reason
                 code description. Also marks reason code as used.

    ARREMIT    - Creates payment remit records.

    ARSADJUST  - Temporary cash application adjustment record created.

    ARSAPPLIED - Temporary cash application record created.

    ARSUMMARY  - Validates summary  record.

    ARUADJUST  -

    ARUDISTRIB -

    ARUOIHDR   -

    ARUPMNTHDR -

    ARUSADJUST -

    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 balance with payment and adjustment amounts.

    GLCOMMIT   -

    GLCOMMITX  -

    MXLISTHDR  -

    NATBALANCE - National account balances updated with payment
                 amounts/applications.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates the tax code.

    TXTAXTABLE - Validates tax table transaction records.

    TXTAXTRAN  - Creates tax transaction records.


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ACACTMXVAL -

    ACAMCODE   -

    ACASSIGN   -

    ACCATSUMX  -

    ACCNTRACT  -

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    ARAPSELECT -

    ARCODE     - Obtains the received not applied code.

    ARCUSTGRP  - Validates the customer group.

    ARMAP      -

    ARPREPAY   -

    ARREMIT    - Creates payment remit records.

    ARRTM      - Used in payment display processing.

    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.

    CUACCT     - Used as part of currency validation.

    CUCONV     - Obtains a currency exchange rate.

    CURELAT    -

    CUSTORDER  -

    GLADDRESS  - Used as part of the company validation.

    GLCHART    - Validates the chart name of the GL company.

    GLCODES    - Used to validate system control.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLNAMES    -

    GLSYSTEM   - Obtains general ledger period information.

    INSTCTRYCD -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTMBR  -

    NATACCT    - Validates national account relationship.

    OECOMPANY  -

    SYSTEMCODE -

    TXTAXRATE  - Validates tax rate.

    WFSETUP    -


AR30.2 - Entry and Speed Application

**Form Purpose
Use Speed Entry (AR30.2) to speed apply cash.

**More Information
This subform does not display open items; you must directly select them for
cash application. You cannot apply cash to items that have already been
selected in Entry and Application (AR30.1) or Line Item Application (AR34.1).

Note This subform creates application select records. To process applications
entered from this subform, use AR30.1 or AR34.1.




Updated Files

    AROPTR     -

    ARPAYMENT  - Creates payment records.

    ARSADJUST  - Creates temporary application adjustment records, deleted by
                 process function.

    ARSAPPLIED - Creates temporary application records, deleted by process
                 function.


Referenced Files

    ARAPSELECT -

    ARCOMP     - Updates company record with last chargeback number used.

    ARCUSTOMER - Updates customer record with payment statistic.

    AROIHDR    - Creates open item header record for credit memo creation.

    AROITEMS   - Updates open item record with applied and adjust amounts.

    ARPROCLEVL - Updates process level with used flag.

    ARREASON   - Updates reason code file with used flag.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    GLCODES    - Used to validate system control.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLSYSTEM   - Used as part of general ledger account validation.

    NATACCT    - Used to validate national account customer relationship.


AR30.3 - Payment Write-Off

**Form Purpose
Use Payment Write-off (AR30.3) to write off a payment.

**More Information
Click the More link to access the Adjustment GL Accounts subform to define
general ledger account information.




Updated Files

    ARSADJUST  - Creates temporary application adjustment records, deleted by
                 process function.

    ARUPMNTHDR -

    ARUSADJUST -


Referenced Files

    ARAPSELECT -

    ARCOMP     - Updates company record with last chargeback number used.

    ARPAYMENT  - Creates payment records.

    ARPROCLEVL - Updates process level with used flag.

    ARPYMNTHDR - Validates payment header record.

    ARREASON   - Updates reason code file with used flag.

    ARSAPPLIED - Creates temporary application records, deleted by process
                 function.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    GLCODES    - Used to validate system control.

    GLSYSTEM   - Used as part of general ledger account validation.


AR30.5 - Selection Criteria

**Form Purpose
Use Selection Criteria (AR30.5) to define selection criteria for open item.
All open items that fit the criteria you define will be marked as selected for
application.

**More Information
Two sets of selection criteria are available; company options and transaction
options. You can combine these two categories of criteria to narrow the
selection process.

Note The selection process will override any open items that have already
been selected. You can select Yes in the Selected Transactions Only field on
the Transaction form tab to refine the search. This will limit the selection
to items already selected.

If you unselect the transactions marked as selected by the filter the
selection criteria are automatically turned off.




Updated Files

    MXLISTHDR  -

    MXLISTMBR  -


Referenced Files

    ACACTGRP   -

    ACACTIVITY -

    ACACTMXVAL -

    ACADDLCNTR -

    ACAMCODE   -

    ACASNROLE  -

    ACASSIGN   -

    ACCNTRACT  -

    ACGRPMXVAL -

    ACROLE     -

    ARCOMP     - Validates Accounts Receivable company file.

    GMAWARD    -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -


AR30.6 - Adjustments

**Form Purpose
Use Adjustments (AR30.6) to define and maintain application adjustments.

**More Information
Click the More link to define GL accounts for the adjustments.




Updated Files

    ADDRDATA   -

    ARSADJUST  - Temporary cash application adjustment record created.

    ARSAPPLIED - Temporary cash application record created.

    ARUOIHDR   -

    ARUSADJUST -

    CBBANKINST -


Referenced Files

    ARAPSELECT -

    ARCOMP     - Validates accounts receivable company.

    ARCUSTGRP  -

    ARCUSTOMER -

    AROIHDR    - Used to validate open item header record.

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

    ARPAYMENT  -

    ARPROCLEVL - Used to validate process level.

    ARPYMNTHDR -

    ARREASON   - Validates reason code record.

    CUCONV     -

    CURELAT    -

    GLADDRESS  -

    GLCHART    -

    GLSYSTEM   -

    INSTCTRYCD -


AR30.7 - Chargeback Memo

**Form Purpose
Use Chargeback Memo (AR30.7) to define and maintain chargeback memos.

**More Information
Click the More link to access the Adjustment GL Accounts subform. Use the
subform to define general ledger account information for the adjustment.




Updated Files

    ARSADJUST  - Temporary cash application adjustment record created.

    ARUSADJUST -


Referenced Files

    ARAPSELECT -

    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTOMER - Used to validate customer.

    ARPAYMENT  - Creates payment records.

    ARPROCLEVL - Used to validate process level.

    ARPYMNTHDR - Validates payment header record.

    ARREASON   - Validates reason code record.

    ARSAPPLIED - Temporary cash application record created.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    GLSYSTEM   - Used as part of general ledger account validation.

    NATACCT    - Used to validate national account customer relationship.


AR30.8 - Range Application

**Form Purpose
Use Range Application (AR30.8) to apply cash to a range of transactions based
on criteria you define.

Note Unlike Entry and Application (AR30.1) or Line Item Application (AR34.1),
this subform does not create select records, all applications are immediately
applied.

**More Information
If you enter a transaction number that is not valid for the transaction type
you selected, the system attempts to find a transaction with that transaction
number, but of a different type. The second transaction type is based on an
ascending order of transaction types; credit memos, debit memos, and invoices.


Examples:

- If the initial transaction type is invoices, the system will check all
credit memos next, then all debit memos for a matching transaction number.

- If the initial transaction type is debit memos, the system will check all
invoices next, then all credit memos for a matching transaction number.

- If the initial transaction type is credit memos, the system will check all
debit memos next, then all invoices for a matching transaction number.




Updated Files

    ADDRDATA   -

    ARADJUST   - Creates application adjustment record.

    ARAPPLIED  - Creates application record.

    ARCOMP     - Updates company record with last chargeback number used.

    ARCUSTOMER - Updates customer record with payment statistic.

    ARCUSTPER  - Updates customer period record with payment and application
                 statistics.

    AROIHDR    - Creates open item header record for credit memo creation.

    AROITEMS   - Updates open item record with applied and adjust amounts.

    AROPIVOT   -

    AROPTR     -

    ARPAYMENT  - Creates payment records.

    ARPROCLEVL - Updates process level with used flag.

    ARREASON   - Updates reason code file with used flag.

    ARSADJUST  - Temporary cash application adjustment record created.

    ARUADJUST  -

    ARUOIHDR   -

    ARUSADJUST -

    ARXIND     -

    CBBANKINST - Used as part of payment code validation.

    CUSTDESC   - Validates customer description record.

    MXLISTHDR  -

    NATBALANCE - Used as part of national account validation.


Referenced Files

    ARAPSELECT -

    ARCUSTGRP  - Used to validate customer group.

    ARDISTRIB  - Validates tax point distribution status.

    ARPYMNTHDR - Validates payment header record.

    ARRTM      - Used in payment display processing.

    ARSAPPLIED - Temporary cash application record created.

    CUACCT     - Used as part of currency validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    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.

    INSTCTRYCD -

    NATACCT    - Used to validate national account customer relationship.


INVOKED Programs

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