Interview Questions.

Question 1. Difference B/w Two Tier And Three Tier Architecture In Navision?

Answer :

Two Tier Architecture

DB Server<-data-> Client
all needed information from DB are despatched to the customer which procedure them
All uncooked records from DB must be transferred to the Client in order to procedure them and display them.
Three Tier Architecture

DB Server <-data-> Service tier <-results/inputs-> Client
Client sends "best" a few request for information, carrier tier study data from DB server, procedure them and only the asked end result is despatched to the purchaser.
Question 2. What Is Delayed Insert Property?

Answer :

Sets a fee that specifies whether a must consumer leaves a report earlier than it's far inserted into the database. By default, new statistics are inserted whilst the consumer leaves the control.

Microsoft Excel Interview Questions
Question 3. What Is Totalscausedby Function (record)?

Answer :

Determines which subject induced a set overall to be calculated. This determines which subject modified contents and thereby concluded a set. This characteristic can handiest be utilized in group header and group footer sections.

Set Range - putting variety (or filtering to at least one unique value if just one parameter entered)

Set Filter - setting any filter you may input in NAV

Question 4. What Is "records Per Company Property"?

Answer :

Sets a cost that shows whether the desk data applies to all companies within the Database or handiest the current organisation.

When you put the belongings "DataPerCompany" to FALSE, the information can be "Common to All Companies".

Microsoft Excel Tutorial
Question five. Differences Between Set Range And Set Filter?

Answer :

Set range is faster than set filter out.
Set variety accepts only a selection (From value, to fee)
Set filter accepts handiest parameters in string format.
Set filter has extra features then set range.
SETFILTER will restrict the statistics returned while doing a FIND. GETFILTER will return the clear out string implemented to the sector you skip to it. It's only a textual content price.
Microsoft Word Interview Questions
Question 6. What Is Blob: (binary Large Object)?

Answer :

Used to shop bitmaps and memos. Max length may be 2 GB.

FINDSET: for buying more than one records, you must loop thru them

FINDFIRST: for getting handiest the primary document in the filter out, just one document

FINDLAST: for purchasing handiest the closing file within the clear out, simply one file

Question 7. What Is A Dimension And A Dimension Value?

Answer :

A size is facts that you could upload to an access as a kind of marker in order that the Program can institution entries with similar characteristics and easily retrieve those organizations for analysis functions. Dimensions may be used throughout this system on entries in journals and documents, in addition to budgets.

Dimensions and size values are person defined and limitless, this means that you can create dimensions tailor-made to your employer's desires and business approaches.

Microsoft Word Tutorial Microsoft Powerpoint Interview Questions
Question eight. What Is Autosplitkey?

Answer :

Autosplitkeys is a shape property that routinely generates key values for number one keys that stop with an integer kind discipline.

Question nine. What Is Transheader & Transfooter?

Answer :

Transheader ought to be printed earlier than the first line of its information object on each page but the first.

Transfooter ought to be revealed after the final line of the records item on each web page however the remaining.

Microsoft Dynamics CRM Interview Questions
Question 10. How To Check The User Name Who Locked The Table?

Answer :

This is due to the fact at equal time two distinct customers are trying to modify the values in equal table. For the integerity and safety of data, Navision might not allow multiple users to alter the values in identical desk at a time.

Microsoft Powerpoint Tutorial
Question 11. What Is Autosplitkey Property ()?

Answer :

It is mechanism in Navision to generate more than a few between a previous and next report.

Microsoft Silverlight Interview Questions
Question 12. What Is Import Worksheet?

Answer :

The Import Worksheet is one of the few paperwork which you can not layout in Dynamics NAV that is used in the course of binary import of objects. If the import record contains simplest gadgets which can be both new or had been updated, they'll be imported. If, however, one or extra gadgets with the same ID Property exist already, a selection must be made approximately what to do. The Import Worksheet shows information about both present and new objects, and we could you decide a way to take care of conflicts.

