O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building ERP Solutions with Microsoft Dynamics NAV

Book Description

Create real-world enterprise solutions with NAV, Cloud, and the Microsoft stack

About This Book

  • Integrate NAV with various offerings of the Microsoft stack to create enterprise-ready and service-oriented solutions
  • Use Power BI and Universal Windows Platform for effective data analysis and real-time tracking with NAV
  • Discover the services offered by Microsoft Azure and implement them in different industries using real-world case scenarios

Who This Book Is For

This book is for NAV developers and solution architects who need to implement real-world enterprise solutions based on Microsoft Dynamics NAV. Knowledge of the NAV programming language (C/AL) and C# language is recommended. Knowledge of ASP.NET and Visual Studio development would help, but is not necessary.

What You Will Learn

  • Configure NAV Web Services and create external applications with Visual Studio, .NET, and .NET Core
  • Solve technical architectural problems by implementing enterprise solutions with NAV
  • Develop applications and solutions with Microsoft Dynamics NAV and the Microsoft technology stack
  • Create a Power BI dashboard for rich reporting and NAV data analysis
  • Find out how to transmit your device location from a UWP application to NAV in order to implement a distributed solution for managing couriers in a sales company
  • Make the most of Microsoft Azure and its services
  • Create enterprise solutions with NAV by using Azure App Service
  • Use Azure Service Bus for managing distributed NAV applications

In Detail

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.

Style and approach

Taking you through a variety of real-world use cases, the book will show you step by step all you need to know to tackle these problems and give you creative ideas to implement in related problems you might come across in the real world.

Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

Table of Contents

  1. Building ERP Solutions with Microsoft Dynamics NAV
    1. Building ERP Solutions with Microsoft Dynamics NAV
    2. Credits
    3. About the Author
    4. About the Reviewer
    5. www.PacktPub.com
      1. Why subscribe?
    6. Customer Feedback
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Downloading the color images of this book
        3. Errata
        4. Piracy
        5. Questions
    8. 1. Introduction to Microsoft Dynamics NAV Architectures
      1. Introducing Microsoft Dynamics NAV
      2. Microsoft Dynamics NAV history
      3. Microsoft Dynamics NAV architecture
      4. Microsoft Dynamics NAV deployments
      5. Differences between NAV deployments
        1. Infrastructure costs
        2. Performance
        3. Growth of solutions
        4. Upgrades
      6. Performance and installation tips
        1. Data tier (SQL Server Database)
        2. Service tier 
          1. Number of Microsoft Dynamics NAV service tiers
          2. Server memory
          3. Server CPU - cores and speed
          4. Data cache size
          5. Metadata provider cache size
          6. Maximum concurrent calls
          7. Maximum concurrent connections
        3. C/AL performance
      7. Summary
    9. 2. Configuring Microsoft Dynamics NAV Web Services
      1. Microsoft Dynamics NAV web service protocols
      2. Microsoft Dynamics NAV web service types
        1. Page web services
        2. Codeunit web services
        3. Query web services
        4. Using filter expressions in an OData URI
        5. NAV web services configuration
        6. SOAP Services tab settings
        7. OData Services tab settings
      3. Publishing NAV web services
        1. Creating and publishing NAV web services
        2. Checking NAV web services
      4. Summary
    10. 3. Creating an Application Using NAV Web Services
      1. Creating the NAV web service
      2. Creating the consumer application
        1. Reading NAV sales orders
        2. Creating a NAV sales order
      3. Testing the application
      4. Using an OData web service
      5. Extending the application for deleting NAV sales order lines
        1. Using the SalesOrder web service (Page 42)
        2. Using the sales order subform web service (Page 46)
      6. Creating a cross-platform application
      7. Tips and tricks
      8. Summary
    11. 4. Using NAV Web Services with Microsoft Power BI
      1. Introducing Microsoft Power BI
      2. Publishing NAV data for Power BI
      3. Loading NAV data on the Power BI desktop
      4. Publishing your NAV dashboard to the Power BI portal
      5. Microsoft Dynamics NAV content pack for Power BI
      6. Summary
    12. 5. Integrating NAV Web Services and External Applications
      1. An overview of the business scenario
      2. Creating NAV business logic
      3. Publishing the NAV objects
      4. Creating the service layer
        1. DALCustomers
        2. DALShipmentAddresses
        3. DALItems
        4. DALPrices
        5. DALOrders
      5. Testing the solution
      6. Solution deployment
      7. Summary
    13. 6. Extending NAV Pages with Control Add-ins
      1. A business case
      2. Control add-in implementation
        1. WinForms control add-in
      3. Universal control add-in
      4. Control add-in deployment
      5. Summary
    14. 7. Programming Universal Windows Apps with NAV and Devices
      1. Business case 1 - handling mobile informations with NAV 
        1. An overview of Universal Windows Platform 
        2. The solution - implementing the NAV business logic
        3. The solution - implementing the integration layer
        4. The solution - implementing the UWP application
      2. Business case 2 - NAV and the Microsoft Band for healthcare
      3. Business case 2 - developing the Band 2 application
      4. Summary
    15. 8. Exploring Microsoft Azure and its Services
      1. The Microsoft Azure platform
      2. Azure Virtual Machines
      3. Azure App Service
      4. Azure Cloud Services
      5. Azure Batch Services
      6. Azure Scheduler
      7. Azure Virtual Network
      8. Azure Active Directory
      9. Azure Storage
      10. Azure Logic Apps
      11. Azure SQL Database
      12. Azure SQL Data Warehouse
      13. Azure Analysis Services
      14. Azure Service Bus
      15. Azure Machine Learning
      16. Azure Internet of Things (IoT) suite
      17. Summary
    16. 9. Working with NAV and Azure App Service
      1. The business scenario
      2. Azure App Service 
      3. Developing the solution
      4. Deployment to Azure App Service
      5. Summary
    17. 10. Implementing a Message-Based Architecture with Azure Service Bus and NAV
      1. The business scenario
      2. An overview of the Azure Service Bus 
        1. Queues
        2. Topics
        3. Relays
      3. Developing the solution
        1. Configuring Azure Service Bus
        2. Publishing NAV business logic for sales orders
        3. Creating a Visual Studio solution for transmitting and receiving orders
      4. Testing the application
      5. Summary