Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MA126


MA126 - Auto Matching

**Form Purpose
Run Auto Matching (MA126) to match invoices based on the parameters you
select on this form.

You can select an invoice processing date range to match invoices with a due
date that falls within this range. The Margin Days parameter controls the
beginning date of the range, the End Range Days parameter controls the ending
date of the range.

You can either match according to the invoice processing date range using the
Margin Days and End Range Days, and Invoice Reconciliation Days (as defined in
MA01.1 (Company)) or you can choose to only look through the updates to the
match pool that fall within a certain number of days from the system date.

**Processing Effect
The processing date is defined as the due date that was keyed on the invoice
minus the number of invoice reconciliation days (as defined on the Options tab
of MA01.1). This enables you to attempt one more match, and still allow time
to manually work the invoice before it is due.

Note If MA126 selects an invoice that is defined as an All-to-All match, the
program will select all invoices in the pool even if they are not in the due
date range.

MA126 creates a report that lists the following information.

- The total number of invoices matched and the total matched amount. This
information is also printed broken down by match status (matched, matched in
tolerance, and matched with chargeback).

- The total number and amount of all matched invoices (every match status).

- The total number and amount of all remaining unmatched invoices.

- The total number and amount of chargebacks that were created.

- The number and amount of cost variance created.

- The total number of invoices in error; items the application could not
attempt to match

MA126 also creates an unmatched report that lists the following information.

- The invoice detail (invoice number, invoice date, due date, and invoice
amount) and the reason the invoice did not match

The unmatched report is sorted by company, vendor, purchase order, and
ship-to.




Updated Files

    ADDRDATA   -

    CKPOINT    -

    MAINVDTL   -

    MAMADHIST  -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    SUBCKPOINT -


Referenced Files

    AMASSET    -

    AMTEMPLATE -

    APCOMPANY  -

    APINVOICE  -

    APVENGROUP -

    CUCONV     -

    CURELAT    -

    GLADDRESS  -

    GLCHART    -

    GLINTCO    -

    GLSYSTEM   -

    INSTCTRYCD -

    MAAOCDTL   -

    MACOMPANY  -

    MAMATCHTBL -

    MAPOINV    -

    POCOMPANY  -

    REQLINE    -

    WFSETUP    -


INVOKED Programs

    API4
    ACAC
    ACCL
    ACTA
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    API5
    IFSC
    MAED
    MAI1
    ACSB
    APDS
    API2
    APCP
    ICCP
    IFRS
    MARC
    POED
    SLSS
    API3
    GLCC
    ICI1
    ICIT
    ICLC
    MAPL
    POCP
    POIF
    POIH
    POI6
    POI4
    POI7
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    POIJ
    POI1
    POIM