Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Programming Microsoft Dynamics 365 Business Central Build customized business applications with the latest tools in Dynamics 365 Business Central

Product type Paperback

Published in Apr 2019

Publisher Packt

ISBN-13 9781789137798

Length 536 pages

Edition 6th Edition

Tools

Dynamics 365

Concepts

Enterprise Resource Planning

Authors (3):

Christopher D. Studebaker

David Studebaker

Marije Brummel

View More author details

Table of Contents (12) Chapters

Preface

1. Introduction to Business Central FREE CHAPTER

2. Tables

3. Data Types and Fields

4. Pages - The Interactive Interface

5. Queries and Reports

6. Introduction to AL

7. Intermediate AL

8. Advanced AL Development Tools

9. Successful Conclusions

10. Assessments

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Relational operators and procedures

The relational operators are listed in the following screenshot. Each of these is used in an expression of the following format:

Expression RelationalOperator Expression

An example is (Variable1 + 97) > ((Variable2 * 14.5) / 57.332). The following operators can be used:

We will spend a little extra time on the IN operator, because this can be very handy and is not documented elsewhere. The term Valueset in the Evaluation column for IN refers to a list of defined values. It would be reasonable to define Valueset as a container of a defined set of individual values, expressions, or other value sets. Some examples of IN, as used in the standard Business Central product code, are as follows:

GLEntry."Posting Date" IN [0D,WORKDATE] 
 
Description[I+2] IN ['0'..'9'] 
 
"Gen. Posting Type" IN ["Gen. Posting Type"::Purchase, "Gen. Posting Type"::Sale] 
 
SearchString IN ['',&apos...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Marije Brummel

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.

See other products by Marije Brummel

Christopher D. Studebaker

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.

See other products by Christopher D. Studebaker

David Studebaker

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.

See other products by David Studebaker