Connection Details
The Connection Form where all your database connections are defined
Main Menu
Menu items added to Excel when running the application
Front Page
The Front Page or 'Cockpit'
Front Page Populated
The Front Page or 'Cockpit' after logging into the application with your Oracle username
User Defined GL Queries
Userdefined SQL queries
Example Query Parameters
Example of parameters for a userdefined SQL query
Saving Query Definitions
Form to save your SQL query definitions
Query Output
Example of output from a userdefined SQL query
Line Graph of Rev. & Exp. YTD
Example of a Line Graph showing total revenue and expense
Block Graph of Rev. & Exp. by Periods
Example of a 3d Block Graph
Line Graph of Asset Management
Example of a Line Graph showing total balance sheet items (Asset Management)
Overview of all Balancing Segments
Pivot table showing an overview for all Balancing Segments. Accounting Flexfield dimensions can be added as needed
PL & BS with Drilldown
Profit & Loss report with possibility of drill down to Subledgers. Accounting Flexfield dimensions can be added as needed
Profit & Loss w. Year-end Estimate
Profit & Loss report with estimated Year End result based on remaining Budget values
Balance Sheet w. Year-end Estimate
Balance Sheet report with estimated Year End result based on remaining Budget values
Trial Balance All periods in Pivot
A Trial Balance with all periods of fiscal year including opening balance of fiscal year
Trial Balance with Drill-Down
A normal Trial Balance with possibility of drill down to Subledger details
Trial Balance By Company in Pivot
A Trial Balance for all Balancing segments including filter for dimensions
Trial Balane for Projects
A Trial Balance for Project values
Account Overview with Drill-Down
Example of Account overview showing net and acumulated values of fiscal year with possibility to drill down to Journals and Subledger details
Account Overview with Graphs
Example of Account overview presented graphically
Journals with Drill-Down
A list of Journals and journal status with possibility to drill down to Subledger details
Budget Amounts – Period and YTD
Example of report showing Budget values defined in General Ledger
Drill Down to FA Additions
Example of drill down from General Ledger to FA Additions
Drill Down to FA Depreciations
Example of drill down from General Ledger to FA Depreciation details
Drill Down to MTL Transactions
Example of drill down from General Ledger to Material Transaction details
Drill Down to RCV Transactions
Example of drill down from General Ledger to Receiving Transaction details
Drill Down to AP Invoices
Example of drill down from General Ledger to AP Invoice details
Drill Down to AP Payments
Example of drill down from General Ledger to AP Payment details
Drill Down to AR Invoices
Example of drill down from General Ledger to AR Invoice details
Drill Down to AR Payments
Example of drill down from General Ledger to AR Payment details
Drill Down to Project revenue
Example of drill down from General Ledger to Project revenue details
Drill Down to Project Cost
Example of drill down from General Ledger to Project cost details
Flex Value Information
Report showing all your Flexfield details for accounting flexfield and asset flexfields
Customer Master Data
Customer Master data
Overdue Aging Buckets with Drill-Down
AR Overdue aging buckets with posibility to drill down to transaction details
Invoice Details
Example of Invoice details
Receipt Details
Example of Receipt details
Outstanding Aging buckets with Drill-Down
AR Outstanding aging buckets with posibility to drill down to transaction details
Invoices not completed
List of invoices not completed
List of Payment Terms
List of payment terms
List of VAT Codes
List of VAT codes etc.
List of Credit Limits
List of custonmer credit limits
AR – GL Reconciliation
AR and GL reconciliation for a specific period
AR – GL Reconciliation YTD
AR and GL reconciliation Year to Date
Open Sales Orders Summary
Summary report of open sales orders
Open Sales Orders Detail
Detailed report of open sales orders
Customer List
List of customers
Customer Credits
List of customer credits
Supplier Master Data
Supplier Master data
Supplier Bank Details
Supplier Bank details
Overdue Aging Buckets with Drill-Down
AP Overdue aging buckets with posibility to drill down to transaction details
Invoice Details
Example of invoice details
Outstanding Aging Buckets with Drill-Down
AP Outstanding aging buckets with posibility to drill down to transaction details
Daily Invoices and Status
Count of invoice types and status for a specific day
Invoices on hold
List of invoices on hold
Payment Terms
List of payment terms
VAT Codes
List of VAT codes etc.
AP – GL Reconciliation
AP and GL reconciliation for a specific period
AP – GL Reconciliation YTD
AP and GL reconciliation Year to Date
Supplier List
List of Suppliers
Open Purchase Orders – Standard
List of open Standard purchase orders
Purchase Orders – Blanket
List of Blanket purchase orders
Approved Supplier List
Approved Supplier list
Sourcing Rules
List of Sourcing rules
Sourcing Rule Assignments
List of Sourcing rules assignments
Asset Categories
List of Asset categories
Asset Register
List of Asset register
Asset Register with Depr. Details
Assert register with depreciation details
Subinventory Setup
List of Subinventory setup
Inventory Categories
List of Inventory categories
Inventory Items
List of Inventory items
Summarized Inventory On Hand
Summarized inventory on hand
Inventory OH with Frozen Cost
Detailed inventory on hand with frozen cost values
Received Quantities
List of received quantities
Employees & Supervisors
List of employees and supervisors
Responsibilities & Usernames
List of user names with responsibilities
French Forms
Forms translated to French
German Forms
Forms translated to German
Italian Forms
Forms translated to Italian
Spanish Forms
Forms translated to Spanish
