Exsion Reporting for Microsoft Dynamics AX

Gaining insight

With Exsion AX you have a grip on your complex Microsoft Dynamics AX database. This allows each controller to combine the data he/she needs in a report.

Features Exsion AX

One of the features we are proud of is that you can get all the data from your database in Excel. The strength of Exsion Reporting is that you can work with data descriptions that are recognizable to you.

Simple Excel reporting

Exsion Reporting makes it possible for each controller to create reports.

Combine all your data

What we are proud of is that you can get all the data from your database in Excel.

Refreshing of reports

Refresh again and again, so that your report contains up-to-date information.

Quick data refresh

Exsion Reporting is designed to make it easy to gain insight into your business.

Reporting after training

For most reports, one day's training is enough. Also for advanced users.

Safety by authorisation

Data cannot be viewed by people for whom it is not intended.


Thanks to Exsion now much more unambiguous data

At one point we were reporting for days on end, that was impossible to do. In 2008 we switched to Microsoft Dynamics NAV, in combination with a.o. Exsion. That saved us a lot of time. Partly thanks to Exsion we now have much more unambiguous data.

Janssen de Jong

Exsion is for making reports a no-brainer

We have been working with Exsion for over 10 years. We find the program very user-friendly. The use of Exsion for making reports and composing NAV-downloads is a no-brainer. Do it right away.

Cogentix Medical

More reviews

Read more reviews and testimonials

EXSION AX offers
solutions to your problems

Read below what controllers run into and what solution Exsion AX offers.

  • No data from Dynamics AX

    I don't get data from Dynamics AX. View problem and solution

  • Cannot select any data

    I can't select any data. View problem and solution

  • Cut and paste

    I cut and paste a lot to get everything right. See problem and solution

  • Hiring expensive consultants

    I have to hire expensive consultants to change a report. View problem and solution

  • Waiting a long time

    I always have to wait a long time for the data to finally be generated. View problem and solution

  • No help

    When I ask for help, I never get an answer or it's too late. View problem and solution

  • Installation is difficult

    The installation of the software is complex, takes a long time and is error-prone. View problem and solution

Your problem

I don't get data from Microsoft Dynamics AX

You have set up Microsoft Dynamics AX well and it works, your colleagues enter the data. Now you want to make an overview.

No expensive consultant

You can call a consultant or work with PowerBI, but the first is expensive and the second is complicated.

Exsion's solution

With Exsion you can easily transfer your selected data to Excel.

The power of Exsion Reporting is that you only need to know which data you want to combine in your report. You click on it in Exsion and it will ask you a question to the database without you having to worry about it. The data is stored in Excel, so you can edit it as well.

Your problem

I can't select any data

If you want to analyse your business properly or make a simple list, you'd prefer to combine all the data as you see fit. In AX you can filter well, but it is difficult to combine data from different screens. This is also difficult with other tools available on the market.

Exsion's solution

You can use the download to select the data yourself

The power of Exsion Reporting is that you can really combine the data that you choose. We call that making a download. The advantage of a download is that it is not an export. You have to make an export over and over again and you can't make a selection.

Download endlessly usable and customizable

Once the download has been created, you can use it endlessly and make any changes or filters you want.

Your problem

I have to work with cutting and pasting to get everything right

You can make an Excel export in AX, but then you have to paste and cut to get the set you want. You have to do this over and over again. This is work that doesn't make you happy. It is a lot of executive work, takes a lot of time and remains error-prone. In addition, you always have to save your versions separately and comparing data over a period of time is very difficult.

Exsion's solution

After you have made a download, all you have to do is press the Refresh button

With Exsion Reporting you don't have to paste and cut anymore. With the download definition you have your report ready, even for all future times you want to use it. Pressing the Refresh button updates your report without pasting and cutting, so it's up to date and error-free.

No more separate Excel versions

Because you get the data directly from the database. Use Excel for what you need to use it: arithmetic. And the database for data. Your work gets complicated when you use Excel to manage a dataset. Unfortunately, a lot of users still do that.

Your problem

I can only access the ledger table and not the rest

There are software tools on the market that also give you access to tables in AX, but with the restriction that they can only show a limited set of tables (view), or that you need a lot of knowledge to unlock tables.

Can't I just use PowerBI?

Yes, you can. The power of PowerBI is that you can create beautiful dynamic dashboards, the disadvantage is that you need a lot of knowledge to form your dataset and that maintaining a dashboard is difficult.

Exsion's solution

With Exsion you can select and download all data

The power of Exsion Reporting is that you can work with data descriptions that are recognizable to you. Data you see on your screen can be selected, you don't need to know the technical names. In addition, you can maintain reports yourself after a day of training.

Your problem

I have to hire expensive consultants to change a report.

You can make overviews in BC and also in other tools. Changing them yourself, however, is very difficult. First of all you have to change the dataset, which means you have to know how the complex database of AX is constructed. Secondly you will have to make yourself familiar with the functionality of the tool, if you want to change the visualisation in a report, for example.  If this is not your daily work, it often doesn't pay off.

