Index

A

• About This Page function
  • using / Using About This Page and About This Report
  • using, permission assigning for / Assigning permission to use the About This Page function
  • for subform page / About This Page for subform page
  • for report / About This Page for report
• About This Report
  • using / About This Report, There's more...
• activities / How it works...
• AddInfoColumn function / How it works...
• Add Watch action / How it works...
• ADO
  • using, to access outside data / Using ADO to access outside data, How to do it...
• array
  • creating / Creating an array, There's more...
• automation
  • writing, C# used / Writing your own automation using C#, How to do it..., How it works...

B

• backup plan
  • setting up / Setting up a backup plan, How to do it..., There's more...
• Blocked sessions
  • from SQL, identifying / Identifying Blocked and Blocking sessions from SQL, There's more...
• Blocking sessions
  • from SQL, identifying / Identifying Blocked and Blocking sessions from SQL, There's more...
• Break on Error / Breakpoint options in the debugger
• Break on Record Changes / Breakpoint options in the debugger
• breakpoints
  • setting / Setting breakpoints, How to do it..., How it works...
  • options, in debugger / Breakpoint options in the debugger
• Break Rules action
  • Break on Error / Breakpoint options in the debugger
  • Break on Record Changes / Breakpoint options in the debugger
  • Skip Codeunit 1 / Breakpoint options in the debugger

C

• C#
  • used, for writing automation / Writing your own automation using C#, How to do it..., How it works...
• C/AL
  • about / Introduction
  • query / Working with queries in C/AL, How it works...
• C/AL code
  • RDLC report, exporting from / Exporting an RDLC report from C/AL code
  • used, for writing to file / Writing to and reading from a file using the C/AL code, How it works...
  • used, for reading from file / Writing to and reading from a file using the C/AL code, How it works...
• C/SIDE
  • about / Introduction
• CAL
  • about / Introduction
• CALCDATE() function / How it works...
• CALCDATE NAV function / Using the date formula to calculate dates
• CalcNumberOfPeriods() function / There's more...
• Call Stack window / How it works...
• Cartesian products
  • about / Cross join
• CASE statement
  • using, to test multiple conditions / Using the CASE statement to test multiple conditions, How it works...
• ChangeCustomerName function / How it works..., How it works...
• ChangeCustomerNameRef function / How it works...
• chart
  • adding, to page / Adding a chart to the page, How to do it...
• charts
  • creating, with Visio / Creating charts with Visio, How to do it..., There's more...
• CheckCreditCardData() function / There's more...
• code
  • repeating, loop used / Repeating code using a loop, How to do it..., There's more...
• communication / How to do it...
• companies
  • data, retieving from / Retrieving data from other companies, How it works...
• conditions
  • checking, IF statement used / Checking for conditions using an IF statement, How to do it...
• CopyHere function / How it works...
• CreateBookAndOpenExcel function / How it works...
• CREATE function / How it works..., How it works...
• cross join
  • about / Cross join
• CSV (Comma Separated Values) format / Exporting Sales Invoices in the CSV format
• CSV format
  • sales invoices, exporting / Exporting Sales Invoices in the CSV format
• CURRENTDATETIME function / How it works..., There's more...
• CurrPage.UPDATE command / How it works...
• Customer table / How it works...
• Customer variable / How it works...

D

• data
  • retrieving, FIND statement used / Retrieving data using the FIND and GET statements, How to do it..., How it works...
  • retrieving, GET statement used / Retrieving data using the FIND and GET statements, How to do it..., How it works...
  • retrieving, from FlowField / Retrieving data from FlowField and SumIndexField, How it works...
  • retrieving, from SumIndexField / How it works...
  • retrieving, from other companies / Retrieving data from other companies, How it works...
  • extracting, query used / Using a query to extract data, How to do it..., How it works...
  • processing, by report creation / Creating reports to process data, How it works..., There's more...
  • sending, to Microsoft Word / Sending data to Microsoft Word, How it works...
  • exporting, Excel buffer used / Exporting data using the Excel Buffer, How it works...
  • connection creating from Excel, NAV used / Creating data connection from Excel to NAV, How to do it...
  • showing in Excel, PowerPivot used / Showing data in Excel using PowerPivot, How to do it..., How it works...
  • showing in Excel, PowerPoint used / How to do it...
  • sending, through FTP / Sending data through FTP, How to do it..., How it works..., There's more...
  • displaying, from SQL view / Displaying data from a SQL view in NAV, How to do it..., How it works..., There's more...
