Shortcut Key − A keystroke or keystroke combination that moves to another
screen or function within Navision.
Sort − The ability to change the order in which records are displayed or printed.
SQL − Structured Query Language.
Status Bar − Located at bottom of the application window; it shows the name
and contents of the active field, work date, user ID, and whether a filter
(FILTER), insert (INS), or overwrite (OVR) mode is on.
System Date − The date of your computer.
Table − A table consists of a group of related records, each record is made up of
fields and each field holds one piece of information; one example of a table is the
entire listing of Vendor records. One of seven Object types in Navision.
Object Designer − The interface used to modify or design additional forms,
reports, tables, dataports and codeunits.
Objects − The building blocks of Navision. There are seven types of objects:
Forms, Tables, Reports, Dataports, Codeunits, XMLports, and the MenuSuite.
ODBC − An acronym for Open Database Connectivity. ODBC enables Navision
to be linked and data copied to Excel, Crystal Reports, etc.
Option Button − A circular field which serves to select only one option from
those listed. Clicking in this field indicates the desired choice.
Option List − One of four types of AssistButtons. The Option List is a short,
predefined list from which the user selects the desired choice.
Order − An original entry document in Purchases and Sales allowing
information to be recorded and posted for purposes of recording amounts due
to/from Vendors and Customers. Orders differ from Invoices in that Receiving
and/or Shipping are done from an Order.
Master Item − The primary table in a granule, around which that granule
functions. For instance, Customers are the Master Item in Sales; Vendors in
Purchases; and Contacts in Marketing.
Menu Bar − Located just below the Title Bar; this standard Windows feature
contains pull-down menus to select functions such as creating new companies,
design tools, and help.
Menu Button − Have a downward-pointing triangle on them and they are found
on the majority of windows. When clicked, they display a menu from which you
can, for example, select a function, open a different window or open a submenu.
MenuSuite − The MenuSuite object contains the menus that are displayed in the
Navigation Pane and in the Navigation Pane Designer. Each menu contains
content for a specific departmental area, for example, Finance or Manufacturing.
One of seven Object types in Navision.
Ellipsis Button − One of the four types of AssistButtons. Ellipsis Buttons are
used to view system-filtered options.
Field − Used to enter or display information; consists of a field name, definition
and field contents.Field Filter − A filter that is set on a single field in a table, limiting the amount
of information displayed or printed.
Filters − A tool that allows the user to limit the scope of information presented
online or in printed format; the three filters are Field, Table and Flow.
Active − Used to describe the window or button that is being used or is selected.
Only one window or one button can be active at a time. When a window is
active, the color of the title bar changes to assist you in determining which
window is active. When a button is active, the name changes color.
Application Area − One of the main functional areas of the program in which a
user selects to work, e.g. General Ledger, Inventory, etc.
Application Window − The window in the program on which the rest of the
work in the program is based. In Navision, it is the empty area where all
windows are opened, and where the program, company and database names
appear, as well as the menu bar and Toolbar.
Arrow Keys − A group of keys on the keyboard used to move up, down, to the
right and to the left; these keys can be used instead of the mouse to move through
AssistButton − One of four buttons that are accessed using the F6 function key;
Drill-down, Look Up, Options and Ellipsis.
Backup − A file you create which contains a copy of your data.
Batch job − A routine that processes selected entries according to general or
specific guidelines. Examples include Close Income Statement.
BLOB − An acronym for Binary Large Object, used to store bitmaps such as a
Boolean − A data type that is used to indicate one of two values: TRUE or
FALSE; a typical use may be in a Check Box field.
There are three basic types of information which are important in Navision:
* Stock data
* Transaction data
* Calculated data
* What is Stock data – Stock data is the type of data that, in principle, should never change. The name and tax ID of your firm for example are types of stock data. Another example would be the names and account numbers of your Chart of Accounts. Stock data is the information backbone of the daily business and should rarely change. In Microsoft Navision this type of information is usually presented in the file card type view, like the customer or item cards for example.
* What is Transaction data – Transaction data is the information type that records the history of your daily business activities. It is called transaction data because it is continually growing with every movement of your accounts and is usually presented in a table view. The table view is excellent for transaction data because it shows you many records in a chronological list which helps you see the timeline of
movements. Examples of transaction data in Microsoft Navision include: the Chart of Accounts postings, the inventory postings and customer payments.
*What is Calculated data – Calculated data is where stock and transaction data types meet—where we find the sum of changes or movements associated with a standard product. For example, in the Item Card where the inventory movements of an item are shown in the Inventory field. We find another calculation field in the Customer Card
where the customer’s actual account balance (the sum of all payments and charges) is shown. This type of data is always current and actual in Microsoft Navision and can be found everywhere, including table views and file cards. When you click on
such a field and the arrow that appears, the information that Microsoft Navision used to arrive at its calculation is immediately opened.
* Print (Ctrl+P) – This button only functions when you are viewing a printable report.
* Page View- This button functions to execute a viewable report.
* Cut (Ctrl+X) – With this function you can remove and save information selected
from within fields (or many selected records simultaneously) to
the Windows clipboard for pasting into Microsoft Navision or
other applications like Microsoft Excel.
* Copy (Ctrl+C) – This functions just like the Cut function except that it does not
remove the information it copies to the clipboard.
* Undo (Ctrl+Z) – This function will reverse your action in a field before you have
left that field (ESC will do the same).
# Paste (Ctrl+V) – This function enters contents to the clipboard into the area you
# Insert (F3) – This function will open a new, empty record into a table.
# Delete (F4) – This function deletes a selected record from a table.
# Search (Ctrl+F) – This function opens the search, find and replace window.
# Field Filter (F7) – With this function you can limit what records you retrieve from
the database with Microsoft Navision filter keys. (We will go into
great detail about this important tool later).
# Table Filter (Ctrl+F7)- With this function you can view, add to and/or remove all the
filters in a table that limit the records Microsoft Navision can retrieve.
# Flow Filter(Shift+F7)- This function shows which filters determine the values in calculated fields, such as an account balance or total sales.
# Sorting (Ctrl+F8)- This button opens the Sorting window and shows you what options
are available to sort the records in a table.
# First, Previous,Next, Last – These buttons allow you to toggle through the records in a table.
# List (F5)- This button displays the table view of the file card you are currently
in. If the file card does not have a table view it is possible
to create one.
# Help (F1) – When you have a question about a Microsoft Navision feature
you can select the object and press the F1 function button on
your keyboard. Not every feature contains help in the documentation,
however, most are covered.
C/FRONT: This is an application programming interface that allows you to develop applications in other programming languages to access a Microsoft NAV database, either the C/SIDE Database Server or the Microsoft SQL Server.
The primary component of C/FRONT is a library of callable C functions, which provide access to every aspect of data storage and maintenance. This allows creation of custom components written in C, C++, VB, Delphi, and the Visual Studio.NET languages as well as other languages that support compatible calling conventions. C/FRONT is only tested by Microsoft for use with code built using either the Watcom C or Microsoft C++ compilers. C/AL triggers cannot be invoked via C/FRONT code.
C/FRONT comes as a set of files to be installed guided by the instructions given in the C/FRONT manual.
C/SIDE: Client/Server Integrated Development Environment is the development tool specified for using C/AL. It includes the language editor, compiler, debugger, reports and form generators and code management tools.
Almost all the C/AL development is done within C/SIDE without the use of external tools. For most application development, NAV is entirely self sufficient except for those services provided by the Windows operating systems. It is possible, though generally not recommended, to write code using a text editor and then import it into C/SIDE.