AR501 – Customer Conversion
- System
- Accounts Receivable (AR)
- Type
- Batch program
- Updates
- 37 tables
- References
- 47 tables
AR501 (Customer Conversion) is a Lawson Accounts Receivable batch program. It updates ARACMUF, ARAUDIT, ARCCUST, ARCCUST2, ARCSTMXVAL, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER and 29 more and references AGEUSERONE, AGINGCODE, APACCRCODE, APCOMPANY, APVENGROUP, ARAPPLDBOD, ARAPPLIED, ARCODE and 39 more.
About AR501
Run Customer Conversion (AR501) to import customer records to the Lawson Accounts Receivable application from the customer conversion file (ARCCUST). **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 (37)
| Table | Description | System |
|---|---|---|
| ARACMUF | The Customer User Fields file contains extra user fields that can be entered for a customer. | AR |
| ARAUDIT | No description in the Lawson data dictionary | AR |
| ARCCUST | AR Customer Conversion | AR |
| ARCCUST2 | No description in the Lawson data dictionary | AR |
| ARCSTMXVAL | This file contains an attribute value for a customer. | AR |
| ARCUSTFLDS | AR Customer User Fields | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| ARCUSTPER | AR Customer Period Totals | AR |
| ARIBILLTO | No description in the Lawson data dictionary | AR |
| ARICUSTPER | Customer Period Conversion | AR |
| ARIEFT | No description in the Lawson data dictionary | AR |
| ARIMICR | MICR Customer Xref Conversion | AR |
| ARIOECUST | Customer Order Processing Conv | AR |
| ARLOCKBOX | Lock Box Location | AR |
| ARMICRCUST | AR MICR Customer Cross Ref | AR |
| BILLTO | Bill To | AR |
| CBBANKINST | Bank Transaction Code | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CRANALYST | AR Credit Analysts | AR |
| CUSTDEFLTS | AR Customer Defaults | AR |
| CUSTDESC | AR Group Customer | AR |
| CUSTEP | No description in the Lawson data dictionary | BL |
| DTCUSTBANK | AR Customer Paying Bank | DT |
| FTCUSTNOTE | EFT Customer Notification | AR |
| HOLDCODES | AR Hold Code | AR |
| MAJCUSTCL | Major Customer Class | AR |
| MINCUSTCL | Minor Customer Class | AR |
| MXLISTHDR | Attribute List Header | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECUST | Customer Order Processing | AR |
| SALESREP | Accounts Receivables Sales Rep | AR |
| TERITORY | AR Territories | AR |
| TERMS | Payment Terms Maintenance | TE |
| TXCOMPANY | Tax Company | TX |
Referenced files (47)
| Table | Description | System |
|---|---|---|
| AGEUSERONE | No description in the Lawson data dictionary | AR |
| AGINGCODE | Accounts Receivable Aging Code | AR |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| ARAPPLDBOD | No description in the Lawson data dictionary | AR |
| ARAPPLIED | Acct Receivables Application | AR |
| ARCODE | AR GL Code | AR |
| ARCOMP | Accounts Receivable Company | AR |
| ARCONTACTS | AR Customer Contacts | AR |
| ARCUSTBOD | No description in the Lawson data dictionary | AR |
| ARCYCLE | Accounts Receivable Cycle Code | AR |
| ARDUNCODE | Dunning Process Code | AR |
| ARFINANCE | Finance Charge Rate Code | AR |
| AROIHDR | Acct Receivables Trans Header | AR |
| AROITEMS | Acct Receivables Transaction | AR |
| ARPAYMENT | Acct Receivables Payment | AR |
| ARREASON | Accounts Receivable Reason Cd | AR |
| ARREMIT | Payment Remittance | AR |
| ARUSRFLDEF | The User Field Definition file defines field types and data types for customer, payment, payment header, and trasaction… | AR |
| BILLTOBOD | No description in the Lawson data dictionary | AR |
| CBBANKENT | Bank | CB |
| CONBOD | No description in the Lawson data dictionary | AR |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTORDER | Customer Order File | OE |
| EPTRANS | No description in the Lawson data dictionary | BL |
| FTCUSTGRP | EFT Customer Group | AR |
| FTTRANS | EFT Transaction | AR |
| GLINTCO | General Ledger Intercompany | IF |
| GLSYSTEM | General Ledger Company | IF |
| ICLOCATION | Company Location | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| MXTMPLDTL | Attribute Template Detail | IF |
| MXTMPLHDR | Attribute Template Header | IF |
| OECOMPANY | Order Entry Company | BL |
| OECUSTCODE | Order Entry Customer Codes | BL |
| OEFRTCODE | Order Entry Freight Code | BL |
| OEINVOICE | Invoice | BL |
| OEMETHOD | Shipping Method | WH |
| OEORDDISC | Order Discount | BL |
| OEPRCLIST | Price List | BL |
| SHIPTO | Customer Ship To Address | BL |
| TXTAXCODE | Tax Code Maintenance | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU