|
This powerful Pegasus reporting tool allows Microsoft Excel to directly access the
Opera tables.
Not having to enter information on to a spreadsheet means you can spend more
time producing detailed analysis
using XRL’s powerful reporting tools. With XRL you can create links between the
data in Opera 3 and cells in a
spreadsheet so that you can design Management Reports such as P&L and Balance
Sheets in Excel to present
up-to-date, accurate information based on the live data within Opera.
Advanced Implementation. XRL software is capable of some very complex reporting tasks. We will either
train you in its
use or will design
the reports in consultation with you.
Drilldown
Not only can you export data into Excel, but you can also interrogate those
fields and drill down to the transactions behind them. For
example, a Turnover Value for a customer can be interrogated to extract invoice
numbers and then further so that you can see the stock
items which make up that invoice. The real power of this would be seen if you
were asked to explain a value on a spreadsheet such as
“Total Debtors”: using drilldown to investigate the transactions behind
the field, you would have an immediate answer and would not
have to refer back to Opera 3.
Writeback to Opera 3
The Data Send facility in XRL allows you to take information prepared in Excel
and write it back into Opera 3. Information such as
Nominal Budgets, Price Lists and Stock Adjustments can be entered with minimal
effort.
All this information on one screen!
Below is one example of the many exercises that we have designed for our
customers.
 | 
