MA540 – Invoice Interface

System
Matching (MA)
Type
Batch program
Updates
47 tables
References
102 tables

MA540 (Invoice Interface) is a Lawson Matching batch program. It updates ADDRDATA, APAPIHIST, APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV and 39 more and references AMASSET, AMTEMPLATE, APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHBUY, APAUTHOR, APBATCH and 94 more.

About MA540

Run Invoice Interface (MA540) to import expense and match invoices, and PO Service only invoices, into the Invoice Matching application from an external source. The input options are CSV, database , and EDI. MA540 creates invoice detail from detail provided by the interfaceinformation. **Processing Effect Match invoices are created as unreleased (status = 0). A match may be attempted if you have selected Add and Match in the Invoice Process field. If the match is successful, the invoice status is updated to released (status = 1). If you allow auto release, some invoices may be created as unreleased due to exceptions on the invoice (for example, out of tolerance conditions). Unreleased invoices may be maintained using Basic Invoice (AP20.1). Unreleased invoices may be matched using AP20 or Auto Matching (MA126). For AP batch invoices a starting batch number is required if the Accounts Payable company is defined as batch processing. The batch number is used to create unreleased invoices for batch processing companies. A batch size limit is also required. The application will start a new batch when the maximum batch size has been reached and increment the starting batch number to find the next unused batch number. Invoices that have errors will remain in the interface files until they are maintained, released, or updated via MA540. Use Invoice (MA54.1) tomaintain interfaced invoices.

More information: NOTE Under certain circumstances, you can release invoices with errors by selecting Yes in the Include Invoices in Error field. It is recommended that this option only be used when there are a large number of invoices with a simple error. For example if you interface a large number of invoiceswithout establishing a code in the Lawson application. These invoices will be added to the error file. After you added the code, normally you would have torelease each invoice individually in MA54.1. The Include Invoices in Error parameter lets you release the invoices as a group. MA540 creates three output reports: - The Fatal EDI Invoice Errors Report lists any invoices that could not be loaded due to severe data problems (for example, the invoice number is a duplicate of an existing invoice). Use Invoice (MA54.1),Distribution (MA54.2), or Line Detail (MA54.3) to correct interface errors. - The Released Audit Report lists all of the released invoices that were loaded. - The Unreleased Audit Report lists all of the unreleased invoices that were loaded. - Credit and Debit memos can be interfaced in this program. The change is toapply the rules that are being added to APIN70PD Invoice entry to this programas well. Once the invoices are interfaced they can only be changed on the MA42screens, and viewed on AP20.

Updated files (47)

TableDescriptionSystem
ADDRDATAAddress CodeIF
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUDITVendor Invoice AuditAP
APCOMMENTSCommentsAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APHLDINVHoldAP
APINVOICEAccounts Payable InvoiceAP
APVENADDRAP Vendor AddressAP
APVENBALVendor BalanceAP
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
CBCHECKAccounts Payable Cash PaymentCB
CKPOINTNo description in the Lawson data dictionary
CUSTDESCAR Group CustomerAR
ICLOCATIONCompany LocationIC
JBOOKHDRJournal Book HeaderIF
MACAPDTLInvoice Distrib ConversionMA
MACINVAOCNo description in the Lawson data dictionaryMA
MACINVDTLInvoice Conversion/InterfaceMA
MACINVERRInv Interface/Conversion ErrorMA
MACINVOICEInvoice Conversion/InterfaceMA
MMDISTAccount DistributionsPO
MMUAVALNo description in the Lawson data dictionaryPO
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
POAOCDTLAdd On Cost DetailPO
POAOCMASTAdd On Cost MasterPO
POITEMVENPO Vendor Item InformationPO
POPOVUFNo description in the Lawson data dictionaryPO
POREBDISTNo description in the Lawson data dictionaryPO
POREBDUEContract Rebate HeaderPO
POREBRECDContract Rebate DetailPO
PORECLINEPO Line Item ReceivingsPO
POVENDLOCVendor Location MasterPO
POVENDORPO Vendor MasterPO
TERMSPayment Terms MaintenanceTE
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (102)