• database
  • new database, creating / Creating a new database, How to do it..., There's more...
• database, NAV
  • testing / How to do it..., How it works...
• data in process
  • displaying / Displaying the progress bar and data in process
• DataPerCompany property / How it works..., How it works...
• data type
  • string, converting to / Converting a string to another data type, There's more...
• data types
  • about / Introduction
• date formula
  • using, to calculate dates / Using the date formula to calculate dates, How it works...
• dates
  • calculating, date formula used / Using the date formula to calculate dates, How it works..., There's more...
• day
  • from given date, retrieving / Determining the day, month, and year from a given date, How it works...
• debugger
  • using / Using the debugger, How to do it..., How it works..., There's more...
  • breakpoint, options / Breakpoint options in the debugger
• decimal field
  • totals, adding on / How to do it..., How it works...
• decimal values
  • rounding / Rounding decimal values, How to do it..., How it works...
• DecomposeRowID() function / There's more...
• Development Environment / Introduction
• dialog
  • about / How it works...
• Document report
  • about / Introduction
• DT2DATE function / How it works...
• DT2TIME function / How it works..., There's more...

E

• Enable property / How it works...
• ENVIRON command / How it works...
• ENVIRON function / Working with environmental variables
• environmental variables
  • about / Working with environmental variables, How to do it..., How it works...
• EOS (End of Stream) function / How it works...
• ERP
  • about / Introduction
• errors
  • finding, NAS used / Finding errors while using NAS, How it works...
• EVALUATE() function / How it works..., There's more...
• Excel
  • to NAV, data connection creating from / Creating data connection from Excel to NAV, How to do it...
  • report, printing in / Printing a report in a PDF, Excel, and Word format, How it works...
• Excel buffer
  • used, for exporting data / Exporting data using the Excel Buffer, How to do it..., How it works...
• external applications
  • running, SHELL used / Using SHELL to run external applications, How it works...
• external files
  • opening, HYPERLINK used / Using HYPERLINK to open external files, How it works...

F

• FactBox page
  • creating / Creating a FactBox page, How to do it..., How it works...
• FastTabs / How it works...
• FDB
  • about / Introduction
• Field-level security
  • about / Field-level security, How to do it...
  • working / How it works...
• file
  • browsing for / Browsing for a file, How it works...
  • access permissions, checking / Checking file and folder access permissions, How to do it...
  • zipping, with NAV / Zipping folders and files within NAV, How it works...
  • writing to, C/AL code used / Writing to and reading from a file using the C/AL code, How it works...
  • reading, from C/AL code used / Writing to and reading from a file using the C/AL code, How it works...
• FILTERGROUP function
  • about / Using the FILTERGROUP function
  • using / How to do it..., How it works...
• filtering
  • about / Advanced filtering, How it works...
• filters
  • applying, on lookup page / Applying filters on the lookup page, How to do it..., How it works...
  • custom filters, adding to Request Page / Adding custom filters to the Request Page, How to do it..., How it works..., There's more...
  • setting, on report loading / Setting filters when report is loaded, There's more...
• FINDFIRST function / How it works...
• FIND function / How it works...
• FINDSET function / How it works...
• FIND statement
  • used, for retrieving data / Retrieving data using the FIND and GET statements, How to do it..., How it works...
• FlowField
  • adding / Adding a FlowField, How it works...
  • data, retrieving from / Retrieving data from FlowField and SumIndexField, How it works...
• folder
  • browsing for / Browsing for a folder, How it works..., There's more...
  • access permissions, checking / Checking file and folder access permissions, How to do it...
• folders
  • zipping, with NAV / Zipping folders and files within NAV, How it works...
• FORMAT function / Converting a value to a formatted string, How it works...
• formatted string
  • value, converting to / How to do it..., How it works..., There's more...
• FTP
  • data, sending through / Sending data through FTP, How to do it..., How it works...
• full outer join
  • about / Full outer join
• functions
  • rounding / Creating functions, How it works...
  • private functions, creating / Creating local or private functions
  • local functions, creating / Creating local or private functions

G

