AP115 – Vendor Merge
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 101 tables
- References
- 101 tables
AP115 (Vendor Merge) is a Lawson Accounts Payable batch program. It updates ACAMCODE, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU, AMACCTGRP, AMASSET, AMASSETADJ and 93 more and references AMASSETBOD, AMASSETDSP, AMASSETTRF, AMASTBKDSP, AMASTBKTRF, AMASTITDSP, AMASTITTRF, AMASTMXVAL and 93 more.
About AP115
Run Vendor Merge (AP115) to transfer a vendor's open invoices to another vendor. You can also transfer 1099 historical invoices from one vendor to another. This form creates an audit trail for the vendor merge. AP115 gives you the option to create comments about the vendor merge for both to vendor and from vendor. The comment will include the system date of the vendor merge. AP115 creates three reports: Report 1 lists the invoices that were transferred. Listing includes: - A detail listing of invoices transferred - Summary listing of invoices transferred - Lists invoices moved Report 2 lists invoices where the location code was removed. Listingincludes: - Listing of invoices not transferred and the reason/error Report 3 lists invoices that cannot be transferred. **Processing Effect If a duplicate invoice is encountered, the invoice is given an extension to the invoice number. This extension is "-1". The form then checks to see if the new invoice number is a duplicate. The form uses the company, vendor, invoice number, and invoice suffix. If this invoice number is still aduplicate invoice, the invoice will not be transferred and the invoice will be listed on the duplicate invoice report. If an invoice is a duplicate it will not be transferred, and it will be listed on the Duplicate Invoice Report. You will have to manually resolve the invoice. If an invoice with an extension number is not a duplicate it will be listed on the Invoice Number Change Audit Report. This provides audit trail for changed invoice numbers. If the original invoice number is greater than 20 characters, the form cannot add an extension to the invoice number and the invoice will not be transferred. It will be listed on the Duplicate Invoice Report, and must be resolved manually. If an invoice has a remit to location code that is not defined for the vendor the invoice is being transferred to, the location code will be removed from the invoice when it is transferred. This has an impact on the location code balance and vendor balances. If an invoice with a remit to code that does not exist on the to vendor is transferred, the remit to code will not be transferred. AP115 will list invoices where the remit to code was removed. Cash codes and bank codes will be updated on invoices that are transferred between vendors. Partially paid invoices will not be transferred. Partially paid invoices will be listed by AP115. The current balances (vendor group, company, vendor, location code, and balance currency) and highest balance are updated as invoices aretransferred between vendors. If an invoice has a location code that is not defined for the vendor the invoice is being transferred to, the location code will be removed from the invoice. In this case the location code balance of the original vendor will decrease by the invoice amount, and the vendor balance (not the location code balance) of the new vendor will increase by the invoice amount. NOTE 1 AP115 does not update the vendor hash totals on the batch records. NOTE 2 AP115 will not transfer unreleased invoices that have applications by an unreleased payment or check. NOTE 3 AP115 will not transfer prepayment credit memos and employee advance credit memos between vendors. NOTE 4 AP115 does not update the invoice description on the distribution records. These descriptions will be inaccurate if you have set the vendor number and vendor name to default as the invoice description.
Updated files (101)
| Table | Description | System |
|---|---|---|
| ACAMCODE | Activity Asset | AC |
| ADDRDATA | Address Code | IF |
| AMACCOUNT | Asset Management Account | AM |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMACCTGRP | Asset Account Group | AM |
| AMASSET | Asset | AM |
| AMASSETADJ | Asset Adjustment | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETGRP | Asset Group | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKADJ | Asset Book Adjustment | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTBOOK | Asset Book | AM |
| AMASTITADJ | Asset Item Adjustment | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITEM | Asset Item | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRECAP | Asset Depreciation Recapture | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMASTTYPE | Asset Type | AM |
| AMAUGROUP | Asset Accounting Unit Group | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMBKHIST | Asset Book History | AM |
| AMBKHISTX | Period Asset Book History | AM |
| AMBKTEMPLT | Book Template | AM |
| AMBKTRANS | Asset Book Transactions | AM |
| AMCALENDAR | Asset Calendar | AM |
| AMCLASSDEP | This file contains the depreciation information for account level depreciation to support Telecommunications Industry… | AM |
| AMCNTRLAU | Asset System Options Audit | AM |
| AMCONTROL | Asset Internal Control | AM |
| AMCTLTRANS | Asset Control Transaction | AM |
| AMDIVISION | Asset Division | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMINTER | Asset Interface | AM |
| AMINTERAU | Asset Interface Audit | AM |
| AMLOCATION | Asset Location | AM |
| AMLOCAUDIT | AM Location Audit | AM |
| AMMONITOR | No description in the Lawson data dictionary | AM |
| AMPOASTDTL | PO Asset Detail | AM |
| AMPOASTHDR | PO Asset Header | AM |
| AMPODFLTS | PO Defaults | AM |
| AMPUHIS | Personal Use History | AM |
| AMSEGBLOCK | No description in the Lawson data dictionary | AM |
| AMTAXAUTH | Tax Authority | AM |
| AMTEMPLATE | Asset Template | AM |
| AMTRANS | Asset Transaction | AM |
| AMTRANSUMM | Asset Transaction Summary | AM |
| APAPDHIST | No description in the Lawson data dictionary | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPHIST | AP Payment History | AP |
| 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 |
| APDISCACC | Discount | AP |
| APDISTRIB | Invoice Distribution | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APRPTBLINC | No description in the Lawson data dictionary | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | 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 |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAAOIHIST | No description in the Lawson data dictionary | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MAPOINV | Multiple PO Invoice | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAOCSPRD | Add On Cost Spread | PO |
| POAUDIT | Audit Records | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POPSPHIST | No description in the Lawson data dictionary | PO |
| PORECLINE | PO Line Item Receivings | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| RQAUDIT | Requisition Audit | RQ |
| SYSTEMCODE | System Code | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (101)
| Table | Description | System |
|---|---|---|
| AMASSETBOD | No description in the Lawson data dictionary | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMBOOK | Asset Book Name | AM |
| AMCOMPUTE | Compute | AM |
| AMLOCDTL | Location Detail | AM |
| AMMETHOD | Asset Method | AM |
| AMPUCODE | Asset Personal Use Code | AM |
| AMTABLEPCT | Percent Table | AM |
| AMTABLETAX | Asset Management Tax Table | AM |
| AMTRANSBOD | No description in the Lawson data dictionary | AM |
| AMTYPALLOC | The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype). | AM |
| AMTYPALLOX | The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or… | AM |
| AMUOPPDS | Units of Production Periods | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | 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 |
| APPAYGROUP | Pay Group | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCGRP | Process Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | 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 |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| ICCOMPANY | Inventory Company Information | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| LMLEASE | Lease Information | LM |
| LMLEASESEG | This file stores the user analysis values for a lease. | LM |
| 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 |
| POAOCMAST | Add On Cost Master | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| POCOMPANY | Company System Master | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POLINE | Line Items | PO |
| PORECLINE | PO Line Item Receivings | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| POVAGRMTHD | Vendor Agreement | PO |
| POVENDLOC | Vendor Location Master | PO |
| PROCUREGRP | Procurement Group | PO |
| PURCHORDER | Purchase Order Master | PO |
| REQHEADER | Requisition Header | RQ |
| REQLINE | Requisition Line | RQ |
| 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 (27)
ACAC, ACTA, AMCO, API3, API4, GLCC, ICI1, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POIF, POIG, POIL, POIM, SLFD, SLSB, SLSE, SLSS, SLSU