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)

TableDescriptionSystem
APAPPROVALInvoice ApprovalAP
APAUDITVendor Invoice AuditAP
APCOMMENTSCommentsAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APHLDINVHoldAP
APVENADDRAP Vendor AddressAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENGROUPVendor GroupAP
APVENLOCVendor LocationAP
APVENMASTVendor Master RecordAP
APVENPAYNo description in the Lawson data dictionaryAP
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CKPOINTNo description in the Lawson data dictionary
CUSTDESCAR Group CustomerAR
GLNLOCDTLNo description in the Lawson data dictionaryIC
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
POPOVUFNo description in the Lawson data dictionaryPO
POVENDLOCVendor Location MasterPO
POVENDORPO Vendor MasterPO
TERMSPayment Terms MaintenanceTE
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (61)

TableDescriptionSystem
APACCRCODEInvoice Accrual CodeAP
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUTHORAuthority CodeAP
APCOMMENTSCommentsAP
APCOMPANYAccounts Payable CompanyAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APDISCCODEDiscount CodeAP
APDISTHDRDistribution Code HeaderAP
APDIVCODEAccounts Payable Diversity CdAP
APDRAFTSAP Bill of ExchangeAP
APHOLDCODEHold CodeAP
APINCCODEIncome CodeAP
APINVOICEAccounts Payable InvoiceAP
APPAYMENTInvoice PaymentAP
APPMTBODNo description in the Lawson data dictionaryAP
APPROCGRPProcess GroupAP
APUSRFLDEFAP User Field DefinitionAP
APVENBALVendor BalanceAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENCLASSVendor ClassAP
APVENLCBODNo description in the Lawson data dictionaryAP
APVNMXVALNo description in the Lawson data dictionaryAP
ARCUSTGRPAccounts Receivable Cust GroupAR
CBBANKENTBankCB
CBCASHFORMCash Payment FormatCB
CBCHECKAccounts Payable Cash PaymentCB
CBPAYMENTCash PaymentCB
CBRECPTHDRCash Receipt DepositCB
CBTRANSBank TransactionCB
CBTRANSBODNo description in the Lawson data dictionaryCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
EEADVANCEEmployee AdvanceAP
EEAPPROVALExpense Advance Approval CodeAP
EEEXPENSEEmployee ExpenseAP
GLNLOCDTLNo description in the Lawson data dictionaryIC
GLSYSTEMGeneral Ledger CompanyIF
INSTCTRYCDIntrastat Country CodesTX
INSTREGNIntrastat Region CodeTX
MAINVHANDInvoice Handling CodeMA
MAMATCHTBLMatch TableMA
MAMSGTOLNo description in the Lawson data dictionaryMA
MAMTCHRULEMatching RulesMA
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
POAOCDTLAdd On Cost DetailPO
POITEMVENPO Vendor Item InformationPO
POVAGRMTHDVendor AgreementPO
POVENDLOCVendor Location MasterPO
PROCUREGRPProcurement GroupPO
PURCHORDERPurchase Order MasterPO
TXTAXRATETax RateTX
VBABODNo description in the Lawson data dictionaryAP
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (11)

ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU