Invoice Reports In Oracle Payables

Payment Batch Control Report

Payment batch control report to review detailed information about the payments printed in one or more payment batches. We can submit this report after every payment batch to compare it with actual payment information.

Credit Memo Matching Report

This report lists credit memos and debit memos that match the supplier and date parameters we specify. This report also lists the total of the distribution line amounts of each credit memo in our entered currency and our functional currency. It also lists total credit memo amounts for each supplier and a total amount for the supplier.

Invoice Aging Report

This report is used to analyze the cash flows of our unpaid invoices. This report provides information about invoice payments due within four weeks periods our specify in aging periods window.

Invoice Audit Listing by Voucher Number

This report to review our invoices with assigned sequential voucher numbers. Either we are payables can assign a unique, sequential number to an invoice during invoice entry, if we enable the sequential numbering profile option.

Invoice Audit Listing

This report to audit invoices for duplicates. We should audit invoices periodically to ensure control of invoice payments. We can sort this listing in six different ways. For example we may want to only audit invoices over $500. We can specify a minimum invoice amount, and sort invoices by amount then the supplier name and date.

Invoice Audit Report

This report lists invoices that appear as potential duplicates according to several criteria. One criterion we specify is the number of characters in the invoice number which two or more invoice have in common. The report lists invoices which meets this criteria and have the same invoice amount, the same invoice date, and same supplier. We can limit the search by checking for duplicate invoices within a time period we specify.

Invoice History Report

The invoice history report is needed to justify the balance for a given range of invoices. It helps us to quickly identify and review a detailed list of all activities pertaining to a specific invoice including all payments, gain/loss, credit , debit memos and discounts.

It also helps us to identify activities on prepayments and credit ,debit memos.

The balance of the invoices in then summed for each supplier site for each supplier and for the entire report.

Invoice on Hold Report

This report to review detailed information about invoices on hold. We can submit the approval process before submitting this report to obtain the most up to date hold info. To obtain additional detail for invoices on matching hold, we can submit the matching hold detail report.

This report is divided into three sections. The first section gives us supplier , invoice, purchase order, amount and hold information for each invoice o hold. Payables subtotals the invoices on hold by supplier or by hold code. The subtotal information includes the number of invoices, total original amount and total amount remaining for the invoices on hold. The report does not include cancelled invoices.

Second section, invoice hold code description, lists all predefined and user defined hold codes that are in the first section of report, description of each code and whether the hold allows posting. The third section the report, invoices with no exchange rates lists foreign currency invoices without exchange rates.

Invoice Register

This report shows detailed information about invoices.

We can use this report to view the offsetting liability accounts that payable creates for each invoice distribution when our approve an invoice. Payables orders the report by invoice currency and invoice batch name. Within the currency and batch name the report orders by the supplier name and invoice number.

Posted Invoice Register

This report to review invoices posted in particular period. We post invoices by submitting the payable transfer to general ledger program. The posted invoice register lists each accounts payable liability account and the invoice posted to the account along with the supplier and amount information for each invoice listed.

Payables displays the invoice amount and posted distribution amount in the invoice currency. Payables also displays the posted distribution amount in our functional currency for easier reconciliation with our general ledger. We can also use this report to reconcile variances between an invoice amount and its distribution amount. Variances can result from reversing distribution or correcting entries.

Invoice Validation Report

This invoice validation report to review the total number of matching and variance holds that payables applies and releases after we submit invoice validation. If we use budgetary control payables also lists any funds control holds.

Matching Hold Detail Report

This matching hold detail report to review detailed accounts payables and purchasing information for invoices with matching holds and matching hold releases. We can print this report before initiating a payment batch to determine whether to manually release any invoices for payment. We can print this report for all invoices with matching hold and releases during a time period we specify, or we can print this report to review only invoices with matching holds applied or released since the last time we submitted for approval.

Open Items Revaluation Report

This report to revaluate our open items, for example invoices, prepayments and credit memos and debit memos that are not fully paid. This report takes into account the changes of the value due to changes in the foreign currency rates.

Recurring Invoices Report

This report to review recurring invoice templates we defined during a specific time period. We can review this report to determine the amount we have authorized for a recurring invoice template, how much we have released, and the next amount we have scheduled. The report also lists the number of periods remaining for a recurring invoice and the next period we have scheduled.

This report lists recurring invoice templates by supplier and supplier site.