Microsoft Dynamics NAV 2009 Programming Cookbook

Table of Contents

• Preface

• Chapter 1: Strings, Dates, and Other Data Types
  • Introduction
  • Retrieving the system date and time
  • Retrieving the work date
  • Determining the day, month, and year from a given date
  • Converting a value to a formatted string
  • Creating an array
  • Creating an Option variable
  • Converting a string to another data type
  • Manipulating string contents
  • Using date formulas to calculate dates

• Chapter 2: General Development
  • Introduction
  • Repeating code using a loop
  • Displaying a Progress Bar
  • Checking for conditions using an IF statement
  • Using a CASE statement to test multiple conditions
  • Creating a function
  • Passing parameters by reference
  • Referencing dynamic tables and fields
  • Using recursion

• Chapter 3: Working with Tables and Records
  • Introduction
  • Creating a table
  • Adding a key to a table
  • Creating transactions to alter data
  • Validating data
  • Retrieving a single record from the database
  • Using advanced filtering
  • Retrieving data using FIND
  • Adding a FlowField to a table
  • Creating a SumIndex field
  • Marking records for future use
  • Clearing filters, keys, and values
  • Using temporary tables to store data
  • Retrieving data from another company
  • Merging records
  • Writing your own rollback routine

• Chapter 4: Designing Forms
  • Introduction
  • Obtaining input without a form
  • Using the Form Generation Wizard
  • Changing text appearance
  • Preventing editable lookup forms
  • Adding an editable field to a non-editable form
  • Creating a matrix form
  • Creating a wizard-style form
  • Designing a form based on a temporary table
  • Updating a subform from a parent form
  • Updating a parent form from a subform

• Chapter 5: Report Design
  • Introduction
  • Using the Report Generation Wizard
  • Adding custom filters to the request form
  • Setting filters when a report is loaded
  • Creating a report to process data
  • Displaying a check mark on a report
  • Dynamically showing Sections on reports
  • Grouping data to display totals
  • Adding page totals to reports
  • Display page X of Y
  • Using virtual tables to loop through data
  • Adding a watermark to a page

• Chapter 6: Diagnosing Code Problems
  • Introduction
  • Using the debugger
  • Setting breakpoints
  • Using Code Coverage
  • Handling runtime errors
  • Using Client Monitor to diagnose problems
  • Finding errors when using NAS
  • Implementing Try / Catch / Finally

• Chapter 7: Roles and Security
  • Introduction
  • Adding roles through the User Setup table
  • Creating and assigning a security role
  • Using FILTERGROUP to restrict data
  • Checking for user-assigned roles
  • Checking Active Directory groups
  • Using security filters
  • Field-level security
  • Assigning menu suites based on company
  • Ending an idle session
  • Automatically adding users to NAV
  • Hiding values in Zoom

• Chapter 8: Leveraging Microsoft Office
  • Introduction
  • Using the style sheet tool
  • Sending data to Microsoft Word
  • Sending an e-mail from NAV through Outlook
  • Exporting data using the Excel buffer
  • Creating a data connection from Excel to NAV
  • Creating an InfoPath form with NAV data
  • Instant messaging using Office Communicator
  • Creating charts with Visio

• Chapter 9: OS Interaction
  • Introduction
  • Using HYPERLINK to open external files
  • Working with environment variables
  • Using SHELL to run external applications
  • Browsing for a file
  • Browsing for a folder
  • Checking file and folder access permissions
  • Querying the registry
  • Zipping folders and files within NAV

• Chapter 10: Integration
  • Introduction
  • Flat file exchange using dataports
  • Sharing information through XMLports
  • Manually writing to and reading from files
  • Creating a web service
  • Consuming web services
  • Sending data through FTP
  • Printing reports to PDF
  • Creating a custom NAS handler
  • Writing your own automation using C#
  • Using ADO to access outside data

• Chapter 11: Working with SQL Server
  • Introduction
  • Creating a basic SQL query
  • Adding the xp_ stored procedures
  • Understanding SIFT tables
  • Using SQL Profiler
  • Displaying data from a SQL view in NAV
  • Figuring out who is blocking whom
  • Setting up a backup plan
  • Scheduling NAV tasks from SQL Server

• Chapter 12: The RoleTailored Client
  • Introduction
  • Creating a page using the Page Generation Wizard
  • Building a Role Center
  • Changing default filter columns
  • Building the report layout
  • Interactive sorting for reports
  • Displaying a graph on a report
  • Displaying a .NET add-in on a page

• Index

Matt Traxinger

The book is divided into 112 recipes that go from the noddy stuff (like basic building blocks of programming NAV) to pretty advanced topics that require creating .NET controls and automations using Visual Studio

The book achieves its goal, to be a “cookbook” ! It is precise and to the point.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Errata

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.