You are previewing Microsoft Dynamics NAV 7 Programming Cookbook.
O'Reilly logo
Microsoft Dynamics NAV 7 Programming Cookbook

Book Description

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

  • 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

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.

Table of Contents

  1. Microsoft Dynamics NAV 7 Programming Cookbook
    1. Table of Contents
    2. Microsoft Dynamics NAV 7 Programming Cookbook
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. Acknowledgements
    7. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    8. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    9. 1. String, Dates, and Other Data Types
      1. Introduction
      2. Retrieving the system date and time
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Retrieving the work date
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      4. Determining the day, month, and year from a given date
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Using the date formula to calculate dates
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Converting a value to a formatted string
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Creating an array
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      8. Creating an option variable
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      9. Converting a string to another data type
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      10. Manipulating string contents
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
    10. 2. General Development
      1. Introduction
      2. Displaying the progress bar and data in process
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Repeating code using a loop
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Using a WHILE loop
          2. Using a REPEAT..UNTIL loop
        4. See also
      4. Checking for conditions using an IF statement
        1. How to do it...
        2. How it works...
        3. There's more...
          1. The nested IF statement
        4. See also
      5. Using the CASE statement to test multiple conditions
        1. How to do it...
        2. How it works...
        3. See also
      6. Rounding decimal values
        1. How to do it...
        2. How it works...
        3. See also
      7. Creating functions
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Creating local or private functions
        4. See also
      8. Passing parameters by reference
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      9. Referencing dynamic tables and fields
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      10. Using recursion
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
    11. 3. Working with Tables, Records, and Queries
      1. Introduction
      2. Creating a table
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Adding a key to a table
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      4. Retrieving data using the FIND and GET statements
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Advanced filtering
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Adding a FlowField
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Creating a SumIndexField
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      8. Retrieving data from FlowField and SumIndexField
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      9. Using a temporary table
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Storing records to be processed
        4. See also
      10. Retrieving data from other companies
        1. Getting ready…
        2. How to do it...
        3. How it works...
        4. See also
      11. Using a query to extract data
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      12. Creating a query to link three tables
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Left outer join
          2. Inner join
          3. Right outer join
          4. Full outer join
          5. Cross join
        4. See also
      13. Working with queries in C/AL
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
    12. 4. Designing Pages
      1. Introduction
      2. Creating a page using a wizard
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Using multiple options to run the page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      4. Applying filters on the lookup page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Updating the subform page from a parent page
        1. How to do it...
        2. How it works...
        3. See also
      6. Creating a FactBox page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Creating a Queue page
        1. How to do it...
        2. How it works...
        3. See also
      8. Creating a Role Center page
        1. How to do it...
        2. How it works...
        3. See also
      9. Creating a wizard page
        1. How to do it...
        2. How it works...
        3. See also
      10. Displaying a .NET add-in on a page
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      11. Adding a chart to the page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
    13. 5. Report Design
      1. Introduction
      2. Creating an RDLC report
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Using multiple options to run a report
        1. How to do it...
        2. How it works...
        3. See also
      4. Adding custom filters to the Request Page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Setting filters when report is loaded
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Creating reports to process data
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Creating a link from report to page
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      8. Creating a link from report to report
        1. How to do it...
        2. How it works...
        3. See also
      9. Adding totals on decimal field
        1. How to do it...
        2. How it works...
        3. See also
      10. Adding interactive sorting on reports
        1. How to do it...
        2. How it works...
        3. See also
      11. Creating a matrix report
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Exporting an RDLC report from viewer
          2. Exporting an RDLC report from C/AL code
        4. See also
    14. 6. Diagnosing Code Problems
      1. Introduction
      2. Using the debugger
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Setting breakpoints
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Breakpoint options in the debugger
        4. See also
      4. Handling runtime errors
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Using About This Page and About This Report
        1. How to do it...
          1. About This Page
          2. About This Report
        2. How it works...
        3. There's more...
          1. How to get the subform information
        4. See also
      6. Finding errors while using NAS
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
    15. 7. Roles and Security
      1. Introduction
      2. Assigning a role to a user
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Creating a new role
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      4. Using the FILTERGROUP function
        1. How to do it...
        2. How it works...
        3. See also
      5. Using security filters
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Applying security filter modes
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Field-level security
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      8. Assigning permission to use the About This Page function
        1. How to do it...
        2. How it works...
        3. There's more...
          1. About This Page for subform page
          2. About This Page for report
        4. See also
      9. Killing a user session
        1. How to do it…
        2. How it works...
        3. See also
    16. 8. Leveraging Microsoft Office
      1. Introduction
      2. Sending data to Microsoft Word
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      3. Managing stylesheets
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Sending an e-mail from NAV through SMTP
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Sending an HTML-formatted e-mail
      5. Exporting data using the Excel Buffer
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      6. Creating data connection from Excel to NAV
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      7. Showing data in Excel using PowerPivot
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      8. Creating an InfoPath form for the NAV data
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      9. Creating charts with Visio
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
    17. 9. OS Interaction
      1. Introduction
      2. Using HYPERLINK to open external files
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Working with environmental variables
        1. How to do it...
        2. How it works...
        3. See also
      4. Using SHELL to run external applications
        1. How to do it...
        2. How it works...
        3. See also
      5. Browsing for a file
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Browsing for a folder
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Checking file and folder access permissions
        1. How to do it...
        2. How it works...
        3. See also
      8. Querying the registry
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      9. Zipping folders and files within NAV
        1. How to do it...
        2. How it works...
    18. 10. Integration
      1. Introduction
      2. Sharing information through XMLports
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Exporting Sales Invoices in the CSV format
        4. See also
      3. Writing to and reading from a file using the C/AL code
        1. How to do it...
        2. How it works...
        3. See also
      4. Creating web services
        1. How to do it...
        2. How it works...
        3. See also
      5. Consuming web services
        1. How to do it...
        2. How it works...
        3. See also
      6. Sending data through FTP
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      7. Printing a report in a PDF, Excel, and Word format
        1. How to do it...
        2. How it works...
        3. See also
      8. Writing your own automation using C#
        1. How to do it...
        2. How it works...
        3. See also
      9. Using ADO to access outside data
        1. How to do it...
        2. How it works...
    19. 11. Working with the SQL Server
      1. Introduction
      2. Creating a basic SQL query
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      3. Understanding SIFT
        1. How to do it...
        2. How it works...
        3. See also
      4. Using the SQL profiler
        1. How to do it...
        2. How it works...
        3. See also
      5. Displaying data from a SQL view in NAV
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Identifying Blocked and Blocking sessions from SQL
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Setting up a backup plan
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      8. Maintaining the transaction logfiles
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    20. 12. NAV Server Administration
      1. Introduction
      2. Creating a NAV Server Instance
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Using Microsoft Dynamics NAV Administration Shell
        4. See also
      3. Configuring NAS to run Job Queue
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      4. Creating a user on NAV
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      5. Changing the NAV license
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      6. Creating a new database
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
      7. Testing the NAV database
        1. How to do it...
        2. How it works...
        3. See also
    21. Index