Microsoft Dynamics NAV 7 Programming Cookbook


Microsoft Dynamics NAV 7 Programming Cookbook
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
$28.04
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
$54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Integrate NAV with external applications, using the C/AL or SQL server
  • Develop .NET code to extend NAV programming possibilities
  • Administer the Microsoft NAV 7 server and database

Book Details

Language : English
Paperback : 312 pages [ 235mm x 191mm ]
Release Date : September 2013
ISBN : 1849689105
ISBN 13 : 9781849689106
Author(s) : Rakesh Raul
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Microsoft Dynamics, Enterprise

Table of Contents

Preface
Chapter 1: String, Dates, and Other Data Types
Chapter 2: General Development
Chapter 3: Working with Tables, Records, and Queries
Chapter 4: Designing Pages
Chapter 5: Report Design
Chapter 6: Diagnosing Code Problems
Chapter 7: Roles and Security
Chapter 8: Leveraging Microsoft Office
Chapter 9: OS Interaction
Chapter 10: Integration
Chapter 11: Working with the SQL Server
Chapter 12: NAV Server Administration
Index
  • 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

                          Rakesh Raul

                          Rakesh Raul is from a small town of India, with a vision of doing something big in programming. He completed his first diploma in Programing at the age of 16, and continued his higher studies in Computer Software Development.

                          He started his programming career with a small software development company in Mumbai. After 2 years of development in Visual Basic he was introduced to Microsoft Dynamics NAV version 3. For the initial 2-3 years he worked as a Microsoft Dynamics NAV developer and at the same time he learned all areas of the product and earned his first Microsoft Certification - Business Solutions Professional. He continues to stay updated with new releases of the product and is certified in multiple areas for versions 4.0, 5.0, 2009, and 2013. Apart from Microsoft Dynamics NAV, he also has a good handle on Microsoft SQL Server and Business Intelligence.

                          His 7 year journey with Microsoft Dynamics NAV includes more than 30 implementations, and one horizontal and two vertical solution designs and development. Currently, Rakesh works in Tectura, India, as Senior Technical Consultant. Tectura is a worldwide provider of business consulting services delivering innovative solution.

                          Sorry, we don't have any reviews for this title yet.

                          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.

                          Sample chapters

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

                          Frequently bought together

                          Microsoft Dynamics NAV 7 Programming Cookbook +    Implementing Microsoft Dynamics NAV 2013 =
                          50% Off
                          the second eBook
                          Price for both: £19.54

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

                          • 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

                          In Detail

                          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.

                          Approach

                          Written in the style of a cookbook. Microsoft Dynamics NAV 7 Programming Cookbook is full of recipes to help you get the job done.

                          Who this book is for

                          If you are a junior / entry-level NAV developer then the first half of the book is designed primarily for you. You may or may not have any experience programming. It focuses on the basics of NAV programming.

                          If you are a mid-level NAV developer, you will find these chapters explain how to think outside of the NAV box when building solutions. There are also recipes that senior developers will find useful.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Resources
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software