Vision Xl

Vision XL is an intuitive addition to the capabilities of Microsoft Excel and provides fast and adaptive ways to exchange data with your data source. The extensive functionality of Excel is enhanced through Vision XL, enabling powerful reporting and presentation.

Vision XL provides a dynamic link between mulitple data sources, such as SunSystems or SharpOwl, and Microsoft Excel into a single report. Conversely, data prepared in Excel worksheets can be transferred back to your specified data source.

With its flexibility and ease-of-use, Vision XL allows non-technical and non-accounting staff to effectively analyze data, providing enhanced analytical power and assisting the decision-making process.

Vision XL, is an Excel add-in displayed as an item on the menu bar or as a toolbar. Purpose-built functions, represented on the Vision XL menu allow dynamic and flexible access to data from any data source to populate your Excel worksheets. Both transaction and reference information can be combined to generate formatted output, which is suitable for use as forms or for inquiry.

Benefits

• Vision XL enables information to be extracted to Excel, and then combined with key data from other corporate or external sources held in Excel. Information held in multiple tables can be contained in the same report. This use of Excel allows for more comprehensive and wider ranging analysis and reporting.
• Macro Builder enables you to combine Vision XL functions to automate complementary tasks without user intervention. With the click of a button, different types of data can be extracted, processed in Excel and either returned to your application or displayed for viewing and for printing. Reference File Link provides a dynamic link to your data source reference files. Extract Balances enables sales, purchasing and inventory quantities and values to be dynamically linked to worksheet cells.
• Data Fill extracts summary details and references master file information from your data source into an Excel worksheet.
• Send data back to the data source using the Send Data function.
• Data Selector creates and displays a dynamic lookup on a single or multi-column range of data in Excel or directly from your data source.
• Perform statistical reporting using Extract Modes.
• The powerful Report Designer provides for flexible reporting. Report Designer includes the use of headers, details, subtotals and footer sections to provide for professional reports. Vision XL also enables the diverse range of report styles, formats and printing options available in Excel to be applied to business data. The data can then be prepared and printed using Excel.
• Use search expressions, called Wildcards, in definition forms and dialog boxes. These Wildcard searches provide for pattern matching when aggregating information.
• Vision XL incorporates multi-lingual and multi-currency functionality.