Book Image

Programming Microsoft Dynamics NAV 2013 - Third Edition

Book Image

Programming Microsoft Dynamics NAV 2013 - Third Edition

Overview of this book

Microsoft Dynamics NAV 2013 is a complete and robust ERP system that is accompanied by a comprehensive set of development tools. You will learn how to master these tools and tailor Microsoft Dynamics NAV 2013 to meet your customer's specific business needs."Programming Microsoft Dynamics® NAV 2013" will lead you from start to finish, teaching you how to use this incredible ERP software whilst simultaneously making you a more productive developer. You'll learn how to implement your solutions, as well as evaluating, managing and appraising Dynamics NAV 2013 productions and projects.You will be empowered with the skills and knowledge that you need to get the job done and exceed your client's expectations. Step by step, you will learn how to use NAV, master the C/AL programming language, as well as the construction and uses of each object type. Ultimately, you will be able to bring your NAV 2013 solution together with fantastic efficiency.Hands-on development examples and additional material teach you by example and uncover the insider knowledge that only years of experience can provide, truly unleashing your productivity and potential.

Related Content you might be interested in

Current Title:

Small book image
Programming Microsoft Dynamics NAV 2013 - Third Edition
Feb, 2013 | 630 pages
No titles found
Table of Contents (19 chapters)
Programming Microsoft Dynamics NAV 2013
Programming Microsoft Dynamics NAV 2013
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
Acknowledgements
Acknowledgements
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
An Introduction to NAV 2013
An Introduction to NAV 2013
NAV 2013 – an ERP system
Significant changes for NAV 2013
A developer's overview of NAV 2013
Developing in NAV 2013 – hands-on
Summary
Review questions
2
Tables
Tables
An overview of tables
Enhancing our sample application
Types of tables
Summary
Review questions
3
Data Types and Fields
Data Types and Fields
Basic definitions
Fields
Data types
FieldClass property options
Filtering
Summary
Review questions
4
Pages – the User's Interactive Interface
Pages – the User's Interactive Interface
Page Design and Structure Overview
Types of pages
Page Designer
Page Components
WDTU Page Enhancement – part 1
Page Controls
WDTU Page Enhancement – part 2
Page Actions
Learning more
Summary
Review questions
5
Queries and Reports
Queries and Reports
Queries
Reports
Report components – overview
Report data flow
Report components – detail
Creating a Report in NAV 2013
Summary
Review questions
6
Introduction to C/SIDE and C/AL
Introduction to C/SIDE and C/AL
Understanding C/SIDE
C/AL syntax
Some simple coding modifications
Finishing the processing code
Summary
Review questions
7
Intermediate C/AL
Intermediate C/AL
Some C/AL development tools
Validation functions
Date and Time functions
Data conversion and formatting functions
FlowField SumIndexField functions
Flow control
Input and Output functions
Filtering
InterObject communication
Enhancing the WDTU application
Summary
Review questions
8
Advanced NAV Development Tools
Advanced NAV Development Tools
NAV process flow
Role Center pages
XMLports
Web services
Summary
Review questions
9
Develop, Debug, Deliver
Develop, Debug, Deliver
Creating new C/AL routines
Multi-language system
Multi-currency system
Navigate
Debugging in NAV 2013
C/SIDE Test-driven development
Other Interfaces
NAV Application Server (NAS)
Client Add-ins
Customizing Help
NAV development projects – some general guidance
Design for efficiency
Updating and upgrading
Supporting material
Summary
Review questions
Answers to Review Questions
Answers to Review Questions
Chapter 1, An Introduction to NAV 2013
Chapter 2, Tables
Chapter 3, Data Types and Fields
Chapter 4, Pages – the User's Interactive Interface
Chapter 5, Queries and Reports
Chapter 6, Introduction to C/SIDE and C/AL
Chapter 7, Intermediate C/AL
Chapter 8, Advanced NAV Development Tools
Chapter 9, Develop, Debug, Deliver
Index
Index

Chapter 2. Tables

 

When done well, software is invisible.

 
 --Bjarne Stroustrup
 

Design and programming are human activities; forget that and all is lost.

 
 --Bjarne Stroustrup

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 overall 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 code.

In this chapter, we will learn about the structure and creation of tables. Details about Fields, the components of tables, will be covered in the following chapter. Our topics in this chapter include:

  • An overview of...

Previous Section
End of Section 1
Next Section