Book Image

Mastering Microsoft Dynamics 365 Business Central

By : Stefano Demiliani, Duilio Tacconi
Book Image

Mastering Microsoft Dynamics 365 Business Central

By: Stefano Demiliani, Duilio Tacconi

Overview of this book

Dynamics 365 Business Central is an all-in-one business management solution, which is easy to adopt and helps you make smarter business decisions. This book is a comprehensive guide to developing solutions with Microsoft ERP (in the cloud and also on-premises). It covers all aspects of developing extensions, right from preparing a sandbox environment to deploying a complete solution. The book starts by introducing you to the Dynamics 365 Business Central platform and the new Modern Development Environment. You'll then explore the sandbox concept, and see how to create sandboxes for development. As you advance, you’ll be able to build a complete advanced solution for Dynamics 365 Business Central with AL language and Visual Studio Code. You'll then learn how to debug and deploy the extension and write automatic testing. The book will also take you through advanced topics like integration (with Azure Functions, web services, and APIs), DevOps and CI/CD techniques, and machine learning. You'll discover how Dynamics 365 Business Central can be used with Office 365 apps. Finally, you'll analyze different ways to move existing solutions to the new development model based on extensions. By the end of this book, you'll be able to develop highly customized solutions that meet the requirements of modern businesses using Dynamics 365 Business Central.
Table of Contents (25 chapters)
Free Chapter
Section 1: Dynamics 365 Business Central - Platform Overview and the Basics of Modern Development
Section 2: Developing Extensions for Dynamics 365 Business Central
Section 3: Debugging, Testing, and Release Management (DevOps)
Section 4: Advanced Integrations with Dynamics 365 Business Central
Section 5: Moving Solutions to the New Extension Model

Handling attachments

Attachments are files that you can link to entities or documents in Dynamics 365 Business Central. Two main tables are used to store attachments:

  • Document attachment (ID = 1173)
  • Attachment (ID = 5062)

To store an attachment in these tables and then download an attachment from these tables, you need to use the previously mentioned UploadIntoStream and DownloadFromStream methods and load the BLOB field by using Streams.

An example of a function that uploads a file to the Attachment table is as follows:

procedure UploadAttachment()
Attachment: Record Attachment;
outStr: OutStream;
inStr: InStream;
tempfilename: text;
FileMgt: Codeunit "File Management";
DialogTitle: Label 'Please select a File...';
if UploadIntoStream(DialogTitle, '', 'All Files (*.*)|*.*&apos...