XRL

 

Accessing Opera II data within MS Excel
Opera II 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 II. With its flexibility, ease of use and advanced drilldown capabilities, Opera II 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 II, removing the need to re-key any information.

Comprehensive enterprise reporting and analysis
Information extracted from Opera II 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 II XRL Macro Builder. At the click of a mouse, different types of data can be extracted from Opera II and processed in Excel.

Secure access and control
Opera II XRL supports the Opera II 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 II 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 II transactions
• Access to data controlled by Opera II 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