Payables and Match standard application reports and lists

Using filters

Match reports and listings each contain filter functionality so that you can narrow the number of records. Use the filters to save time and ensure that the process runs by not requesting large amounts of data. When specifying filter parameters, attempt to get to the data in the most direct manner. For example, if you know the invoice number, filter on the invoice number instead of the company and vendor only. Use status or date range parameters when applicable if you are unsure but have some idea of a date and that the invoice is still open.

Reports and listings

Payables and Match information for reporting is located throughout the navigation menus. In addition, you can create a report from any list.

This table contains the standard application reports and lists for Payables and Match. To find the reports, use the menu search. Search for the Report name unless a name is specified in the Menu name column.

Report name Description Menu name
1099 Tape Creation Create a 1099 reportable income tape for a reportable income group. US 1099 Tape Creation
Auto Match Match invoices based on selected parameters. n/a
Auto Match Results View the results of auto matching. n/a
Bank Account Payment History View manual and system-generated payments for a pay group. n/a
Bill of Exchange Bank Statement Create a statement of bills of exchange that are printed on Bill of Exchange Creation. Bill of Exchange and then select the Processing tab and the Bank Statement button
Bill of Exchange Cashing Statement Create a statement of bills of exchange drafts that have been selected for cashing by the bank on the same date. Bill of Exchange and then select the Processing tab and the Cashing Statement button
Bill of Exchange Cashing Update Create Global Ledger distribution records for bill of exchange activity that has occurred since the last time bill of exchange cashing update was run. Bill of Exchange and then select the Processing tab and the Cashing Update button
Bill of Exchange Creation Schedule invoices for bill of exchange payment and create the payments. Bill of Exchange and then select the Processing tab and the Creation button
Bill of Exchange Distributions Transfer Global Ledger distributions that are created by Bill of Exchange Cashing Update. Transfers all other distributions that have been created during bill of exchange processing. Bill of Exchange and then select the Journalize Preview tab
Bill of Exchange Generation Schedule invoices that are paid with a bill of exchange and generate bills of exchange for the selected invoices. Bill of Exchange and then select the Processing tab and the Generation button
Bill of Exchange Statement Update Update cashed and dishonored bills of exchange. Create Global Ledger distribution records for bills of exchange that were cashed and dishonored, and update vendor balances. Bill of Exchange and then select the Processing tab and the Statement Update button
Cash Payment Register View invoice payments for a pay group. n/a
Chargeback View a list of chargebacks. n/a
Cost Variance Analysis View cost variances for several scenarios, such as cost changes for a buyer. n/a
Electronic Payment File Creation Create an electronic payment transfer file to pay scheduled invoices for vendors that are defined to pay by electronic payment.

See the Payables User Guide appendix for the file layout.

 Electronic Payment Creation
ERS Invoice Creation Create invoices from receipts. n/a
Financial Reporting Update Provide adjustments or difference postings for Stock Ledger or Purchase Journal Interface. n/a
Interface Document Management Invoices Import expense and match invoices and PO service only invoices into Match from an external source. Interface Invoices
Interface Payables Invoices Import invoice, split invoice payment, and general ledger distribution information from a non-Infor system to the Payables application. n/a
Interface Receipts Import receipts from an external source into Match and Terms. Receipt Interface
Intrastat Data Report Edit Intrastat data and create, re-create, or reprint an Intrastat data report for a selected period. n/a
Invoice Accrual Reconciliation View invoice transactions and analyze the balance of your organization's accrual accounts. Invoice Accrual Reconciliation Report
Invoice Add On Charges View invoices that have add on charges and allowances. Add on charges and allowances are charges or discounts in addition to the charge for goods and services on PO invoices. You cannot change records on this screen. n/a
Invoice Cost Update Search for invoices that have had a cost change against the initial purchase order cost. n/a
Invoice Data Archival Archive invoice and Payables-related data. Archival is an alternative to purging data using Payables History Purge. One-time vendors, no activity vendors, and comments are not archived. n/a
Invoiced Not Received Search for invoices that are available to match but have no receipt. This is only a listing. No actions are available to change records. n/a
Invoice Hold Mass Update Add or remove multiple holds simultaneously. Mass Update Invoices On Hold
Invoice Messages View invoices that have purchasing review or reconciliation messages. n/a
Invoice Processing Statistics Track and report invoice statistics, match statistics, and canceled invoice statistics. n/a
Journalize Distributions Post released invoice distributions to Global Ledger. n/a
Mass Invoice Release Release registered invoices for a company that has selected Invoice Approval and has not selected Batch Release in Company. n/a
Mass Retainage Payment Adjust Modify payment records for the portion of an invoice that has amounts retained. n/a
Match Analysis Report View the match status of invoices. Use the parameters to filter by vendor if the work distribution within the department is divided by vendor. n/a
Match Discount Posting Accrue discounts that were taken during the match process. n/a
Match Reference Adjustment Search for adjustments that have been made to match references. n/a
Open Receipt Archive Write off receipts, archive receipts, or both. Receipts that are written off have the profit recognized, but are not removed from the matching pool, including Landed Tax and Landed spread AOC. Receipts that are archived have the profit recognized, if it is not written off, and completely removed from the matching pool. The receipt status is updated to Ready To Archive when every line on the receipt is matched but there is a remaining amount to match. the receipt is also removed from the open receipt pool.
Note: An asterisk is displayed on receipts that were archived and written off in a previous run of this archive job.
 n/a
