Microsoft Dynamics NAV 2017 – PayPal invoice link and upgrade of OCR service

Since end of October, the latest release of Microsoft’s ERP solution Dynamics NAV 2017 has been available. Many of the new features help to simplify users’ daily work with the system – including in financial accounting. Particularly significant new features include a new PayPal link in invoice documents and the upgrading of the OCR service which was introduced in the 2016 version.

In this age of online banking, along with PayPal, Microsoft is responding with a special innovation, offering the chance to insert a hyperlink for the online payment service into the invoice.

Invoice with PayPal link
Invoice with PayPal link

By clicking on this link, customers are forwarded directly to PayPal, allowing them to pay the respective invoice more conveniently and more quickly online. The necessary invoice information is transferred to PayPal by Dynamics NAV, so the customer has just to confirm the payment.

PayPal Login
PayPal Login

The link can also be attached subsequently to sales invoices that have already been booked. In addition, Dynamics NAV 2017 allows the user to flexibly configure which documents should contain a PayPal link. The link can be added to both individual invoices and all invoices as standard with the corresponding Settings.

Payments configuration
Payments configuration

Improvement of e-services

To simplify the completion of sales processes for users, the previous version of Dynamics NAV introduced a special OCR service. Along with the introduction of the PayPal invoice link, the OCR functionalities have now been upgraded.

With the text recognition service from Lexmark, incoming receipts in PDF format (scanned or received electronically) can be converted into a structure which is easily processed by the ERP system.

So far it has only been possible to transmit header data and invoice amounts via the OCR service to a partial extent. Dynamics NAV 2017 simplifies this process as the article and general ledger account lines are also extracted. Invoice capture with OCR can be seen to be especially valuable for repeat invoices, since items can be determined easily using cross-references (e.g. the manufacturer). In addition, the new visual Lexmark website helps with checking invoices as well as with recognizing creditors and items.

More information on the use of the OCR service in Dynamics NAV is available in our blog article “Incoming invoice process with OCR in Microsoft Dynamics NAV 2016” and in the following Video:

Lexmark Invoice Capture Service
Lexmark Invoice Capture Service

Creating and sharing reports with Qlik NPrinting

Appealing reports can be generated and automatically distributed quickly and easily using the Qlik NPrinting reporting platform – in various formats via different channels. The add-on sources the required data and analyses for the adaptable reports from QlikView and Qlik Sense.

Qlik NPrinting uses QlikView and Qlik Sense as a data source and therefore accesses patterns and QlikView or Qlik Sense elements which the required reports are finally based on. Thanks to complete Microsoft Office Integration suitable report templates can be created in the native Office environment.

Report Designer in Qlik NPrinting
Report Designer in Qlik NPrinting

The reports can be produced in various standard formats, such as PDF, Excel, Word, PowerPoint or HTML and distributed accordingly – at a scheduled time or whenever they are requested by individual users.

Final Report in Qlik NPrinting
Final Report in Qlik NPrinting

They are distributed, e.g. by email or a transfer drive, but mainly through a centralized distribution system, the web-based NPrinting NewsStand Portal, which ensures that the reports are reaching their user extremely easy and fast. The user can finally subscribe to the required reports from a computer or mobile end device or have the available reports displayed or download them. As a result, the correct information always reaches the right recipient at the required time.

Qlik NPrinting NewsStand
Qlik NPrinting NewsStand

Qlik NPrinting also guarantees optimized flexibility, control and security through multi-engine scalability. Role-based security at app level ensures at the same time that administrators, developers and recipients only receive access to information that they are authorized for and is relevant to them.

Would you also like to create, schedule and automatically distribute reports quickly and easily using Qlik NPrinting? Contact us or visit our website for more detailed information about Qlik NPrinting in combination with QlikView and Qlik Sense!

Microsoft Dynamics NAV 2017 officially available

As announced a few weeks ago, Microsoft has now officially launched its latest release Dynamics NAV 2017 on the market. According to Microsoft, the new version of the ERP system puts the worlds of NAV and Office 365 closer together, enhances the platform in different areas and creates completely new opportunities with various apps and Extensions.

