MA180 – Open Receipt Archive
- System
- Matching (MA)
- Type
- Batch program
- Updates
- 178 tables
- References
- 185 tables
MA180 (Open Receipt Archive) is a Lawson Matching batch program. It updates ACAMCODE, ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU and 170 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 177 more.
About MA180
Run Open Receipt Archive (MA180) to write off receipts, archive receipts, orboth. Receipts that are written off will have the profit recognized, but will not be removed from the matching pool (including Landed Tax and Landed spread AOC). Receipts that are archived will have the profit recognized (if it has not been written off) and completely removed from the matching pool. MA180 processes complete or partial receipt lines that have not been matchedwith invoice matching. NOTE: If a receipt status is archived, but the receipt was written off by a previous run of MA180, an asterisk (*) will display in the far right column of the report. Matching will update the receipt status to "ready to be archived" when every line on the receipt has been matched, but there is a remainingamount to be matched. The receipt will also be removed from the open receipt pool. **Processing Effect For inventory items, MA180 will debit the PO Accrual Account and credit thereceipt Write-off Inventory Receipt Archival account when Underbill Account isnot populated. Report Option to process: Write Off This option applies to Inventory items only. Running MA180 with this optionwill write off the receipts, Debit the PO Receipt Accrual account, and Credit the Inventory Receipt Archival account. These receipts will have general ledger postings created but are not removedfrom the matching pool and are still available in the match process. IMPORTANT: Non-inventory items cannot be written off. You must remove themfrom the application using the Archive or Write-Off and Archive processes. Archive This option applies to both Inventory and non inventory items. An errormessage will be displayed if Inventory item is archived before being written off. Running MA180 with this option will close the receipt, update the archivedquantity on the purchase order line, and close the purchase order line if the received quantity is equal to the PO line quantity. These receipts are removedfrom the match pool so they are not available for matching. NOTE: no General Ledger account posting will be generated Write Off and Archive This option applies to both Inventory and non inventory items. Run MA180 with this option Debits the PO Receipt Accrual account and Creditsthe Inventory Receipt Archival account for Inventory items; Debits the PO LineExpense account and Credits the Receipt write off account for non-inventory items. Write off and archive closes the receipt, updates the archived quantityon the purchase order line, and closes the purchase order line if the receivedquantity is equal to the PO line quantity. Note: General Ledger postings will be generated and the receipts will beremoved from the match pool so they are not available for matching. Underbill Account The Underbill account is used under two circumstances: during an InvoiceLevel match, when the invoice amount is less than the receipt amount; and if there is no invoice for a receipt. NOTE The Underbill account supersedes the Inventory Receipt Archival andReceipt Write Off accounts. If the Underbill account is populated - Inventory Receipt Archived account and Receipt Write off account will not be used. Expense and Service items Expense and service items cannot be written off. You must remove them usingthe archive process. MA180 creates two reports: - A listing of receipts and the amount written off or archived. - A summary report that lists the general ledger accounts and the amountsposted to those accounts.
Updated files (178)
| Table | Description | System |
|---|---|---|
| ACAMCODE | Activity Asset | AC |
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | 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 |
| 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 |
| BUYER | PO Buyer Master | PO |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| COCOMP | Demand Line Kit Components | WH |
| COLINE | Customer Order Line | OE |
| COSGBLK | No description in the Lawson data dictionary | OE |
| CUSTDESC | AR Group Customer | AR |
| CXCOMPANY | Case Cart Company | CX |
| CXCPIUAVAL | No description in the Lawson data dictionary | CX |
| CXITEMHIST | Case Cart Item History | CX |
| CXPREFITEM | Preference Items | CX |
| 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 |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| HCHPPAUDIT | No description in the Lawson data dictionary | IC |
| HCPATCHRG | Patient Charge | IC |
| HCPATPROC | No description in the Lawson data dictionary | IC |
| HCPATVISIT | Patient Visit | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICFACILITY | Ship To Facility | IC |
| ICHISTORY | Transaction History | IC |
| ICICRAUDIT | No description in the Lawson data dictionary | IC |
| ICITEMCODE | Item Code | IC |
| ICLOCATION | Company Location | IC |
| ICLOT | Lots with Expire Date/On Hold | IC |
| ICRECEIPTS | Costing Record | IC |
| ICTRANS | Inventory Transaction | IC |
| ICTRANSDTL | Inventory Transaction Detail | IC |
| INSTDETAIL | Intrastat Detail Transactions | TX |
| INSTHEADER | Intrastat Transaction Header | TX |
| INSTNBR | Intrastat Company Numbers | TX |
| ITEMLOC | Item Location | IC |
| ITSERIAL | Serial Numbers | IC |
| KWDDETAIL | No description in the Lawson data dictionary | IC |
| KWDMASTER | No description in the Lawson data dictionary | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAGMAUDIT | Vendor Agreement Audit | PO |
| POAGMTPRIC | Agreement Pricing | PO |
| POAOCDTL | Add On Cost Detail | PO |
| POAOCMAST | Add On Cost Master | PO |
| POAOCSPRD | Add On Cost Spread | PO |
| POAPPROVE | No description in the Lawson data dictionary | PO |
| POAUDIT | Audit Records | PO |
| POCODE | Purchase Order Codes | PO |
| POCOMPANY | Company System Master | PO |
| POHDROUT | No description in the Lawson data dictionary | PO |
| POHDRPVT | No description in the Lawson data dictionary | PO |
| POINTAOC | Interface Add On Cost | PO |
| POINTAUDIT | No description in the Lawson data dictionary | PO |
| POINTERFAC | Interface File | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POIVACMNT | No description in the Lawson data dictionary | PO |
| POLINE | Line Items | PO |
| POLINEOUT | No description in the Lawson data dictionary | PO |
| POLINEPVT | No description in the Lawson data dictionary | PO |
| POLINESRC | PO Line Source | PO |
| POMATCHOBJ | Cost Change Information | PO |
| POMESSAGE | Buyer Messages | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PORETURNHD | PO Return Header | PO |
| PORETURNLN | PO Return Line | PO |
| POREVISION | PO Revision | PO |
| POTRACK | Package Tracking Number | PO |
| POTRANSDTL | PO Transaction Detail | PO |
| POVACOMMIT | Commitments for Vendor Agrmt | PO |
| POVACOMMIX | No description in the Lawson data dictionary | PO |
| POVADIST | Vendor Agreement Distribution | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVAGRMTLN | Vendor Agreement Line | PO |
| POVAPARTLN | Contract Participant Line | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| PURCHORDER | Purchase Order Master | PO |
| RECAOCDTL | Receiving AOC Detail | PO |
| REQHEADER | Requisition Header | RQ |
| REQLINE | Requisition Line | RQ |
| ROUTEDOC | Route Document | WH |
| ROUTEHDR | Route Header | WH |
| ROUTESTOP | Route Stop | WH |
| RQAUDIT | Requisition Audit | RQ |
| RQTRANS | Requisition Transactions | RQ |
| SOHDETAIL | Stock-on-Hand Detail | IC |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| WHDEMAND | Demand | WH |
| WHDEMNDHDR | Demand Header | WH |
Referenced files (185)
| 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 |
| 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 |
| ACPRDPERF | Activity Period Performance | AC |
| ACTRANS | Activity Transaction | AC |
| 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 |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | 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 |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | 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 |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCOMP | Accounts Receivable Company | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| BILLTO | Bill To | AR |
| BUYBOD | No description in the Lawson data dictionary | PO |
| BUYCLASS | PO Buyer Purch Class Auth | PO |
| BUYCMPLOC | No description in the Lawson data dictionary | PO |
| BUYVENPF | Buyer/Vendor Purchase From | PO |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| COMPONENT | User Field | IC |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTORDER | Customer Order File | OE |
| CXBURDEN | Case Cart Burden | CX |
| CXCASEPREF | Case Cart Preferences | CX |
| CXPTMPITEM | Template Items | CX |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| HCCHRGITEM | Charge Item | IC |
| ICBIN | Bin Numbers | IC |
| ICCATEGORY | GL Account Category | IC |
| ICCOUT | No description in the Lawson data dictionary | WH |
| ICFACILITY | Ship To Facility | IC |
| ICITEMGTIN | Inventory Item for GTIN | IC |
| ICMFGCODE | IC Manufacturing Code | IC |
| ICMFGDIST | IC Manufacturers Distribution | 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 |
| ITEMGROUP | Item Group | IC |
| ITEMMAST | Item Master | IC |
| ITEMSPECL | No description in the Lawson data dictionary | IC |
| ITEMSUB | Item Substitute | IC |
| KITITEM | Kit Item | IC |
| KWDSETUP | No description in the Lawson data dictionary | IC |
| KWDSYNONYM | Keywords Synonym | IC |
| LMLEASE | Lease Information | LM |
| LMLEASESEG | This file stores the user analysis values for a lease. | LM |
| MACOMPANY | Matching Company | MA |
| MAELMGPREL | Match Element Group Relation | MA |
| MAELMVALUE | Matching Element Value | 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 |
| MAPOINV | Multiple PO Invoice | MA |
| MAREASONCD | Matching Reason Code | MA |
| MATCHCLASS | Match Class | MA |
| MFGSHPFAC | Manufacturer Relationship | IC |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECOMPANY | Order Entry Company | BL |
| OECUST | Customer Order Processing | AR |
| OEFRTCODE | Order Entry Freight Code | BL |
| OEROUTE | Order Entry Route | OE |
| ORDERTYPE | Order Type | OE |
| PDCARD | P-Card | PO |
| PDCCHRGERR | No description in the Lawson data dictionary | PO |
| PJLBOD | No description in the Lawson data dictionary | PO |
| POAGMTPART | Vendor Agreement Participants | PO |
| POAPPCODE | No description in the Lawson data dictionary | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| PODOCREF | Document Reference | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POMXVAL | Attribute | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| PORECADJHD | Receiving Adjustments Header | PO |
| PORECADJLN | Receiving Adjustments Line | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| POVAGLNERR | No description in the Lawson data dictionary | PO |
| PROCLEV | Matching Process Level | MA |
| PROCTEMPLN | Procurement Template Line | PO |
| PROCUREGRP | Procurement Group | PO |
| PTHBOD | No description in the Lawson data dictionary | PO |
| PVHBOD | No description in the Lawson data dictionary | PO |
| REASON | Reason Code | IC |
| REQUESTER | Requester | RQ |
| RQLOC | Requesting Locations | RQ |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| STCOMMCODE | PO Standard Comment Codes | PO |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
| WHPROCTYPE | Shipment Process Type | WH |
| WHSHIPLINE | Shipment Line | WH |
| WHSHIPMENT | Shipment | WH |
| WHSHLAUD | Shipment Line Audit | WH |
Program calls
Invoked programs (43)
ACAC, ACSB, ACTA, AMCO, API3, API4, GLCC, ICCP, ICI1, ICI9, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POBL, POCP, POI1, POI4, POI6, POI7, POI9, POIA, POIF, POIG, POIH, POII, POIJ, POIL, POIM, POIX, SLFD, SLSB, SLSE, SLSS, SLSU