AP520 – Invoice Interface
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 54 tables
- References
- 97 tables
AP520 (Invoice Interface) is a Lawson Accounts Payable batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, AMCONTROL, AMINTER, AMINTERAU, AMRPRINTER and 46 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBRDNTRAN, ACBUDHDR and 89 more.
About AP520
Run Invoice Interface (AP520) to import invoice, split invoice payment, and general ledger distribution information from a non-Lawson system to the Accounts Payable application. You must set up the following codes and information as valid records if this information is to be converted as part of the invoice, split invoice payment, or distribution records: cash codes, payment codes, accrual codes, distribution codes, hold codes, diversity codes, vendor location codes,currency codes, tax codes, activities, and asset information. **Process at a Glance 1. Load external invoice data into the appropriate interface files. 2. Use this form to interface invoice information from a non-Lawson system. 3. List invoices with errors using Invoice Errors (AP52.6). 4. Correct records that did not interface using Invoice Interface (AP52.1),Multiple Payment Interface (AP52.2), or Distribution Interface (AP52.3). 5. Run AP520 again to interface corrected records. The application will not let you reprocess the interface until you correct the invoiceerrors. **Processing Effect You load external invoice data through specified input files. For a list of these files, see the Accounts Payable User Guide. If your Accounts Payable application is set up to check payment status on invoices, after release an Accounts Payable API is run to verify ifactivity requires payment information.
More information: Indicate which company you want to interface invoices information for and the sort order for the resulting report. You must select a batch number or an authority code if you are interfacing or converting unreleased invoices. The batch number or authority code isoptional when interfacing or converting released (open) or historical invoice, split invoice payment, and distribution records. You can use Invoice Interface (AP52) to add invoice, payment, and distribution information to the invoice, distribution, and paymentconversion files or to maintain information already loaded into these files before you run this form. After the appropriate invoice, payment, and distributioninformation has been loaded into the conversion files, you can run this form to edit the information for completeness and accuracy, create new invoice, payment, and distribution records in the Accounts Payable application, and purge thecorresponding records from the conversion files. Note that you must set up the following codes and information as valid records if this information is to be converted as part of the invoice, split invoice payment, or distribution records: cash codes, payment codes, accrual codes, distribution codes, hold codes, vendor location codes, currency codes, tax codes, activities, and asset information. You can maintain unreleased invoice records on Invoice Entry (AP20.1) and released (open) invoice records on Invoice Maintenance (AP30.1) after you convert them.
Updated files (54)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| AMCONTROL | Asset Internal Control | AM |
| AMINTER | Asset Interface | AM |
| AMINTERAU | Asset Interface Audit | AM |
| AMRPRINTER | Asset Repair Interface | AM |
| APASTDTL | Asset Detail | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APBATCH | Batch | AP |
| APCATTACH | No description in the Lawson data dictionary | AP |
| APCDISTRIB | Distribution Interface | AP |
| APCINVERR | AP Invoice Conversion Error | AP |
| APCINVOICE | Invoice Interface | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCPAYMENT | Invoice Payment Interface | AP |
| APDISTRIB | Invoice Distribution | AP |
| APDSUSRFLD | Accounts Payable User Fields | AP |
| APHLDINV | Hold | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCLASS | Vendor Class | AP |
| APVENMAST | Vendor Master Record | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| INSTDETAIL | Intrastat Detail Transactions | TX |
| INSTHEADER | Intrastat Transaction Header | TX |
| INSTNBR | Intrastat Company Numbers | TX |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| JBOOKHDR | Journal Book Header | IF |
| POAOCMAST | Add On Cost Master | PO |
| SUBCKPOINT | Subledger Check Point | IF |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| TXTAXTRAN | Tax Transaction | TX |
Referenced files (97)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBRDNTRAN | The Burden Transactions file is updated by the Activity Posting (AC190) program. | AC |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| AMASSET | Asset | AM |
| AMTEMPLATE | Asset Template | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCATTACH | No description in the Lawson data dictionary | AP |
| APCDISTRIB | Distribution Interface | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPAYMENT | Invoice Payment Interface | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTCODE | Distribution Code Detail | 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 |
| APPAYCOREL | Pay Group-Company Relationship | AP |
| APPAYGROUP | Pay Group | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUDISTCD | No description in the Lawson data dictionary | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENDIV | The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | AP |
| APWTHCODE | Income Withholding Code | AP |
| CBBANKENT | Bank | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBDRFTFORM | Bill of Exchange Paymnt Format | CB |
| CBPAYMENT | Cash Payment | CB |
| CBPMTCAT | No description in the Lawson data dictionary | 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 |
| EEEXPENSE | Employee Expense | AP |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| FOBCODE | PO Shipping Terms Master | PO |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INDOCTPCD | No description in the Lawson data dictionary | TX |
| INFERCONCD | No description in the Lawson data dictionary | TX |
| INSTATPROC | Intrastat Stat Procedure | TX |
| INSTCMDTY | ICN and Unit of Measure Codes | TX |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTNOTC | Intrastat Nature of Trans Code | TX |
| INSTPORTS | No description in the Lawson data dictionary | TX |
| INSTREGN | Intrastat Region Code | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MACOMPANY | Matching Company | MA |
| MAINVHAND | Invoice Handling Code | MA |
| POCOMPANY | Company System Master | PO |
| PROCUREGRP | Procurement Group | PO |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| TXUSAGECD | Tax Usage Codes | TX |
| VBABOD | No description in the Lawson data dictionary | AP |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (17)
ACAC, ACTA, API3, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, MARC, SLSE, SLSS, SLSU