Showing posts with label Reports. Show all posts
Showing posts with label Reports. Show all posts

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.

Following are some Important GL Standard reports with a brief description of their purpose:

Account Analysis Report: Lists the accumulated balances of range of accounts and all journal lines that affect that range . Details listed for each journal line include source, batch name and description.

Account Analysis with Payable Detail Report: This report is same as the Account Analysis Report and the details listed for each journal line additionally include vendor name and invoice number.

Budget Trial balance Report: Lists the GL account budget balances and activity for a specific currency.

Detail Trial Balance Report: Lists the GL account balances and activity for GL accounts in detail.

Encumbrance Trial Balance Report: Lists the encumbrance balances and activity for GL accounts in detail.

Expanded Trial Balance Report: Lists the beginning, ending and net balances as well as period activity for a set of accounts.

Foreign Account Analysis Report: Lists the accumulated foreign balances of range of accounts and all journal lines that affect that range. Details listed for each journal line include source, batch name, and description.

Foreign Account Analysis Report with Payables Detail: This report is the same as the Foreign Account Analysis Report and the details listed for each journal line additionally include vendor name and invoice number.

Foreign Currency Detail Trial Balance Report: Lists the GL account balances and activity entered in a foreign currency in detail.

Foreign Currency Summary Trial Balance Report: Lists the GL balances and activity in a foreign currency.

General Ledger Report: Lists beginning and ending account balances and all journal lines affecting each account balance in functional currency. Details listed for each journal line include source and category.

Summary1 Trial Balance Report: Lists the GL account balances and activity for each segment value.

Summary2 Trial Balance Report: Lists the GL account balances and activity for a combination of account segment values and secondary segment values.

Translation Trial Balance Report: Lists the translated account balances and period activity for a specific foreign currency.