XRL

 

Accessing OPERA 3 data within MS Excel
OPERA 3 XRL is an intuitive addition to the capabilities of Microsoft Excel. It provides powerful and adaptable access to the financial and distribution modules within OPERA 3. With its flexibility, ease of use and advanced drilldown capabilities, OPERA 3 XRL delivers fast and accurate information to provide enhanced analytical power. Nominal Ledger budgets, price lists and stock adjustments manipulated in Excel can also be written back into OPERA 3, removing the need to re-key any information.

Comprehensive enterprise reporting and analysis
Information extracted from OPERA 3 to Excel can be combined with key data from other corporate or external sources to offer comprehensive reporting and analysis.

Automated processes
Reports can be set up and run without manual intervention using the OPERA 3 XRL Macro Builder. At the click of a mouse, different types of data can be extracted from OPERA 3 and processed in Excel.

Secure access and control
OPERA 3 XRL supports the OPERA 3 security features, protecting a company’s data by ensuring that only authorised users have access to sensitive company information.

• Allows information to be incorporated into MS Excel from the OPERA 3 financial and distribution modules
• Cross-company reporting
• Cube analysis for multi-dimensional reporting
• Report Designer facilities
• Dynamic writeback facilities for Nominal budgets, price lists and stock adjustments
• Progressive drilldown to the live underlying OPERA 3 transactions
• Access to data controlled by OPERA 3 security settings

 

Testimonials "The OPERA II accounting solution not only allows us to control the financial ledgers across multiple companies but also lets us maintain control over the supply chain including stock levels and job costing. Together with the powerful XRL management reporting tool for microsoft excel we can have up-to-the minute key financial information at our fingertips." Cedric Randle FCMA - Finance Director Narrow Aisle Ltd