Wise Analyzer

Inventory - Value The Inventory - Value analysis shows you your inventory on any selected date by locations and Item Variants.   Of course you have the  full power of our Pivot tables to pivot your data as you need. Average Days to Pay The Average Days to Pay analysis shows you exactly how long it takes your customers to pay each invoice and the Total row is calculated using the formula: total days / number of payments.

Join us as well on facebook !

Install latest version of Wise Analyzer You can install Wise Analyzer in two ways, either directly under your user profile using Microsoft ClickOnce technology, or under the "Program Files" folder using ordinary .msi file.  The latter is almost only used when installing Wise Analyzer on a Windows Terminal Server or Citrix environment. If you use the ClickOnce setup, the system will automatically inform you when new versions are available and allow you to upgrade instantly.  Click  here for ClickOnce setup Click here for msi setup When the system starts it will show you a login screen, there you need to type in the SQL Server name and then select the Dynamics NAV database and select the Company you want to connect to. If you connect to a Cronus company (Demo database from Microsoft) you can explore the whole system apart from the Dashboard designer and the Query builder. If you connect to your own company a license window appears and there you jus...

The filters in Wise Analyzer pivot reports are default " Exclusive Filters ", meaning that you are deselecting items you don't want to see.  This can, in version 5, be easily seen in the status bar below the report after you have changed any filter: Here I have deselect "Beef House" and that can be seen in the status bar. Now, if you want to reverse this (show only Beef House and nothing else) and you want to save this filter for future use, then you also need to change the behavior of the filter to be "Inclusive filter".  If not it will show/and behave like this: Here I have pressed the Invert Filter, but not changed it's behavior, thus the sell to customer filter now excludes all customers loaded into this dataset, and those customers will not be included, however if I select another period with other customers, they will be. The trick here is to change the filter to "Inclusive" by pressing the star icon on the filter form:...

Wise Analyzer 5.0 comes with 20 + reports/analysis, some old and some new. Furthermore, many previous reports/analysis have been upgraded and enhanced. Here are some of the changes described. Improved G/L Analysis - Enhanced In the G/L Analysis you can now view your Income statement month by month, see the trend graphically and double click on any value to see all the entries in that month. KPI's and Excel export has also been enhanced and in the filtering for Departments and Project we have added the <empty> filter and a clear button. hint: to deselect the budget selection, press Ctrl-delete when the focus is on the Budget drop-down editor. Drill down window - Enhanced Each drill down window (the window that opens when you double click on a cell in Wise Analyzer) now remembers how you left it last.  So all changes in summaries, filtering, column order and column visibility is kept. Aged Accounts Receivable and Payable - Enhanced Here...