Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Programming Microsoft Dynamics NAV

You're reading from Programming Microsoft Dynamics NAV Hone your skills and increase your productivity when programming in Microsoft Dynamics NAV 2017

Product type Paperback

Published in Apr 2017

Publisher Packt

ISBN-13 9781786468192

Length 706 pages

Edition 5th Edition

Languages

C/AL

Tools

Dynamics NAV

Concepts

Enterprise Resource Planning

Authors (3):

Marije Brummel

David Studebaker

Christopher D. Studebaker

View More author details

Table of Contents (18) Chapters

Title Page

Credits

Foreword

About the Authors

About the Reviewer

www.PacktPub.com

Preface

Customer Feedback

Acknowledgments

1. Introduction to NAV 2017 FREE CHAPTER

2. Tables

3. Data Types and Fields

4. Pages - the Interactive Interface

5. Queries and Reports

6. Introduction to C/SIDE and C/AL

7. Intermediate C/AL

8. Advanced NAV Development Tools

9. Successful Conclusions

Chapter 2. Tables

"If you don't know where you are going, you might wind up someplace else." - Yogi Berra

"Successful design is anticipating the anticipations of others." - John Maynard Keynes

The foundation of any system is the data structure definition. In NAV, the building blocks of this foundation are the tables and the individual data fields that the tables contain. Once the functional analysis and process definition has been completed, any new design work must begin with the data structure. For NAV, that means the tables and their contents.

A NAV table includes much more than just the data fields and keys. A NAV table definition also includes data validation rules, processing rules, business rules, and logic to ensure referential integrity. The rules are in the form of properties and C/AL...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

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 $15.99/month. Cancel anytime

Authors (3)

Marije Brummel

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

David 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

Christopher D. Studebaker

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

Other recommended products

Related to this chapter

Programming Microsoft Dynamics 365 Business Central

Programming Microsoft Dynamics 365 Business Central

Programming Microsoft Dynamics 365 Business Central will help you effectively use the development tools that are built into Dynamics Business Central. You will understand the strengths of Microsoft Dynamics 365 Business Central's development tools and how they can be applied to address functional business requirements.

Apr 2019 17h 52m

Microsoft Dynamics NAV Development Quick Start Guide

Microsoft Dynamics NAV Development Quick Start Guide

Microsoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems through customizing business processes.

Extending Microsoft Dynamics NAV 2016 Cookbook

Extending Microsoft Dynamics NAV 2016 Cookbook

Jan 2017 15h 16m

Building ERP Solutions with Microsoft Dynamics NAV

Building ERP Solutions with Microsoft Dynamics NAV

Mar 2017 13h 4m

Microsoft Dynamics NAV 2016 Financial Management

Microsoft Dynamics NAV 2016 Financial Management

Discover how easy it is to manage finance by using Microsoft Dynamics NAV 2016. This book will help you get practical knowledge of cash flow management, currencies, intercompany postings, budgets, and accounting implications in areas such as jobs, services, warehousing, and manufacturing.

Jan 2017 7h 24m

Implementing Microsoft Dynamics 365 Business Central On-Premise

Implementing Microsoft Dynamics 365 Business Central On-Premise

Microsoft Dynamics Business Central is a complete ERP software solution for all kinds of organizations. It is fast to implement and easy to configure and use. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book details new features and functionalities available in Dynamics Business Central and NAV.

Dec 2018 25h 28m

Mastering Microsoft Dynamics NAV 2016

Mastering Microsoft Dynamics NAV 2016

With the latest release, Microsoft has rolled out several new features for developers, administrators, consultants, and users alike, to tailor their implementation to best meet each individual's requirements. This book will help you get a firm understanding of the ins and outs of the latest version of Dynamics NAV.

Mar 2017 15h 0m

Microsoft Dynamics 365 Business Central Cookbook

Microsoft Dynamics 365 Business Central Cookbook

With this comprehensive guide, you will become familiar with the latest Dynamics 365 Business Central which is a complete business application management application. It helps you streamline business processes in your company, connect the company across the individual departments, and enhance customer interactions.

Aug 2019 12h 40m

Dynamics 365 Business Central Development Quick Start Guide

Dynamics 365 Business Central Development Quick Start Guide

Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.

Aug 2018 7h 28m

Mastering Microsoft Dynamics 365 Business Central

Mastering Microsoft Dynamics 365 Business Central

Mastering Microsoft Dynamics 365 Business Central is a comprehensive solution which will help you in managing end-to-end business requirements with its features to connect to your financials, sales, service, and operations to streamline business processes. This book will help you in advancing with developing the solutions for your customers with improved interactions and better decisions.

Dec 2019 25h 40m

Personalised recommendations for you

Based on your interests and search pattern

Designing Information Architecture

Designing Information Architecture

Designing Information Architecture is a concise reference on information architecture for UX professionals working within a variety of business contexts for domains like enterprise IA, cross-channel IA, eCommerce IA, and user-generated IA.

Mar 2025 19h 0m

The Ultimate Studio One Pro 7 Book

The Ultimate Studio One Pro 7 Book

This book shows you how to turn your musical ideas into fully produced songs using Studio One's powerful tools and user-friendly workflow, from installing Studio One to mastering and publishing your songs.

Apr 2025 13h 24m

Learn Blender Simulations the Right Way

Learn Blender Simulations the Right Way

This book teaches how to create realistic simulations such as fire, water, and explosions, waving flags, and more using Blender's built in physics system. You'll create animations and gain a deep understanding of all the simulations Blender offers.

Apr 2025 13h 44m

Mastering Clip Studio Paint

Mastering Clip Studio Paint

For artists struggling with the advanced features in Clip Studio Paint, this guide offers step-by-step tutorials and expert tips to master the range of tools, enhancing creativity and efficiency in digital art creation.

May 2025 14h 56m

RxJS Cookbook for Reactive Programming

RxJS Cookbook for Reactive Programming

This book teaches you to craft reactive UI components and animations; leverage browser web APIs; and optimize performance for blazing-fast apps. You'll see how RxJS unlocks elegant solutions for state management and event-driven systems among others.

Mar 2025 10h 20m