Programming Microsoft® Dynamics™ NAV Table of Contents

Table of Contents

• Preface

• Chapter 1: The Basic Ingredients
• Some Unique NAV Terms Defined
• The C/SIDE Integrated Development Environment
• Object Designer Tool Icons
• Seven Kinds of NAV Objects
• More Definitions (Related to NAV)
• NAV Functional Terminology
• Getting Started with Application Design
• Tables
• Example: Table Design
• Example: Table Creation
• Forms
• Card Forms
• Tabular Forms
• Main/Sub Forms
• Matrix Forms
• Trendscape Forms
• All Forms
• Creating a Card Form
• Creating a List Form
• Reports
• Creating a List Format Report
• Codeunits
• MenuSuites
• Dataports
• XMLports
• Integration Tools
• Backups and Documentation
• Summary

• Chapter 2: Tables
• Overview of Tables
• What Makes Up a Table?
• Table Naming
• Table Numbering
• Table Properties
• Table Triggers
• Keys
• SumIndexFields
• Expanding Our Sample Application
• Table Creation and Modification
• Keys
• Adding Some Activity-Tracking Tables
• New Tables
• Keys and SumIndexFields in Our Examples
• Types of Tables
• Totally Modifiable Tables
• Content-Modifiable Tables
• Read-Only Tables
• Summary

• Chapter 3: Fields
• Fields
• Field Properties
• Field Numbering
• Renumbering a Field
• Changing the Data Type of a Field
• Field Triggers
• Some Data Structure Examples
• More Definitions
• Variable Naming
• Data Types
• Fundamental Data Types
• Numeric Data
• String Data
• Time Data
• Complex Data Types
• Data Item
• DateFormula
• Data Structure
• Objects
• Automation
• Input/Output
• References and Other
• Data Type Usage
• FieldClasses
• Filtering
• Defining Filter Syntax and Values
• Experimenting with Filters
• Summary

• Chapter 4: Forms
• What Is a Form?
• Controls
• Bound and Unbound
• NAV Form Look and Feel
• Types of Forms
• Accessing the Form Designer
• What Makes Up a Form?
• Form Properties
• Forms Controls
• Explore
• Inheritance
• Experimenting with Controls
• Control Triggers
• Control Properties
• Experimenting with Control Properties
• Some Control Property Tips
• More Illumination with C/ANDL
• Update the Member Forms
• Testing Forms
• Creative Plagiarism
• Form Design Hints
• A Quick Tour of the Form Designer
• Keys to Learning NAV
• Summary

• Chapter 5: Reports
• What is a Report?
• NAV Report Look and Feel
• NAV Report Types
• Report Types Summarized
• Report Naming
• Report Components Overview
• The Components of a Report Description
• Report Data Flow
• The Elements of a Report
• Report Properties
• Report Triggers
• Data Items
• Data Item Properties
• Data Item Triggers
• Data Item Sections
• Run-Time Formatting
• Report Wizard-Generated Sections
• Report Section Descriptions
• More Run-Time Formatting
• Section Properties
• Section Triggers
• Controls for Reports
• Control Properties
• Inheritance
• Request Form
• Request Form Properties
• Request Form Triggers
• Request Form Controls
• Request Form Control Triggers
• Processing-Only Reports
• Revising a Generated Report
• Revision—First Design
• Revision—Second Design
• Creating a Report from Scratch
• Creative Report Plagiarism
• Special Output Issues
• Printing PDF Files
• Printing HTML Formatted Output
• Printing to an Impact Printer
• Summary

• Chapter 6: Introduction to C/SIDE and C/AL
• Essential Navigation
• Object Designer
• Starting a New Object
• Some Designer Navigation Pointers
• Exporting Objects
• Importing Objects
• Text Objects
• Object Numbers
• Some Useful Practices
• Changing Data Definitions
• Saving and Compiling
• Some C/AL Naming Conventions
• Variables
• Global Variables
• Local Variables
• Special Working Storage Variables
• A Definition of Programming in C/SIDE
• Functions
• Basic C/AL Syntax
• Assignment and Punctuation
• Wild Cards
• Expressions
• Operators
• Some Basic C/AL
• MESSAGE, ERROR, CONFIRM, and STRMENU Functions
• SETCURRENTKEY Function
• SETRANGE Function
• GET Function
• FIND–NEXT Functions
• BEGIN–END Compound Statement
• IF–THEN–ELSE Statement
• Indenting Code

• Some Simple Coding Modifications
• Adding a Validation to a Table
• Adding Code to Enhance a Report

• Summary

