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
- Microsoft Dynamics NAV 7 Programming Cookbook
- Table of Contents
- Microsoft Dynamics NAV 7 Programming Cookbook
- Credits
- About the Author
- About the Reviewers
- Acknowledgements
- www.PacktPub.com
- Preface
- 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
- 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
- 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
- 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
- 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
- 6. Diagnosing Code Problems
- 7. Roles and Security
- 8. Leveraging Microsoft Office
- 9. OS Interaction
- 10. Integration
- 11. Working with the SQL Server
- 12. NAV Server Administration
- Index