Paid Invoice Project Update Run after Payment Close to list the transactions that are affected by payment status updates. You can list all updates or only payment updates to a paid transaction. n/a
Payables Period Close Run at the end of each accounting period for companies that have system control that is selected in Global Ledger. Close Period in Payables
Pay Group Update Update pay groups for payment cycle processing. A pay group update report can be generated. n/a
Payment Clearing File Creation Create a file in the Automated Clearing House (ACH) or Bankers Automated Clearing Services (BACS). Use it to pay invoices that are scheduled by the most recent run of cash requirements.

See the Payables User Guide appendix for the file layout.

 n/a
Payment Closing Complete a cash payment cycle for a pay group. This is the last form in the payment cycle. Create a summary payment listing, a listing of recurring invoices, and a summary of Global Ledger transactions. Payment Close
Payment Void Stop Pay Update Reinstate invoices that are associated with payments that are voided in Cash. n/a
Perform Cash Requirements Schedule released invoices for payment. n/a
Prepaid Invoice Not Received Generate chargeback of invoices that were paid but the goods were never received. n/a
Process Group Update Update selected vendors and associated invoices with a new process group. A listing of updated vendors is displayed. You cannot run this update when a cash payment cycle is in progress. n/a
Proof Of Delivery Statements Create proof of delivery statements. Proof Of Delivery Notification
Purchasing And Sales Journal Generate a report of transaction records and optionally, their distribution detail lines. The source of the transactions is input or output.

Input: Payables, Cash, and Tax input transactions.

Output: Receivables, Billing, Project Invoicing and Revenue, Cash, and Tax output transactions.

 n/a
Recurring Invoice Update Update recurring invoices. n/a
Unmatched Invoice List Generate a list of unmatched invoices for a specific company. n/a
Unmatched Receipt Lines View a list of receipt lines that have not been matched to an invoice. Use the filter parameters to narrow the number of receipt lines. No actions are available. You cannot change the receipt lines that are displayed. n/a
Unrealized Gain Or Loss Report for companies that pay non-base currency invoices. Use to calculate and create unrealized gain and loss Global Ledger transactions for payment accrual and unrealized gain and loss accounts. Unrealized gain and loss transactions are only created for released, non-base currency invoices. Unrealized Gain And Loss Calculation
Update Analytic Cube Cube-based reporting is a feature that is used for multidimensional reporting. Cubes are built-in tools that are used for visualizing and sorting data. n/a
Vendor Balance Rebuild Rebuild vendor balances. n/a
Vendor Balance Year End Run at the end of the fiscal year to establish new period end dates for a vendor group and transfer current year balances. n/a
Vendor Deletion Delete a large number of vendors. n/a
Vendor Group Copy Copy selected hold codes, vendors, vendor classes, vendor locations, and user fields from one vendor group to another within the Payables application. n/a
Vendor Interfaces Import vendors and alternate vendor locations from a non-Infor system to Payables. n/a
Vendor Merge Transfer a vendor's open invoices to another vendor. n/a