Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

MA540

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