AR501 - Customer Conversion

AR501 (Customer Conversion) lets you convert customer records to the Lawson
Accounts Receivable system from a file created by an external source. 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. AR502
(Transaction Conversion), AR503 (Payment Conversion), AR504 (Application
Conversion) do not update customer period totals.



Updated Files

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


    ARCOMMENT  - Creates customer level comment records.

    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.


    ARICUSTCMT - Deletes conversion customer comment records after like records
                 are created.


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


    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.

    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.

    DTCUSTBANK - Validates customer paying bank information.

    HOLDCODES  - Verifies hold codes.

    MAJCUSTCL  - Use to verify major class.

    MINCUSTCL  - Use to verify minor class.

    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.

    APCPYVND   - Used as part of vendor validation.

    APHLDINV   - Used as part of vendor validation.

    APVENCLASS - Verifies vendor information if carrier field is used.

    APVENGROUP - Verifies vendor information if carrier field is used.

    APVENMAST  - Verifies vendor information if carrier field is used.

    ARCODE     - Validates AR code.

    ARCOMP     - Validates company

    ARCYCLE    - Verifies statement cycle code.

    ARFINANCE  - Validates finance charge code.

    ARREASON   - Validates reason code record.

    CBBANKENT  - Validates general bank information.

    CUCONV     - Validates the currency conversion rate.

    CURELAT    - Verifies currency relationship with invoice currency code.

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


    GLINTCO    - Verifies intercompany relationships for national accounts.

    GLSYSTEM   - Validates part of company information.

    ICLOCATION - Validates item location record.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTREGN   - Validates the Intrastat region code.

    OECOMPANY  - Validates Order Entry company record.

    OECREDCARD - Validates Order Entry credit card data.

    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  -


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFCC