Book Image

Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

By : Simon Buxton
Book Image

Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

By: Simon Buxton

Overview of this book

Dynamics 365 Finance and Supply Chain Management is Microsoft’s ERP solution, which can be implemented as a cloud or on-premise solution to facilitate better decision-making with the help of contemporary, scalable ERP system tools. This book is updated with the latest features of Dynamics 365 Finance and Supply Chain Management including Chain of Command (CoC), Acceptance Test Libraries (ATL), and Business Events. The book not only features more than 100 tutorials that allow you to create and extend business solutions, but also addresses specific problems and offers solutions with insights into how they work. This cookbook starts by helping you set up a Azure DevOps project and taking you through the different data types and structures used to create tables. You will then gain an understanding of user interfaces, write extensible code, manage data entities, and even model Dynamics 365 ERP for security. As you advance, you’ll learn how to work with various in-built Dynamics frameworks such as SysOperation, SysTest, and Business Events. Finally, you’ll get to grips with automated build management and workflows for better application state management. By the end of this book, you’ll have become proficient in packaging and deploying end-to-end scalable solutions with Microsoft Dynamics 365 Finance and Supply Chain Management.
Table of Contents (17 chapters)

Advanced Data Handling

This chapter focuses on the more advanced elements of data structures and how we interact with them. The topics that will be covered in this chapter should be considered a toolbox that we can call on, should the standard development patterns not be suitable.

Data structures represent physical entities in the SQL Server database, which means they are much harder to change later especially after they contain data. Due to this, we need to make the right design choices during the design phase. Knowing the benefits and drawbacks of using inheritance and date-time effectiveness is important when designing a technical solution.

In this chapter, we will cover the following recipes:

  • Implementing table inheritance
  • Using menu items to create a record for a table that uses inheritance
  • Using date-time effectiveness
  • Creating a view with a query and computed...