TableDescriptionSystem
AMASSETAssetAM
AMTEMPLATEAsset TemplateAM
APACCRCODEInvoice Accrual CodeAP
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUTHBUYNo description in the Lawson data dictionaryAP
APAUTHORAuthority CodeAP
APBATCHBatchAP
APCOMMENTSCommentsAP
APCOMPANYAccounts Payable CompanyAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APDISCCODEDiscount CodeAP
APDISTHDRDistribution Code HeaderAP
APDIVCODEAccounts Payable Diversity CdAP
APHLDINVHoldAP
APHOLDCODEHold CodeAP
APINCCODEIncome CodeAP
APINVOICEAccounts Payable InvoiceAP
APPAYGROUPPay GroupAP
APPAYMENTInvoice PaymentAP
APPROCGRPProcess GroupAP
APPROCLEVAccounts Payable Process LevelAP
APUAVALNo description in the Lawson data dictionaryAP
APUSRFLDEFAP User Field DefinitionAP
APVENBALVendor BalanceAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENCLASSVendor ClassAP
APVENDIVThe APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMASTAP
APVENLOCVendor LocationAP
APVNMXVALNo description in the Lawson data dictionaryAP
ARCUSTGRPAccounts Receivable Cust GroupAR
C3BODRETNo description in the Lawson data dictionaryC3
C3TAXRETNo description in the Lawson data dictionaryC3
CBCHECKAccounts Payable Cash PaymentCB
CBPMTCATNo description in the Lawson data dictionaryCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
COMMCODESNo description in the Lawson data dictionaryIC
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
EEADVANCEEmployee AdvanceAP
EEAPPROVALExpense Advance Approval CodeAP
EEEXPENSEEmployee ExpenseAP
FOBCODEPO Shipping Terms MasterPO
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLNLOCDTLNo description in the Lawson data dictionaryIC
GLSYSTEMGeneral Ledger CompanyIF
ICCOMPANYInventory Company InformationIC
ICVALUOMValid Units Of MeasureIC
INDOCTPCDNo description in the Lawson data dictionaryTX
INLINETYPENo 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
ITEMLOCItem LocationIC
ITEMMASTItem MasterIC
JBKOPCODEJournal Book Operator CodeIF
JBKSYSCODEJournal Book SystemIF
MAAOCDTLInvoice Add On Cost DetailMA
MACOMPANYMatching CompanyMA
MAELMVALUEMatching Element ValueMA
MAINVDTLInvoice Line DetailMA
MAINVHANDInvoice Handling CodeMA
MAMATCHTBLMatch TableMA
MAMSGTOLNo description in the Lawson data dictionaryMA
MAMTCHELEMMatching ElementsMA
MAMTCHRULEMatching RulesMA
MATCHCLASSMatch ClassMA
MMDISTAccount DistributionsPO
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
POAGMTPRICAgreement PricingPO
POAOCSPRDAdd On Cost SpreadPO
POCOMPANYCompany System MasterPO
POCONTGRPThis table contains detail information on a CM contract group.PO
POCONTRACTContract DescriptionPO
POCONTREBNo description in the Lawson data dictionaryPO
PODOCREFDocument ReferencePO
POITEMVENPO Vendor Item InformationPO
POLINELine ItemsPO
POLINESRCPO Line SourcePO
PORECEIVEPO ReceiversPO
PORECLINEPO Line Item ReceivingsPO
PORETURNLNPO Return LinePO
POVAGRMTHDVendor AgreementPO
POVAGRMTLNVendor Agreement LinePO
POVENDLOCVendor Location MasterPO
PROCUREGRPProcurement GroupPO
PURCHORDERPurchase Order MasterPO
REQHEADERRequisition HeaderRQ
REQLINERequisition LineRQ
TXTAXRATETax RateTX
TXUSAGECDTax Usage CodesTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (54)

ACAC, ACSB, ACTA, AMCO, APCP, APDS, API1, API2, API3, API4, API5, GLCC, ICCP, ICI1, ICI9, ICIT, ICLC, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, MAI1, MAPL, MARC, POBL, POCP, POED, POI1, POI3, POI4, POI6, POI7, POI9, POIA, POIF, POIG, POIH, POII, POIJ, POIL, POIM, POIX, SLFD, SLSB, SLSE, SLSS, SLSU