Microsoft Excel Interview Questions
Question thirteen. What Is Role Center?

Answer :

Role Centre is one of the maximum appealing capabilities available in the cutting-edge of Microsoft Dynamics NAV 2009. Basically, a Role Centre is designed to help users by identifying the precise roles performed of their everyday life. It improves the user friendliness of the ERP system via offering them a top level view of the obligations and information applicable to their process and helps to devise their daily work

Role middle Configuration and Personalization: The difference among configuration and personalization is that configuring a Role Centre changes the user interface for all users with the identical profile, whereas personalizing a Role Centre only modifications the user interface for a unmarried user. This means that configuration is something performed by means of the System Administrator or the System Manager ordinarily at implementation time, while Personalization is some thing finished by means of the character users depending on the priorities of their everyday life and it'll now not affect the position centres of different users.

To be able to configure a Role Centre, you should satisfy the followings;

You should be an administrator with the role SUPER.
You need to be the owner of the precise Role Centre
Microsoft Dynamics CRM Tutorial
Question 14. Difference Between Tracking And Tracing?

Answer :

Item Tracking is used to track Serial / Lot facts on Items for Inbound or Outbound entries. Item tracing is used to trace the Serial / Lot no. That has been posted within the transactions as to in which it has been used.

Question 15. Google Maps - Show In Map / Show Route In Customer Or Vendor Card?

Answer :

I discovered how to show consumer/vendor addresses in Google maps without typing the address manually inside the browser.

Just upload a button with this code within the on push trigger to the client/dealer card.

HYPERLINK ('http://www.Google.De/maps?F=q&hl=en&q=' +Address+' '+"Post Code"+' '+City);

Microsoft Outlook Interview Questions
Question 16. How To Disable Zoom (ctrl+f8) From A Form?

Answer :

Just add a new Menu Button to the form, and add a new alternative. Caption may be whatever you need, for example "Disable Shortcut Key". Then outline the Shortcut Key to Ctrl+F8, but do now not define any research action. This will override the default Ctrl+F8 behaviour. What I did is to resize this new Menu Button small enough so I can hide it at the back of one of the other current Buttons at the form (use Format->Send to Back to cover it).

Microsoft Silverlight Tutorial
Question 17. What Are The Web Services?

Answer :

Page Web Services: When a web page is exposed as a Web carrier, a default set of operations is exposed to builders for you to manipulate commonplace record coping with operations consisting of Create, Read, Update, and Delete. Page-primarily based Web services offer integrated positive concurrency management. Each operation name in a page-primarily based Web provider is managed as a unmarried transaction.

Codeunit Web Services: Codeunit Web offerings provide you with the maximum manipulate and flexibility. When a codeunit is exposed as a Web service, no default set of operations is exposed. You can determine which operations are to be had on a codeunit.

Microsoft Entity Framework Interview Questions
Question 18. What Are Virtual Tables?

Answer :

Virtual Tables work in the identical manner as everyday tables with the difficulty being which you can not regulate the statistics. Virtual Tables are not saved in the database as ordinary tables, however are computed at run-time. Virtual tables can not be edited via Web services despite the fact that they're editable in Microsoft Dynamics NAV.

Microsoft Word Interview Questions
Question 19. Transfer Orders Vs Item Reclass Journal?

Answer :

Transfer Order is a process so it involves physical true transferred from one area to any other with transit time, cargo date, receiving dates and so on. Item reclass magazine is more like an adjustment than anything else.

In the older variations of Navision, Transfer Order did no longer exist, so the only manner to switch items from 1 location to every other changed into the Item reclass magazine.

Purchase/Sales in Item magazine: it is viable to put up purchases/income with out an order for it. For the moment, I do not assume anyone is still using it. Everyone uses Purchase/Sales orders.

Microsoft Entity Framework Tutorial
Question 20. Item Reclass Vs Item Movement?

