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.
Pegasus XRL appears as an additional menu item in Excel. Any Microsoft Excel user, regardless of their broader technical awareness, can quickly learn how to use XRL Wizards to create bespoke reports and analysis based on live Opera 3 data, often with just a few clicks of the mouse. Management can therefore view and manipulate complex business reports in a familiar spreadsheet format. The XRL Wizard will help you create reports by extracting the data into Excel. Simply select the Company which you want to extract data for, identify the area of the system you are interested in (such as Sales, Stock, Costing, Payroll) and choose the fields. Plus, it’s all written in simple English so that you don’t have to work with technical jargon. Getting your company’s data into Excel will take seconds!
