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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
AMCONTROLAsset Internal ControlAM
AMINTERAsset InterfaceAM
AMINTERAUAsset Interface AuditAM
AMRPRINTERAsset Repair InterfaceAM
APASTDTLAsset DetailAP
APAUDITVendor Invoice AuditAP
APBATCHBatchAP
APCATTACHNo description in the Lawson data dictionaryAP
APCDISTRIBDistribution InterfaceAP
APCINVERRAP Invoice Conversion ErrorAP
APCINVOICEInvoice InterfaceAP
APCOMPANYAccounts Payable CompanyAP
APCPAYMENTInvoice Payment InterfaceAP
APDISTRIBInvoice DistributionAP
APDSUSRFLDAccounts Payable User FieldsAP
APHLDINVHoldAP
APINUSRFLDAP Invoice User FieldsAP
APINVOICEAccounts Payable InvoiceAP
APMONITORAccounts Payable MonitorAP
APPAYMENTInvoice PaymentAP
APUAVALNo description in the Lawson data dictionaryAP
APVENADDRAP Vendor AddressAP
APVENBALVendor BalanceAP
APVENCLASSVendor ClassAP
APVENMASTVendor Master RecordAP
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CBCPYCASHCompany-Cash Code RelationshipCB
CKPOINTNo description in the Lawson data dictionary
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
INSTDETAILIntrastat Detail TransactionsTX
INSTHEADERIntrastat Transaction HeaderTX
INSTNBRIntrastat Company NumbersTX
JBKSEQNBRJournal Book Sequence NumberGL
JBOOKHDRJournal Book HeaderIF
POAOCMASTAdd On Cost MasterPO
SUBCKPOINTSubledger Check PointIF
TERMSPayment Terms MaintenanceTE
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX
TXTAXTRANTax TransactionTX

Referenced files (97)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACBILLActivity BillingBR
ACBILLXActivity Billing DetailBR
ACBRDNTRANThe Burden Transactions file is updated by the Activity Posting (AC190) program.AC
ACBUDHDRActivity Budget HeaderAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCNTRACTActivity ContractBR
ACCONSOLActivity ConsolidationAC
ACIFACTVThis file contains activity import information from AC500 (Activity Import).AC
AMASSETAssetAM
AMTEMPLATEAsset TemplateAM
APACCRCODEInvoice Accrual CodeAP
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUTHORAuthority CodeAP
APCATTACHNo description in the Lawson data dictionaryAP
APCDISTRIBDistribution InterfaceAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPAYMENTInvoice Payment InterfaceAP
APCPYVNDVendor Company CodesAP
APDISCCODEDiscount CodeAP
APDISTCODEDistribution Code DetailAP
APDISTHDRDistribution Code HeaderAP
APDIVCODEAccounts Payable Diversity CdAP
APDRAFTSAP Bill of ExchangeAP
APHOLDCODEHold CodeAP
APINCCODEIncome CodeAP
APPAYCORELPay Group-Company RelationshipAP
APPAYGROUPPay GroupAP
APPMTBODNo description in the Lawson data dictionaryAP
APPROCLEVAccounts Payable Process LevelAP
APUDISTCDNo description in the Lawson data dictionaryAP
APUSRFLDEFAP User Field DefinitionAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENDIVThe APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMASTAP
APVENGROUPVendor GroupAP
APVENLCBODNo description in the Lawson data dictionaryAP
APVENLOCVendor LocationAP
APWTHCODEIncome Withholding CodeAP
CBBANKENTBankCB
CBCASHFORMCash Payment FormatCB
CBCHECKAccounts Payable Cash PaymentCB
CBDRFTFORMBill of Exchange Paymnt FormatCB
CBPAYMENTCash PaymentCB
CBPMTCATNo description in the Lawson data dictionaryCB
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
EEEXPENSEEmployee ExpenseAP
FBFUNDDTLBudget Fund DetailGL
FBHEADERBudget HeaderGL
FOBCODEPO Shipping Terms MasterPO
GLADDRESSGeneral Ledger Company AddressIF
GLAMOUNTSGeneral Ledger AmountsGL
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCHARTSUMGeneral Ledger Chart SummaryIF
GLCODESGeneral Ledger CodesIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
GMFNDACTGrant Eligible ActivitiesGM
INDOCTPCDNo description in the Lawson data dictionaryTX
INFERCONCDNo description in the Lawson data dictionaryTX
INSTATPROCIntrastat Stat ProcedureTX
INSTCMDTYICN and Unit of Measure CodesTX
INSTCTRYCDIntrastat Country CodesTX
INSTNOTCIntrastat Nature of Trans CodeTX
INSTPORTSNo description in the Lawson data dictionaryTX
INSTREGNIntrastat Region CodeTX
JBKOPCODEJournal Book Operator CodeIF
JBKSYSCODEJournal Book SystemIF
MACOMPANYMatching CompanyMA
MAINVHANDInvoice Handling CodeMA
POCOMPANYCompany System MasterPO
PROCUREGRPProcurement GroupPO
SYSTEMCODESystem CodeIF
TXTAXRATETax RateTX
TXUSAGECDTax Usage CodesTX
VBABODNo description in the Lawson data dictionaryAP
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (17)

ACAC, ACTA, API3, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, MARC, SLSE, SLSS, SLSU