AP110 – Mass Vendor Update
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 27 tables
- References
- 61 tables
AP110 (Mass Vendor Update) is a Lawson Accounts Payable batch program. It updates APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APVENADDR, APVENCERT and 19 more and references APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND and 53 more.
About AP110
Run Mass Vendor Update (AP110) to update codes assigned to all or a range of vendors within a vendor group. The form lets you update vendorpriority, prenotification status, and any of the codes listed on this form with a new code without having to change each vendor record individually in AP10.1(Vendor). If you select Yes in the Update Locations field, the form updates vendors and associated alternate vendor locations, if applicable.
More information: Use the Invoice tab to define information used to update invoice processing codes. Use the Payment tab to define information used to update paymentprocessing codes. Use the Distribution tab to define information used to update default invoice distribution codes and activities. Use the Match tab to defineinformation used to update matching options. For each code, you can - update vendors assigned a specific code with a new code by completing theBefore and After fields, - update vendors with a new code regardless of the old code assigned byleaving the Before field blank and completing the After field, or - clear a code field for vendors assigned a specific code by completing theBefore field and leaving the After field blank. If you clear a code field and the vendor class has a default code assigned, the code assigned to the vendor class defaults on the updated vendor record. For example, you change your standard payment terms from 30 days to 45 days. You define a new terms code, called "P45" in the Terms application. Most of the vendors in your vendor group have the old "P30" terms codeassigned. The vendor update form lets you assign the new "P45" terms code to all vendors and locations that have the old "P30" terms code assigned.
Updated files (27)
| Table | Description | System |
|---|---|---|
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (61)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APDIVCODE | Accounts Payable Diversity Cd | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCGRP | Process Group | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| CBBANKENT | Bank | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBPAYMENT | Cash Payment | CB |
| CBRECPTHDR | Cash Receipt Deposit | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSBOD | No description in the Lawson data dictionary | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVENDLOC | Vendor Location Master | PO |
| PROCUREGRP | Procurement Group | PO |
| PURCHORDER | Purchase Order Master | PO |
| TXTAXRATE | Tax Rate | TX |
| VBABOD | No description in the Lawson data dictionary | AP |
| 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