Programming Microsoft Dynamics 365 Business Central : Build Powerful, Robust, and Scalable Extensions Customized for Your Business Requirements / Marije Brummel [and three others].

Format:

Book

Author/Creator:

Brummel, Marije, author.

Language:

English

Subjects (All):

Microsoft Dynamics AX.

Management information systems.

Enterprise resource planning.

Business--Data processing.

Business.

Physical Description:

1 online resource (466 pages)

Edition:

Seventh edition.

Place of Publication:

Birmingham, England : Packt Publishing Ltd., [2024]

System Details:

Mode of access: World Wide Web.

Biography/History:

Brummel Marije: Marije Brummel is a coach, author, programmer, consultant, project manager, presenter, evangelist, and a trainer. Marije has received the Microsoft MVP and the NAVUG All-Star awards, among several other awards. She has chaired the Microsoft Dynamics Credentialing committee and has authored official Microsoft Exam materials. She's the go-to girl for performance troubleshooting and upgrade challenges. One of her biggest achievements was introducing Design Patterns into the Business Central community. Her books, blog articles, and YouTube videos have influenced almost everyone involved with Business Central. She is a mother of five, enjoys the outdoors with her dog and loves spending time with her family. Karolak Natalie: Natalie Karolak works at COSMO CONSULT, a leading European provider of industry-specific business software and end-to-end IT solutions. As a product architect, she develops and maintains Business Central apps for Microsoft AppSource. Programming for NAV/BC partners since 2006, Natalie has always been passionate about knowledge gain and knowledge sharing. For her commitment to the German-speaking online community, she was presented with the MVP award from 2012 and 2016. She regained the award in 2024. Today, she shares English-speaking news and information for AL programmers on X, and on her blog that is named after the title that the community gave her: The BC Docs Librarian. Studebaker Christopher D. : Chris Studebaker was a certified environmental consultant working with manufacturing facilities to meet national and state regulations before he started working with Business Central (then known as Navision) in 1999. After working on regulatory reporting, data analysis, project management, and subcontractor oversight, Chris has used those skills to sell, develop, and implement Business Central for more than 25 years. He has specialized in retail, manufacturing, job shop, and distribution implementations, mostly in high-user-count, high-data-volume applications. Chris serves as a technical consultant and trainer for customers and fellow Business Central professionals. He has a Bachelor of Science degree from Northern Illinois University and has done graduate work at Denmark Technical University. Studebaker David: David Studebaker has been designing and developing software since 1962 as a developer, consultant, manager, and business owner. In 1967, David co-authored the first general-purpose SPOOL system, an AT&T/IBM joint project. He has been a founding partner in several firms, most recently Studebaker Technology and Liberty Grove Software. David's publications include a decade of technical reviews for ACM Computing Reviews and a number of articles on shop floor data collection. David originated the Packt series of books on programming Microsoft Dynamics Business Central (aka Dynamics NAV). He holds a BS in mechanical engineering from Purdue University and an MBA from the University of Chicago. He is a life member of the Association for Computing Machinery.

Summary:

Business Central opens a world of endless possibilities for custom business logic and functionality through extensions and customizations. For beginners in the AL language, navigating the vast landscape can feel overwhelming. It’s challenging to know where to start and what’s essential to learn. This updated edition offers a concise and well-organized guide, featuring hands-on exercises to support a successful learning journey. You’ll get to grips with the basics of Business Central and how to create your first Visual Studio Code project with the AL language. As you learn about the table data structure, simple and complex data types, relationships, validation, and data flow, you’ll be able to add and extend tables to your project. Progressively, you'll uncover the intricacies of user interfaces with pages, create advanced Excel report layouts, and harness the power of data queries. Immersing yourself in the AL language syntax, you’ll start with variables, methods, procedures, and statements. You'll explore advanced topics to create business logic such as FlowFields, filtering, CRUD methods, interactions between object types, and different API interfaces that can be created using the AL language. By the end of this book, you’ll be equipped to build fully featured, robust extensions and custom capabilities for Business Central.

Contents:

Cover

Title page

Copyright and credits

Contributors

Table of Contents

Preface

Chapter 1: Introduction to Business Central

Technical requirements

Business Central - an ERP system

Financial management

Manufacturing

Supply chain management

Business intelligence and reporting

Relationship management

Human resource management

Project management

A developer's overview of Business Central

Business Central applications

Business Central object types

The Visual Studio Code integrated development environment

Visual Studio Code icons

AL programming language

Business Central object elements

Business Central functional terminology

UI

Hands-on development in Business Central

Business Central development exercise scenario

Getting started with application design

Folder structure

Symbol files

Application tables

Pages

Creating a list page

Creating a card page

Creating some sample data

Creating a list report

Other Business Central object types

Extension data types

Codeunits

Queries