Dynamics NAV 2017 Features
Quelle: Microsoft

With the release of Microsoft Dynamics NAV 2017, users and developers have now the following new functions, enhancements and improvements available:

  • Linked directly to Office 365 for easier navigation between Dynamics NAV and Office applications, such as Outlook or Excel as well as Power BI integration
  • Numerous functional enhancements in Financial Management and E-Everything (e.g. improvement of OCR services, cash flow, financial reports, faster payment of invoices thanks to integrated links to payment services such as PayPal and simplified creation of account categories)
  • Integration of Cortana Intelligence for the specific analysis and use of business data and generation of intelligent forecasts and decision making – calculated by powerful machine learning
  • Enhanced user experience due to numerous web, app, and phone client improvements as well as Smart Notifications, which guide users through processes relevant to the context and an Assisted Setup Wizard, which supports the setting up and importing of data, besides other things
  • Improved CRM integration through simplified usage within Dynamics NAV and enhanced CRM functions
  • Simplified categorization, management and filtering of articles by allocating article attributes and enhancing sales documents
  • Many new options for users thanks to helpful extensions that are provided by the already rolled out AppSource (e.g. Quick Box and PayPal)
  • Numerous other new features, such as the integration of Power Apps to create and publish streamlined apps and Microsoft Flow to link various cloud-based data and services as well as many enhancements for developers (e.g. additional object types)

You will soon be able to obtain detailed information regarding the feature highlights mentioned and many other new functions in Dynamics NAV 2017 in our new Dynamics NAV 2017 blog series.

On November 1st, Microsoft also released its new cloud-based business solution Dynamics 365 on the basis of Dynamics NAV 2017 in North America and Canada. We will keep you informed about its content and differences to the “traditional” NAV.

Qlik Sense 3.1: Qlik publishes new release of its data visualisation software

Qlik Sense 3.1Business intelligence provider Qlik has brought the latest version of its data visualisation tool Qlik Sense onto the market providing users with numerous bug fixes, improvements and new functionalities.

The feature highlights of Qlik Sense 3.1 include:

  1. Drag & Drop Coloring of measures and dimensions
    The new version allows measures and dimensions to be colored conveniently by simply dragging the appropriate fields into the chart by drag & drop. Subsequently, the chart color is automatically configured on the basis of expression settings. This facilitates the process of using several colors within a chart to clearly distinguish the individual values.
  2. Geographic Data Profiling
    Qlik Sense 3.1 offers the chance to profile the available datasets according to geographical information (e.g. city and country names) and create a map with the required geographical points and polygon forms on the basis of the found data. Thus, it is no longer necessary to upload geographical data separately to generate a geographical visualisation
  3. Pivot Table Loading
    In addition, the release makes it easier for the user to load unstructured data such as pivot tables or crosstables. To this end, the “Unpivot” button in the table editor makes it possible to select individual columns, to transpose them into rows and rename the attributes and measures.
  4. Improved User Experience
    In Qlik Sense 3.1, a new style of theme can be chosen that changes the background color of a sheet quickly and easily and provides the sheet objects with borders. This gives the dashboard a classic and structured look to support, for example, an accurate adjustment of a charts size and Position.

In addition to the listed functions, Qlik Sense 3.1 also offers other expansions, such as an enhanced scripting editor, a keyword and phrase search when browsing through DataMarket packages, an improvement of the Data Storytelling design as well as numerous bug fixes.

There are also a few innovations for developers. For example, in the new, free development environment Qlik Playground, they can learn to use APIs and the associated Qlik Engine and experiment with them.

Watch the following video to get more information on the expanded functions in Qlik Sense 3.1:

Qlik Sense 3.1 - What's New

Fast And Simple Geo-Visualisation With Qlik Sense

Qlik Sense Geo-VisualisationIt is increasingly important to maintain a constant overview of company-relevant data, particularly in the time of big data, but that does not make it easier. As a result, modern business intelligence solutions have become indispensable for companies in making the respective information as clear and coherent as possible.

