Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Programming Microsoft Dynamics 365 Business Central
  • Table Of Contents Toc
  • Feedback & Rating feedback
Programming Microsoft Dynamics 365 Business Central

Programming Microsoft Dynamics 365 Business Central - Sixth Edition

By : Marije Brummel, David Studebaker, Christopher D. Studebaker
3.4 (5)
Buy this Book
close
close
Programming Microsoft Dynamics 365 Business Central

Programming Microsoft Dynamics 365 Business Central

3.4 (5)
By: Marije Brummel, David Studebaker, Christopher D. Studebaker
Buy this Book

Overview of this book

Microsoft Dynamics 365 Business Central is a full ERP business solution suite with a robust set of development tools to support customization and enhancement. These tools can be used to tailor Business Central's in-built applications to support complete management functions for finance, supply chain, manufacturing, and operations. Using a case study approach, this book will introduce you to Dynamics 365 Business Central and Visual Studio Code development tools to help you become a productive Business Central developer. You'll also learn how to evaluate a product's development capabilities and manage Business Central-based development and implementation. You'll explore application structure, the construction of and uses for each object type, and how it all fits together to build apps that meet special business requirements. By the end of this book, you'll understand how to design and develop high-quality software using the Visual Studio Code development environment, the AL language paired with the improved editor, patterns, and features.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
A brief history of Business Central
Icon
The beginning
Icon
Single-user PC Plus
Icon
Multi-user Navigator
Icon
Navision Financials for Windows
Icon
Growth and mergers
Icon
Continuous enhancement
Icon
AL's roots
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Downloading the example code files
Icon
Downloading the color images
Icon
Conventions used
Icon
Get in touch
Icon
Reviews
Lock Free Chapter
1
Introduction to Business Central
Icon
Introduction to Business Central
Icon
Business Central – an ERP system
Icon
Financial management
Icon
Manufacturing
Icon
Supply chain management
Icon
Business intelligence and reporting
Icon
Relationship management
Icon
Human resource management
Icon
Project management
Icon
A developer's overview of Business Central
Icon
Business Central object types
Icon
The Visual Studio Code integrated development environment
Icon
Visual Studio Code icons
Icon
Explorer
Icon
Search
Icon
Source control
Icon
Debugger
Icon
Extensions
Icon
AL programming language
Icon
Business Central object and system elements
Icon
Business Central functional terminology
Icon
User interface
Icon
Hands-on development in Business Central
Icon
Business Central development exercise scenario
Icon
Getting started with application design
Icon
Folder structure
Icon
launch.json
Icon
app.json
Icon
Symbol files
Icon
Application tables
Icon
Designing a simple table
Icon
Creating a simple table
Icon
Pages
Icon
Standard elements of pages
Icon
List pages
Icon
Card pages
Icon
Document pages
Icon
Journal/worksheet pages
Icon
Creating a list page
Icon
Creating a card page
Icon
Creating some sample data
Icon
Creating a list report
Icon
Generating the layout
Icon
Designing the layout
Icon
Other Business Central object types
Icon
TableExtension and PageExtension
Icon
Codeunits
Icon
Queries
Icon
XMLports
Icon
Control add-ins
Icon
Development backups and documentation
Icon
Summary
Icon
Questions
2
Tables
Icon
Tables
Icon
An overview of tables
Icon
Components of a table
Icon
Naming tables
Icon
Table numbering
Icon
Table properties
Icon
Table triggers
Icon
Keys
Icon
SumIndexFields
Icon
Field groups
Icon
Bricks
Icon
Enhancing our sample application
Icon
Creating and modifying tables
Icon
Assigning a table relation property
Icon
Assigning an InitValue property
Icon
Adding a few activity-tracking tables
Icon
New tables for our WDTU project
Icon
New list pages for our WDTU project
Icon
Keys, SumIndexFields, and table relations in our examples
Icon
Secondary keys and SumIndexFields
Icon
Table relations
Icon
Modifying an original Business Central table
Icon
Types of table
Icon
Fully modifiable tables
Icon
Master data
Icon
Journal
Icon
Template
Icon
Entry tables
Icon
Subsidiary (supplementary) tables
Icon
Register
Icon
Posted document
Icon
Singleton
Icon
Temporary
Icon
Content modifiable tables
Icon
System table
Icon
Read-only tables
Icon
Virtual
Icon
Summary
Icon
Questions
3
Data Types and Fields
Icon
Data Types and Fields
Icon
Basic definitions in Business Central
Icon
Fields
Icon
Field properties
Icon
Field triggers
Icon
Field events
Icon
Data structure examples
Icon
Field numbering
Icon
Field and variable naming
Icon
Data types
Icon
Fundamental data types
Icon
Numeric data
Icon
String data
Icon
Date/Time data
Icon
Complex data types
Icon
Data structure
Icon
Objects
Icon
Web services
Icon
DotNet
Icon
Input/output
Icon
DateFormula
Icon
References and other data types
Icon
Data type usage
Icon
FieldClass property options
Icon
FieldClass – Normal
Icon
FieldClass – FlowField
Icon
FieldClass – FlowFilter
Icon
FlowFields and FlowFilter for our application
Icon
Filtering
Icon
Experimenting with filters
Icon
Accessing filter controls
Icon
Summary
Icon
Questions
4
Pages - The Interactive Interface
chevron up
Icon
Pages - The Interactive Interface
Icon
Page design and structure overview
Icon
Page design guidelines
Icon
Business Central page structure
Icon
Types of pages
Icon
Role Center page
Icon
HeadlinePart page
Icon
List page
Icon
Card page
Icon
Document page
Icon
FastTabs
Icon
List Plus page
Icon
Worksheet (journal) page
Icon
ConfirmationDialog page
Icon
StandardDialog page
Icon
Navigate page
Icon
Navigate function
Icon
Request page
Icon
Page parts
Icon
FactBox area
Icon
Card Parts and List Parts
Icon
Charts
Icon
Page names
Icon
In-client designer
Icon
Designer
Icon
Page components
Icon
Page triggers
Icon
Page properties
Icon
Inheritance
Icon
WDTU page enhancement – part 1
Icon
Page controls
Icon
Control types
Icon
Container controls
Icon
group controls
Icon
Field controls
Icon
Page part controls
Icon
Page control triggers
Icon
Bound and unbound pages
Icon
WDTU page enhancement – part 2
Icon
Page actions
Icon
Page action types and subtypes
Icon
Action groups
Icon
Navigation pane button actions
Icon
Actions summary
Icon
Learning more
Icon
Patterns and creative plagiarism
Icon
Experimenting on your own
Icon
Experimentation
Icon
Summary
Icon
Questions
5
Queries and Reports
Icon
Queries and Reports
Icon
Queries
Icon
Building a simple query
Icon
Query and query component properties
Icon
Query properties
Icon
DataItem properties
Icon
Column properties
Icon
Reports
Icon
What is a report?
Icon
Four Business Central report designers
Icon
Business Central report types
Icon
Report types summarized
Icon
Report naming
Icon
Report components – overview
Icon
Report structure
Icon
Report data overview
Icon
Report layout overview
Icon
Report data flow
Icon
Report components – detail
Icon
Report properties
Icon
Microsoft Word – report properties
Icon
Report triggers
Icon
Request page properties
Icon
Request page triggers
Icon
DataItem properties
Icon
DataItem triggers
Icon
Creating a report in Business Central
Icon
Learn by experimentation
Icon
Report building – phase 1
Icon
Report building – phase 2
Icon
Report building – phase 3
Icon
Modifying an existing report with Report Designer or Word
Icon
Request page
Icon
Adding a request page option
Icon
Processing-only reports
Icon
Creative report plagiarism and patterns
Icon
Summary
Icon
Questions
6
Introduction to AL
Icon
Introduction to AL
Icon
Understanding Visual Studio Code
Icon
Explorer
Icon
Starting a new object
Icon
Object designer navigation
Icon
Some AL naming conventions
Icon
Variables
Icon
AL Globals
Icon
AL Locals
Icon
Special working storage variables
Icon
AL programming
Icon
Non-modifiable procedures
Icon
Modifiable procedures
Icon
Custom procedures
Icon
Creating a procedure
Icon
AL syntax
Icon
Assignment and punctuation
Icon
Expressions
Icon
Operators
Icon
Arithmetic operators and procedures
Icon
Boolean operators
Icon
Relational operators and procedures
Icon
Precedence of operators
Icon
Frequently used AL procedures
Icon
The MESSAGE procedure
Icon
The ERROR procedure
Icon
The CONFIRM procedure
Icon
The STRMENU procedure
Icon
Record procedures
Icon
The SETCURRENTKEY procedure
Icon
The SETRANGE procedure
Icon
The SETFILTER procedure
Icon
The GET procedure
Icon
FIND procedures
Icon
FIND ([Which]) options and the SQL Server alternatives
Icon
Conditional statements
Icon
The BEGIN-END compound statement
Icon
IF-THEN-ELSE statement
Icon
Indenting code
Icon
Some simple coding modifications
Icon
Adding field validation to a table
Icon
Adding code to a report
Icon
Laying out the new Report Heading
Icon
Saving and testing
Icon
Lookup-related table data
Icon
Laying out the new report Body
Icon
Saving and testing
Icon
Handling user entered report options
Icon
Defining the Request Page
Icon
Finishing the processing code
Icon
Testing the completed report
Icon
Summary
Icon
Questions
7
Intermediate AL
Icon
Intermediate AL
Icon
IntelliSense
Icon
Internal documentation
Icon
Source code management
Icon
Validation functions
Icon
TESTFIELD
Icon
FIELDERROR
Icon
INIT
Icon
VALIDATE
Icon
Date and time functions
Icon
TODAY, TIME, and CURRENTDATETIME
Icon
WORKDATE
Icon
DATE2DMY function
Icon
DATE2DWY function
Icon
DMY2DATE and DWY2DATE functions
Icon
CALCDATE
Icon
Data conversion and formatting functions
Icon
ROUND
Icon
FORMAT function
Icon
EVALUATE function
Icon
FlowField and SumIndexField functions
Icon
CALCFIELDS function
Icon
SETAUTOCALCFIELDS function
Icon
CALCSUMS function
Icon
Comparing CALCFIELDS and CALCSUMS
Icon
Flow control functions
Icon
REPEAT-UNTIL
Icon
WHILE-DO
Icon
FOR-TO or FOR-DOWNTO
Icon
CASE-ELSE statement
Icon
WITH-DO statement
Icon
QUIT, BREAK, EXIT, and SKIP functions
Icon
QUIT function
Icon
BREAK function
Icon
EXIT function
Icon
SKIP function
Icon
Input and output functions
Icon
NEXT function with FIND or FINDSET
Icon
INSERT function
Icon
MODIFY function
Icon
Rec and xRec
Icon
DELETE function
Icon
MODIFYALL function
Icon
DELETEALL function
Icon
Filtering
Icon
The SETFILTER function
Icon
The COPYFILTER and COPYFILTERS functions
Icon
The GETFILTER and GETFILTERS functions
Icon
The FILTERGROUP function
Icon
The MARK function
Icon
CLEARMARKS function
Icon
The MARKEDONLY function
Icon
The RESET function
Icon
InterObject communication
Icon
Communicating through data
Icon
Communicating through function parameters
Icon
Communication via object calls
Icon
Enhancing the WDTU application
Icon
Modifying table fields
Icon
Adding validation logic
Icon
Playlist Header validation
Icon
Creating the Playlist subpage
Icon
Playlist Line validations
Icon
Creating a function for our FactBox
Icon
Creating a FactBox page
Icon
Summary
Icon
Questions
8
Advanced AL Development Tools
Icon
Advanced AL Development Tools
Icon
Business Central process flow
Icon
Initial setup and data preparation
Icon
Transaction entry
Icon
Testing and posting the Journal batch
Icon
Utilizing and maintaining the data
Icon
Data maintenance
Icon
Role Center pages
Icon
Role Center structure
Icon
Role Center headlines page
Icon
Role Center activities page
Icon
Cue groups and cues
Icon
System part
Icon
Page parts
Icon
Page parts not visible
Icon
Page parts for user data
Icon
Navigation pane and action menus
Icon
Action Designer
Icon
Creating a WDTU Role Center ribbon
Icon
XMLports
Icon
XMLport components
Icon
XMLport properties
Icon
XMLport triggers
Icon
XMLport data lines
Icon
The XMLport line properties
Icon
SourceType as text
Icon
SourceType as table
Icon
SourceType as field
Icon
Element or attribute
Icon
NodeType element data item
Icon
NodeType attribute data item
Icon
XMLport line triggers
Icon
DataType as text
Icon
DataType as Table
Icon
DataType as Field
Icon
XMLport Request Pages
Icon
Web services
Icon
Exposing a web service
Icon
Publishing a web service
Icon
Enabling web services
Icon
Determining what was published
Icon
XMLport – web services integration example for WDTU
Icon
Summary
Icon
Questions
9
Successful Conclusions
Icon
Successful Conclusions
Icon
Creating new AL routines
Icon
Callable functions
Icon
Codeunit 358 – DateFilterCalc
Icon
Codeunit 359 – Period Form Management
Icon
FindDate function
Icon
NextDate function
Icon
CreatePeriodFormat function
Icon
Codeunit 365 – Format Address
Icon
Codeunit 396 – NoSeriesManagement
Icon
Function models to review and use
Icon
Management codeunits
Icon
Multi-language system
Icon
Multi-currency system
Icon
Navigate
Icon
Modifying for Navigate
Icon
Debugging in Business Central
Icon
Dialog function debugging techniques
Icon
Debugging with MESSAGE and CONFIRM
Icon
Debugging with DIALOG
Icon
Debugging with text output
Icon
Debugging with ERROR
Icon
The Business Central debugger
Icon
Activating the debugger
Icon
Creating break events
Icon
The debugger window
Icon
Visual Studio Code test-driven development
Icon
Other interfaces
Icon
Client Add-ins
Icon
Client Add-in comments
Icon
Business Central development projects – general guidance
Icon
Knowledge is key
Icon
Data-focused design
Icon
Defining the required data views
Icon
Designing the data tables
Icon
Designing the user data access interface
Icon
Designing the data validation
Icon
Data design review and revision
Icon
Designing the Posting processes
Icon
Designing the supporting processes
Icon
Double-check everything
Icon
Designing for efficiency
Icon
Disk I/O
Icon
Locking
Icon
Updating and upgrading
Icon
Design for updating
Icon
Customization project recommendations
Icon
One change at a time
Icon
Testing
Icon
Database testing approaches
Icon
Testing in production
Icon
Using a testing database
Icon
Testing techniques
Icon
Deliverables
Icon
Finishing the project
Icon
Plan for upgrading
Icon
Benefits of upgrading
Icon
Coding considerations
Icon
Low-impact coding
Icon
Supporting material
Icon
Summary
Icon
Questions
10
Assessments
Icon
Chapter 1
Icon
Chapter 2
Icon
Chapter 3
Icon
Chapter 4
Icon
Chapter 5
Icon
Chapter 6
Icon
Chapter 7
Icon
Chapter 8
Icon
Chapter 9
11
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Page components

All pages are made up of certain common components. The basic elements of a page object are the page triggers, page properties, page layout controls with their triggers and properties, and page actions.

In this section, we will first focus on page triggers and properties, and apply our knowledge to update our WDTU Radio Show extension. After that, we will continue with page layout controls, then update the extension once again, and finally look at page actions.

Page triggers

The following screenshot shows page triggers. Note that the OnQueryClosePage trigger isn’t related to any query object action:

Figure 4.25 – Page triggers

Figure 4.25 – Page triggers

Tip

The Microsoft docs do not provide an overview article about page triggers. An easy way of looking up any individual page trigger from Visual Studio Code is to select its name through IntelliSense, then hover over the pasted trigger name and press Get help.

In general, according to...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Programming Microsoft Dynamics 365 Business Central
End of Section 4
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon