Help
Contains all the information needed to use Exsion.
Info
Information about your Exsion setup Tab Description Settings Field Description Language Choices are NL, EN, FR or DE. The language setting is saved
Refresh Data
The “Refresh data” button will activate all dynamic downloads and force a recalculation of all formulas so that all information will reflect the
Download to pivottable
After a download has been used for the first time, it can be modified to use it for creating a PivotTable. Click on
Join Types
There are 5 jointypes to choose from. Type of join Description 1=Inner Include only records where the joined fields from both tables are
Joining tables
After adding a second table Exsion will show a JOIN proposal: Field Description Join fields The list of fields that can be used
Dynamic download
A Dynamic Download is used to get data from the Dynamics NAV database in the Excel sheet. As opposed to functions, this will
Show details
This option is used to provide detailed information for the Exsion formula in the active cell. The way this information is displayed depends
Formulas to values
This option is used to replace all Exsion functions in your document by their current values so the document can be send to
Function definition
Functions can also be created without storing them in the Function Libray. The advantage is that it also can be used by Exsion
Function Library
The function library contains the User Defined Functions. These functions act like any other Excel or Exsion function and will be available for
Database structure
This option will create a roadmap from your Dynamics NAV database to provide information about tables, fields, indexes, datatypes and possible joins. When
Connection
Create or modify database connections. This option shows the following window: The “Save” button stores a new connection or changes an existing one.
Activate Exsion
Click on “Activate” from the Exsion menu to open the activation form. Click on the “Activate” button to activate the license. During activation,
Incident Process
Incident Process This chapter describes the way the SmartTrade Incident module can be used within you complete process. You will learn how to
Using filters
Filter usage in Exsion functions and the Filter column of a dynamic download. When you enter a filter, you can use all
Advanced functions
These functions can be found in Excel’s function wizard under the heading “Exsion advanced” These are functions that only work in the document
Standard functions
These functions can be found in Excel’s function wizard under the category “Exsion standard”. EXSION_ACCBAL Returns the balance or budget of a G/L