The data discovery software Qlik Sense with its integrated geo-functions allows data to be evaluated and displayed, even for different geographical zones. It can, for instance, show you which regions in Germany sell a product particularly well, or if you were able to increase turnover internationally with an individual product in the past year. Qlik Sense offers various possibilities to visually display the relevant data on a map, and allows analyses and comparisons to be carried out.

Qlik Sense Geo-Visualisation - Sales in Germany
Qlik Sense Geo-Visualisation – Sales in Germany

This makes it possible for regional sales figures to be pictured on a map in the form of different coloured areas. In addition, the respective data can also be displayed on uploaded maps as circles of various sizes. Qlik Sense offers a diverse range of interaction options. Map scaling can be carried out by swiping, panning or scrolling (depending on the device being used).

Qlik Sense Geo-Visualisation - Area and Point Visualisation
Qlik Sense Geo-Visualisation – Area and Point Visualisation

In addition, you can focus on a specific area in just a few clicks, letting you take a closer look at selected information. A number of different selection possibilities are available to the user (marking, clicking, lasso and legends selection) to limit the examined data.

The pre-integrated mapbox background function can be used for geo-visualisation in Qlik Sense. Users can also add maps from external providers. Aside from additional maps, these also offer other expansions for more complex geo-visualisations. You will receive an overview of possible functionalities of external providers in a separate blog.

“Internal Security” in ERP Systems

Internal security in ERP systemsMid-sized companies are being targeted these days by plenty of ads for “IT security in business”. Focus is on securing data and protecting the IT infrastructure against external attack. Daily headlines about hacker attacks are drawing attention to the vulnerability of one’s business at a fundamental level.

For an internal ERP system, however, the data security concept ought to give equal importance to how its user permissions are set up. Because of its complexity this issue is often neglected, although it holds a great potential for harm. Even disregarding any criminal intent of employees who might want to steal or manipulate sensitive data, it should be clear that sensible, role-based granting or limitation of access for individual users is a critically important administrative task.

Defining user rights helps, after all, to avoid errors and to increase data quality, since only entitled (= competent) users can perform certain transactions.

The ERP system Microsoft Dynamics NAV, for example, allows you to adapt which features will be available to a user depending on that user’s permission settings. This greatly improves usability, because each role in a company will only use a fraction of the functions of a typical ERP system. Therefore, many companies have adopted high compliance standards for data access, which have to be guaranteed by a sophisticated access concept.

A number of important updates in this vein have made their way into the NAV standard with the release of NAV Version 2016. Some of these solutions had already existed in partner solutions. Microsoft has now consolidated these into a new release. Unfortunately, they did little to announce these functions, and most of us have had to stumble upon these “hidden features” by accident.

To summarize the most important changes:

It is possible to define specific permission roles. These roles can be assigned to permission sets that precisely control access to a system object (table, table data, report etc.). This administrative level makes configuring new users much more efficient, by having preconfigured roles to choose from.

Microsoft Dynamics NAV 2016 user groups
Microsoft Dynamics NAV 2016 user groups

Matrix views show quickly and clearly which users have been assigned to which groups.

Users ordered by user groups in Microsoft Dynamics NAV 2016
Users ordered by user groups in Microsoft Dynamics NAV 2016

The creation of permission sets has also been simplified. A “recording” mode now lets the authorization administrator select the necessary system objects by simply running a session and working with the system the way a given user will work with it in future. Thus, the system objects are logged and summarized in a permission set. A user assigned to that permission set will then have exactly those permissions (read, write, execute, delete) that the administrator accessed while recording the model use of the application.

User permissions in Microsoft Dynamics NAV 2016
User permissions in Microsoft Dynamics NAV 2016

“Project Madeira”: Improvements and new Features to the July update

In July, Microsoft released an update for its cloud-based solution “Project Madeira”. This offers the users some interesting new expansions in addition to a number of small improvements.

The innovations mostly affect the interaction between “Project Madeira” and Outlook, the improvement of the sales documents and the connection to Dynamics CRM.

New features in Microsoft Outlook

