Microsoft Dynamics NAV 7 Programming Cookbook

Learn to customize, integrate and administer NAV 7 using practical, hands-on recipes
Preview in Mapt
Code Files

Microsoft Dynamics NAV 7 Programming Cookbook

Rakesh Raul

1 customer reviews
Learn to customize, integrate and administer NAV 7 using practical, hands-on recipes

Quick links: > What will you learn?> Table of content> Product reviews

Mapt Subscription
FREE
$29.99/m after trial
eBook
$23.10
RRP $32.99
Save 29%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$23.10
$54.99
$29.99 p/m after trial
RRP $32.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Microsoft Dynamics NAV 7 Programming Cookbook Book Cover
Microsoft Dynamics NAV 7 Programming Cookbook
$ 32.99
$ 23.10
Getting Started with Dynamics NAV 2013 Application Development Book Cover
Getting Started with Dynamics NAV 2013 Application Development
$ 26.99
$ 18.90
Buy 2 for $35.00
Save $24.98
Add to Cart

Book Details

ISBN 139781849689106
Paperback312 pages

Book Description

Microsoft Dynamics NAV 7 is a business management solution that helps simplify and streamline highly specialized business processes. Learning NAV programing in NAV 7 gives you the full inside view of an ERP system.

Microsoft Dynamics NAV 7 Programming Cookbook covers topics that span a wide range of areas such as integrating the NAV system with other software applications including Microsoft Office, and creating reports to present information from multiple areas of the system,. We will not only learn the essentials of NAV programming, you will also be exposed to the technologies that surround NAV including.NET programming, SQL Server and NAV system administration.

Microsoft Dynamics NAV 7 Programming Cookbook is written in a direct, to-the-point style to help you get what you need and continue working in NAV. The first half of the cookbook will help programmers using NAV for the first time, by walking them through the building blocks of writing code and creating objects such as tables, pages, and reports.

The second half focuses on using the technologies surrounding NAV to build better solutions. You will learn how to write .NET code that works with the NAV system and how to integrate the system with other software applications such as Microsoft Office or even custom programs.

You will learn everything you need to know for developing all types of NAV CSIDE objects, as well as how to integrate and maintain a NAV system.

Table of Contents

Chapter 1: String, 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
Using the date formula to calculate dates
Converting a value to a formatted string
Creating an array
Creating an option variable
Converting a string to another data type
Manipulating string contents
Chapter 2: General Development
Introduction
Displaying the progress bar and data in process
Repeating code using a loop
Checking for conditions using an IF statement
Using the CASE statement to test multiple conditions
Rounding decimal values
Creating functions
Passing parameters by reference
Referencing dynamic tables and fields
Using recursion
Chapter 3: Working with Tables, Records, and Queries
Introduction
Creating a table
Adding a key to a table
Retrieving data using the FIND and GET statements
Advanced filtering
Adding a FlowField
Creating a SumIndexField
Retrieving data from FlowField and SumIndexField
Using a temporary table
Retrieving data from other companies
Using a query to extract data
Creating a query to link three tables
Working with queries in C/AL
Chapter 4: Designing Pages
Introduction
Creating a page using a wizard
Using multiple options to run the page
Applying filters on the lookup page
Updating the subform page from a parent page
Creating a FactBox page
Creating a Queue page
Creating a Role Center page
Creating a wizard page
Displaying a .NET add-in on a page
Adding a chart to the page
Chapter 5: Report Design
Introduction
Creating an RDLC report
Using multiple options to run a report
Adding custom filters to the Request Page
Setting filters when report is loaded
Creating reports to process data
Creating a link from report to page
Creating a link from report to report
Adding totals on decimal field
Adding interactive sorting on reports
Creating a matrix report
Chapter 6: Diagnosing Code Problems
Introduction
Using the debugger
Setting breakpoints
Handling runtime errors
Using About This Page and About This Report
Finding errors while using NAS
Chapter 7: Roles and Security
Introduction
Assigning a role to a user
Creating a new role
Using the FILTERGROUP function
Using security filters
Applying security filter modes
Field-level security
Assigning permission to use the About This Page function
Killing a user session
Chapter 8: Leveraging Microsoft Office
Introduction
Sending data to Microsoft Word
Managing stylesheets
Sending an e-mail from NAV through SMTP
Exporting data using the Excel Buffer
Creating data connection from Excel to NAV
Showing data in Excel using PowerPivot
Creating an InfoPath form for the NAV data
Creating charts with Visio
Chapter 9: OS Interaction
Introduction
Using HYPERLINK to open external files
Working with environmental 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
Sharing information through XMLports
Writing to and reading from a file using the C/AL code
Creating web services
Consuming web services
Sending data through FTP
Printing a report in a PDF, Excel, and Word format
Writing your own automation using C#
Using ADO to access outside data
Chapter 11: Working with the SQL Server
Introduction
Creating a basic SQL query
Understanding SIFT
Using the SQL profiler
Displaying data from a SQL view in NAV
Identifying Blocked and Blocking sessions from SQL
Setting up a backup plan
Maintaining the transaction logfiles
Chapter 12: NAV Server Administration
Introduction
Creating a NAV Server Instance
Configuring NAS to run Job Queue
Creating a user on NAV
Changing the NAV license
Creating a new database
Testing the NAV database

