Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Building ERP Solutions with Microsoft Dynamics NAV
  • Table Of Contents Toc
Building ERP Solutions with Microsoft Dynamics NAV

Building ERP Solutions with Microsoft Dynamics NAV

By : Stefano Demiliani
close
close
Building ERP Solutions with Microsoft Dynamics NAV

Building ERP Solutions with Microsoft Dynamics NAV

By: Stefano Demiliani

Overview of this book

Implementing Microsoft Dynamics NAV in the real world often requires you to integrate the ERP with external applications or solve complex architectural tasks in order to have a final successful project. This book will show you how to extend a Microsoft Dynamics NAV installation to the enterprise world in a practical way. The book starts with an introduction to Microsoft Dynamics NAV architecture and then moves on to advanced topics related to implementing real-world solutions based on NAV and external applications. You will learn how an enterprise distributed architecture with NAV at the core can be implemented. Through a series of real-world cases on every topic and every industry (sales, retail, manufacturing, distribution, healthcare, and so on), you’ll see step by step how to efficiently solve a technical problem. These common problems encountered in a NAV implementation will be solved using the entire technology stack that Microsoft offers. By the end of the book, you will have the knowledge to efficiently solve certain scenarios, you will know which is the best solution architecture to propose to a customer and how to implement it.
Table of Contents (11 chapters)
close
close

Publishing NAV data for Power BI


In order to use NAV data from Power BI, we need to publish it as OData web services (we want to absolutely avoid direct access to SQL Server tables). The best way to work is to use Query objects. This permits you to query the NAV database and retrieve fields from a single table or from multiple tables (by using join clauses):

  1. We can start by using the standard NAV Query object with ID = 102(Item Sales by Customer):

  2. You can directly run the Query object from the NAV Development Environment and see the following result set:

  3. When your Query is ready to be published, you've to access the Microsoft Dynamics NAV RoleTailored Client and create a new entry on the Web Services page by setting the record as described:

    • Object Type: Query

    • Object ID: 102

    • Service Name: Your desired service name, recommended without using spaces (here it is ItemSalesByCustomer)

    • Published: TRUE

    Your record will appear as follows:

  4. When published, NAV gives you the OData URL. You can check...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Building ERP Solutions with Microsoft Dynamics NAV
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon