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)

TableDescriptionSystem
ACAMCODEActivity AssetAC
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
AMACCOUNTAsset Management AccountAM
AMACCTAUAsset Account AuditAM
AMACCTGPAUAsset Account Group AuditAM
AMACCTGRPAsset Account GroupAM
AMASSETAssetAM
AMASSETADJAsset AdjustmentAM
AMASSETDSPAsset DisposalAM
AMASSETGRPAsset GroupAM
AMASSETTRFAsset TransferAM
AMASTBKADJAsset Book AdjustmentAM
AMASTBKDSPAsset Book DisposalAM
AMASTBKTRFAsset Book TransferAM
AMASTBOOKAsset BookAM
AMASTITADJAsset Item AdjustmentAM
AMASTITDSPAsset Item DisposalAM
AMASTITEMAsset ItemAM
AMASTITTRFAsset Item TransferAM
AMASTMXVALAsset AttributesAM
AMASTRECAPAsset Depreciation RecaptureAM
AMASTRPAIRAsset RepairAM
AMASTTYPAUAsset Type AuditAM
AMASTTYPEAsset TypeAM
AMAUGROUPAsset Accounting Unit GroupAM
AMAUGRPAUAM Accounting Unit Group AuditAM
AMBKHISTAsset Book HistoryAM
AMBKHISTXPeriod Asset Book HistoryAM
AMBKTEMPLTBook TemplateAM
AMBKTRANSAsset Book TransactionsAM
AMCALENDARAsset CalendarAM
AMCLASSDEPThis file contains the depreciation information for account level depreciation to support Telecommunications Industry…AM
AMCNTRLAUAsset System Options AuditAM
AMCONTROLAsset Internal ControlAM
AMCTLTRANSAsset Control TransactionAM
AMDIVISIONAsset DivisionAM
AMDIVISNAUAM Division AuditAM
AMINTERAsset InterfaceAM
AMINTERAUAsset Interface AuditAM
AMLOCATIONAsset LocationAM
AMLOCAUDITAM Location AuditAM
AMMONITORNo description in the Lawson data dictionaryAM
AMPOASTDTLPO Asset DetailAM
AMPOASTHDRPO Asset HeaderAM
AMPODFLTSPO DefaultsAM
AMPUHISPersonal Use HistoryAM
AMSEGBLOCKNo description in the Lawson data dictionaryAM
AMTAXAUTHTax AuthorityAM
AMTEMPLATEAsset TemplateAM
AMTRANSAsset TransactionAM
AMTRANSUMMAsset Transaction SummaryAM
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
BUYERPO Buyer MasterPO
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CBCHECKAccounts Payable Cash PaymentCB
CKPOINTNo description in the Lawson data dictionary
COCOMPDemand Line Kit ComponentsWH
COLINECustomer Order LineOE
COSGBLKNo description in the Lawson data dictionaryOE
CUSTDESCAR Group CustomerAR
CXCOMPANYCase Cart CompanyCX
CXCPIUAVALNo description in the Lawson data dictionaryCX
CXITEMHISTCase Cart Item HistoryCX
CXPREFITEMPreference ItemsCX
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
GLNLOCDTLNo description in the Lawson data dictionaryIC
HCHPPAUDITNo description in the Lawson data dictionaryIC
HCPATCHRGPatient ChargeIC
HCPATPROCNo description in the Lawson data dictionaryIC
HCPATVISITPatient VisitIC
ICCOMPANYInventory Company InformationIC
ICFACILITYShip To FacilityIC
ICHISTORYTransaction HistoryIC
ICICRAUDITNo description in the Lawson data dictionaryIC
ICITEMCODEItem CodeIC
ICLOCATIONCompany LocationIC
ICLOTLots with Expire Date/On HoldIC
ICRECEIPTSCosting RecordIC
ICTRANSInventory TransactionIC
ICTRANSDTLInventory Transaction DetailIC
INSTDETAILIntrastat Detail TransactionsTX
INSTHEADERIntrastat Transaction HeaderTX
INSTNBRIntrastat Company NumbersTX
ITEMLOCItem LocationIC
ITSERIALSerial NumbersIC
KWDDETAILNo description in the Lawson data dictionaryIC
KWDMASTERNo description in the Lawson data dictionaryIC
MAAOCDTLInvoice Add On Cost DetailMA
MAINVDTLInvoice Line DetailMA
MAMAAHISTNo description in the Lawson data dictionaryMA
MAMADHISTNo description in the Lawson data dictionaryMA
MMDISTAccount DistributionsPO
MMUAVALNo description in the Lawson data dictionaryPO
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
POAGMAUDITVendor Agreement AuditPO
POAGMTPRICAgreement PricingPO
POAOCDTLAdd On Cost DetailPO
POAOCMASTAdd On Cost MasterPO
POAOCSPRDAdd On Cost SpreadPO
POAPPROVENo description in the Lawson data dictionaryPO
POAUDITAudit RecordsPO
POCODEPurchase Order CodesPO
POCOMPANYCompany System MasterPO
POHDROUTNo description in the Lawson data dictionaryPO
POHDRPVTNo description in the Lawson data dictionaryPO
POINTAOCInterface Add On CostPO
POINTAUDITNo description in the Lawson data dictionaryPO
POINTERFACInterface FilePO
POITEMVENPO Vendor Item InformationPO
POIVACMNTNo description in the Lawson data dictionaryPO
POLINELine ItemsPO
POLINEOUTNo description in the Lawson data dictionaryPO
POLINEPVTNo description in the Lawson data dictionaryPO
POLINESRCPO Line SourcePO
POMATCHOBJCost Change InformationPO
POMESSAGEBuyer MessagesPO
POPCRUFNo description in the Lawson data dictionaryPO
POPLIUFNo description in the Lawson data dictionaryPO
POPOVUFNo description in the Lawson data dictionaryPO
PORECEIVEPO ReceiversPO
PORECLINEPO Line Item ReceivingsPO
PORETURNHDPO Return HeaderPO
PORETURNLNPO Return LinePO
POREVISIONPO RevisionPO
POTRACKPackage Tracking NumberPO
POTRANSDTLPO Transaction DetailPO
POVACOMMITCommitments for Vendor AgrmtPO
POVACOMMIXNo description in the Lawson data dictionaryPO
POVADISTVendor Agreement DistributionPO
POVAGRMTHDVendor AgreementPO
POVAGRMTLNVendor Agreement LinePO
POVAPARTLNContract Participant LinePO
POVENDLOCVendor Location MasterPO
POVENDORPO Vendor MasterPO
PURCHORDERPurchase Order MasterPO
RECAOCDTLReceiving AOC DetailPO
REQHEADERRequisition HeaderRQ
REQLINERequisition LineRQ
ROUTEDOCRoute DocumentWH
ROUTEHDRRoute HeaderWH
ROUTESTOPRoute StopWH
RQAUDITRequisition AuditRQ
RQTRANSRequisition TransactionsRQ
SOHDETAILStock-on-Hand DetailIC
SUBCKPOINTSubledger Check PointIF
SYSTEMCODESystem CodeIF
TERMSPayment Terms MaintenanceTE
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX
WHDEMANDDemandWH
WHDEMNDHDRDemand HeaderWH

