Building ERP Solutions with Microsoft Dynamics NAV

Building ERP Solutions with Microsoft Dynamics NAV

by Stefano Demiliani
Released March 2017
Publisher(s): Packt Publishing
ISBN: 9781787123083

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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.

    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

    Product information

    • Title: Building ERP Solutions with Microsoft Dynamics NAV
    • Author(s): Stefano Demiliani
    • Release date: March 2017
    • Publisher(s): Packt Publishing
    • ISBN: 9781787123083