MA540 - EDI Line Level Match Run this program to load Accounts Payable and purchase order invoices from the selected file, produce reports, and, if specified, produce released invoices. For purchase order invoices, this program also performs a line-level match of the invoice against its associated purchase order. The system first attempts to load the invoice and then attempts to create invoice approval lines in the same manner as MA43.1 (Line Match). Purchase order invoices may be released and scheduled for payment automatically if the purchase order specifies auto release of invoices. Accounts Payable invoices may be released and scheduled for payment automatically if the vendor set up specifies EDI auto release. You may override this process by selecting N in the Auto Release parameter. If you allow autorelease, some invoices may be created as unreleased due to exceptions on the invoice (for example, out of tolerance conditions) or because the purchase order specified no autorelease. Unreleased invoices may be updated with MA40.1 (Invoice) or invoice entry forms (AP20), and released through normal Accounts Payable processes of AP125 (Batch Release) or AP126 (Mass Invoice Release). You must provide a starting batch number, which is used to create unreleased invoices for batch processing companies. Along with the batch number, you also need to provide the maximum batch size. The system starts a new batch when the maximum batch size is reached. It increments the starting batch number to find the next unused batch to use. You also must provide a default authority code, which is used for invoice registration companies. This process creates five output reports: 1. The fatal errors report shows any receipts for which invoices could not be loaded due to severe data problems (for example, the invoice number is a duplicate of an existing invoice). These invoices will have to be added manually. 2. The released exceptions report shows warning messages for released invoices (for example, a miscellaneous add-on cost was added to a purchase order invoice). You may want to review these messages for vendor conformance to your Electronic Data Interchange (EDI) or procurement program. 3. The unreleased exceptions report shows warning and error messages for unreleased invoices. If a purchase order specifies that the invoice is to be automatically released, but it cannot be due to a discrepancy (for example, a tolerance exception), the reason will be listed on this report. Similarly, for Accounts Payable invoices, if the vendor specifies auto release but the invoice cannot be released automatically (for example, distributions are out of balance) the reason will be listed on this report. 4. The released audit report lists all of the released invoices that were loaded. 5. The unreleased audit report lists all of the unreleased invoices that were loaded. Updated Files ACCOMMIT - Used to reference and update Activity Management commitment records. ACCOMMITX - Used to create or update commitment records in the Activity Management system. AMCONTROL - Used to update last asset number used. AMINTER - Used to maintain the interface to the new asset file. AMRPRINTER - Used to maintain the interface to the asset repair file. APACCRCODE - Used to validate the Accounts Payable accrual code. APASTDTL - Used to create asset detail records. APAUTHOR - Used to validate authority code records. APBATCH - Used to update batch control totals. APCOMMENTS - Used to update invoice comments. APCOMPANY - Used to update the Accounts Payable company last batch or last voucher used. APDISTRIB - Used to create and update invoice distributions. APHLDINV - Used to create records of invoices on hold. APHOLDCODE - Used to validate Accounts Payable hold code records. APINCCODE - Used to validate income code records. APINVOICE - Used to create invoice records. APPAYMENT - Used to create and maintain an invoice payment record. APUAVAL - Used to store user analysis values defined for transactions. User Analysis values represent information your organization can use to measure profitability. To utilize this measure of organizational profitability, you must be set up to use the Strategic Ledger system. APVENBAL - Used to update vendor balance records. CBBANKINST - Used to validate the payment type. CBCASHCODE - Used to validate a cash code and updates the used flag. CBCPYCASH - Used to validate the company-cash code relationship and updates the used flag. CKPOINT - Used to determine if restart information exists. ICRECEIPTS - Used to update the Inventory Control detail receiving information for nonstandard cost companies where invoice unit cost is different from the purchase order unit cost. ICTRANS - Creates Inventory Control transaction detail records if invoice unit cost and purchase order unit cost are different. ITEMLOC - Used to update last cost information for cost defaulting and update the average cost if invoice unit cost and purchase order unit cost are different inventory items. MMDIST - Used to create account distribution records for noninventory type items. MMUAVAL - Used to store user analysis values defined for transactions. User Analysis values represent information your organization can use to measure profitability. To utilize this measure of organizational profitability, you must be set up to use the Strategic Ledger system. POAOCDTL - Used to update approved quantities when invoice is released. POAPPROVE - Used to create approvals when creating invoices. POCOMPANY - Used to validate the Purchase Order company. POINTAOC - Used to update purchase order add-on cost interface feedback. POINTERFAC - Used to update the purchase order interface with invoice approval data. POINVOICE - Used to create the purchase order invoice record. POLINE - Used to reference and update the purchase order line record with approved quantity data. POMESSAGE - Used to delete the purchase order buyer message record. PORECEIVE - Used to validate and default purchase order receiving information. PORECLINE - Used to edit receiving line item information. PORETURNHD - Used to edit a vendor return header to validate the return number. POVENDOR - Used to update the open purchase order amount. PURCHORDER - Used to validate and default purchase order header information. TERMS - Used to default payment terms. TXCODEMAST - Used to validate the tax code and display information. TXCOMPANY - Used to validate the tax company record. TXTAXCODE - Used to validate the tax code record. TXTAXTABLE - Used to obtain tax information from the tax table for display and updating. TXTAXTRAN - Used to update tax transaction records. Referenced Files ACACCTCAT - Used to validate the account category. ACACTGRP - Used to validate the activity group. ACACTIVITY - Used to validate the activity. ACCAL - Used to validate the calendar year records. ACCALX - Used to validate that the calendar records exist for the complete date range. AMASSET - Used to validate the asset. AMTEMPLATE - Used to validate the asset template. APAPPROVAL - Used to validate an approval record for a given company or vendor. APCPYVND - Used to retrieve company-specific defaults for a vendor. APDISCCODE - Used to validate an Accounts Payable discount code. APPAYCOREL - Used to validate a relationship between a pay group and a company. APPAYGROUP - Used to validate a paygroup record. APPROCLEV - Used to validate the process level. APVENCLASS - Used to validate vendor class or to default vendor class information. APVENGROUP - Used to validate vendor group or to default vendor group information. APVENLOC - Used to validate and default Accounts Payable vendor location information. APVENMAST - Used to validate the vendor ID and obtain vendor display information. APWTHCODE - Used to validate the Accounts Payable income withholding code. CBUSER - Used to validate that the user can access cash codes. CBUSRCLASS - Used to validate all users for a user class. CUCONV - Used to access general ledger and currency information. CURELAT - Used to validate currency relationships. EEADVANCE - Used to access employee advance records. EEEXPENSE - Used to access employee expense records. GLADDRESS - Used to obtain the General Ledger company address. GLCHART - Used to validate the system account. GLCODES - Used for validating source codes. GLINTCO - Used to validate the intercompany relationship. GLSYSTEM - Used to validate the General Ledger company. ICCATEGORY - Used to obtain General Ledger category account information for inventory items. ICCOMPANY - Used to validate the Inventory Control company. ICLOCATION - Used to validate the Inventory Control inventory location. ITEMMAST - Used to validate item and to obtain item descriptive information. POAOCMAST - Used to validate and default add-on cost master information. POITEMVEN - Used to validate and obtain vendor item information. POPROCLEV - Used to determine General Ledger accounts to use for creating General Ledger distributions. REQHEADER - Used to display information from the requisition. SYSTEMCODE - Used to validate system code information used for remote site processing. TXTAXRATE - Used to validate and default tax rate information. WFSETUP - INVOKED Programs ACAC IFCR IFSG IFCU IFAC IFAU SLSE SLSU IFCC IFOB IFRS SLSS |