Outlook now is equipped with certain new functions. From an appointment in the Outlook calendar, you can directly open the “Project Madeira” add-in, for example, in order to get an overview over the customer associated to the respective meeting. It is even possible to create and send an invoice for the appointment – without leaving the application.

Microsoft Project Madeira new features in Outlook
Source: Microsoft

A further possibility is, to send e-mail attachments (e.g. invoices as a pdf file) directly from the Outlook add-in to the list of “Incoming Documents” in “Project Madeira”. Then they can be forwarded to an OCR service which converts the received information into a digitally useable format. The entire process is carried out in the Outlook add-in. By the way, the user will also be informed there as soon as a software update is available.

Expansion of sales and delivery documents

The sales documents in “Project Madeira” have been expanded with a number of important fields. The changes now allow information in relation to the transport service and the tracking number to be recorded, which allows a better traceability for the delivery of goods.

Microsoft Project Madeira expansion of sales and delivery documents
Source: Microsoft


Adding own article attributes

Inventory articles can now also be labelled with various characteristics. The user can define his own types of attributes (e.g. colour, country of manufacture or size) and add these to the articles in addition to the built-in item characteristics. The inventory can subsequently be filtered using the various attributes. This makes the search for specific articles easier for both the user and the customer.

Linking with Microsoft Dynamics CRM

“Project Madeira“ already contains basic customer relationship management and opportunity management. If the available functions are not enough, it is now possible – supported by a setup guide on the Business Manager homepage – to create a link to the Microsoft Dynamics CRM in order to use its comprehensive features (e.g. in the area of marketing and customer service). This means that data from “Project Madeira” and information from the CRM can be connected seamlessly.

Further innovations

Further additional expansions can be installed via the “Extension Management” webpage. These include the verification and correction of all addresses in “Project Madeira”, as well as a simplified migration of data (e.g. customers, vendors and items) from Opera or Sage to “Project Madeira”.

Microsoft Dynamics 365: Microsoft will bundle ERP and CRM in one cloud service

With Microsoft Dynamics 365, Microsoft has announced a new platform for cloud-based services that will enrich and correlate the current ERP and CRM applications. Furthermore, the future offer is to include new business apps for domains such as finance, marketing, sales, and customer Service.

Microsoft refers to this service as “end-to-end suite for smart cloud-based business”, which will be available from autumn 2016. The user will then be able to use the individual applications as required. In the event of changing requirements or new challenges, the solutions can then be readily expanded by the new services – allowing users to only pay for what they actually need. Pricing details regarding Dynamics 365 are yet to be announced by Microsoft.

Microsoft Dynamics 365
Source: Microsoft

There will be two Dynamics 365 editions – a Business and an Enterprise Edition. The Business Edition Financial will be published this fall in the US and Canada, followed by its release in four European countries and the worldwide availability of the associated sales and marketing module in 2017. The worldwide availability of the Business Edition Financial is planned for 2018. There is no official release date for the also announced Enterprise Edition of the service, yet.

Moreover, the cloud service will natively integrate the two tools “Power BI” and “Cortana Intelligence” in order to support companies in the field of predictive analytics and regarding specific recommended actions based on their data.

Additionally, the integration of Dynamics 365 and Office 365 is intended to increase productivity, especially when working in teams, through the use of structured workflows. In order to facilitate the processes of managing and analysing data, both solutions draw on the same data model. For example, the applications are linked using “PowerApps” or the “Flow” tool already available with Office 365 today.

The perfect app for your business requirements

Via the new AppSource platform already rolled out by Microsoft, the various applications published so far can be viewed. On the one hand, entire industry solutions can be procured, and on the other hand partial solutions which enrich a default solution for specific purposes and corporate requirements. Look for more Details in the following video:

Microsoft AppSource

Up to now, we are not able to provide any comprehensive information on experience of the quality and compatibility of the individual offers. However, we will continue to keep you up to date here. Please feel free to provide your own experience as a comment.

Qlik Releases Qlik Sense 3.0

Qlik Sense 3.0As already announced at this year’s Qonnections in Orlando, BI solutions provider Qlik has now released the new version of its data visualization platform Qlik Sense. Alongside various improvements and bug fixes, Qlik Sense 3.0 offers many new user features.

