Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Programming Microsoft Dynamics NAV 2013

You're reading from   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.

Arrow left icon
Product type Paperback
Published in Feb 2013
Publisher Packt
ISBN-13 9781849686488
Length 630 pages
Edition 3rd Edition
Arrow right icon
Toc

Table of Contents (19) Chapters Close

Programming Microsoft Dynamics NAV 2013
Credits
Foreword
About the Authors
Acknowledgements
About the Reviewers
www.PacktPub.com
Preface
1. An Introduction to NAV 2013 FREE CHAPTER 2. Tables 3. Data Types and Fields 4. Pages – the User's Interactive Interface 5. Queries and Reports 6. Introduction to C/SIDE and C/AL 7. Intermediate C/AL 8. Advanced NAV Development Tools 9. Develop, Debug, Deliver Answers to Review Questions Index

Index

A

  • ActionContainer action line type / Page Action Types and Subtypes
  • ActionContainer properties
    • ID property / Action Properties
    • name property / Action Properties
    • caption property / Action Properties
    • CaptionML property / Action Properties
  • Action Designer / Page Actions, Action Designer
  • ActionGroup properties
    • ID property / Action Properties
    • caption property / Action Properties
    • name property / Action Properties
    • visible property / Action Properties
    • enabled property / Action Properties
    • CaptionML property / Action Properties
    • description property / Action Properties
    • image property / Action Properties
    • ToolTipML property / Action Properties
  • Action Groups / Action Groups
  • ActionItems SubType / Page Action Types and Subtypes
  • Action properties
    • ID property / Action Properties
    • name property / Action Properties
    • visible property / Action Properties
    • enabled property / Action Properties
    • RunPageMode property / Action Properties
    • CaptionML property / Action Properties
    • ToolTip property / Action Properties
    • image property / Action Properties
    • promoted property / Action Properties
    • PromotedCategory property / Action Properties
    • PromotedIsBig property / Action Properties
    • Ellipsis property / Action Properties
    • ShortCutKey property / Action Properties
    • RunObject property / Action Properties
    • RunPageView property / Action Properties
    • RunPageLink property / Action Properties
    • RunPageOnRec property / Action Properties
    • InFooterBar property / Action Properties
  • Add Filter button / Experimenting with filters
  • Address Bar, pages / NAV 2013 Page structure
  • All button / Object Designer
  • answers / Chapter 1, An Introduction to NAV 2013, Chapter 2, Tables, Chapter 4, Pages – the User's Interactive Interface, Chapter 5, Queries and Reports, Chapter 6, Introduction to C/SIDE and C/AL, Chapter 8, Advanced NAV Development Tools
  • application changes, NAV 2013 / Application changes
  • application tables
    • about / Application tables
  • Application Test Toolset for Microsoft Dynamics NAV 2013 / C/SIDE Test-driven development
  • arrays, storage variables / Arrays
  • Assemble to Order (ATO)
    • about / Manufacturing
  • assignment / Assignment and punctuation
  • AtomPub Document / Exposing a web service
  • attribute-specific property / NodeType of Attribute
  • AutoCalcField / SourceType as Field
  • automated / C/SIDE Test-driven development
  • automation controller
    • about / Automation Controller
    • uses / Automation Controller
  • automation data types
    • OCX / Automation
    • automation / Automation
    • DotNet / Automation
  • AutoReplace / SourceType as Table
  • AutoSave / SourceType as Table
  • AutoSplitKey property / Page properties
  • AutoUpdate / SourceType as Table

B

  • 9004 - Bookkeeper / Role Center pages
  • BaseDate parameter / Codeunit 358 – Date Filter-Calc
  • batch
    • about / NAV functional terminology
  • BEGIN-END compound statement / The BEGIN–END compound statement, Indenting code
  • BEGIN - END framework / The IF–THEN–ELSE statement
  • BLOB / References and other data types
  • BLOB-specific properties
    • SubType / Field properties
    • owner / Field properties
    • compressed / Field properties
  • Block of code / The BEGIN–END compound statement
  • Boolean operators / Boolean operators
  • BooleanValue / The SETCURRENTKEY function
  • bound pages / Bound and Unbound Pages
  • brackets / Assignment and punctuation
  • brackets [ ] / Operators
  • BREAK function
    • about / BREAK function
  • Breakpoint / Creating break events
  • Break Rule / Creating break events
  • Business Intelligence
    • about / Business Intelligence and reporting (BI)
    • functions / Business Intelligence and reporting (BI)

