By the end of this session, you will be able to run Vision XL and explain its main components.

Each of the Vision XLB functions and utilities enables the user to extract, manipulate or transfer data in a different way.
Vision XL provides an intelligent link between SunSystems Accounts modules and Microsoft Excel allowing you to access and exchange data held in SunSystems data files from within Microsoft Excel.
Vision XL is a Microsoft Excel add-in. It is represented as a menu item on the Excel toolbar or as a toolbar comprising individual function buttons.
Vision XL is a part of the Vision suite of products and provides seven purpose-built functions, which can be used together or separately. These functions are:
Reference File Link
This function provides a dynamic link between Excel and SunSystems tables. The link is represented by a formula retained in a cell within an Excel worksheet, which can be saved with the worksheet and copied to other locations in your worksheet. This function only returns the value of a single record, however, a single formula can output multiple data items for that record.
Reference File Fill
Reference File Fill provides a straightforward way of generating reference data from Sun tables into an Excel worksheet. It is easy and quick to use. There are no formulas to enter as it is not a direct link to Sun, therefore, the function must be re-run if data in your Sun database changes.
Extract Balances
Extract Balances can be used to extract balances and reference information in various extract modes from your Sun tables into multiple cells within an Excel worksheet. This function maintains a dynamic link, which represented by a formula retained in an Excel cell, to your Sun modules. Extract Balances returns the value of the selected range to a single cell. A formula can output multiple data items for that range of records.
Data Fill
This function can be used to extract summary details reference information from Sun tables into an Excel worksheet. Unlike Extract Balances, the information extracted from Sun tables using Data Fill doesn’t reflect Excel formulas and permanent links to the Sun tables are not retained.
Extract Transactions
This function extracts transaction details from Sun tables into an Excel worksheet. For example, you can extract the details of all transactions for current period that have a particular analysis code.
Send Data and Send Reference Details
Use Send Data to export multiple data entries for Ledger Accounting or Fixed Assets and reference information (Chart of Accounts and so on) from an Excel worksheet into a transaction text file to import into a Sun database. For example, you can set up your worksheet with a New Chart of Accounts codes and then import them into Sun database using Transfer Manager.
Macro Builder
Macro Builder provides the facility to create an Excel macro that automates Vision XL activities. It stores a series of commands and functions that can be run whenever the activities are required.

By the end of this session, you will be able to extract transactional data using the Extract Transactions function and sort the Transactions produced.
Discuss in forum

Extract Transactions produces a snapshot of the transactions on the system which meet the criteria that have been specified
Use Extract Transactions to extract transaction details from your SunSystems data into an Excel worksheet. For example, you can extract the details of all transactions for a selected range of periods, limited by a range of customers and further limited by all transactions that have a particular Movement Order Analysis Code (M-Code).
You can set a transaction limit in Vision Setup to limit the number of transactions extracted at any one time. When the transactions extracted reach that number, a message appears notifying you of the limit and the first cell in the extraction is colored blue with a note of the limit attached. You must reset the limit in Vision Setup to view further transactions.
Go to “Vision XL” -> “Extract Transactions”

By the end of this session, you will be able to generate a Reference File Link formula, use cell references in filters and use Vision XL Recalculate.
Discuss in forum

Use Reference File Link to extract detailed SunSystems data into an Excel worksheet. Reference File Link maintains a direct link to your SunSystems files and creates Excel compatible formulas for each entry. Formula values are updated after recalculating. You can copy these formulas to other locations in your worksheet or use them as references.
The Excel format of the cell to which the information is extracted determines the way in which it is displayed in the worksheet.
It is useful for building complex on screen inquiries that link to a base reference cell. When you change the value in the base reference cell, the linked information changes as well. Reference File Link extracts data from a single code; however, it can output multiple data items relating to that single record from one formula. The first output item must be in the cell where the Reference File Link definition form is opened.
In this topic you are going to extract the Asset Name, Depreciation Percent, Base Gross Value, Base Net Value for a single Asset Code. You use a cell reference on the Excel worksheet for the Asset Code. You change the Asset Code and recalculate the information for another asset code.