What You Will Learn

  • Build tables and perform complex actions on their data
  • Design different types of pages to display and interact with business data
  • Create reports to present information from multiple areas of the system
  • Build solutions that work with the entire Microsoft Office suite of products
  • Learn to work with SQL Server and execute basic queries against the NAV database
  • Diagnose and resolve code problems

Authors

Table of Contents

Chapter 1: String, 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
Using the date formula to calculate dates
Converting a value to a formatted string
Creating an array
Creating an option variable
Converting a string to another data type
Manipulating string contents
Chapter 2: General Development
Introduction
Displaying the progress bar and data in process
Repeating code using a loop
Checking for conditions using an IF statement
Using the CASE statement to test multiple conditions
Rounding decimal values
Creating functions
Passing parameters by reference
Referencing dynamic tables and fields
Using recursion
Chapter 3: Working with Tables, Records, and Queries
Introduction
Creating a table
Adding a key to a table
Retrieving data using the FIND and GET statements
Advanced filtering
Adding a FlowField
Creating a SumIndexField
Retrieving data from FlowField and SumIndexField
Using a temporary table
Retrieving data from other companies
Using a query to extract data
Creating a query to link three tables
Working with queries in C/AL
Chapter 4: Designing Pages
Introduction
Creating a page using a wizard
Using multiple options to run the page
Applying filters on the lookup page
Updating the subform page from a parent page
Creating a FactBox page
Creating a Queue page
Creating a Role Center page
Creating a wizard page
Displaying a .NET add-in on a page
Adding a chart to the page
Chapter 5: Report Design
Introduction
Creating an RDLC report
Using multiple options to run a report
Adding custom filters to the Request Page
Setting filters when report is loaded
Creating reports to process data
Creating a link from report to page
Creating a link from report to report
Adding totals on decimal field
Adding interactive sorting on reports
Creating a matrix report
Chapter 6: Diagnosing Code Problems
Introduction
Using the debugger
Setting breakpoints
Handling runtime errors
Using About This Page and About This Report
Finding errors while using NAS
Chapter 7: Roles and Security
Introduction
Assigning a role to a user
Creating a new role
Using the FILTERGROUP function
Using security filters
Applying security filter modes
Field-level security
Assigning permission to use the About This Page function
Killing a user session
Chapter 8: Leveraging Microsoft Office
Introduction
Sending data to Microsoft Word
Managing stylesheets
Sending an e-mail from NAV through SMTP
Exporting data using the Excel Buffer
Creating data connection from Excel to NAV
Showing data in Excel using PowerPivot
Creating an InfoPath form for the NAV data
Creating charts with Visio
Chapter 9: OS Interaction
Introduction
Using HYPERLINK to open external files
Working with environmental 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
Sharing information through XMLports
Writing to and reading from a file using the C/AL code
Creating web services
Consuming web services
Sending data through FTP
Printing a report in a PDF, Excel, and Word format
Writing your own automation using C#
Using ADO to access outside data
Chapter 11: Working with the SQL Server
Introduction
Creating a basic SQL query
Understanding SIFT
Using the SQL profiler
Displaying data from a SQL view in NAV
Identifying Blocked and Blocking sessions from SQL
Setting up a backup plan
Maintaining the transaction logfiles
Chapter 12: NAV Server Administration
Introduction
Creating a NAV Server Instance
Configuring NAS to run Job Queue
Creating a user on NAV
Changing the NAV license
Creating a new database
Testing the NAV database

Book Details

ISBN 139781849689106
Paperback312 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Getting Started with Dynamics NAV 2013 Application Development Book Cover
Getting Started with Dynamics NAV 2013 Application Development
$ 26.99
$ 18.90
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
Microsoft Dynamics GP 2013 Cookbook Book Cover
Microsoft Dynamics GP 2013 Cookbook
$ 35.99
$ 25.20
Learning Mambo: A Step-by-Step Tutorial to Building Your Website Book Cover
Learning Mambo: A Step-by-Step Tutorial to Building Your Website
$ 26.99
$ 18.90
eZ Publish 4: Enterprise Web Sites Step-by-Step Book Cover
eZ Publish 4: Enterprise Web Sites Step-by-Step
$ 29.99
$ 21.00
ImageMagick Tricks Book Cover
ImageMagick Tricks
$ 20.99
$ 2.10