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