By the end of this session, you will be able to create a report using the Extract Balances function.
Use Extract Balances to extract both balances and reference information in various extract modes and also user defined calculations from your SunSystems data into multiple cells within an Excel worksheet.
Discuss in forum
Overview

Extract Balances maintains a direct link to your SunSystems files and creates Excel compatible formulas for each entry. Formulas are updated after recalculating. You can copy these formulas to other locations in your worksheet or use them as references.
Once you have set up a worksheet using Extract Balances, you can edit the formulas within the definition form to return the same information against different data. For example, you can set up your worksheet to show the total cost and average cost of purchase orders for one supplier using the supplier address code as the reference link. If you change the address code then recalculate, the total and average purchase orders costs for the newly entered supplier is returned.

The Excel format of the cell to which the information is extracted determines the way in which it is displayed in the worksheet.
First of all prepare an Excel worksheet as shown below:

Click on cell B2 and go to “Vision XL” -> “Extract Balances”.

The finale Extract Balance definition form should look like this:

Click OK. The Excel worksheet looks like this:

Now you copy cell B2 and paste it in the cells B3-B5. After the formula has been copied you have to recalculate your workbook you can do this in two ways either clicking the right button of your mouse or going to “Vision XL” -> “Recalculate” -> “Worksheet”.

The cells have been recalculated: