Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MA60


MA60.1 - Reconciliation Queue



Use Reconciliation Queue (MA60.1) to view unmatched invoices.



**More Information

Choose the Filter button to customize the display by selecting a purchase
order, ship to, or a due date range to limit the unmatched invoices that
display.
Invoices display in due date and vendor order.
Choose one of the Match Option buttons to begin the manual matching
process.
To attempt a match at the invoice level, choose the Inv button to open
Invoice Level Match (MA60.2).
To attempt a match at the detail level, choose the Dtl button to open
Detail Level Match (MA60.3).





Updated Files

    None.


Referenced Files

    APAUTHBUY  -

    APAUTHOR   -

    APCOMPANY  -

    APINVOICE  -

    APVENGROUP -

    BUYER      -

    MACOMPANY  -

    MAPOOLCNT  -

    PORECEIVE  -

    PROCUREGRP -


MA60.2 - Invoice Level Match



Use Invoice Level Match (MA60.2) to match invoices to receipts at the
line invoice level. You can match one or more invoices to one or more
receipts.

When using MA60.2, the receipts selected and matched will be closed.  If
there are remaining quantities on the receipt, they will no longer be
available to match.

NOTE  You have the option to force a match between an invoice and receipt
with invoice details that do not match.



**More Information

To match at the detail level, select an invoice using the Select line
action. Then choose the Detail Match button to open the Detail Match form
(MA60.3). Use MA60.3 to match at the detail level.
Choose the Chargeback Info button to open the Chargeback subform. You
can use the subform to enter optional reason codes and hold codes on
chargebacks.  A chargeback is a system-generated credit memo invoice for the
difference when an invoice is greater than the receipt cost.

Choose the Filter button to open the Filter subform. Use the subform
to define display parameters for the data that displays on this form.
Invoices display in due date order. Receipts display in receipt number
order.

An asterisk (*) displays next to the Up or Down button if more invoices
or receipts exist. To scroll through the list of invoices or receipts, choose
the Up or Down buttons in the invoice or receipt areas of the form.
The Discrepancy field displays the difference between the selected invoice
amounts and the selected receipt amounts. The Invoice Total displays the total
amount of all selected invoices. The Receipt Total displays the total amount
of all selected receipts.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITSERIAL   -

    MAINVDTL   -

    MAMADHIST  -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APAUTHOR   -

    APCOMPANY  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    -

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   -

    KITITEM    -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.3 - Detail Level Match

Use Detail Level Match (MA60.3) to match at the detail level.
MA60.3 displays all receipt detail lines for the selected invoice.

NOTE:  You have the option to force a match between an invoice and receipt
with invoice details that do not match.


**Troubleshooting

You cannot partially match an invoice. All invoice line details must
be selected.

Reasons for discrepancies:
An item is listed on the receipt, but is not listed on the invoice

- An item is listed on the invoice, but is not listed on the
receipt


- An item on the invoice is more costly than the item on the
receipt (overbill)


- An item on the invoice is less costly than the item on the
receipt (underbill)


- MA60.3 can process all these scenarios.


**More Information

Choose the Invoice Detail button to open the Invoice Detail subform.
From the subform you can access MA65.1 (Invoice Line Adjustment) to maintain
invoice detail, MA43.3 (Invoice Line Detail - Receipt) to maintain receipt
detail, and MA43.1 (Invoice Line Detail - Purchase Order) to maintain purchase
order detail.

Choose the Filter button to open the Filter subform. Use the subform
to define reconciliation selection criteria.

Choose the Chargeback Info button to open the Chargeback subform. You
can use the subform to enter optional reason codes and hold codes on
chargebacks.  A chargeback is a system-generated credit memo invoice for the
difference when an invoice is greater than the receipt cost.

The chargeback funtion has changed the invoice header can be marked for
chargeback and the lines can be marked for chargeback.  The match action will
note all chargeback options on the invoice.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    APINVOICE  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITSERIAL   -

    MAINVDTL   -

    MAINVMSG   -

    MAMADHIST  -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APAUTHBUY  -

    APAUTHOR   -

    APCOMPANY  -

    APHLDINV   -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    -

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   -

    KITITEM    -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    POMATCHOBJ -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.4 - Invoice Match Reference Adjustment



Use Invoice Match Reference Adjustment (MA60.4) to view and maintain
invoice match reference numbers. MA60.4 displays the match reference number,
invoice number, invoice date, and invoice amount for unmatched invoices with
a handling code defined as Match.
You can change an existing match reference number, add a match reference
number to an unmatched invoice that does not have a number assigned, or delete
a match reference number assigned to an unmatched invoice.





Updated Files

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    MAINVDTL   -


Referenced Files

    APCOMPANY  -

    APVENGROUP -

    MACOMPANY  -

    WFSETUP    -


MA60.5 - Receipt Match Reference Adjustment



Use Receipt Match Reference Adjustment (MA60.5) to view and maintain
the match reference numbers assigned to open receipts. MA60.5 displays the
match reference number, receipt number, receipt date, and receipt amount.
You can change an existing match reference number, add a match reference
number to an open receipt that does not have a number assigned, or delete
a match reference number assigned to a receipt.





Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    -

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   -

    KITITEM    -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.7 - Chargeback



Use Chargeback (MA60.7) to enter optional reason codes and hold codes
on the system-generated chargeback.





Updated Files

    APHOLDCODE -


Referenced Files

    APCOMPANY  -

    APVENGROUP -


INVOKED Programs

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