CorporateServe Solution Navision Technical Consultant Interview Questions and Answers

Setrange and Setfilter are methods used in Navision to filter records in a table.

• Setrange is used to set a single filter on a field, while Setfilter is used to set multiple filters on multiple fields.

• Setrange can only be used on primary keys or indexed fields, while Setfilter can be used on any field.

• Setrange can only be used to filter for equality, while Setfilter can be used for various types of filters like range, w...read more

There are three types of keys in Navision: Primary Key, Foreign Key, and Unique Key.

• Primary Key: A primary key is a unique identifier for a record in a table. It ensures that each record is unique and can be used to establish relationships with other tables.

• Foreign Key: A foreign key is a field in a table that refers to the primary key of another table. It establishes a relationship between two tables.

• Unique Key: A uni...read more

Grouping in Navision allows for categorizing and organizing data based on common attributes.

• Grouping can be done on various fields such as customer, vendor, item, etc.

• Grouping can be used for reporting and analysis purposes.

• Grouping can also be used to set up permissions and access levels for different groups of users.

• Example: Grouping customers by region or salesperson to analyze sales performance.

• Example: Grouping it...read more

Triggers, reports, pages, and tables are key components in Navision development.

• Triggers are used to execute code before or after certain events occur in a table.

• Reports are used to present data in a structured format for printing or viewing.

• Pages are used to create user interfaces for data entry, modification, and display.

• Tables store and organize data in Navision, serving as the foundation for other components.

Properties of pages and tables in Navision

• Pages in Navision are used to display and interact with data

• Tables in Navision store the data

• Pages have properties like SourceTable, Caption, and PageType

• Tables have properties like TableType, DataPerCompany, and DataCaption

• Pages and tables can have triggers and actions associated with them