C

  • C/AL
    • about / C/AL programming language
    • naming conventions / Some C/AL naming conventions
    • functions, frequently used / Frequently used C/AL functions
    • validation functions / Validation functions, FIELDERROR, INIT, VALIDATE
  • C/AL code / Page Triggers
    • field validation, adding to table / Adding field validation to a table
    • adding, to report / Adding code to a report
    • new report heading, layouting / Layout the new report heading
    • testing / Save and test
    • saving / Save and test
    • processing, finishing / Finishing the processing code
  • C/AL functions
    • about / Frequently used C/AL functions
    • MESSAGE function / The MESSAGE function
    • ERROR function / The ERROR function
    • CONFIRM function / The CONFIRM function
    • STRMENU function / The STRMENU function
    • record functions / Record functions
    • SETCURRENTKEY function / The SETCURRENTKEY function
    • SETRANGE function / The SETRANGE function
    • SETFILTER function / The SETFILTER function
    • GET function / The GET function
    • FIND function / FIND functions
  • C/AL Globals
    • Global Text Constants / C/AL Globals
    • about / C/AL Globals
    • Global Functions / C/AL Globals
  • C/AL Locals
    • about / C/AL Locals
    • Function local identifiers / Function local identifiers
    • trigger local variables / Other local identifiers
    • other local identifiers / Other local identifiers
  • C/AL Locals screen / XMLport – web services integration example
  • C/AL Symbol Menu / Object Designer navigation
    • about / C/AL Symbol Menu
    • overview / C/AL Symbol Menu
  • C/AL syntax
    • about / C/AL syntax
    • assignment / Assignment and punctuation
    • punctuation / Assignment and punctuation
    • expressions / Expressions
  • C/SIDE
    • about / C/SIDE, Understanding C/SIDE
    • and C/AL / Understanding C/SIDE
    • Object Designer / Object Designer
    • text objects / Text objects
  • C/SIDE Format/Evaluate / XMLport properties
  • C/SIDE programming
    • about / C/SIDE programming
    • non-modifiable functions / Non-modifiable functions
    • modifiable functions / Modifiable functions
    • custom functions / Custom functions
    • function, creating / Creating a function
  • C/SIDE RD
    • about / Two NAV report designers, Report data overview
  • C/SIDE Report, properties
    • about / C/SIDE Report properties
    • ID / C/SIDE Report properties
    • Name / C/SIDE Report properties
    • Caption / C/SIDE Report properties
    • CaptionML / C/SIDE Report properties
    • Description / C/SIDE Report properties
    • UseRequestPage / C/SIDE Report properties
    • UseSystemPrinter / C/SIDE Report properties
    • EnableExternalImages / C/SIDE Report properties
    • EnableHyperLinks / C/SIDE Report properties
    • EnableExternalAssemblies / C/SIDE Report properties
    • ProcessingOnly / C/SIDE Report properties
    • ShowPrintStatus / C/SIDE Report properties
    • TransactionType / C/SIDE Report properties
    • Permissions / C/SIDE Report properties
    • PaperSourceFirstPage / C/SIDE Report properties
    • PaperSourceDefaultPage / C/SIDE Report properties
    • PaperSourceLastPage / C/SIDE Report properties
  • CALCDATE function
    • about / CALCDATE function
    • syntax / CALCDATE function
  • CalcFields / SourceType as Table
  • CALCFIELDS function
    • about / CALCFIELDS function
    • syntax / CALCFIELDS function
    • versus CALCSUMS function / CALCFIELDS and CALCSUMS comparison
  • CALCSUMS function
    • about / CALCSUMS function
    • syntax / CALCSUMS function
    • versus CALCFIELDS function / CALCFIELDS and CALCSUMS comparison
  • callable functions
    • about / Callable functions
    • Codeunit 358(Date Filter Calc) / Codeunit 358 – Date Filter-Calc
    • Codeunit 359 (Period Form Management) / Codeunit 359 – Period Form Management
    • Codeunit 365(Format Address) / Codeunit 365 – Format Address
    • Codeunit 369(NoSeriesManagement) / Codeunit 396 – NoSeriesManagement
    • function models / Function models to review and use
  • CaptionML property / Page properties, Action Properties
  • Caption property / Page properties, Page Controls, Action Properties
  • Card page / Card page
  • CardPageID property / Page properties
  • card pages
    • about / Card pages
    • creating / Creating a Card page
  • CardParts, page part / CardParts and ListParts
  • CASE-ELSE statement
    • about / CASE-ELSE statement
  • CASE statement / Finishing the processing code
  • Chart Control Add-in / Chart Control Add-in
  • chart part / Chart part
  • ChartPartID property / Page Part controls
  • charts, page part
    • about / Charts
    • chart part / Chart part
    • Chart Control Add-in / Chart Control Add-in
  • CLEARMARKS function
    • about / CLEARMARKS function
    • syntax / CLEARMARKS function
  • client add-ins
    • about / Client Add-ins
    • constructing / Client Add-in construction
    • WDTU Client Add-in / WDTU Client Add-in
    • comments / Client Add-in comments
  • client enhancements, NAV 2013 / Client enhancements
  • code
    • indenting / Indenting code
  • codeunit
    • about / Codeunits
  • Codeunit 358(Date Filter Calc) / Codeunit 358 – Date Filter-Calc
  • Codeunit 359 (Period Form Management / Codeunit 359 – Period Form Management
  • Codeunit 365(Format Address) / Codeunit 365 – Format Address
  • Codeunit 369(NoSeriesManagement) / Codeunit 396 – NoSeriesManagement
  • Codeunit Designer
    • accessing / Accessing the Codeunit Designer
  • codeunits
    • about / NAV object types
  • coding consideration
    • about / Coding considerations
    • good documentation / Good documentation
    • low-impact coding / Low-impact coding
  • Column properties
    • about / Column properties
    • MethodType / Column properties
    • Method / Column properties
    • ReverseSign / Column properties
  • ColumnSpan property / Field controls
  • comma-delimited text files / XMLport properties
  • COMMIT command / Locking
  • complex data type
    • data structure / Data structure
    • objects / Objects
    • automation / Automation
    • Input/Output / Input/Output
    • DateFormula / DateFormula
    • references / References and other data types
    • RecordID / References and other data types
    • RecordRef / References and other data types
    • FieldRef / References and other data types
    • KeyRef / References and other data types
    • Variant / References and other data types
    • TableFilter / References and other data types
    • Transaction Type / References and other data types
    • BLOB / References and other data types
    • BigText / References and other data types
    • GUID / References and other data types
    • test page / References and other data types
    • ExecutionMode / References and other data types
  • Complex data type / Basic definitions
  • components, reports
    • C/SIDE Report properties / C/SIDE Report properties
    • Visual Studio Report properties / Visual Studio Report properties
    • report triggers / Report triggers
    • Request Page properties / Request Page properties
    • Request Page triggers / Request Page triggers
    • Data item properties / Data item properties
    • Data Item triggers / Data Item triggers
  • compound statement / The BEGIN–END compound statement
  • conditional statements
    • about / Conditional statements
  • ConfirmationDialog page / ConfirmationDialog page
  • CONFIRM function / The CONFIRM function
  • CONFIRM message / Debugging with MESSAGE and CONFIRM
  • Constant / Basic definitions
  • constants / Expressions
  • CONST filter / FieldClass – FlowField
  • container controls / Container controls
  • Content Area, pages / NAV 2013 Page structure
  • content modifiable tables
    • system / System
  • ControlAddIn property / Field controls
  • controls
    • about / NAV object and system elements
  • Coordinated Universal Time (UTC) / Date/Time data
  • Copy (Ctrl + C) / MenuSuite Designer
  • COPYFILTER function
    • about / COPYFILTER and COPYFILTERS functions
    • syntax / COPYFILTER and COPYFILTERS functions
  • COPYFILTERS function
    • about / COPYFILTER and COPYFILTERS functions
  • COPYFILTERS functions
    • syntax / COPYFILTER and COPYFILTERS functions
  • Create Group (Ctrl + Insert) / MenuSuite Designer
  • Create Item… (Insert) / MenuSuite Designer
  • create method / Exposing a web service
  • CreateMultiple method / Exposing a web service
  • CreatePeriodFormat function / Codeunit 359 – Period Form Management
  • creative report plagiarism
    • about / Creative report plagiarism
  • CRONUS database
    • about / Developing in NAV 2013 – hands-on
  • Ctrl + C / Object Designer navigation
  • Ctrl + V / Object Designer navigation
  • Ctrl + X / Object Designer navigation
  • Cue Group Actions / Cue Group Actions
  • CueGroup property / Group controls
  • Cue Groups / Cue Groups and Cues
  • Cues / Role Center page, Cue Groups and Cues
    • about / Queries
  • Cue source table / Cue source table
  • CURRENTDATETIME function
    • about / TODAY, TIME, and CURRENTDATETIME functions
    • syntax / TODAY, TIME, and CURRENTDATETIME functions
  • Customer Relationship module / Relationship Management (RM)
  • custom functions
    • about / Custom functions
    • creating / Creating a function
  • Cut (Ctrl + X) / MenuSuite Designer

D

  • dashboard display / Page Design Guidelines
  • data, NAV system
    • maintaining / Utilizing and maintaining the data
    • utilizing / Utilizing and maintaining the data
    • maintenance / Data maintenance
  • data conversion functions, NAV
    • ROUND / ROUND
    • FORMAT / FORMAT function
    • EVALUATE / EVALUATE function
  • data definitions
    • changing / Changing data definitions
  • Data Element / Basic definitions
  • data fields
    • about / Report data overview
  • data fields, Playlist Header / Playlist Header Validations
  • data fields, Playlist Line / Playlist Line validations
  • data item
    • about / Report data flow
  • Data item, properties
    • about / Data item properties
    • Indentation / Data item properties
    • DataItemTable / Data item properties
    • DataItemTableView / Data item properties
    • DataItemLinkReference / Data item properties
    • DataItemLink / Data item properties
    • ReqFilterFields / Data item properties
    • CalcFields / Data item properties
    • MaxIteration / Data item properties
    • PrintOnlyIfDetail / Data item properties
  • DataItem properties
    • about / The DataItem properties
    • Indentation / The DataItem properties
    • DataItemLinkType / The DataItem properties
    • SQLJoinType / The DataItem properties
    • DataItemTableFilter / The DataItem properties
  • Data Item triggers
    • about / Data Item triggers
    • OnPreDataItem() / Data Item triggers
    • OnAfterGetRecord() / Data Item triggers
    • OnPostDataItem() / Data Item triggers
  • data lines, XMLports / XMLport data lines
  • DataSet_Result / Layout the new report body
  • data structure
    • file / Data structure
    • record / Data structure
  • DataType, as Field
    • Import$$OnAfterAssignField() / DataType as Field
    • Export$$OnBeforePassField() / DataType as Field
  • DataType, as Table
    • Import$$OnAfterInsertRecord() / DataType as Table
    • Import$$OnBeforeModifyRecord() / DataType as Table
    • Import$$OnAfterModifyRecord() / DataType as Table
    • Export$$OnPreXMLItem() / DataType as Table
    • Export$$OnAfterGetRecord() / DataType as Table
    • Import$$OnAfterInitRecord() / DataType as Table
    • Import$$OnBeforeInsertRecord() / DataType as Table
  • DataType, as Text
    • about / DataType as Text
    • Export$$onBeforePassVariable() / DataType as Text
    • Import$$OnAfterAssignVariable() / DataType as Text
  • data types
    • about / Basic definitions, Data types
    • fundamental / Fundamental data types
    • complex / Complex data types
    • usage / Data type usage
  • Data Types column / Arithmetic operators and functions
  • Date/Time data
    • date / Date/Time data
    • DateTime / Date/Time data
    • time / Date/Time data
    • duration / Date/Time data
  • DATE2DMY, non-modifiable functions / Non-modifiable functions
  • DATE2DMY function
    • about / DATE2DMY function
    • syntax / DATE2DMY function
  • DATE2DWY function
    • about / DATE2DWY function
  • date and time functions, NAV
    • about / Date and Time functions
    • TODAY / TODAY, TIME, and CURRENTDATETIME functions
    • TIME / TODAY, TIME, and CURRENTDATETIME functions
    • CURRENTDATETIME / TODAY, TIME, and CURRENTDATETIME functions
    • WORKDATE / WORKDATE function
    • DATE2DMY / DATE2DMY function
    • DATE2DWY / DATE2DWY function
    • DMY2DATE / DMY2DATE and DWY2DATE functions
    • DWY2DATE / DMY2DATE and DWY2DATE functions
    • CALCDATE / CALCDATE function
  • Date Filter - Properties window / FlowFields and a FlowFilter for our application
  • Date Filter field / WDTU Page Enhancement – part 1
  • DateFormula
    • about / DateFormula, CALCDATE function
    • numeric multipliers / DateFormula
    • alpha time units / DateFormula
    • math symbol interpretation / DateFormula
  • deadlock / Locking
  • Debugger window
    • Step Into / The Debugger window
    • Step Over / The Debugger window
    • Step Out / The Debugger window
    • Continue / The Debugger window
    • Break / The Debugger window
    • Stop / The Debugger window
    • Toggle / The Debugger window
    • Set/Clear Condition / The Debugger window
    • Disable All / The Debugger window
    • Break Rules / The Debugger window
    • Debugger Break Rules / The Debugger window
    • Breakpoints / The Debugger window
    • Variables / The Debugger window
  • debugging, NAV 2013
    • about / Debugging in NAV 2013
    • objects, exporting into text files / Text Exports of Objects
  • Decimal and Integer properties
    • DecimalPlaces / Field properties
    • MinValue / Field properties
    • MaxValue / Field properties
    • AutoIncrement / Field properties
  • DecimalPlaces property / Field controls
  • DefaultNamespace property / XMLport properties
  • Default Role Center box / Navigation Pane and Action Menus
  • DelayedInsert property / Page properties
  • Delete (Delete) / MenuSuite Designer
  • DELETEALL function
    • about / DELETEALL function
    • syntax / DELETEALL function
  • DELETE function
    • about / DELETE function
    • syntax / DELETE function
  • delete method / Exposing a web service
  • Department field / MenuSuite Designer
  • Departments button / NAV 2013 Page structure
  • departments page / Departments page
  • description property / Page properties, Action Properties
  • design, for updating
    • customization project recommendations / Customization project recommendations, One change at a time
    • testing / Testing
    • deliverables / Deliverables
    • project, finishing / Finishing the project
  • Design Level values / MenuSuite Designer
  • Developer and IT Pro Help / Exposing a web service
  • Developer and IT Pro Help information
    • about / FORMAT function
  • Development Environment filter access
    • Field Filter (F7) / Development Environment filter access
    • Table Filter(Ctrl+F7) / Development Environment filter access
    • Flow Filter (Shift + F7) / Development Environment filter access
    • Show All (Shift + Ctrl + F7) / Development Environment filter access
    • Sort (Shift + F8) / Development Environment filter access
  • development overview, NAV 2013
    • about / A developer's overview of NAV 2013
    • object types / NAV object types
    • C/SIDE / C/SIDE
    • object designer tool icons / Object Designer tool icons
    • C/AL / C/AL programming language
    • objects / NAV object and system elements
    • system elements / NAV object and system elements
    • functional terminologies / NAV functional terminology
    • user interface / User Interface
  • development tools, NAV 2013 / Development tools
  • DIALOG
    • using / Debugging with DIALOG
  • DIALOG functions
    • about / Dialog function debugging techniques
    • MESSAGE / Debugging with MESSAGE and CONFIRM
    • DIALOG / Debugging with DIALOG
    • text output, using / Debugging with text output
    / Debugging with ERROR
  • Dimensions property / Arrays
  • DIV statement
    • syntax / Arithmetic operators and functions
  • DMY2DATE function
    • about / DMY2DATE and DWY2DATE functions
    • syntax / DMY2DATE and DWY2DATE functions
  • document
    • about / NAV functional terminology
  • Documentation(), XMLport triggers / XMLport triggers
  • Documentation Feedback function / Experimenting on your own
  • Document page / Document page
  • document pages
    • about / Document pages
  • document report
    • about / NAV report types, Report types summarized
  • double quotes / Assignment and punctuation
  • DWY2DATE function
    • about / DMY2DATE and DWY2DATE functions
    • syntax / DMY2DATE and DWY2DATE functions

E

  • editable property / Page properties, Group controls, Field controls
  • efficiency designing
    • about / Design for efficiency
    • Disk I/O / Disk I/O
    • locking / Locking
  • Element-specific properties / NodeType of Element
  • element data item
    • about / Element or Attribute
    • node type / NodeType of Element
    • attribute-specific property / NodeType of Attribute
  • Ellipsis property / Action Properties
  • enabled property / Group controls, Field controls
  • Encoding (or TextEncoding) / XMLport properties
  • ERP
    • about / NAV 2013 – an ERP system
  • ERROR function / The ERROR function, Debugging with ERROR
  • EVALUATE function
    • about / EVALUATE function
    • syntax / EVALUATE function
  • Evaluate property / XMLport – web services integration example
  • Excel
    • about / Interactive report capabilities
    • outputting to / Output to Excel
  • existing report
    • modifying / Modifying an existing report
  • EXIT function
    • about / EXIT function
  • Export$$OnAfterGetRecord() / DataType as Table
  • Export$$OnBeforePassField() / DataType as Field
  • Export$$onBeforePassVariable() / DataType as Text
  • Export$$OnPreXMLItem() / DataType as Table
  • expressions, C/AL syntax
    • about / Expressions
    • operators / Operators
  • ExtendedDatatype property / Field controls
  • ExtractionChoice parameter / DATE2DWY function

F

  • .fob file / Importing objects
  • F3 / Object Designer navigation
  • F4 / Object Designer navigation
  • F5 / Object Designer navigation
  • F8 / Object Designer navigation
  • F9 / Object Designer navigation
  • F9 key / Creating break events
  • F11 / Object Designer navigation
  • FactBox Area, page part / FactBox Area
  • FactBoxes
    • about / Document pages
  • FactBox page
    • creating / Creating a FactBox page
  • FactBox Pane, pages / NAV 2013 Page structure
  • FastTab page / FastTab
  • FastTabs
    • about / Card pages
  • FastTabs control / Page Controls
  • FieldClass property
    • about / FieldClass property options
    • normal / FieldClass – Normal
    • FlowFields / FieldClass – FlowField
    • FlowFilter / FieldClass – FlowFilter
  • field controls
    • about / Field controls
    • properties / Field controls
  • field controls, properties
    • visible property / Field controls
    • enabled property / Field controls
    • editable property / Field controls
    • HideValue property / Field controls
    • MultiLine property / Field controls
    • OptionCaptionML property / Field controls
    • OptionCaption property / Field controls
    • ShowCaption property / Field controls
    • DecimalPlaces property / Field controls
    • Width property / Field controls
    • QuickEntry property / Field controls
    • importance property / Field controls
    • ColumnSpan property / Field controls
    • RowSpan property / Field controls
    • ControlAddIn property / Field controls
    • ExtendedDatatype property / Field controls
  • FieldDelimiter property / XMLport properties
  • FIELDERROR function
    • about / FIELDERROR
    • syntax / FIELDERROR
  • field filter / FieldClass – FlowField
  • Field Filter (F7) / Development Environment filter access
  • field groups / Field Groups
  • field numbering / Field numbering
  • field numbers
    • about / NAV object and system elements
  • field properties
    • about / Field properties
    • Field No / Field properties
    • name / Field properties
    • caption / Field properties
    • captionML / Field properties
    • description / Field properties
    • data type / Field properties
    • enabled / Field properties
    • BLOB-specific properties / Field properties
    • DataLength / Field properties
    • InitValue / Field properties
    • AltSearchField / Field properties
    • Caption Class / Field properties
    • editable / Field properties
    • SQL Data Type / Field properties
    • TableRelation / Field properties
    • Validate TableRelation / Field properties
    • Test TableRelation / Field properties
    • ExtendedDataType / Field properties
    • Decimal and Integer properties / Field properties
    • Option-specific properties / Field properties
  • fields
    • about / NAV object and system elements, Fields
    • properties / Field properties
    • triggers / Field triggers
    • data structure examples / Data structure examples
    • numbering / Field numbering
    • variable naming / Field and Variable naming
  • FieldSeparator property / XMLport properties
  • field triggers
    • about / Field triggers
    • OnValidate() / Field triggers
    • OnLookup() / Field triggers
  • FieldValidate / SourceType as Field
  • FileName property / XMLport properties
  • filter controls
    • accessing / Accessing filter controls
    • Development Environment filter access / Development Environment filter access
    • RTC / Role Tailored Client filter access
  • FilterExpression / The SETFILTER function
  • FILTERGROUP function
    • about / FILTERGROUP function
    • syntax / FILTERGROUP function
  • filtering
    • about / Filtering
  • filtering, functions
    • SETFILTER / SETFILTER function
    • COPYFILTER / COPYFILTER and COPYFILTERS functions
    • COPYFILTERS / COPYFILTER and COPYFILTERS functions
    • GETFILTER / GETFILTER and GETFILTERS functions
    • GETFILTERS / GETFILTER and GETFILTERS functions
    • FILTERGROUP / FILTERGROUP function
    • MARK / MARK function
    • CLEARMARKS / CLEARMARKS function
    • MARKEDONLY / MARKEDONLY function
    • RESET / RESET function
  • FilterPane, pages / NAV 2013 Page structure
  • Filter properties / Filter properties
  • filters
    • about / Filtering
    • experimenting / Experimenting with filters
  • fin.stx file / C/SIDE Report properties
  • Financial Management
    • about / Financial Management
    • functions / Financial Management
  • FIND('+') / FIND functions
  • FIND('-') / FIND functions
  • FIND ([Which]) option / FIND ([Which]) options and the SQL Server alternates
  • FindDate function / Codeunit 359 – Period Form Management
  • FINDFIRST / FIND functions
  • FIND function / FIND functions
    • about / NEXT function with FIND or FINDSET
  • FINDLAST / FIND functions
  • FIND options
    • SQL Server specific / FIND ([Which]) options and the SQL Server alternates
  • FINDSET / FIND functions
  • FINDSET function
    • about / NEXT function with FIND or FINDSET
  • Fixed Asset Card page / Page Controls
  • FixedLayout property / Group controls
  • FlowFields
    • about / FieldClass – FlowField
    • sum / FieldClass – FlowField
    • average / FieldClass – FlowField
    • exist / FieldClass – FlowField
    • count / FieldClass – FlowField
    • min / FieldClass – FlowField
    • max / FieldClass – FlowField
    • lookup / FieldClass – FlowField
    • using / FlowFields and a FlowFilter for our application
  • FlowField SumIndexField functions
    • about / FlowField SumIndexField functions
    • CALCFIELDS / CALCFIELDS function
    • SETAUTOCALCFIELDS / SETAUTOCALCFIELDS function
    • CALCSUMS / CALCSUMS function
  • FlowFilter
    • using / FlowFields and a FlowFilter for our application
  • Flow Filter (Shift + F7) / Development Environment filter access
  • FOR-DOWNTO control
    • about / FOR-TO or FOR-DOWNTO
  • FOR-TO control
    • about / FOR-TO or FOR-DOWNTO
  • FormatAddr function / Codeunit 365 – Format Address
  • FORMAT function
    • about / FORMAT function
    • syntax / FORMAT function
  • format property / XMLport properties
  • Format property / XMLport – web services integration example
  • FreezeColumnID property / Group controls
  • fully modifiable tables
    • master / Master
    • journal / Journal
    • template / Template
    • ledger / Ledger
    • reference tables / Reference tables
    • register / Register
    • posted document / Posted Document
    • setup / Setup
    • temporary / Temporary
  • functional terminology, NAV
    • about / NAV functional terminology
    • journal / NAV functional terminology
    • ledger / NAV functional terminology
    • posting / NAV functional terminology
    • batch / NAV functional terminology
    • register / NAV functional terminology
    • document / NAV functional terminology
  • Function local identifiers / Function local identifiers
  • function models / Function models to review and use
  • Functions tab / Creating a function
  • fundamental data type / Basic definitions
    • numeric data / Numeric data
    • string data / String data
    • Date/Time data / Date/Time data

G

  • GET, non-modifiable functions / Non-modifiable functions
  • GETFILTER function
    • about / GETFILTER and GETFILTERS functions
    • syntax / GETFILTER and GETFILTERS functions
  • GETFILTERS function
    • about / GETFILTER and GETFILTERS functions
    • syntax / GETFILTER and GETFILTERS functions
  • GET function / The GET function
  • GetRecIDFromKey method / Exposing a web service
  • Global Command Bar, pages / NAV 2013 Page structure
  • Global Functions / C/AL Globals
  • global symbols
    • about / C/AL Symbol Menu
  • Global Text Constants / C/AL Globals
  • GridLayout property / Group controls
  • group controls
    • about / Group controls
    • properties / Group controls
  • group controls, properties
    • visible property / Group controls
    • enabled property / Group controls
    • editable property / Group controls
    • GroupType property / Group controls
    • IndentationColumnName property / Group controls
    • IndentationControls property / Group controls
    • FreezeColumnID property / Group controls
    • ShowAsTree property / Group controls
  • group property / Group controls
  • GroupType property / Group controls
  • GUID / References and other data types
  • GUI guidelines / Page Design Guidelines

H

  • Help information / Experimenting on your own
  • HideValue property / Field controls
  • Human Resource management (HR)
    • about / Human Resource management (HR)
    • functions / Human Resource management (HR)

I

  • ID property / Page properties
  • IF-THEN-ELSE statement / The IF–THEN–ELSE statement
  • IF conditional statement / Indenting code
  • image property / Action Properties
  • Import$$OnAfterAssignField() / DataType as Field
  • Import$$OnAfterAssignVariable() / DataType as Text
  • Import$$OnAfterInitRecord() / DataType as Table
  • Import$$OnAfterInsertRecord() / DataType as Table
  • Import$$OnAfterModifyRecord() / DataType as Table
  • Import$$OnBeforeInsertRecord() / DataType as Table
  • Import$$OnBeforeModifyRecord() / DataType as Table
  • importance property / Field controls
  • IndentationColumnName property / Group controls
  • IndentationControls property / Group controls
  • Independent Software Vendor (ISV) / NAV object and system elements
  • InFooterBar property / Action Properties
  • inheritance
    • about / Inheritance
  • INIT function
    • about / INIT
    • syntax / INIT
  • initialization, storage variables / Initialization
  • initial setup, NAV system
    • about / Initial setup and data preparation
  • InitValue property
    • assigning / Assigning an InitValue property
  • InlineSchema property / XMLport properties
  • Input/Output data types
    • dialog / Input/Output
    • OutStream / Input/Output
    • InStream / Input/Output
  • input and output functions
    • about / Input and Output functions
    • NEXT / NEXT function with FIND or FINDSET
    • FIND / NEXT function with FIND or FINDSET
    • FINDSET / NEXT function with FIND or FINDSET
    • INSERT / INSERT function
    • MODIFY / MODIFY function
    • DELETE / DELETE function
    • MODIFYALL / MODIFYALL function
    • DELETEALL / DELETEALL function
  • INSERT, non-modifiable functions / Non-modifiable functions
  • INSERT function
    • about / INSERT function
    • syntax / INSERT function
  • Insert Items…(Shift + Insert) / MenuSuite Designer
  • interactive report, capabilities
    • about / Interactive report capabilities
    • Interactive Sorting / Interactive sorting
    • Interactive visible/not visible / Interactive visible/not visible
  • internal documentation
    • about / Internal documentation
  • interobject communication
    • about / InterObject communication
    • via data / Communication via data
    • via function parameters / Communication through function parameters
    • via object calls / Communication via object calls
  • IsUpdated method / Exposing a web service
  • ISVs / Table numbering

J

  • joins, methods
    • inner / Queries
    • outer / Queries
    • left join / Queries
    • right join / Queries
    • cross join / Queries
  • journal
    • about / NAV functional terminology, Journal/Worksheet pages
  • Journal Batch, NAV system
    • testing / Testing and posting the Journal Batch
    • posting / Testing and posting the Journal Batch
  • Journal table / Journal
  • Journal table / NAV process flow

K

  • keys, tables / Keys
  • key terms, NAV
    • fields / NAV object and system elements
    • records / NAV object and system elements
    • controls / NAV object and system elements
    • properties / NAV object and system elements
    • triggers / NAV object and system elements
    • object numbers / NAV object and system elements
    • field numbers / NAV object and system elements
    • Work Date / NAV object and system elements
    • license / NAV object and system elements

L

  • ledger
    • about / NAV functional terminology
  • Ledger table
    • about / Ledger
    • Item Ledger Entries list / Ledger
    • Customer Ledger Entries page / Ledger
    • Item Ledger Entries page / Ledger
  • license limits
    • about / NAV object and system elements
  • line properties, XMLports
    • about / XMLport line properties
    • indentation / XMLport line properties
    • NodeName / XMLport line properties
    • NodeType / XMLport line properties
    • SourceType / XMLport line properties
    • SourceType, as text / SourceType as Text
    • SourceType, as table / SourceType as Table
    • SourceType, as field / SourceType as Field
  • Lines FastTab connection / Page Controls
  • LinkedInTransaction property / Table properties
  • LinkFields / SourceType as Table
  • LinkTable / SourceType as Table
  • LinkTableForceInsert / SourceType as Table
  • List page / List page
  • list pages
    • about / List pages
    • creating / Creating a List page
  • ListParts, page part / CardParts and ListParts
  • ListPlus page / ListPlus page
  • list report
    • creating / Creating a List Report
    • about / Report types summarized
  • local symbols
    • about / C/AL Symbol Menu
  • locking / Locking
  • look and feel attribute / Page Design Guidelines

M

  • MaintainSIFTIndex property / SumIndexFields
  • Make to Order (MTO)
    • about / Manufacturing
  • Make to Stock (MTS)
    • about / Manufacturing
  • management codeunits / Management codeunits
  • MARKEDONLY function
    • about / MARKEDONLY function
    • syntax / MARKEDONLY function
  • MARK function
    • about / MARK function
    • syntax / MARK function
  • Master table / Master
  • MaxOccurs property / NodeType of Element
  • MenuSuite Designer / MenuSuite Designer
    • Create Item… (Insert) / MenuSuite Designer
    • Insert Items…(Shift + Insert) / MenuSuite Designer
    • Create Group (Ctrl + Insert) / MenuSuite Designer
    • Delete (Delete) / MenuSuite Designer
    • Rename (F2) / MenuSuite Designer
    • Move Up (Ctrl + Shift + Up) / MenuSuite Designer
    • Move Down (Ctrl + Shift + Down) / MenuSuite Designer
    • Cut (Ctrl + X) / MenuSuite Designer
    • Copy (Ctrl + C) / MenuSuite Designer
    • Paste (Ctrl + V) / MenuSuite Designer
    • Properties (Alt + Enter) / MenuSuite Designer
  • MenuSuite object / Departments page
  • MenuSuites
    • about / NAV object types, MenuSuites
  • MESSAGE / Debugging with MESSAGE and CONFIRM
  • MESSAGE, non-modifiable functions / Non-modifiable functions
  • MESSAGE function / The MESSAGE function
  • mibuso.com NAV forum
    • URL / Navigation Pane and Action Menus
  • Microsoft Dynamics NAV 2013 Help Toolkit
    • about / Customizing Help
  • Microsoft Dynamics Sure Step Methodology tools / User Interface
  • MinOccurs property / NodeType of Element
  • modifiable functions
    • about / Modifiable functions
  • MODIFYALL function
    • about / MODIFYALL function
    • syntax / MODIFYALL function
  • MODIFY function
    • about / MODIFY function, MODIFYALL function
    • syntax / MODIFY function
    • Rec variable / Rec and xRec
    • xRec variable / Rec and xRec
  • MOD statement
    • syntax / Arithmetic operators and functions
  • Move Down (Ctrl + Shift + Down) / MenuSuite Designer
  • Move Up (Ctrl + Shift + Up) / MenuSuite Designer
  • MSDN Library / Page Design Guidelines
  • MSDN library
    • URL / Developing in NAV 2013 – hands-on
  • MSDN NAV Team blog / Chart part
  • multi-currency system / Multi-currency system
  • multi-language system
    • about / Multi-language system
    • basic element / Multi-language system
  • MultiLine property / Field controls
  • MultipleNewLines property / Page properties

N

  • name property / Page properties
  • Namespace Identifier / XMLport properties
  • naming conventions
    • C/AL / Some C/AL naming conventions
  • NAS
    • about / NAV Application Server (NAS)
  • NAV
    • data type / Basic definitions
    • fundamental data type / Basic definitions
    • complex data type / Basic definitions
    • Data Element / Basic definitions
    • Constant / Basic definitions
    • variable / Basic definitions
    • report designers / Two NAV report designers
    • report types / NAV report types
    • date and time functions / Date and Time functions, TODAY, TIME, and CURRENTDATETIME functions, WORKDATE function, DMY2DATE and DWY2DATE functions, CALCDATE function
    • formatting functions / Data conversion and formatting functions, ROUND, FORMAT function, EVALUATE function
    • data conversion functions / Data conversion and formatting functions, ROUND, FORMAT function, EVALUATE function
    • FlowField SumIndexField functions / FlowField SumIndexField functions, SETAUTOCALCFIELDS function, CALCFIELDS and CALCSUMS comparison
    • process flow control functions / Flow control, REPEAT-UNTIL, FOR-TO or FOR-DOWNTO, CASE-ELSE statement, WITH-DO statement, EXIT function
    • input and output functions / Input and Output functions, INSERT function, MODIFY function, MODIFYALL function, DELETEALL function
    • filtering functions / Filtering, GETFILTER and GETFILTERS functions, FILTERGROUP function, CLEARMARKS function
    • system / NAV process flow
    • process flow / NAV process flow
  • NAV 2013
    • about / NAV 2013 – an ERP system
    • modifications / Significant changes for NAV 2013
    • developer's overview / A developer's overview of NAV 2013
    • object types / NAV object types
    • scenario, for development exercises / Our scenario for development exercises
    • application design / Getting started with the application design
    • application tables / Application tables
    • pages / Pages
    • documentation / Backups and documentation
    • backups / Backups and documentation
    • pages, structure / NAV 2013 Page structure
    • queries / Queries
    • reports / Reports, What is a report?
    • reports, creating / Creating a Report in NAV 2013, Learn by experimentation
    • Role Center Page / Role Center pages
    • debugging / Debugging in NAV 2013
    • supporting material / Supporting material
  • NAV 2013 Debugger
    • about / The new NAV 2013 Debugger
    • activating / Activating the Debugger
    • attaching, to session / Attaching the Debugger to a Session
    • break events, creating / Creating break events
    • Debugger window / The Debugger window
    • code change, while debugging / Changing the code while debugging
  • NAV 2013 ERP
    • overview / NAV 2013 – an ERP system
    • Financial Management / Financial Management
    • Manufacturing / Manufacturing
    • Supply Chain Management (SCM) / Supply Chain Management (SCM)
    • Business Intelligence (BI) / Business Intelligence and reporting (BI)
    • reporting / Business Intelligence and reporting (BI)
    • Relationship Management (RM) / Relationship Management (RM)
    • Service Management (SM) / Relationship Management (RM)
    • Human Resource management (HR) / Human Resource management (HR)
    • Project Management / Project Management
  • NAV CRONUS demonstration / Creative plagiarism
  • NAV data entry
    • keyboard shortcuts / Object Designer navigation
  • NAV development projects
    • general guidance / NAV development projects – some general guidance
    • data-focused design / Data-focused design
    • needed data views, defining / Defining the needed data views
    • data tables, designing / Designing the data tables
    • user data access interface, designing / Designing the user data access interface
    • data validation, designing / Designing the data validation
    • data design review / Data design review and revision
    • posting processes, designing / Designing the Posting processes
    • supporting processes, designing / Designing the supporting processes
  • navigate
    • about / Navigate
    • modifying for / Modifying for Navigate
  • Navigate function / Posted Document
  • NavigatePage page / NavigatePage
  • navigation departments button / Navigation Departments Button
  • Navigation Home Button / Navigation Home Button
  • Navigation Pane, pages / NAV 2013 Page structure
  • navigation pane, Role Center Page
    • about / Navigation Pane and Action Menus, Navigation Pane
    • Action Designer / Action Designer
    • navigation home button / Navigation Home Button
    • navigation departments button / Navigation Departments Button
    • other buttons / Other Navigation Buttons
  • Navigation Pane Button actions / Navigation Pane Button actions
  • NAV interfaces
    • about / Other Interfaces
    • automation controller / Automation Controller
    • linked data sources / Linked data sources
  • NAV Manufacturing
    • about / Manufacturing
    • functions / Manufacturing
  • NAV processing
    • interobject communication / InterObject communication, Communication via data, Communication via object calls
  • NAV RDLC Report
    • structure / Report structure
    • elements / Report structure
  • NAV Role Tailored Client / Actions Summary
  • NAV system
    • about / NAV process flow
    • initial setup / NAV process flow, Initial setup and data preparation
    • transaction entry / NAV process flow, Transaction entry
    • validation / NAV process flow
    • posting / NAV process flow
    • utilization / NAV process flow
    • maintenance / NAV process flow
    • Journal Batch, posting / Testing and posting the Journal Batch
    • Journal Batch, testing / Testing and posting the Journal Batch
    • data, maintaining / Utilizing and maintaining the data
    • data, utilizing / Utilizing and maintaining the data
  • negative testing / C/SIDE Test-driven development
  • new C/AL routines
    • about / Creating new C/AL routines
    • creating / Creating new C/AL routines
    • callable functions / Callable functions
    • management codeunits / Management codeunits
  • NewDocumentItems SubType / Page Action Types and Subtypes
  • new page wizard / New Page Wizard
  • NextDate function / Codeunit 359 – Period Form Management
  • NEXT function / FIND ([Which]) options and the SQL Server alternates
    • about / NEXT function with FIND or FINDSET
    • syntax / NEXT function with FIND or FINDSET
  • NextStep parameter / Codeunit 358 – Date Filter-Calc
  • non-modifiable functions
    • examples / Non-modifiable functions
  • numeric data
    • integer / Numeric data
    • decimal / Numeric data
    • option / Numeric data
    • boolean / Numeric data
    • BigInteger / Numeric data
    • Char / Numeric data

O

  • 9006 - Order Processor / Role Center pages, Role Center structure
  • Object Designer
    • about / C/SIDE
  • Object Designer, C/SIDE
    • about / Object Designer
    • new object, starting / Starting a new object
    • Table Designer, accessing / Accessing the Table Designer
    • Page Designer, accessing / Accessing the Page Designer
    • Report Dataset Designer, accessing / Accessing the Report Dataset Designer
    • Codeunit Designer, accessing / Accessing the Codeunit Designer
    • Query Designer, accessing / Query Designer
    • XMLport Designer / XMLport Designer
    • MenuSuite Designer / MenuSuite Designer
    • navigation / Object Designer navigation
    • objects, exporting / Exporting objects
    • objects, importing / Importing objects
  • object designer tool icons
    • about / Object Designer tool icons
  • object numbers
    • about / NAV object and system elements
  • objects
    • exporting / Exporting objects
    • importing / Importing objects
  • Object Type field / MenuSuite Designer
  • object types, NAV
    • about / NAV object types
    • tables / NAV object types
    • pages / NAV object types
    • reports / NAV object types
    • codeunits / NAV object types, Codeunits
    • queries / NAV object types, Queries
    • XMLports / NAV object types, XMLports
    • MenuSuites / NAV object types, MenuSuites
  • OnControlAddin trigger / Client Add-ins
  • OnDelete() trigger / Table triggers
  • OnInitXMLport(),XMLport triggers / XMLport triggers
  • OnInsert
    • about / NAV object and system elements
  • OnInsert() trigger / Table triggers
  • OnLookup() trigger / Field triggers
  • OnModify() trigger / Table triggers
  • OnNextRecord
    • about / NAV object and system elements
  • OnOpenPage
    • about / NAV object and system elements
  • OnPostXMLport(),XMLport triggers / XMLport triggers
  • OnPreXMLport(),XMLport triggers / XMLport triggers
  • OnQueryClosePage trigger / Page Triggers
  • OnRename() trigger / Table triggers
  • OnValidate() trigger / Field triggers
  • operators / Expressions
    • about / Operators
    • Arithmetic operators / Arithmetic operators and functions
    • Boolean operators / Boolean operators
    • Relational operators / Relational operators and functions
    • precedence / Precedence of operators
  • Option-specific properties
    • OptionString / Field properties
    • OptionCaptionML / Field properties
    • OptionCaption / Field properties
  • OptionCaptionML property / Field controls
  • OptionCaption property / Field controls

P

  • Page 9006 ribbon layout / Creating a WDTU Role Center Ribbon
  • Page 9060 - SO Processor Activities / Cue Groups and Cues
  • page actions
    • about / Page Actions
    • types / Page Action Types and Subtypes
    • subtypes / Page Action Types and Subtypes
    • groups / Action Groups
    • ActionContainer properties / Action Properties
    • navigation pane button action / Navigation Pane Button actions
    • summary / Actions Summary
  • page controls
    • about / Page Controls
    • types / Control Types
  • page controls, types
    • container controls / Container controls
    • group controls / Group controls
    • field controls / Field controls
  • page control triggers
    • about / Page Control triggers
    • bound pages / Bound and Unbound Pages
    • unbound pages / Bound and Unbound Pages
  • Page Designer
    • accessing / Accessing the Page Designer
  • page part, controls
    • about / Page Part controls
    • SubPageView / Page Part controls
    • SubPageLink / Page Part controls
    • ProviderID / Page Part controls
    • PartType / Page Part controls
    • PagePartID / Page Part controls
    • SystemPartID / Page Part controls
    • ChartPartID / Page Part controls
  • PagePartId property / Role Center activities page
  • PagePartID property / Page Part controls
  • page parts, Role Center Page
    • about / Page Parts
    • visibility / Page Parts not visible
    • charts / Page Part Charts
    • for user data / Page Parts for user data
  • pages
    • about / NAV object types, Pages
    • list pages / List pages
    • card pages / Card pages
    • document pages / Document pages
    • Journal/Worksheet pages / Journal/Worksheet pages
    • standard elements / Standard elements of pages
    • design / Page Design and Structure Overview
    • design, guidelines / Page Design Guidelines
    • structure / NAV 2013 Page structure
    • Travel Buttons / NAV 2013 Page structure
    • Title Bar / NAV 2013 Page structure
    • Address Bar / NAV 2013 Page structure
    • Global Command Bar / NAV 2013 Page structure
    • FilterPane / NAV 2013 Page structure
    • Ribbon / NAV 2013 Page structure
    • Search Field / NAV 2013 Page structure
    • Navigation Pane / NAV 2013 Page structure
    • Status Bar / NAV 2013 Page structure
    • Content Area / NAV 2013 Page structure
    • FactBox Pane / NAV 2013 Page structure
    • types / Types of pages
    • parts / Page parts
    • names / Page names
    • designer / Page Designer
    • new page wizard / New Page Wizard
    • components / Page Components
    • triggers / Page Triggers
    • properties / Page properties
    • preview tool / Page Preview tool
    • inheritance / Inheritance
  • pages, names
    • about / Page names
  • pages, parts
    • FactBox Area / FactBox Area
    • CardParts / CardParts and ListParts
    • ListParts / CardParts and ListParts
    • charts / Charts
  • pages, properties
    • about / Page properties
    • ID property / Page properties
    • name property / Page properties
    • CaptionML property / Page properties
    • Caption property / Page properties
    • editable property / Page properties
    • description property / Page properties
    • permissions property / Page properties
    • PageType property / Page properties
    • CardPageID property / Page properties
    • RefreshOnActivate property / Page properties
    • PromotedActionCategoriesML property / Page properties
    • SourceTable property / Page properties
    • SourceTableView property / Page properties
    • ShowFilter property / Page properties
    • DelayedInsert property / Page properties
    • MultipleNewLines property / Page properties
    • SaveValues property / Page properties
    • AutoSplitKey property / Page properties
    • SourceTableTemporary property / Page properties
  • pages, types
    • Role Center page / Role Center page
    • List page / List page
    • Card page / Card page
    • Document page / Document page
    • ListPlus page / ListPlus page
    • Worksheet (Journal) page / Worksheet (Journal) page
    • ConfirmationDialog page / ConfirmationDialog page
    • StandardDialog page / StandardDialog page
    • NavigatePage page / NavigatePage
    • special pages / Special pages
    • request page / Request page
    • departments page / Departments page
  • PageType property / Page properties
  • parentheses / Assignment and punctuation
  • parentheses ( ) / Operators
  • PartType property / Page Part controls
  • Paste (Ctrl + V) / MenuSuite Designer
  • PDF
    • about / Interactive report capabilities
  • permissions property / Page properties, XMLport properties
  • Permissions setup data / An overview of tables
  • plagiarism
    • about / Creative plagiarism
  • Playlist Header
    • data fields / Playlist Header Validations
  • Playlist Line
    • data fields / Playlist Line validations
  • Playlist Subform page
    • creating / Creating the Playlist Subform page
  • positive testing / C/SIDE Test-driven development
  • Post Code field / Adding field validation to a table
  • PostCode Global Variable definition / Adding field validation to a table
  • Post Code maintenance / Adding field validation to a table
  • Post Code OnValidate trigger / Adding field validation to a table
  • Posted Document type / Posted Document
  • posting
    • about / NAV functional terminology
  • posting report
    • about / NAV report types, Report types summarized
  • preview tool, pages
    • about / Page Preview tool
  • process flow control functions
    • about / Flow control
    • REPEAT-UNTIL / REPEAT-UNTIL
    • WHILE-DO / WHILE-DO
    • FOR-TO / FOR-TO or FOR-DOWNTO
    • FOR-DOWNTO / FOR-TO or FOR-DOWNTO
    • CASE-ELSE / CASE-ELSE statement
    • WITH-DO / WITH-DO statement
    • QUIT / QUIT function
    • BREAK / BREAK function
    • EXIT / EXIT function
    • SKIP / SKIP function
  • Processing-Only reports
    • about / Processing-Only reports
  • Processing Only reports / What is a report?
  • Project Management
    • about / Project Management
    • functions / Project Management
  • PromotedActionCategoriesML property / Page properties
  • Promoted Actions Categories / Promoted Actions Categories
  • PromotedCategory property / Action Properties
  • PromotedIsBig property / Action Properties
  • promoted property / Action Properties
  • properties
    • about / NAV object and system elements
  • Properties (Alt + Enter) / MenuSuite Designer
  • properties, query objects
    • OrderBy / Query properties
    • TopNumberOfRows / Query properties
    • ReadState / Query properties
  • properties option / Role Center structure
  • ProviderID property / Page Part controls
  • public service announcements (PSAs) / Our scenario for development exercises
  • punctuation / Assignment and punctuation

Q

  • queries
    • about / NAV object types, Queries, Queries
    • benefits / Queries
    • building / Building a simple Query
  • Query Designer / Query Designer
  • Query Line
    • DataItem properties / The DataItem properties
    • Column properties / Column properties
    • Filter properties / Filter properties
  • query objects
    • about / Queries
    • benefits / Queries
    • properties / Query properties
  • questions / Review questions, Review questions
  • QuickEntry property / Field controls
  • QUIT function
    • about / QUIT function

R

  • 21 Role Centers / Role Center pages
  • Radio Show List page / Page properties
  • range operator / Operators
  • RDLC Report
    • about / Report components – overview
  • read-only tables
    • virtual / Virtual
  • ReadByRecID method / Exposing a web service
  • read method / Exposing a web service
  • ReadMultiple method / Exposing a web service
  • records
    • about / NAV object and system elements
  • RecordSeparator property / XMLport properties
  • Rec variable / Rec and xRec
  • Reference table / Reference tables
  • RefreshOnActivate property / Page properties
  • register
    • about / NAV functional terminology
  • Register table / Register
  • register tables / Testing and posting the Journal Batch
  • regression testing / C/SIDE Test-driven development
  • RelatedInformation SubType / Page Action Types and Subtypes
  • Relational operators / Relational operators and functions
  • Relationship Management (RM)
    • about / Relationship Management (RM)
    • functions / Relationship Management (RM)
  • Rename (F2) / MenuSuite Designer
  • REPEAT-UNTIL control
    • about / REPEAT-UNTIL
  • REPEAT-UNTIL control structure / FIND ([Which]) options and the SQL Server alternates
  • repeater property / Group controls
  • report
    • about / What is a report?
    • components / Report components – detail
    • creating, in NAV 2013 / Creating a Report in NAV 2013, Learn by experimentation
    • testing / Test the completed report
  • report data
    • overview / Report data overview
    • flow / Report data flow
  • Report Dataset Designer
    • accessing / Accessing the Report Dataset Designer
  • Report Definition Language Client-side (RDLC)
    • about / Two NAV report designers
  • Report Designer
    • about / Two NAV report designers
  • report designers, NAV / Two NAV report designers
  • reporting
    • about / Business Intelligence and reporting (BI)
  • Report Layout
    • about / Report Layout overview
    • overview / Report Layout overview
  • report layout
    • about / Layout the new report body
  • Report Request Page / Report data overview
  • reports
    • about / NAV object types, Reports
    • naming / Report naming
    • structure / Report structure
    • runtime rendering / Runtime rendering
  • reports, building
    • phase 1 / Report building – phase 1
    • phase 2 / Report building – phase 2
    • phase 3 / Report building – phase 3
    • inheritance / Inheritance
  • Reports SubType / Page Action Types and Subtypes
  • report triggers
    • about / Report triggers
    • Documentation() / Report triggers
    • OnInitReport() / Report triggers
    • OnPreReport() / Report triggers
    • OnPostReport() / Report triggers
  • report types, NAV
    • about / NAV report types
    • document / NAV report types, Report types summarized
    • transaction / NAV report types, Report types summarized
    • test / NAV report types, Report types summarized
    • posting / NAV report types, Report types summarized
    • list / Report types summarized
  • ReqFilterFields / SourceType as Table
  • ReqFilterHeading / SourceType as Table
  • ReqFilterHeadingML / SourceType as Table
  • Request Page
    • about / Request Page
    • defining / Defining the Request Page
    / XMLport Request Page
  • request page / Request page
  • Request Page option
    • adding / Add a Request Page option
  • Request Page properties
    • about / Request Page properties
  • Request Page triggers
    • about / Request Page triggers
  • RESET function / Initialization
    • about / RESET function
    • syntax / RESET function
  • Return Value tab / Creating a function
  • ReVision
    • for NAV / Exporting objects
  • Ribbon, pages / NAV 2013 Page structure
  • Ribbon tabs / Page Actions
  • RoleCenterArea SubType / Role Center structure
  • Role Center Page
    • about / Role Center pages
    • 21 Role Centers / Role Center pages
    • structure / Role Center structure
    • system part / System Part
    • page parts / Page Parts
    • navigation pane / Navigation Pane and Action Menus
    • action ribbon / Navigation Pane and Action Menus
    • Action Designer / Action Designer
  • Role Center page
    • about / User Interface
    / Role Center page
  • Role Center Page, structure
    • about / Role Center structure
    • representation / Role Center structure
    • layout / Role Center structure
    • activities page / Role Center activities page
    • Cue Groups / Cue Groups and Cues
    • Cues / Cue Groups and Cues
    • Cue source table / Cue source table
    • Cue Group Actions / Cue Group Actions
  • Role Tailored Client
    • about / Significant changes for NAV 2013
  • ROUND function
    • about / ROUND
    • syntax / ROUND
  • RowSpan property / Field controls
  • RTC / Role Tailored Client filter access
  • RTC (Role Tailored Client) / Creating a List Report
  • RunObject property / Action Properties
  • RunPageLink property / Action Properties
  • RunPageMode property / Action Properties, Cue Group Actions
  • RunPageOnRec property / Action Properties
  • RunPageView property / Action Properties

S

  • 9005 - Sales Manager / Role Center pages
  • sample application, enhancing
    • about / Enhancing our sample application
    • tables, modifying / Creating and modifying tables
    • tables, creating / Creating and modifying tables
    • Table Relation property, assigning / Assigning a Table Relation property
    • InitValue property, assigning / Assigning an InitValue property
    • few activity-tracking tables, adding / Adding a few activity-tracking tables
    • WDTU project, tables / New tables for our WDTU project
    • WDTU project, list pages / New list pages for our WDTU project
    • SIFT / Keys, SumIndexFields, and table relations in our examples
    • secondary fields / Secondary keys and SumIndexFields
    • table relations / Table relations
    • standard table, modifying / Modifying a standard table
    • version list documentation / Version list documentation
  • sample data
    • creating / Creating some sample data
  • SaveValues property / Page properties
    • about / Request Page properties
  • scope operator / Operators
  • Search Description field / Field Groups
  • Search Field, pages / NAV 2013 Page structure
  • SearchTarget, text variable / Assignment and punctuation
  • SearchValue, text variable / Assignment and punctuation
  • Service Management (SM)
    • about / Relationship Management (RM)
    • functions / Relationship Management (RM)
  • service metadata (EDMX) document / Exposing a web service
  • SETAUTOCALCFIELDS function
    • about / SETAUTOCALCFIELDS function
    • syntax / SETAUTOCALCFIELDS function
  • SETCURRENTKEY function / The SETCURRENTKEY function
    • about / Filtering
  • SETFILTER function / The SETFILTER function
    • about / SETFILTER function
    • syntax / SETFILTER function
  • SETRANGE function / The SETRANGE function
    • about / Filtering
  • Setup table / Setup
  • Shift + F4 / Object Designer navigation
  • ShortCutKey property / Action Properties
  • ShowAsTree property / Group controls
  • ShowCaption property / Field controls, WDTU Client Add-in
  • ShowFilter property / Page properties
  • SIFT / SumIndexFields
  • significant modifications, for NAV 2013
    • about / Significant changes for NAV 2013, Other areas
    • application changes / Application changes
    • client enhancements / Client enhancements
    • development tools / Development tools
  • single quotes / Assignment and punctuation
  • SKIP function
    • about / SKIP function
  • SLEEP command / Locking
  • Sort (Shift + F8) / Development Environment filter access
  • SourceExpr / Page Controls
  • SourceField / SourceType as Field
  • SourceTable / SourceType as Table
  • SourceTable property / Page properties
  • SourceTableTemporary property / Page properties
  • SourceTableView / SourceType as Table
  • SourceTableView property / Page properties
  • SourceType, as Field
    • about / SourceType as Field
    • SourceField / SourceType as Field
    • FieldValidate / SourceType as Field
    • AutoCalcField / SourceType as Field
  • SourceType, as Table
    • SourceTable / SourceType as Table
    • VariableName / SourceType as Table
    • SourceTableView / SourceType as Table
    • ReqFilterHeading / SourceType as Table
    • ReqFilterHeadingML / SourceType as Table
    • CalcFields / SourceType as Table
    • ReqFilterFields / SourceType as Table
    • LinkTable / SourceType as Table
    • LinkTableForceInsert / SourceType as Table
    • LinkFields / SourceType as Table
    • temporary / SourceType as Table
    • AutoSave / SourceType as Table
    • AutoUpdate / SourceType as Table
    • AutoReplace / SourceType as Table
  • SourceType, as Text
    • TextType / SourceType as Text
    • variable name / SourceType as Text
  • SQL Server Indexed Views / SumIndexFields
  • StandardDialog page / StandardDialog page
  • standard elements, pages / Standard elements of pages
  • Status Bar, pages / NAV 2013 Page structure
  • storage variables
    • about / Special working storage variables
    • temporary tables / Temporary tables
    • arrays / Arrays
    • initialization / Initialization
    • system-defined variables / System-defined variables
  • string data
    • text / String data
    • code / String data
  • STRMENU function / The STRMENU function
  • Strong Key Name (SNK) / WDTU Client Add-in
  • STRPOS, non-modifiable functions / Non-modifiable functions
  • SubPageLink property / Page Part controls
  • SubPageView property / Page Part controls
  • SubType RelatedInformation / Action Designer
  • SubType value / Page Action Types and Subtypes
  • Supply Chain Management (SCM)
    • about / Supply Chain Management (SCM)
    • functions / Supply Chain Management (SCM)
  • symbol table
    • about / C/AL Symbol Menu
  • system-defined variables, storage variables / System-defined variables
  • System Date
    • about / NAV object and system elements
  • system part, Role Center Page
    • about / System Part
  • SystemPartID property / Page Part controls
  • System table
    • about / System
    • system data variety, tracking / System

T

  • T-SQL statements
    • about / Queries
  • table
    • about / An overview of tables
    • advantages / An overview of tables
    • components / Components of a table
    • naming / Naming a table
    • numbering / Table numbering
    • properties / Table properties
    • Table - Properties / Table properties
    • triggers / Table triggers
    • keys / Keys
    • SumIndexFields / SumIndexFields
    • types / Types of tables
    • field validation, adding / Adding field validation to a table
  • Table Data / An overview of tables
  • table definition / An overview of tables
  • Table Designer
    • accessing / Accessing the Table Designer
  • table fields
    • modifying / Modifying table fields
  • Table Filter(Ctrl+F7) / Development Environment filter access
  • TableRelation property / Field triggers
  • Table Relation property
    • assigning / Assigning a Table Relation property
  • tables
    • designing / Designing a simple table
    • creating / Creating a simple table
    • field groups / Field Groups
  • TableSeparator property / XMLport properties
  • table types
    • fully modifiable tables / Fully Modifiable tables
    • content modifiable tables / Content Modifiable tables
    • read-only tables / Read-only tables
  • Template table / Template
  • temporary / SourceType as Table
  • Temporary table / Temporary
  • temporary tables, storage variables / Temporary tables
  • Test-driven development
    • about / C/SIDE Test-driven development
    • advantages / C/SIDE Test-driven development
    • Test Running Codeunits / C/SIDE Test-driven development
    • C/AL Testability feature / C/SIDE Test-driven development
    • steps / C/SIDE Test-driven development
  • testability / C/SIDE Test-driven development
  • TESTFIELD function
    • about / TESTFIELD
    • syntax / TESTFIELD
    • advantages / TESTFIELD
  • testing
    • database testing approaches / Database testing approaches
    • in production / Testing in production
    • database, using / Using a testing database
    • techniques / Testing techniques
  • Testing Best Practices / Dialog function debugging techniques
  • TestIsolation property / C/SIDE Test-driven development
  • TestMethodType property / C/SIDE Test-driven development
  • test report
    • about / NAV report types, Report types summarized
  • Text Constants tab / Other local identifiers
  • TextEncoding option / XMLport properties
  • text objects, C/SIDE
    • about / Text objects
    • practices / Some useful practices
    • data definitions, changing / Changing data definitions
    • saving / Saving and compiling
    • compiling / Saving and compiling
    • C/AL naming conventions / Some C/AL naming conventions
  • TextType / SourceType as Text
  • The Req. Worksheet
    • about / Journal/Worksheet pages
  • TIME function
    • about / TODAY, TIME, and CURRENTDATETIME functions
    • syntax / TODAY, TIME, and CURRENTDATETIME functions
  • Title Bar, pages / NAV 2013 Page structure
  • TODAY function
    • about / TODAY, TIME, and CURRENTDATETIME functions
    • syntax / TODAY, TIME, and CURRENTDATETIME functions
  • ToolTipML property / Action Properties
  • ToolTip property / Action Properties
  • transaction entry, NAV system / Transaction entry
  • transaction report
    • about / NAV report types, Report types summarized
  • transactions / Journal
  • TransactionType property / XMLport properties
  • Travel Buttons, pages / NAV 2013 Page structure
  • trigger local variables / Other local identifiers
  • triggers
    • about / NAV object and system elements
    • documentation / NAV object and system elements
    • functions / NAV object and system elements
  • triggers, pages
    • about / Page Triggers
  • Type to filter / Role Tailored Client filter access

U

  • unbound pages / Bound and Unbound Pages
  • update method / Exposing a web service
  • UpdateMultiple method / Exposing a web service
  • updating
    • about / Updating and upgrading
    • design / Design for updating
  • upgrading plan
    • about / Plan for upgrading
    • benefits / Benefits of upgrading
  • URN (Uniform Resource Name) / XMLport properties
  • UseDefaultNamespace property / XMLport properties
  • UseLax property / XMLport properties
  • UseRequestForm property / XMLport properties
  • user interface
    • about / User Interface
  • UX Guide / Page Design Guidelines
  • UX Guidelines
    • about / UX (User Experience) Guidelines

V

  • VALIDATE function
    • about / VALIDATE
    • syntax / VALIDATE
  • ValidatePostCode function / Adding field validation to a table
  • validation functions, C/AL
    • about / Validation functions
    • TESTFIELD / TESTFIELD
    • FIELDERROR / FIELDERROR
    • INIT / INIT
    • VALIDATE / VALIDATE
  • validation logic
    • adding, to WDTU application / Adding validation logic, Playlist Header Validations
  • ValueX entries / The ERROR function
  • Var column / Creating a function
  • variable / Basic definitions
  • variable name / SourceType as Text
  • VariableName / SourceType as Table
  • variable numbering / Field and Variable naming
  • variables, C/SIDE
    • about / Variables, Expressions
    • C/AL Globals / C/AL Globals
    • C/AL Locals / C/AL Locals
    • storage variables, working / Special working storage variables, Temporary tables
  • Virtual table / Virtual
  • visible property / Group controls, Field controls
  • Visual Studio Report Designer
    • about / Two NAV report designers
  • Visual Studio Report Designer (VS RD) / Report data overview
  • Visual Studio Report properties
    • about / Visual Studio Report properties

W

  • WDTU application
    • enhancing / Enhancing the WDTU application
  • WDTU application, enhancing
    • about / Enhancing the WDTU application
    • table fields, modifying / Modifying table fields
    • validation logic, adding / Adding validation logic, Playlist Header Validations
    • Playlist Subform page, creating / Creating the Playlist Subform page
    • function, creating / Creating a function
    • FactBox page, creating / Creating a FactBox page
  • WDTU Client Add-in / WDTU Client Add-in
  • WDTU Page Enhancement
    • about / WDTU Page Enhancement – part 1
    • part 2 / WDTU Page Enhancement – part 2
  • WDTU project
    • tables / New tables for our WDTU project
    • list pages / New list pages for our WDTU project
  • WDTU Role Center Ribbon
    • creating / Creating a WDTU Role Center Ribbon
    • Page 9006 ribbon layout / Creating a WDTU Role Center Ribbon
    • Promoted Actions Categories / Promoted Actions Categories
    • Action Groups / Action Groups
    • configuration / Configuration/Personalization
    • personalization / Configuration/Personalization
  • WDTU Role Center Ribbon, Role Center Page
    • creating / Creating a WDTU Role Center Ribbon
  • WDTU_mp3 / WDTU Client Add-in
  • web service
    • about / Web services
    • benefits / Web services
    • disadvantages / Web services
    • exposing / Exposing a web service
    • methods / Exposing a web service
    • create method / Exposing a web service
    • CreateMultiple method / Exposing a web service
    • read method / Exposing a web service
    • ReadMultiple method / Exposing a web service
    • update method / Exposing a web service
    • UpdateMultiple method / Exposing a web service
    • delete method / Exposing a web service
    • IsUpdated method / Exposing a web service
    • ReadByRecID method / Exposing a web service
    • GetRecIDFromKey method / Exposing a web service
    • publishing / Publishing a web service
    • integration, example / XMLport – web services integration example
  • Web Services Description Language (WSDL) / Determining what was published
  • Which parameter option / FIND ([Which]) options and the SQL Server alternates
  • WHILE-DO control
    • about / WHILE-DO
  • Width property / Field controls, NodeType of Element
  • WITH-DO statement
    • about / WITH-DO statement
  • Work Date
    • about / NAV object and system elements
  • WORKDATE function
    • about / WORKDATE function
    • syntax / WORKDATE function
  • Working Storage
    • about / Report data overview
  • Worksheet (Journal) page / Worksheet (Journal) page
  • Worksheet pages
    • about / Journal/Worksheet pages

X

  • XML
    • about / XMLports, XMLports
  • XML Format Evaluate / XMLport properties
  • XMLport, triggers
    • Documentation() / XMLport triggers
    • OnInitXMLport() / XMLport triggers
    • OnPreXMLport() / XMLport triggers
    • OnPostXMLport() / XMLport triggers
  • XMLport Designer / XMLport Designer
  • XMLports
    • about / NAV object types, XMLports, XMLports
    • components / XMLport components
    • properties / XMLport properties
    • triggers / XMLport triggers
    • data lines / XMLport data lines
    • line properties / XMLport line properties
    • element data item / Element or Attribute
    • attribute data item / Element or Attribute
    • line triggers / XMLport line triggers
    • Request Page / XMLport Request Page
  • XMLports, properties
    • about / XMLport properties
    • ID property / XMLport properties
    • name property / XMLport properties
    • caption property / XMLport properties
    • CaptionML property / XMLport properties
    • direction property / XMLport properties
    • DefaultFieldsValidation property / XMLport properties
    • Encoding (or TextEncoding) property / XMLport properties
    • TextEncoding option / XMLport properties
    • XMLVersionNo option / XMLport properties
    • XML Format Evaluate property / XMLport properties
    • UseDefaultNamespace property / XMLport properties
    • DefaultNamespace property / XMLport properties
    • InlineSchema property / XMLport properties
    • UseLax property / XMLport properties
    • format property / XMLport properties
    • FileName property / XMLport properties
    • FieldDelimiter property / XMLport properties
    • FieldSeparator property / XMLport properties
    • RecordSeparator property / XMLport properties
    • TableSeparator property / XMLport properties
    • UseRequestForm property / XMLport properties
    • TransactionType property / XMLport properties
    • permissions property / XMLport properties
  • XMLVersionNo / XMLport properties
  • xRec variable / Rec and xRec

Y

  • YELLOW Location entry / Role Tailored Client filter access
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image