Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MA60


MA60.1 - Reconciliation Queue

**Form Purpose
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  -

    PROCUREGRP -


MA60.2 - Invoice Level Match

**Form Purpose
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.

Note You have the option to force a match between an invoice and receipt with
invoice line item 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.

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  -

    ADDRDATA   -

    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   -

    MAAOCDTL   -

    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  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APAUTHBUY  -

    APAUTHOR   -

    APCOMPANY  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    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  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.3 - Detail Level Match

**Form Purpose
Use Detail Level Match (MA60.3) to match at the detail level.

MA60.3 displays all receipt detail lines for the selected invoice. MA60.3
displays following information from the invoice:

- the invoice number

- match detail (item) or item description (based on the Display field)

- cost

- quantity

- extended cost

MA60.3 displays the following information from the receipt:

- receipt number

- match detail (item) or item description (based on the Display field)

- cost

- quantity

- extended cost

Records are sorted according to the match detail (item order) for all invoice
and receipt lines.

**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.




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    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  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APAUTHBUY  -

    APAUTHOR   -

    APCOMPANY  -

    APHLDINV   -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    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    -

    MAAOCDTL   -

    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  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.4 - Invoice Match Reference Adjustment

**Form Purpose
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  -

    MAAOCDTL   -

    MAINVDTL   -


Referenced Files

    APCOMPANY  -

    APVENGROUP -

    MACOMPANY  -

    WFSETUP    -


MA60.5 - Receipt Match Reference Adjustment

**Form Purpose
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  -

    ADDRDATA   -

    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  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ACCATSUMX  -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    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    -

    MAAOCDTL   -

    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  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


MA60.7 - Chargeback

**Form Purpose
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
    ACTA
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    ACSB
    API3
    API5
    ICCP
    ICI1
    IFRS
    IFSC
    MAED
    MAI1
    APDS
    API2
    APCP
    MARC
    POED
    SLSS
    GLCC
    ICIT
    ICLC
    MAPL
    POCP
    POIF
    POIH
    POI6
    POI4
    POI7
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    POIJ
    POI1
    POIM