• Chapter 7: Intermediate C/AL
• Development
• C/AL Symbol Menu
• Internal Documentation
• Computation—Validation Utility Functions
• TESTFIELD
• FIELDERROR
• VALIDATE
• ROUND
• TODAY, TIME, and CURRENTDATETIME Function
• WORKDATE Function
• Data Conversion Functions
• FORMAT Function
• EVALUATE Function
• DATE Functions
• DATE2DMY Function
• DATE2DWY Function
• DMY2DATE and DWY2DATE Functions
• CALCDATE Function
• FlowField-SumIndex Functions
• CALCFIELDS Function
• CALCSUMS Function
• Flow Control
• REPEAT–UNTIL Control Structure
• WHILE–DO Control Structure
• CASE–ELSE Statement
• WITH–DO Statement
• QUIT, BREAK, EXIT, SKIP, and SHOWOUTPUT Functions
• QUIT Function
• BREAK Function
• EXIT Function
• SKIP Function
• SHOWOUTPUT Function
• Input and Output Functions
• NEXT Function (with FIND)
• INSERT Function
• MODIFY Function
• Rec and xRec
• DELETE Function
• MODIFYALL Function
• DELETEALL Function
• Filtering
• SETRANGE Function
• SETFILTER Function
• COPYFILTER and COPYFILTERS Functions
• GETFILTER and GETFILTERS Functions
• MARK Function
• CLEARMARKS Function
• MARKEDONLY Function
• RESET Function
• InterObject Communication
• Via Data
• Via Function Parameters
• Via Object Calls
• Use the New Knowledge
• A Development Challenge for You
• Phase 1
• Phase 2
• Phase 3
• A Sample Approach to the Challenge
• Phase 1
• Phase 2
• Phase 3
• Summary

• Chapter 8: Advanced NAV Development
• Callable Functions
• Codeunit – 358 Date Filter-Calc
• Codeunit 359 – Period Form Management
• Codeunit 365 – Format Address
• Codeunit 396 – NoSeriesManagement
• Codeunit 397 – Mail
• Codeunit 408 – Dimension Management
• Codeunit 412 – Common Dialog Management
• Sampling of Function Models to Review
• Codeunit 228 – Test Report-Print
• Codeunit 229 – Print Documents
• Some other Objects to Review
• Management Codeunits
• Documenting Modifications
• Multi-Language
• Multi-Currency
• Code Analysis and Debugging Tools
• Developer's Toolkit
• Relations to Tables
• Relations from Objects
• Source Access
• Where Used
• Try it Out
• Working in Exported Text Code
• Using Navigate
• Testing with Navigate
• The Debugger
• The Code Coverage Tool
• Dialog Function Debugging Techniques
• Debugging with MESSAGE
• Debugging with CONFIRM
• Debugging with DIALOG
• Debugging with Text Output
• Debugging with ERROR
• Summary

• Chapter 9: Designing NAV Modifications
• Starting a New NAV Enhancement Project
• Design of NAV Modifications
• Knowledge is Key
• Creating a New Functional Area
• Advantages of Designing New Functionality
• Enhancing an Existing Functional Area
• NAV Development Time Allocation
• Data-Focused Design for New Functionality
• Define the Big Picture: The End Goals
• A Simple Sample Project
• Then Define the Little Pictures
• Sample Project Continued—1
• Define What Data is Required to Create the Pictures
• Sample Project Continued—2
• Define the Sources for the Data
• Sample Project Continued—3
• Define the Data "Views"
• Sample Project Continued—4
• Other Factors Must Always be Considered
• NAV Processing Flow
• Data Preparation
• Enter Transactions
• Provide for Additional Data Testing
• Post the Journal Batch
• Access the Data
• Continuing Maintenance
• Designing a New NAV Application Functionality
• Define the Data Tables
• Design the User Data Access Interface
• Design the Data Validation
• Appropriate Data Design Sequence
• Design Posting Processes
• Design Support Processes
• Double-Check Everything
• Summary

• Chapter 10: External Interfaces
• MenuSuites
• MenuSuite Levels
• MenuSuite Structure
• MenuSuite Internal Structure
• MenuSuite Development
• NAV Menus before V4.0
• Dataports
• Dataport Components
• Dataport Properties
• Dataport Triggers
• Data Item
• Data Item Properties
• Data Item Triggers
• Dataport Fields
• Dataport Field Properties
• Dataport Field Triggers
• XMLports
• XMLport Components
• XMLport Properties
• XMLport Triggers
• XMLport Data Lines
• XMLport Line Properties
• Element or Attribute
• XMLport Line Triggers
• Advanced Interface Tools
• Automation Controller
• NAV Communication Component
• Linked Server Data Sources
• NAV ODBC
• C/OCX
• C/FRONT
• NAV Application Server (NAS)
• Summary

• Chapter 11: Design to Succeed
• Design for Efficiency
• Disk I/O
• Locking
• C/SIDE versus SQL Server Databases
• SQL Server I/O Commands
• FINDFIRST Function
• FINDLAST Function
• FINDSET Function
• Design for Updating
• Customization Project Recommendations
• One at a Time
• Design, Design, Design
• Test, Test, Test
• Plan for Upgrading
• Benefits of Upgrading
• Coding Considerations
• Good Documentation
• Low-Impact Coding
• The Upgrade Process
• Upgrade Executables Only
• Full Upgrade
• Tips for Small Successes
• Cache Settings for Development
• Two Monitors
• Simple System Administration
• Careful Naming
• Tools
• Code Coverage
• Client Monitor
• Creating Help for Modifications
• Implementation Tool
• Other Reference Material
• Summary

• Index