De oplossing van Exsion

Met Exsion kun je na 1 dag training zelf rapporten maken

We hebben inmiddels Exsion aan bijna 1000 klanten verkocht. Zij hebben allemaal 1 dag training gehad en kunnen werken met Exsion.

Wat moet ik kunnen om Exsion Reporting te leren?

Je moet handig in Excel zijn, hoewel wij je tijdens de cursus diverse slimme trucs leren. Daarnaast moet je ervaring hebben met het werken in AX.

Your problem

I always have to wait a very long time for the data to finally be generated

Many tools in the market are slow. That's because of the technology behind it. Data often has to come to the user via links and services.

Exsion's solution

With Exsion you get a quick answer

We've made Exsion so that it's fast in almost all cases. Indeed, it says almost, because there is a limit to every technology. Our customers are satisfied with Exsion's performance.

What techniques are used to get Exsion Reporting fast?

If we can access the database directly (usually in hosting and on premises), the database will be queried directly and not via a link. This makes Exsion lightning-fast.

Your problem

When I ask for help, I never get an answer, or it's too late.

Everyone is familiar with the nuisance of having to contact a helpdesk. You are put through, will have to wait and your problem is always unique, thus making it impossible to solve quickly.

Exsion's solution

With Exsion you can select and download all data

When you have a subscription, you can call our helpdesk to get an answer. Almost 90% of all issues reported we can solve directly.

Your problem

Software Installation Is Complex, Time-Consuming and Error-Prone

Some packages require a very time-consuming process to get them running on a server or tenant, due to the fact that they consist of many components that work together.

Exsion's solution

A half-day to install Exsion

Installation of Exsion is a standard procedure, and will not take more than a morning or afternoon. We will come by for this or install it remotely.

Features and benefits of

View the features and benefits of EXSION AX

Easily Create Reports in Excel

Exsion Reporting allows any controller to create reports based on data present within Microsoft Dynamics AX versions 2009 and 2012. We do not support later versions. A few years ago, Microsoft released Microsoft Dynamics Finance and Operations, a SaaS app, for which we did not create a special version.

Combining All Your Data Present Within Dynamics 365 Business Central

Exsion Reporting for AX allows you to combine all data present in the database, in the case of AX, a great deal(!), within Excel.

How to Select Desired Data

We have created a Wizard for this purpose, a screen that shows the BC/NAV tables on the left. When you click on a table, the data stored within it are shown, which you can subsequentially click to add them to the collection of data you want to incorporate in your report. It is that simple, which you will learn in just one day.

Once Made, Reports Can Be Refreshed Infinitely

Have you ever slogged away at a AX export, using cutting or a sort function to select a subset? The next time you want the report, you will have to do the above again, since you want a report containing the latest data. With Exsion Reporting, this tedious work belongs to the past. Once you have created your data selection (what we call a download definition), you can refresh it time and again, thus ensuring your report will contain the latest data.

Refresh Your Data with a Single Button Click

We have built Exsion Reporting in such a way, that you can effortlessly gain better insight into your company. To make the right decisions, you need accurate reports that can be retrieved at any given moment. The Refresh button takes care of this. Once you have created a download definition, you only have to click Refresh to view the latest data.

Exsion Reporting Is Fast

It goes without saying, that once you click the Refresh button, you do not want to wait a long time. We do everything in our power to ensure that Exsion works fast. Of course, every technology has its limitations, but our clients are very satisfied with Exsion’s overall performance. Ergo, you will not be confronted with annoyances and have quick access to your data.

Create Reports After a One-Day Training Course

People often think that creating reports is very difficult. The basis, however, is quite simple, but you can make things as complicated as you like, due to also having all Excel functionality at your disposal. You can use slicers to add a time dimension to your report, create pivot tables to generate beautiful overviews and much more, but let’s drop that for now. Exsion’s basic functionality is fairly straightforward, a one-day training will suffice for creating most reports.

Would you like to expand your Exsion skills? We provide a training for advanced users, very useful if you want to create complex reports or optimise them.

Automatic Forwarding of Reports

You can use the Windows task planner, or Exsion’s. We also collaborate with RBE, a company that creates task planners. Based on, for example, (a) change(s) in the database, a report can be forwarded to selected staff, without requiring any human interaction.

Exsion AX Helps You Configuring Authorisations

Not everyone should be allowed access to all data. Therefore the application administrator can,  with assistance from us when needed, configure an authorisation table, thus ensuring that data can only be viewed by the eyes they’re intended for.

Want to know more about Exsion AX?

Curious about Exsion AX? We'd be happy to show it to you. In the no-obligation Exsion AX demo, the Exsion team will show you how it works behind the lightning-fast merge of all administrations.

Exsion AX Demo

You'll see sample reports as you use them and discover why Exsion offers so much flexibility in reporting for such low costs.

Does Exsion AX work for us?

Would you like to hear from our software specialists whether Exsion AX fits your needs? We are happy to think along with you.