• Get-Command *NAVServer* command / Using Microsoft Dynamics NAV Administration Shell
• Get-Help <cmd name> command / Using Microsoft Dynamics NAV Administration Shell
• Get-Help Get-NAVServerInstance command / Using Microsoft Dynamics NAV Administration Shell
• GetCustomer function / How it works...
• GET function / How it works...
• GetNumberOfYears() function / There's more...
• GET statement
  • used, for retrieving data / Retrieving data using the FIND and GET statements, How to do it..., How it works...

H

• HTML-formatted e-mail
  • sending / Sending an HTML-formatted e-mail
• HYPERLINK
  • using, to open external files / Using HYPERLINK to open external files, How it works..., There's more...

I

• IBAN (International Bank Account Number) / There's more...
• IF statement
  • used, for checking conditions / Checking for conditions using an IF statement, How it works...
  • nested / The nested IF statement
• index
  • reorganizing / There's more...
  • rebuilding / There's more...
• InfoPath form
  • creating, for NAV data / Creating an InfoPath form for the NAV data, How to do it..., How it works...
• information
  • sharing, through XML ports / Sharing information through XMLports, How it works...
• inner join
  • about / Inner join
• InsertLogEntry() method / There's more...
• interactive sorting
  • adding, on reports / How to do it..., How it works...
• Inventory field / How it works...

J

• Job Queue
  • running, NAS configured / Configuring NAS to run Job Queue, How it works..., See also

K

• key
  • adding, to table / Adding a key to a table, How it works...
• KILL spid command / There's more...

L

• left outer join
  • about / Left outer join
• license
  • changing / Changing the NAV license, How it works..., There's more...
• License Information window / How it works...
• link
  • creating, from report to page / Creating a link from report to page, How to do it..., There's more...
  • creating, from report to report / How to do it..., How it works...
• List report
  • about / Introduction
• LoadRSS function / How it works...
• lookup page
  • filters, applying / Applying filters on the lookup page, How it works..., There's more...
• loop
  • used, for repeating code / Repeating code using a loop, How to do it..., There's more...
  • WHILE loop, using / Using a WHILE loop
  • REPEAT..UNTIL loop, using / Using a REPEAT..UNTIL loop

M

• mail
  • sending from NAV, through SMTP / Sending an e-mail from NAV through SMTP, How it works...
• MARK function / Storing records to be processed
• matrix report
  • creating / Creating a matrix report, How to do it..., How it works...
• Microsoft Dynamics NAV 2013 Administration Shell / Introduction
• Microsoft Dynamics NAV Administration / Introduction
• Microsoft Dynamics NAV Administration Shell
  • using / Using Microsoft Dynamics NAV Administration Shell
• Microsoft Dynamics NAV Server
  • about / Introduction
• Microsoft Excel
  • URL / There's more...
• Microsoft MSDN site
  • Finance Performance, URL / There's more...
• Microsoft Office
  • about / Introduction
• Microsoft Word
  • data, sending to / Sending data to Microsoft Word, How it works...
• month
  • from given date, retrieving / Determining the day, month, and year from a given date, How it works...

N

• .NET add-in
  • displaying, on page / Displaying a .NET add-in on a page, How to do it..., How it works...
• NAS
  • used, for finding errors / Finding errors while using NAS, How to do it..., How it works...
  • configuring, to run Job Queue / Configuring NAS to run Job Queue, How it works..., See also
• NAV
  • e-mail sending from, through SMTP / Sending an e-mail from NAV through SMTP, How it works...
  • data connection, creating from Excel / Creating data connection from Excel to NAV, How to do it...
  • folders, zipping / Zipping folders and files within NAV, How it works...
  • files, zipping / Zipping folders and files within NAV, How it works...
  • data, displaying from SQL view / Displaying data from a SQL view in NAV, How to do it..., How it works..., There's more...
  • server instance, creating / Creating a NAV Server Instance, How to do it..., There's more...
  • users, creating on / Creating a user on NAV, How to do it..., How it works...
  • license, changing / Changing the NAV license, How to do it..., How it works..., There's more...
• NAV data
  • InfoPath, creating for / Creating an InfoPath form for the NAV data, How to do it..., There's more...
• NAV database
  • testing / Testing the NAV database, How to do it..., How it works...
• NAV query / There's more...
• NAV Server Instance
  • creating / Creating a NAV Server Instance, How to do it..., How it works...
  • Microsoft Dynamics NAV Administration Shell, using / Using Microsoft Dynamics NAV Administration Shell
