Vision for iPOS is an intuitive addition to the capabilities of Microsoft Excel and provides fast and adaptable ways to access iPOS for SunSystems. The extensive functionality of Microsoft Excel is enhanced through Vision for iPOS, enabling powerful reporting and presentation.

Vision for iPOS provides a dynamic link by allowing information to be incorporated in Microsoft Excel from multiple iPOS for SunSystems tables into a single report.

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

Data from other applications may optionally be combined with iPOS for SunSystems data within a single Vision for iPOS report.

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

Comprehensive Enterprise Reporting and Analysis 
Vision for iPOS enables information to be extracted to Microsoft Excel, and then combined with key data from other corporate or external sources held in Microsoft Excel. Information held in multiple tables can be contained in the same report. This use of Microsoft Excel allows for more comprehensive and wider ranging analysis and reporting.

Automate Processes with Macro Builder
Macro Builder enables the user to combine Vision for iPOS functions to automate complementary Tasks without intervention. With the click of a button, different types of data can be extracted, processed in Microsoft Excel and displayed for viewing or printing.

Powerful Reporting Capabilities
A powerful Report Designer in Vision for iPOS provides flexible reporting formats. Report Designer includes the use of headers, details, subtotals and footer sections to provide professional looking reports. Vision for iPOS also enables the diverse range of report styles, formats and printing options available in Microsoft Excel to be applied to business data. The data can be extracted and then prepared and printed using Microsoft Excel.

You can also use search expressions, called Wildcards, in definition forms and dialog boxes. These Wildcard searches provide for pattern matching when aggregating information.