Referenced files (185)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACBILLActivity BillingBR
ACBILLXActivity Billing DetailBR
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
ACPRDPERFActivity Period PerformanceAC
ACTRANSActivity TransactionAC
AMASSETBODNo description in the Lawson data dictionaryAM
AMASSETDSPAsset DisposalAM
AMASSETTRFAsset TransferAM
AMASTBKDSPAsset Book DisposalAM
AMASTBKTRFAsset Book TransferAM
AMASTITDSPAsset Item DisposalAM
AMASTITTRFAsset Item TransferAM
AMASTMXVALAsset AttributesAM
AMASTRPAIRAsset RepairAM
AMBOOKAsset Book NameAM
AMCOMPUTEComputeAM
AMLOCDTLLocation DetailAM
AMMETHODAsset MethodAM
AMPUCODEAsset Personal Use CodeAM
AMTABLEPCTPercent TableAM
AMTABLETAXAsset Management Tax TableAM
AMTRANSBODNo description in the Lawson data dictionaryAM
AMTYPALLOCThe The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).AM
AMTYPALLOXThe Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or…AM
AMUOPPDSUnits of Production PeriodsAM
APACCRCODEInvoice Accrual CodeAP
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUTHORAuthority CodeAP
APCOMMENTSCommentsAP
APCOMPANYAccounts Payable CompanyAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APDISCCODEDiscount CodeAP
APDISTHDRDistribution Code HeaderAP
APHLDINVHoldAP
APHOLDCODEHold CodeAP
APINCCODEIncome CodeAP
APINVOICEAccounts Payable InvoiceAP
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
APVENLOCVendor LocationAP
APVNMXVALNo description in the Lawson data dictionaryAP
ARCOMPAccounts Receivable CompanyAR
ARCUSTGRPAccounts Receivable Cust GroupAR
ARCUSTOMERAR Company CustomerAR
BILLTOBill ToAR
BUYBODNo description in the Lawson data dictionaryPO
BUYCLASSPO Buyer Purch Class AuthPO
BUYCMPLOCNo description in the Lawson data dictionaryPO
BUYVENPFBuyer/Vendor Purchase FromPO
CBCHECKAccounts Payable Cash PaymentCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
COMPONENTUser FieldIC
CUACCTCurrency Gain and Loss AccountIF
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CUSTORDERCustomer Order FileOE
CXBURDENCase Cart BurdenCX
CXCASEPREFCase Cart PreferencesCX
CXPTMPITEMTemplate ItemsCX
EEADVANCEEmployee AdvanceAP
EEAPPROVALExpense Advance Approval CodeAP
EEEXPENSEEmployee ExpenseAP
FBFUNDDTLBudget Fund DetailGL
FBHEADERBudget HeaderGL
GLADDRESSGeneral Ledger Company AddressIF
GLAMOUNTSGeneral Ledger AmountsGL
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCHARTSUMGeneral Ledger Chart SummaryIF
GLCODESGeneral Ledger CodesIF
GLCPYGRPGeneral Ledger Company GroupIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLNLOCDTLNo description in the Lawson data dictionaryIC
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
GMFNDACTGrant Eligible ActivitiesGM
HCCHRGITEMCharge ItemIC
ICBINBin NumbersIC
ICCATEGORYGL Account CategoryIC
ICCOUTNo description in the Lawson data dictionaryWH
ICFACILITYShip To FacilityIC
ICITEMGTINInventory Item for GTINIC
ICMFGCODEIC Manufacturing CodeIC
ICMFGDISTIC Manufacturers DistributionIC
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
ITEMGROUPItem GroupIC
ITEMMASTItem MasterIC
ITEMSPECLNo description in the Lawson data dictionaryIC
ITEMSUBItem SubstituteIC
KITITEMKit ItemIC
KWDSETUPNo description in the Lawson data dictionaryIC
KWDSYNONYMKeywords SynonymIC
LMLEASELease InformationLM
LMLEASESEGThis file stores the user analysis values for a lease.LM
MACOMPANYMatching CompanyMA
MAELMGPRELMatch Element Group RelationMA
MAELMVALUEMatching Element ValueMA
MAINVHANDInvoice Handling CodeMA
MAMATCHTBLMatch TableMA
MAMSGTOLNo description in the Lawson data dictionaryMA
MAMTCHELEMMatching ElementsMA
MAMTCHRULEMatching RulesMA
MAPOINVMultiple PO InvoiceMA
MAREASONCDMatching Reason CodeMA
MATCHCLASSMatch ClassMA
MFGSHPFACManufacturer RelationshipIC
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
NATACCTAccounts Receivable Natl AcctAR
NATBALANCEAR National Account BalanceAR
OECOMPANYOrder Entry CompanyBL
OECUSTCustomer Order ProcessingAR
OEFRTCODEOrder Entry Freight CodeBL
OEROUTEOrder Entry RouteOE
ORDERTYPEOrder TypeOE
PDCARDP-CardPO
PDCCHRGERRNo description in the Lawson data dictionaryPO
PJLBODNo description in the Lawson data dictionaryPO
POAGMTPARTVendor Agreement ParticipantsPO
POAPPCODENo description in the Lawson data dictionaryPO
POAUDRULESAudit RulesPO
POAUDTYPEAudit TypesPO
PODOCREFDocument ReferencePO
POITEMVENPO Vendor Item InformationPO
POMXVALAttributePO
POPCRUFNo description in the Lawson data dictionaryPO
POPLIUFNo description in the Lawson data dictionaryPO
PORECADJHDReceiving Adjustments HeaderPO
PORECADJLNReceiving Adjustments LinePO
POREVISIONPO RevisionPO
PORLNUFNo description in the Lawson data dictionaryRQ
PORQHUFNo description in the Lawson data dictionaryRQ
POVAGLNERRNo description in the Lawson data dictionaryPO
PROCLEVMatching Process LevelMA
PROCTEMPLNProcurement Template LinePO
PROCUREGRPProcurement GroupPO
PTHBODNo description in the Lawson data dictionaryPO
PVHBODNo description in the Lawson data dictionaryPO
REASONReason CodeIC
REQUESTERRequesterRQ
RQLOCRequesting LocationsRQ
STATICCUSTAR Ovrd Credit Trans ReviewAR
STCOMMCODEPO Standard Comment CodesPO
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF
WHPROCTYPEShipment Process TypeWH
WHSHIPLINEShipment LineWH
WHSHIPMENTShipmentWH
WHSHLAUDShipment Line AuditWH

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