• NewRow function / How it works...

O

• OData web service / How it works...
• OnAfterGetRecord trigger / How it works...
• OnPreDataItem trigger / How it works...
• OnRun trigger / How it works..., How to do it...
• OnValidate() trigger / There's more...
• OpenFileDialog function / How it works...
• Option field / There's more...
• OptionString property / How it works...
• option variable
  • creating / Creating an option variable, How it works..., There's more...

P

• page
  • creating, wizard used / Creating a page using a wizard, How to do it..., How it works..., There's more...
  • running, multiple options used / Using multiple options to run the page, There's more...
  • .NET add-in, displaying / Displaying a .NET add-in on a page, How to do it..., How it works...
  • chart, adding / Adding a chart to the page, How to do it..., How it works...
• Page Designer window
  • Type column / How it works...
  • SubType column / How it works...
• parameters
  • passing, by reference / Passing parameters by reference, How to do it..., There's more...
• parent page
  • subform page, updating from / Updating the subform page from a parent page, How to do it..., How it works...
• PDF
  • report, printing in / Printing a report in a PDF, Excel, and Word format, How it works...
• permission
  • assigning, to use About This Page function / Assigning permission to use the About This Page function
• Permission Set / Assigning a role to a user, How it works...
• Posting report
  • about / Introduction
• PowerPivot
  • used, for showing data in Excel / Showing data in Excel using PowerPivot, How to do it..., How it works...
  • URL, for downloading / There's more...
• precision parameter / How it works...
• Processing-only report
  • about / Introduction
• progress bar
  • displaying / Displaying the progress bar and data in process

Q

• query
  • using, to extract data / Using a query to extract data, How to do it...
  • creating, to link three tables / Creating a query to link three tables, How to do it..., How it works..., There's more...
  • in C/AL / Working with queries in C/AL, How it works...
• Queue page
  • creating / Creating a Queue page, How to do it..., How it works...

R

• RDBMS
  • about / Introduction
• RDLC
  • about / Introduction
• RDLC report
  • creating / Creating an RDLC report, How to do it..., How it works...
  • exporting, from, viewer / Exporting an RDLC report from viewer
  • exporting, from C/AL code / Exporting an RDLC report from C/AL code
• READTEXT function / How it works...
• Really Simple Syndication (RSS) / How it works...
• record / How it works...
• records
  • to processed, storing / Storing records to be processed
• recursion
  • about / Using recursion
  • using / How to do it..., There's more...
• reference
  • parameters, passing by / Passing parameters by reference, How to do it..., There's more...
• Register for COM interop property / How it works...
• registry
  • querying / Querying the registry, How to do it..., There's more...
• REPEAT..UNTIL loop
  • using / Using a REPEAT..UNTIL loop
• report
  • RDLC report, creating / How to do it..., How it works..., There's more...
  • running, multiple options used / Using multiple options to run a report, How it works...
  • loading, filters setting on / Setting filters when report is loaded, There's more...
  • creating, to process data / Creating reports to process data, How to do it..., How it works..., There's more...
  • to page, link creating / Creating a link from report to page, How to do it..., How it works..., There's more...
  • to report, link creating / Creating a link from report to report
  • interactive sorting, adding / Adding interactive sorting on reports, How to do it..., How it works...
  • matrix report, creating / How to do it..., How it works..., There's more...
  • printing, in PDF / Printing a report in a PDF, Excel, and Word format, How it works...
  • printing, in Excel / Printing a report in a PDF, Excel, and Word format, How it works...
  • printing, in Word format / Printing a report in a PDF, Excel, and Word format, How it works...
• Request Page
  • custom filters, adding / Adding custom filters to the Request Page, How to do it..., How it works..., There's more...
• right outer join
  • about / Right outer join
• role
  • assigning, to user / Assigning a role to a user, How it works...
  • new role, creating / Creating a new role, How it works...
• Role Center page
  • about / Creating a Role Center page
  • creating / How to do it..., How it works...
• RoleTailored client / There's more..., Introduction, How to do it...
• Round Function / How it works...
• RTC
  • about / Introduction
• RUNMODAL function / How it works...
• runtime errors
  • handling / Handling runtime errors, How to do it..., How it works...

S

• Sales Invoices
  • exporting, in CSV format / Exporting Sales Invoices in the CSV format
