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