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.
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 system 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
CKPOINT -
MAINVDTL -
MAMADHIST -
MAPOOLCNT -
MMDIST -
MMUAVAL -
SUBCKPOINT -
Referenced Files
AMASSET -
AMTEMPLATE -
APCOMPANY -
APINVOICE -
APVENGROUP -
CUCONV -
CURELAT -
GLADDRESS -
GLCHART -
GLINTCO -
GLSYSTEM -
MACOMPANY -
MAMATCHTBL -
POCOMPANY -
REQLINE -
WFSETUP -
INVOKED Programs
API4
ACAC
ACCL
IFCU
IFSG
IFAC
IFAU
SLSE
SLSU
API5
IFOB
MAED
MAI1
APDS
API2
APCP
ICCP
IFRS
MARC
POED
SLSS
API3
GLCC
ICI1
ICIT
ICLC
MAPL
POCP
POIH
POI6
POI4
POI7
PHI6
POI9
POIA
POIL
POIX
POIF
POIG
POII
POI1
POIJ
|