Qlik Sense Version 3.0 provides the following new functions, among others:

  • New Qlik DataMarket packages
    Qlik Sense 3.0 has new DataMarket sets, including data on the population of India, Canada, and more.
  • Language expansion and choice of reading order
    The Business Intelligence platform is now available in four additional languages: Polish, Turkish, Korean and traditional Chinese. You can also change the reading direction in a Qlik Sense app to “right-to-left”.
  • Visual searching in Smart Search
    Smart Search lets you search through visualizations now. Results are returned in a gallery that lists out those visualizations in which the search terms were found. Clicking in the gallery brings you directly to the desired visualization.
  • Widget expansion for apps
    Qlik Sense apps can now be equipped with a new object type: widgets. Typically, these are customized KPI objects, diagram visualizations, tables and sheet navigation objects. Widgets are kept very simple in design and function, and can be created in the Widget Editor (part of the Dev Hub) without deep knowledge of development.
  • New visual data preparation
    The new visual data preparation lets you graphically integrate and analyse data by drag & drop. The various tables and datasets are displayed as bubbles that can be visually linked and related with one another. No expert knowledge of data modelling is required.
  • Time-aware charts
    Qlik Sense 3.0 lets you add a continuous timescale along the x-axis to a line chart, to provide a complete and accurate view of time-based data. This scale represents an entire period of time (including intervals without data) in a consistent dimension, and allows the user to zoom in to any point.
  • Installing Qlik Connector with Qlik Sense
    Qlik REST Connector 1.1, QlikSalesforce Connector 14.0 and QLIK ODBC Connectors Package 1.1 are now installed with Qlik Sense. This way, data can be loaded especially efficiently into a Qlik Sense app from REST data sources and SalesForce datasets. It has also been made much easier to integrate ODBC data sources.

In addition to all this, the new platform features many bug fixes and technical improvements. Watch the following video to find out more about the above features and discover other new functions.

What's New in Qlik Sense 3.0 Video

Simultaneously to Qlik Sense 3.0, Qlik has also released the new version of its reporting tool Qlik NPrinting 17.1 and the fourth service release for QlikView 12. All three products are already available. Qlik Sense 3.0 and NPrinting 17.1 are also compatible with each other.

QlikView and Qlik Sense – Combined use

QlikView Qlik Sense Combined UseIn the summer of 2014, Swedish business intelligence company Qlik added the new self-service data visualization software Qlik Sense to its product range, which until then had comprised the BI platform QlikView. This release provided users with many new analysis and visualization capabilities, but also made them wonder which of the products was best suited to their company. In fact, QlikView and Qlik Sense can be easily used in parallel.

Before implementing a new Qlik product, however, it should be determined exactly what purposes the platform should serve and whether it might actually make the most sense to use both products combined. Many companies employing QlikView can already meet all daily requirements in terms of information gathering, analysis, evaluation and visualization with this software. But they may still be lacking certain functions that Qlik Sense Enterprise could offer, especially for power users.

The two products have their own strengths that, when combined, complement each other perfectly and can thus fulfill the needs of various user groups in a company. The leading data discovery platform QlikView, for example, is recommendable for developing and implementing detailed managed applications for comprehensive data analysis. The layout and design can be fine-tuned down to the last detail. This makes the software ideal for power users developing analytical environments for expert users.

Qlik Sense, on the other hand, generally offers better options for web development. It can furthermore be employed easily and intuitively by any user as a modern self-service data visualization application for creating and using interactive and intelligent visualizations. The platform’s smart searches and a drag & drop workflow make it especially comfortable to work with. Due to its responsive design, Qlik Sense is also ideal for use on mobile devices. Again, a good reason to be favored by power users, but also an important deciding factor for field staff, for example.

QlikView and Qlik Sense thus complement each another perfectly in terms of what they can be used for. Because they share a common technological basis (QIX engine), the two solutions can be implemented quickly and easily in combined operation – tailored precisely to the respective company’s needs.

Are you interested in a parallel implementation of QlikView and Qlik Sense? Contact us for more Information!

prisma informatik