Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR501


AR501 - Customer Conversion

**Form Purpose
Run Customer Conversion (AR501) to import customer records to the Lawson
Accounts Receivable system from a file created by an external source.

**Processing Effect
The Update Option is used to edit only or edit and update the customer
records. The program edits the external data to protect the integrity of the
Accounts Receivable data.

The program creates a report in customer order that includes each field that
failed an edit, the field data, a description of the error, and totals for the
number of records processed, customers added, customer comments added, and
errors.

Note This program updates customer transaction period totals. Transaction
Conversion (AR502), Payment Conversion (AR503), Application Conversion (AR504)
do not update customer period totals.




Updated Files

    ARACMUF    -

    ARAUDIT    -

    ARCCUST    - Deletes conversion customer records after like records are
                 created.

    ARCSTMXVAL -

    ARCUSTFLDS - Creates customer user-define fields.

    ARCUSTGRP  - Updates customer group with last customer number used.

    ARCUSTOMER - Creates customer records.

    ARCUSTPER  - Updates customer period totals for credits, billed,
                 chargebacks, write-offs, and sales.

    ARIBILLTO  -

    ARICUSTPER - Deletes conversion customer period records after like records
                 are created.

    ARIEFT     -

    ARIMICR    - Deletes conversion MICR/customer records after like records
                 are created.

    ARIOECUST  - Deletes conversion customer OE fields records after like
                 records are created.

    ARLOCKBOX  - Verifies remit lock box code.

    ARMICRCUST - Creates MICR/customer records.

    BILLTO     -

    CBBANKINST - Used to validate payment code.  The used flag is set to "Y".

    CKPOINT    - Used in program re-start logic.

    CRANALYST  - Verifies credit analyst code.

    CUSTDEFLTS - Verifies customer default code.

    CUSTDESC   - Creates customer description records.

    CUSTEP     -

    DTCUSTBANK -

    FTCUSTNOTE -

    HOLDCODES  - Verifies hold codes.

    MAJCUSTCL  - Use to verify major class.

    MINCUSTCL  - Use to verify minor class.

    MXLISTHDR  -

    MXOBJCAT   -

    NATACCT    - Creates national account records.

    NATBALANCE - Creates national account balance records.

    OECUST     - Creates customer OE field records.

    SALESREP   - Verifies sales representative.

    TERITORY   - Verifies territory code.

    TERMS      - Verifies terms code.

    TXCOMPANY  -


Referenced Files

    AGINGCODE  - Verifies aging code.

    APACCRCODE -

    APCOMPANY  - Obtains company default information.

    APVENGROUP - Verifies vendor information if carrier field is used.

    ARCODE     - Validates AR code.

    ARCOMP     - Validates company

    ARCYCLE    - Verifies statement cycle code.

    ARDUNCODE  -

    ARFINANCE  -

    ARREASON   - Validates reason code record.

    ARUSRFLDEF -

    CBBANKENT  -

    CUCONV     -

    CURELAT    - Verifies currency relationship with invoice currency code.

    CUSTORDER  - Determines if any order entry orders exist before a customer
                 can be deleted.

    EPTRANS    -

    FTCUSTGRP  -

    GLINTCO    - Verifies intercompany relationships for national accounts.

    GLSYSTEM   - Validates part of company information.

    ICLOCATION - Validates item location record.

    INSTCTRYCD -

    INSTREGN   -

    MXTMPLDTL  -

    MXTMPLHDR  -

    OECOMPANY  - Validates Order Entry company record.

    OECUSTCODE - Validates Order Entry customer code.

    OEFRTCODE  - Validates Order Entry freight code.

    OEINVOICE  - Determines if any order entry invoices exist before a customer
                 can be deleted.

    OEMETHOD   - Validates Order Entry shipment method code.

    OEORDDISC  - Validates Order Entry order discount code.

    OEPRCLIST  - Validates Order Entry price list code.

    SHIPTO     - Validates Order Entry ship-to code.

    TXTAXCODE  -

    WFSETUP    -


INVOKED Programs

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