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)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPIHIST | Vendor Invoice 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 |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | 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 |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| ICLOCATION | Company Location | IC |
| JBOOKHDR | Journal Book Header | IF |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MACINVAOC | No description in the Lawson data dictionary | MA |
| MACINVDTL | Invoice Conversion/Interface | MA |
| MACINVERR | Inv Interface/Conversion Error | MA |
| MACINVOICE | Invoice Conversion/Interface | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POAOCMAST | Add On Cost Master | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POREBDIST | No description in the Lawson data dictionary | PO |
| POREBDUE | Contract Rebate Header | PO |
| POREBRECD | Contract Rebate Detail | PO |
| PORECLINE | PO Line Item Receivings | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (102)
| Table | Description | System |
|---|---|---|
| AMASSET | Asset | AM |
| AMTEMPLATE | Asset Template | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHBUY | No description in the Lawson data dictionary | AP |
| APAUTHOR | Authority Code | AP |
| APBATCH | Batch | AP |
| APCOMMENTS | Comments | 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 |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYGROUP | Pay Group | AP |
| APPAYMENT | Invoice Payment | 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 |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENDIV | The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| C3BODRET | No description in the Lawson data dictionary | C3 |
| C3TAXRET | No description in the Lawson data dictionary | C3 |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBPMTCAT | No description in the Lawson data dictionary | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| COMMCODES | No description in the Lawson data dictionary | IC |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| FOBCODE | PO Shipping Terms Master | PO |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| ICCOMPANY | Inventory Company Information | IC |
| ICVALUOM | Valid Units Of Measure | IC |
| INDOCTPCD | No description in the Lawson data dictionary | TX |
| INLINETYPE | 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 |
| ITEMLOC | Item Location | IC |
| ITEMMAST | Item Master | IC |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MACOMPANY | Matching Company | MA |
| MAELMVALUE | Matching Element Value | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHELEM | Matching Elements | MA |
| MAMTCHRULE | Matching Rules | MA |
| MATCHCLASS | Match Class | MA |
| MMDIST | Account Distributions | PO |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAGMTPRIC | Agreement Pricing | PO |
| POAOCSPRD | Add On Cost Spread | PO |
| POCOMPANY | Company System Master | PO |
| POCONTGRP | This table contains detail information on a CM contract group. | PO |
| POCONTRACT | Contract Description | PO |
| POCONTREB | No description in the Lawson data dictionary | PO |
| PODOCREF | Document Reference | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POLINE | Line Items | PO |
| POLINESRC | PO Line Source | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PORETURNLN | PO Return Line | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVAGRMTLN | Vendor Agreement Line | 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 |
| TXUSAGECD | Tax Usage Codes | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
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