E-book details

Programming Microsoft Dynamics NAV 2013. Experienced programmers and developers will find this the definitive guide to programming Microsoft Dynamics NAV. Both a reference book and a comprehensive hands-on tutorial, it will expand your knowledge dynamically. - Third Edition

Programming Microsoft Dynamics NAV 2013. Experienced programmers and developers will find this the definitive guide to programming Microsoft Dynamics NAV. Both a reference book and a comprehensive hands-on tutorial, it will expand your knowledge dynamically. - Third Edition

Christopher D. Studebaker, David Studebaker, CHRISTOPHER D. STUDEBAKER, David A. Studebaker, David A. Studebaker

Ebook
Microsoft Dynamics NAV 2013 is a complete and robust ERP system that is accompanied by a comprehensive set of development tools. You will learn how to master these tools and tailor Microsoft Dynamics NAV 2013 to meet your customer's specific business needs.Programming Microsoft Dynamics® NAV 2013 will lead you from start to finish, teaching you how to use this incredible ERP software whilst simultaneously making you a more productive developer. You'll learn how to implement your solutions, as well as evaluating, managing and appraising Dynamics NAV 2013 productions and projects.You will be empowered with the skills and knowledge that you need to get the job done and exceed your client's expectations. Step by step, you will learn how to use NAV, master the C/AL programming language, as well as the construction and uses of each object type. Ultimately, you will be able to bring your NAV 2013 solution together with fantastic efficiency.Hands-on development examples and additional material teach you by example and uncover the insider knowledge that only years of experience can provide, truly unleashing your productivity and potential.
  • Programming Microsoft Dynamics NAV 2013
    • Table of Contents
    • Programming Microsoft Dynamics NAV 2013
    • Credits
    • Foreword
    • About the Authors
    • Acknowledgements
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
        • Instant Updates on New Packt Books
    • Preface
      • A Business history timeline
        • The beginning
        • Single user PC Plus
        • Multiuser Navigator
        • Navision financials for Windows
        • Growth and mergers
        • Continuous enhancement
        • C/ALs roots
      • What you should know
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code
        • Errata
        • Piracy
        • Questions
    • 1. An Introduction to NAV 2013
      • NAV 2013 an ERP system
        • Financial Management
        • Manufacturing
        • Supply Chain Management (SCM)
        • Business Intelligence and reporting (BI)
        • Relationship Management (RM)
        • Human Resource management (HR)
        • Project Management
      • Significant changes for NAV 2013
        • Application changes
        • Client enhancements
        • Development tools
        • Other areas
      • A developer's overview of NAV 2013
        • NAV object types
        • C/SIDE
        • Object Designer tool icons
        • C/AL programming language
        • NAV object and system elements
        • NAV functional terminology
        • User Interface
      • Developing in NAV 2013 hands-on
        • Our scenario for development exercises
        • Getting started with the application design
        • Application tables
          • Designing a simple table
          • Creating a simple table
        • Pages
          • List pages
          • Card pages
          • Document pages
          • Journal/Worksheet pages
            • Standard elements of pages
        • Creating a List page
        • Creating a Card page
        • Creating some sample data
        • Creating a List Report
          • Much more to come
        • Other NAV object types
          • Codeunits
          • Queries
          • MenuSuites
          • XMLports
        • Backups and documentation
      • Summary
      • Review questions
    • 2. Tables
      • An overview of tables
        • Components of a table
        • Naming a table
        • Table numbering
        • Table properties
        • Table triggers
        • Keys
        • SumIndexFields
        • Field Groups
      • Enhancing our sample application
        • Creating and modifying tables
        • Assigning a Table Relation property
        • Assigning an InitValue property
        • Adding a few activity-tracking tables
        • New tables for our WDTU project
        • New list pages for our WDTU project
        • Keys, SumIndexFields, and table relations in our examples
          • Secondary keys and SumIndexFields
          • Table relations
        • Modifying a standard table
        • Version list documentation
      • Types of tables
        • Fully Modifiable tables
          • Master
          • Journal
          • Template
          • Ledger
          • Reference tables
          • Register
          • Posted Document
          • Setup
          • Temporary
        • Content Modifiable tables
          • System
        • Read-only tables
          • Virtual
      • Summary
      • Review questions
    • 3. Data Types and Fields
      • Basic definitions
      • Fields
        • Field properties
        • Field triggers
        • Data structure examples
        • Field numbering
        • Field and Variable naming
      • Data types
        • Fundamental data types
          • Numeric data
          • String data
          • Date/Time data
        • Complex data types
          • Data structure
          • Objects
          • Automation
          • Input/Output
          • DateFormula
          • References and other data types
        • Data type usage
      • FieldClass property options
        • FieldClass Normal
        • FieldClass FlowField
        • FieldClass FlowFilter
        • FlowFields and a FlowFilter for our application
      • Filtering
        • Experimenting with filters
        • Accessing filter controls
          • Development Environment filter access
          • Role Tailored Client filter access
      • Summary
      • Review questions
    • 4. Pages the User's Interactive Interface
      • Page Design and Structure Overview
        • Page Design Guidelines
        • NAV 2013 Page structure
      • Types of pages
        • Role Center page
        • List page
        • Card page
        • Document page
          • FastTab
        • ListPlus page
        • Worksheet (Journal) page
        • ConfirmationDialog page
        • StandardDialog page
        • NavigatePage
        • Special pages
          • Request page
          • Departments page
        • Page parts
          • FactBox Area
            • CardParts and ListParts
          • Charts
            • Chart part
            • Chart Control Add-in
        • Page names
      • Page Designer
        • New Page Wizard
      • Page Components
        • Page Triggers
        • Page properties
        • Page Preview tool
        • Inheritance
      • WDTU Page Enhancement part 1
      • Page Controls
        • Control Types
          • Container controls
          • Group controls
          • Field controls
        • Page Part controls
          • Page Control triggers
        • Bound and Unbound Pages
      • WDTU Page Enhancement part 2
      • Page Actions
        • Page Action Types and Subtypes
        • Action Groups
        • Action Properties
        • Navigation Pane Button actions
        • Actions Summary
      • Learning more
        • UX (User Experience) Guidelines
        • Creative plagiarism
        • Experimenting on your own
        • Experimentation
      • Summary
      • Review questions
    • 5. Queries and Reports
      • Queries
        • Building a simple Query
        • Query and Query component properties
          • Query properties
          • The DataItem properties
          • Column properties
          • Filter properties
      • Reports
        • What is a report?
        • Two NAV report designers
        • NAV report types
          • Report types summarized
          • Report naming
      • Report components overview
        • Report structure
          • Report data overview
          • Report Layout overview
      • Report data flow
      • Report components detail
        • C/SIDE Report properties
        • Visual Studio Report properties
        • Report triggers
        • Request Page properties
        • Request Page triggers
        • Data item properties
        • Data Item triggers
      • Creating a Report in NAV 2013
        • Learn by experimentation
        • Report building phase 1
        • Report building phase 2
        • Report building phase 3
          • Modifying an existing report
          • Runtime rendering
          • Inheritance
        • Interactive report capabilities
          • Interactive sorting
          • Interactive visible/not visible
        • Request Page
          • Add a Request Page option
        • Processing-Only reports
        • Creative report plagiarism
      • Summary
      • Review questions
    • 6. Introduction to C/SIDE and C/AL
      • Understanding C/SIDE
        • Object Designer
          • Starting a new object
            • Accessing the Table Designer
            • Accessing the Page Designer
            • Accessing the Report Dataset Designer
            • Accessing the Codeunit Designer
          • Query Designer
          • XMLport Designer
          • MenuSuite Designer
          • Object Designer navigation
            • Exporting objects
            • Importing objects
        • Text objects
          • Some useful practices
            • Changing data definitions
            • Saving and compiling
          • Some C/AL naming conventions
          • Variables
            • C/AL Globals
            • C/AL Locals
              • Function local identifiers
              • Other local identifiers
            • Special working storage variables
              • Temporary tables
              • Arrays
              • Initialization
              • System-defined variables
        • C/SIDE programming
          • Non-modifiable functions
          • Modifiable functions
          • Custom functions
            • Creating a function
      • C/AL syntax
        • Assignment and punctuation
        • Expressions
          • Operators
            • Arithmetic operators and functions
            • Boolean operators
            • Relational operators and functions
            • Precedence of operators
        • Frequently used C/AL functions
          • The MESSAGE function
          • The ERROR function
          • The CONFIRM function
          • The STRMENU function
          • Record functions
            • The SETCURRENTKEY function
            • The SETRANGE function
          • The SETFILTER function
          • The GET function
          • FIND functions
            • FIND ([Which]) options and the SQL Server alternates
        • Conditional statements
          • The BEGINEND compound statement
          • The IFTHENELSE statement
        • Indenting code
      • Some simple coding modifications
        • Adding field validation to a table
        • Adding code to a report
        • Layout the new report heading
        • Save and test
        • Lookup Related table data
        • Layout the new report body
          • Save and test
          • Handling user-entered selection criteria
          • Defining the Request Page
      • Finishing the processing code
        • Test the completed report
        • Output to Excel
      • Summary
      • Review questions
    • 7. Intermediate C/AL
      • Some C/AL development tools
        • C/AL Symbol Menu
        • Internal documentation
      • Validation functions
        • TESTFIELD
        • FIELDERROR
        • INIT
        • VALIDATE
      • Date and Time functions
        • TODAY, TIME, and CURRENTDATETIME functions
        • WORKDATE function
        • DATE2DMY function
        • DATE2DWY function
        • DMY2DATE and DWY2DATE functions
        • CALCDATE function
      • Data conversion and formatting functions
        • ROUND
        • FORMAT function
        • EVALUATE function
      • FlowField SumIndexField functions
        • CALCFIELDS function
        • SETAUTOCALCFIELDS function
        • CALCSUMS function
          • CALCFIELDS and CALCSUMS comparison
      • Flow control
        • REPEAT-UNTIL
        • WHILE-DO
        • FOR-TO or FOR-DOWNTO
        • CASE-ELSE statement
        • WITH-DO statement
        • QUIT, BREAK, EXIT, and SKIP functions
          • QUIT function
          • BREAK function
          • EXIT function
          • SKIP function
      • Input and Output functions
        • NEXT function with FIND or FINDSET
        • INSERT function
        • MODIFY function
          • Rec and xRec
        • DELETE function
        • MODIFYALL function
        • DELETEALL function
      • Filtering
        • SETFILTER function
        • COPYFILTER and COPYFILTERS functions
        • GETFILTER and GETFILTERS functions
        • FILTERGROUP function
        • MARK function
        • CLEARMARKS function
        • MARKEDONLY function
        • RESET function
      • InterObject communication
        • Communication via data
        • Communication through function parameters
        • Communication via object calls
      • Enhancing the WDTU application
        • Modifying table fields
        • Adding validation logic
          • Playlist Header Validations
        • Creating the Playlist Subform page
          • Playlist Line validations
        • Creating a function
        • Creating a FactBox page
      • Summary
      • Review questions
    • 8. Advanced NAV Development Tools
      • NAV process flow
        • Initial setup and data preparation
        • Transaction entry
        • Testing and posting the Journal Batch
        • Utilizing and maintaining the data
        • Data maintenance
      • Role Center pages
        • Role Center structure
          • Role Center activities page
          • Cue Groups and Cues
          • Cue source table
          • Cue Group Actions
        • System Part
        • Page Parts
          • Page Parts not visible
          • Page Part Charts
          • Page Parts for user data
        • Navigation Pane and Action Menus
          • Action Designer
          • Creating a WDTU Role Center Ribbon
            • Promoted Actions Categories
            • Action Groups
            • Configuration/Personalization
          • Navigation Pane
            • Navigation Home Button
            • Navigation Departments Button
            • Other Navigation Buttons
      • XMLports
        • XMLport components
          • XMLport properties
          • XMLport triggers
          • XMLport data lines
          • XMLport line properties
            • SourceType as Text
            • SourceType as Table
            • SourceType as Field
          • Element or Attribute
            • NodeType of Element
            • NodeType of Attribute
          • XMLport line triggers
            • DataType as Text
            • DataType as Table
            • DataType as Field
          • XMLport Request Page
      • Web services
        • Exposing a web service
        • Publishing a web service
        • Determining what was published
        • XMLport web services integration example
      • Summary
      • Review questions
    • 9. Develop, Debug, Deliver
      • Creating new C/AL routines
        • Callable functions
          • Codeunit 358 Date Filter-Calc
          • Codeunit 359 Period Form Management
          • Codeunit 365 Format Address
          • Codeunit 396 NoSeriesManagement
          • Function models to review and use
        • Management codeunits
      • Multi-language system
      • Multi-currency system
      • Navigate
        • Modifying for Navigate
      • Debugging in NAV 2013
        • Text Exports of Objects
        • Dialog function debugging techniques
          • Debugging with MESSAGE and CONFIRM
          • Debugging with DIALOG
          • Debugging with text output
          • Debugging with ERROR
        • The new NAV 2013 Debugger
          • Activating the Debugger
          • Attaching the Debugger to a Session
          • Creating break events
          • The Debugger window
          • Changing the code while debugging
      • C/SIDE Test-driven development
      • Other Interfaces
        • Automation Controller
        • Linked data sources
      • NAV Application Server (NAS)
      • Client Add-ins
        • Client Add-in construction
        • WDTU Client Add-in
        • Client Add-in comments
      • Customizing Help
      • NAV development projects some general guidance
        • Knowledge is key
        • Data-focused design
          • Defining the needed data views
          • Designing the data tables
          • Designing the user data access interface
          • Designing the data validation
          • Data design review and revision
        • Designing the Posting processes
        • Designing the supporting processes
        • Double-check everything
      • Design for efficiency
        • Disk I/O
        • Locking
      • Updating and upgrading
        • Design for updating
          • Customization project recommendations
            • One change at a time
          • Testing
            • Database testing approaches
            • Testing in production
            • Using a testing database
            • Testing techniques
          • Deliverables
          • Finishing the project
        • Plan for upgrading
          • Benefits of upgrading
        • Coding considerations
          • Good documentation
          • Low-impact coding
      • Supporting material
      • Summary
      • Review questions
    • A. Answers to Review Questions
      • Chapter 1, An Introduction to NAV 2013
      • Chapter 2, Tables
      • Chapter 3, Data Types and Fields
      • Chapter 4, Pages the User's Interactive Interface
      • Chapter 5, Queries and Reports
      • Chapter 6, Introduction to C/SIDE and C/AL
      • Chapter 7, Intermediate C/AL
      • Chapter 8, Advanced NAV Development Tools
      • Chapter 9, Develop, Debug, Deliver
    • Index
  • Title: Programming Microsoft Dynamics NAV 2013. Experienced programmers and developers will find this the definitive guide to programming Microsoft Dynamics NAV. Both a reference book and a comprehensive hands-on tutorial, it will expand your knowledge dynamically. - Third Edition
  • Author: Christopher D. Studebaker, David Studebaker, CHRISTOPHER D. STUDEBAKER, David A. Studebaker, David A. Studebaker
  • Original title: Programming Microsoft Dynamics NAV 2013. Experienced programmers and developers will find this the definitive guide to programming Microsoft Dynamics NAV. Both a reference book and a comprehensive hands-on tutorial, it will expand your knowledge dynamically. - Third Edition
  • ISBN: 9781849686495, 9781849686495
  • Date of issue: 2013-02-22
  • Format: Ebook
  • Item ID: e_3b78
  • Publisher: Packt Publishing