XMLports

Development backups and documentation

Summary

Questions

Chapter 2: Tables

An overview of tables

Components of a table

Naming tables

Table numbering

Table properties

Table triggers

Keys

SumIndexFields

Nonclustered Columnstore Indexes

Field groups

Temporary tables

Enhancing our sample application

Creating and modifying tables

Assigning a table relation property

Assigning an InitValue property

Adding a few activity-tracking tables

New tables for our WDTU project

New list pages for our WDTU project

Keys, SumIndexFields, and table relations in our examples

Extending an original Business Central table

Functional table types

Extensible tables

Non-extensible tables

Questions.

Chapter 3: Data Types and Table Fields

Basic definitions

Table fields

Field definition

Field properties

Field triggers

Field events

Data structure examples

Data types

Simple data types

Complex data types

Data type usage

FieldClass property options

FieldClass - Normal

FieldClass - FlowField

FieldClass - FlowFilter

FlowField and FlowFilter properties for our application

Filtering

Experimenting with filters

Accessing filter controls

Chapter 4: Pages - The Interactive Interface

Page design and structure overview

Business Central page structure

Types of pages

Document page type

ListPlus page type

Worksheet page type

ConfirmationDialog page

StandardDialog page

NavigatePage page type

Request page

Page parts

Power BI

Bound and unbound pages

Page names

Page components

Page triggers

Page properties

WDTU page enhancement - part 1

Page layout

Layout area section

Grouping controls

Layout example

WDTU page enhancement - part 2

Page actions

Action area section

Action group control

action control

Actions summary

Page searchability

UsageCategory property

ApplicationArea property

Advanced content

Client tools for page development

Page inspection

Designer

Learning more

Patterns and creative plagiarism

Experimenting on your own

Experimentation

Chapter 5: Reports and Queries

Reports

What is a report?

Five Business Central report designers

Business Central report types

Report components - overview

Report structure

Report data flow

Report components - detail

Report properties

Report triggers

Request page properties

Request page triggers

Dataset analysis

Rendering layout

DataItem properties.

DataItem triggers

Creating a report in Business Central

Learn by experimentation

Report building - phase 1

Report building - phase 2

Report building - phase 3

Extending an existing report with SQL Report Builder or Microsoft Office

Processing-only reports

Creative report plagiarism and patterns

Building a simple query

Query and query component properties

Chapter 6: Introduction to AL

Understanding Visual Studio Code

Explorer

AL programming

AL naming conventions

Variables

Methods and procedures

AL syntax

Assignment and punctuation

Expressions

Frequently used AL methods

Conditional statements

Indenting code

Some simple coding modifications

Adding field validation to a table

Adding code to a report

Handling user-entered report options

Defining the request page

Testing the completed report

Chapter 7: Intermediate AL

Validation methods

TestField method

FieldError method

Init method

Validate method

Date and time methods

Today, Time, and CurrentDateTime methods

WorkDate method

Date2DMY method

Date2DWY method

DMY2Date and DWY2Date methods

CalcDate method

Data conversion and formatting methods

Round method

Format method

Evaluate method

FlowField and SumIndexField methods

CalcFields method

SetAutoCalcFields method

CalcSums method

AL control statements

repeat-until

while-do

for-to or for-downto

case-else statement

Flow control methods

CRUD record methods

Next method

Insert method

Modify method

Delete method

ModifyAll method

DeleteAll method

Filtering methods

CopyFilter and CopyFilters methods

GetFilter and GetFilters methods

FilterGroup method

Mark method

ClearMarks method.

MarkedOnly method

Reset method

Inter-object communication

Communicating through data

Communicating through procedure parameters

Communication via object calls

Enhancing the WDTU application

Modifying table fields

Creating the Playlist document page

Creating the Playlist subpage

Creating a procedure for our FactBox

Creating a FactBox page

Multi-language system

Translations in AL

Debugging in AL

Breakpoints

Running the AL debugger

Attach and debug next

Snapshot debugging and performance profiling

Troubleshoot directly from the web client

Chapter 8: Extensibility beyond AL

Business Central web services (SOAP/OData)

Authentication

SOAP page

SOAP codeunits

XMLport components

SOAP XMLport through WDTU codeunit

Publishing a web service

Executing web services externally

RESTful calls

OData page

API objects in AL

API pages for WDTU playlist

API query for WDTU listenership

Consuming external API

WDTU Tidal integration

WDTU API codeunit

Adding the new WDTU action

Business Central process flow

Initial setup and data preparation

Transaction entry

Testing and posting the Journal batch

Index

Other Books You May Enjoy.

Notes:

Includes index.

Includes bibliographical references and index.

Description based on publisher supplied metadata and other sources.

Description based on print version record.

ISBN:

9781803242149

1803242140

OCLC:

1468099324