Answer :

Item Movements are for the movement among packing containers inside a warehouse region where you're the use of Directed Put-Away and Pick

Item Reclassification is used for a variety of reasons consisting of:

Movements among bins inside a region with packing containers but isn't always setup as Directed Put-Away and Pick
simple transfers between locations where transport and receiving aren't required
measurement modifications to Item Ledger Entries
Microsoft Azure Interview Questions
Question 21. Is Dimension Set In Item Card? Will Reclass Alter New Information In Item Card?

Answer :

Reclass will not regulate object card, It will create two ledger entries to alter your item.

Question 22. When You're Talking About Item Movement, Are You Talking About Transfer Order Or Warehouse Movement?

Answer :

Basically both 'Movement' and Reclass can be used to adjust/reclass your object ledger entries facts (size, area, and bin).

The distinction is that Movement has a right record (receipt and cargo), however your paintings is also boom due to the fact you need to do receipt and shipment for every item movement.

If you don't need to control receipt and shipment, then reclass is tons less difficult in terms of labor load and records.

Microsoft Azure Tutorial
Question 23. Send A Background Email When Any User Unblock An Item Card?

Answer :

Here is the simple software interior Item Card, "Blocked - OnValidate()"

IF (Rec.Blocked = xRec.Blocked ) OR (Blocked = TRUE ) THEN EXIT;

CurrPage.UPDATE;

Smail.CreateMessage( ......... );

SmailSent; //Smail is Codeunit SMTP Mail.

Microsoft Project Interview Questions
Question 24. Make A Field Editable On A Non-editable Form?

Answer :

There is a touch trick to make a subject EDITABLE on a NON-EDITABLE shape which is to feature this code to the sector you need to still have get right of entry to to.

OnActivate() CurrForm.EDITABLE(TRUE); OnDeactivate() CurrForm.EDITABLE(FALSE);

When you are on that field the form becomes editable again & when you depart it , it once more locks down.

Microsoft Powerpoint Interview Questions
Question 25. How To Restrict Workdate For Several Users

Answer :

Create a New singleinstance codeunit. This codeunit you have to release in Codeunit 1 Function LogInStart(). Globals :

recUserSetup : Record : "User Setup"
autTimer : Automation : 'Navision Timer 1.0'.Timer (property WithEvents=Yes)

OnRun() of your singleinstance codeunit:

IF ISCLEAR(autTimer) THEN BEGIN
CREATE(autTimer);
autTimer.Interval(three * a thousand); // check each three seconds
autTimer.Enabled(TRUE)
END;
CLEAR(recUserSetup);
IF recUserSetup.Get(USERID) THEN ;

On Trigger
autTimer::Timer(Milliseconds : Integer)

IF TODAY <> WORKDATE THEN
IF NOT recUserSetup."User May Change WORKDATE" THEN BEGIN WORKDATE := TODAY;
MESSAGE('You might not exchange the WORKDATE. WORKDATE has been resetted');
END;

Microsoft Project Tutorial
Question 26. What Is Difference B/w Onaftergetrecord And Onaftergetcurrentrecord?

Answer :

"OnAfterGetCurrentRecord" is induced handiest for the cutting-edge selected report.

"OnAfterGetRecord" is brought about for ALL statistics which are shown.

Microsoft Interview Questions
Question 27. What Is Flow Field & Sum Index Field?

Answer :

Flow discipline:

It is a effective characteristic of C/facet database device.
Underlying idea of SIFT that increase overall performance.
Flow subject information does no longer receives stored within the information base.
Sum Index Field Technology(SIFT):

It is a decimal field that may be connected to key definition. Fundamental feature of Navision database that forms foundation for flowfeilds. Fast calculations.
There may be a most of 40 keys to a desk.
Primary key can be composed of 20 fields in a report.
Single Instance CodeUnit
Microsoft Dynamics CRM Interview Questions