Showing posts with label Account Receivable Key Reports. Show all posts
Showing posts with label Account Receivable Key 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.

Oracle 11i Account Receivabls(AR)Key Reports

AR Application provides more than 100 Reports to assist with accounting , collections, execution, printing documents, listings, tax reporting, and miscellaneous activities.

Accounting Reports- These Reports assist with recording the history of transactions, balancing the AR Subledger internally, and recording entries into the General Ledger.

Accounting Reports in AR
Adjustment Apporval- Use this report to see information about transacitons adjustments.
Adjustment Register- Review approved adjustments with this report. This is one of the reports used to balance the system.
Aging By Account Report- This is variation of the aging reports to show open items in summary or detail by accounting flexfield value. This is one of the reports used to balance the system.
Applied Receipts Register-This report shows all activity of receipt. This is one of the reports used to balance the system.
Automatic Receipt Batch Managment- This report is used to review the status of Automatic Receipt Batches.
Automatic Receipt Awaiting Confirmation-This report lists automatic receipts that have been formatted and have been assigned a payment method with a receipt class with Require confirmaiton.
Bad Debt Provision Report- This report can calculate a bad debt exposure from the percent collectable value in the customer profile class.
Billing and Receipt History- Use this report to see detailed list of transaction for the date range.
Billing History Report- This report shows a summary of transaction in an account.
Commitment Balance Report- This is a summary listing of information about commitments.
Invoice Exception Report- This report shows transaction where open Receivables is equal to NO. These transactions do not appear on an aging report but are on the transaction register.
Invoices Posted to Suspence Report- This is listing of invoices where the revenue account is a suspence account.
Journal Entries Report- Use this report to reconcile the AR subledger to the General Ledger.
Journal With GL Detail Report- Use this report to show journal entries for specific transacitons in AR.
Miscellaneus Transaction Report- List miscellaneous receipts activity with this report.
Receipts Register- This is a listing receipts for a date range.
Receipts Journal Report- This reports lists the details of the receipts that have been included in a journal entry.
Sales Jounal by Customer Report- This report lists all transactions by customer.
Sales Journal by GL Account- This report is similar to the transaction register by GL account. Use this report when you balance the AR aging to the General Ledger.
Transaction Reconciliation Report- This is a report to show GL journal entry lines created from specific AR transactions.
Transaction Register- This register to verify that possible items are included in the sales journal. This is one of the key reports used to balance the system.
Unapplied Receipts Register- This report lists the details of on account and unapplied receipts.
Unposted Items Report- This report to see items not posted to General Ledger for a date range.