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
VBA tips & tricks
Automatic procedures using VBA Exsion has the ability to perform your own VBA procedures before or after the data refresh. Furthermore, it is
Currency Coverage Setup
Currency Coverage Setup This chapter describes the setup needed to make use of the SmartTrade Currency Coverage module (Hedging). Since this module is
Currency Coverage Setup Info »
Incident Setup
Incident Setup This chapter describes the setup needed to make use of the SmartTrade Incident module. Incident Setup Use the tell me what
Bonus Setup
Bonus Setup This chapter describes the setup to be done to work with the SmartTrade Bonus module License / Bonus Owners Use the
Customs Setup
Customs Setup This chapter describes the setup needed to make use of the SmartTrade Customs module Custom Status Location On the location code