Sample Report

Advanced Payables Aging Reports

Header Oracle Ap Aging Daily

Knowing what you owe debtors and where you may be able to extend payments is vital to managing cash on hand. The Payables Invoice Aging (as of date) report definition allows you to determine outstanding invoices on a specific date for pre-defined aging buckets. We’ve also created two additional versions of this report for a daily and weekly view.

In a single interface, the data returned can be used to determine unpaid invoices by Supplier or Supplier Site. It is primarily used to report the number of days an invoice is overdue at a specific date in time.

The types of reports you can create include:

  • Classical aging report with the pre-defined aging buckets as columns
  • Listing of invoices not fully paid, grouped and sorted by Supplier Name, Supplier Site, Payment Terms, and other available attributes.


insightsoftware Starter Pack—Wands for Oracle

The insightsoftware starter pack for Wands is a set of templates that enable you to closely monitor costs and cash flows in uncertain times. Wands for Oracle is tightly integrated with your Oracle E-Business Suite (EBS) system and automatically understands your setup, from inheriting security to understanding hierarchies.

Wands for Oracle is purpose-built for Oracle EBS using familiar terminology and designs that make it easy for finance users to learn and use. Build GL reports using your existing Excel skills in minutes. Use the GetBalance functions to define the account balances you want to return by filtering on parameters such as period, balance type, and your Accounting Key Flexfield segments (GL Account, Company, etc.).

Utilize 75 packaged Advanced insights queries to access real-time subledger data in Excel across Financials or leverage the thousands of EBS database views as a starting point for any EBS module. All prebuilt templates allow you to easily drag popular additional fields onto the report or use a wizard to add fields not included in the template without writing any SQL code. Each template provides more flexibility than your Oracle standard reports, allowing you to filter on any of the returned fields and drill down to transaction or related data, all within Excel.

  Download Now


Product: Wands Data Source: Oracle E-Business Suite (EBS) Type: Report Role: Finance