• security filter
  • using / How to do it..., There's more...
  • modes, applying / Applying security filter modes
  • disallowed value / How it works...
  • filtered value / How it works...
  • ignored value / How it works...
  • validated value / How it works...
• SELECT keyword / How it works...
• SETRANGE / How it works...
• SetValues function / How it works...
• Shape.AddPicture method / How it works...
• SHELL
  • using, to run external applications / Using SHELL to run external applications, How it works...
• SIFT
  • about / There's more..., Understanding SIFT, How it works...
• Skip Codeunit 1 / Breakpoint options in the debugger
• SMTP
  • e-mail, sending from NAV / Sending an e-mail from NAV through SMTP, How it works...
• SQL
  • Blocking sessions, identifying / Identifying Blocked and Blocking sessions from SQL, There's more...
  • Blocked sessions, identifying / Identifying Blocked and Blocking sessions from SQL, How it works..., There's more...
• SQL profiler
  • using / Using the SQL profiler, How to do it..., How it works...
• SQL query
  • about / Creating a basic SQL query
  • creating / How to do it..., There's more...
  • data, inserting / There's more...
  • data, addding / There's more...
  • data, modifying / There's more...
  • data, editing / There's more...
  • data. deleting / There's more...
• Starting Date field / There's more...
• string
  • converting, to another data type / Converting a string to another data type, How it works..., There's more...
  • contents, manipulating / Manipulating string contents, How to do it..., There's more...
• stylesheets
  • managing / Managing stylesheets, How it works...
• subform information
  • getting / How to get the subform information
• subform page
  • updating, from parent page / Updating the subform page from a parent page, How to do it..., How it works...
• SumIndexField
  • about / Creating a SumIndexField
  • creating / How to do it..., There's more...
  • data, retrieving from / Retrieving data from FlowField and SumIndexField, How it works...
• system date
  • retrieving / Retrieving the system date and time, There's more...
• system time
  • retrieving / Retrieving the system date and time, There's more...

T

• table
  • data / Introduction
  • design / Introduction
  • creating / Creating a table
  • key, adding / Adding a key to a table, How it works...
  • temporary table, using / Using a temporary table, How it works...
  • linking, by query creation / Creating a query to link three tables, How to do it..., How it works..., There's more...
• Table Data object type / How it works...
• temporary table
  • using / Using a temporary table, How it works...
• TestFolderAccess function / How it works...
• Test report
  • about / Introduction
• TIME keyword / How it works..., How it works...
• TODAY keyword / How it works...
• totals
  • adding, on decimal field / Adding totals on decimal field, How it works...
• transaction log
  • about / Maintaining the transaction logfiles, How it works...
• Transaction report
  • about / Introduction
• TRUNCATE_ONLY command / How it works...
• TypeText method / How it works...

U

• UpdateCurrencyFactor() method / There's more..., There's more...
• UpdateSelf function / How it works...
• user
  • role, assigning / Assigning a role to a user, How it works...
• users
  • creating, on NAV / How to do it..., How it works...
• user session
  • killing / Killing a user session, How it works...

V

• value
  • converting, to formatted string / Converting a value to a formatted string, How it works...
• viewer
  • RDLC report, exporting from / Exporting an RDLC report from viewer
• Visio
  • charts, creating with / Creating charts with Visio, How to do it..., There's more...
  • used, for creating charts / Creating charts with Visio, How to do it..., How it works..., There's more...
• VSIFT
  • data. deleting / How it works...

W

• web services
  • creating / Creating web services, How it works...
  • consuming / Consuming web services, How to do it..., How it works...
• WHILE loop
  • using / Using a WHILE loop
• WithEvents property / How it works...
• wizard
  • used, for creating page / Creating a page using a wizard, How to do it..., How it works..., There's more...
  • page, creating / Creating a wizard page, How to do it..., How it works...
• Word format
  • report, printing in / Printing a report in a PDF, Excel, and Word format, How it works...
• work date
  • retrieving / Retrieving the work date, How it works...
• WORKDATE function / There's more...
• WRITETEXT function / How it works...

X

• XML
  • about / Sharing information through XMLports
• XML ports
  • used, for sharing information / Sharing information through XMLports, How it works..., There's more...

Y

• year
  • from given date, retrieving / Determining the day, month, and year from a given date, How it works...

Z

• ZipFile / How it works...