Interview Questions.

Q1. What Is A Dimension And A Dimension Value?

A size is information that you can upload to an entry as a form of marker in order that the Program can institution entries with comparable characteristics and without difficulty retrieve those agencies for evaluation functions. Dimensions can be used during the program on entries in journals and documents, in addition to budgets.

Dimensions and dimension values are user described and unlimited, which me you could create dimensions tailor-made in your organisation's desires and enterprise procedures.

Q2. What Is Delayed Insert Property?

Sets a fee that specifies whether or not a have to person leaves a report earlier than it's miles inserted into the database. By default, new records are inserted when the person leaves the manipulate.

Q3. Make A Field Editable On A Non-editable Form?

There is a touch trick to make a area EDITABLE on a NON-EDITABLE shape that's to feature this code to the sector you need to still have get entry to to.

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

When you're on that discipline the form will become editable again & while you leave it , it yet again locks down.

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

Two Tier Architecture

DB Server<-data-> Client

all wanted statistics from DB are sent to the client which method them

All raw records from DB need to be trferred to the Client so as to technique them and display them.

Three Tier Architecture

DB Server <-data-> Service tier <-results/inputs-> Client

Client sends "only" a few request for information, carrier tier examine records from DB server, system them and best the asked end result is despatched to the purchaser.

Q5. Send A Background Email When Any User Unblock An Item Card?

Here is the easy 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.

Q6. Differences Between Set Range And Set Filter?

Set variety is quicker than set filter.

Set variety accepts only a variety (From value, to fee)

Set filter out accepts simplest parameters in string layout.

Set filter has more capabilities then set variety.

SETFILTER will restriction the statistics returned whilst doing a FIND. GETFILTER will go back the filter out string implemented to the sector you skip to it. It's just a text value.

Q7. What Is Role Center?

Role Centre is one of the most appealing features available in the modern-day of Microsoft Dynamics NAV 20@Basically, a Role Centre is designed to help customers by using figuring out the precise roles played of their each day existence. It improves the person friendliness of the ERP gadget by means of presenting them an outline of the duties and facts relevant to their process and facilitates to plot their day by day paintings

Role center Configuration and Personalization: The distinction among configuration and personalization is that configuring a Role Centre adjustments the person interface for all users with the identical profile, while personalizing a Role Centre best changes the person interface for a unmarried user. This me that configuration is something performed by the System Administrator or the System Manager often at implementation time, while Personalization is some thing performed by using the person customers relying on the priorities in their day to day life and it'll no longer affect the function centres of other users.

To be able to configure a Role Centre, you need to fulfill the followings;

You should be an administrator with the function SUPER.

You should be the proprietor of the unique Role Centre

Q8. How To Check The User Name Who Locked The Table?

This is because at equal time two one-of-a-kind customers are looking to modify the values in same desk. For the integerity and protection of information, Navision might not permit more than one users to alter the values in identical table at a time.

Q9. What Is Autosplitkey?

Autosplitkeys is a shape belongings that routinely generates key values for number one keys that give up with an integer type area.

Q10. What Is Trheader & Trfooter?

Trheader ought to be published before the primary line of its data object on each web page however the first.

Trfooter must be printed after the last line of the facts object on each page but the ultimate.

Q11. Item Reclass Vs Item Movement?

Item Movements are for the motion among packing containers inside a warehouse location wherein you are the use of Directed Put-Away and Pick

Item Reclassification is used for a ramification of motives together with:

Movements between containers inside a location with containers but isn't setup as Directed Put-Away and Pick

simple trfers among locations in which transport and receiving are not required

measurement adjustments to Item Ledger Entries

Q12. What Are Virtual Tables?

Virtual Tables paintings within the same manner as regular tables with the trouble being which you cannot regulate the statistics. Virtual Tables aren't stored in the database as ordinary tables, but are computed at run-time. Virtual tables cannot be edited thru Web offerings even supposing they're editable in Microsoft Dynamics NAV.

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

I found out how to reveal customer/vendor addresses in Google maps with out typing the deal with manually in the browser.

Just add a button with this code inside the on push cause to the purchaser/supplier card.

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

Q14. What Is Flow Field & Sum Index Field?

Flow discipline:

It is a effective characteristic of C/facet database device.

Underlying concept of SIFT that boom overall performance.

Flow area data does not receives stored within the records base.

Sum Index Field Technology(SIFT):

It is a decimal subject that may be attached to key definition. Fundamental characteristic of Navision database that bureaucracy basis for flowfeilds. Fast calculations.

There can be a most of forty keys to a desk.

Primary key may be composed of 20 fields in a file.

Single Instance CodeUnit

Q15. What Is Totalscausedby Function (document)?

Determines which field induced a collection overall to be calculated. This determines which area modified contents and thereby concluded a collection. This feature can simplest be used in group header and organization footer sections.

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

Set Filter - setting any filter you may input in NAV

Q16. What Is Autosplitkey Property ()?

It is mechanism in Navision to generate a number of between a preceding and subsequent record.

Q17. How To Disable Zoom (ctrl+f8) From A Form?

Just add a new Menu Button to the form, and add a brand new alternative. Caption may be something you want, for instance "Disable Shortcut Key". Then outline the Shortcut Key to Ctrl+F8, but do now not outline any research motion. This will override the default Ctrl+F8 behaviour. What I did is to resize this new Menu Button small sufficient so I can disguise it at the back of one of the different present Buttons at the form (use Format->Send to Back to hide it).

Q18. Is Dimension Set In Item Card? Will Reclass Alter New Information In Item Card?

Reclass will no longer adjust item card, It will create  ledger entries to adjust your item.

Q19. How To Restrict Workdate For Several Users

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 * 1000); // test every 3 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 won't trade the WORKDATE. WORKDATE has been resetted');

END;

Q20. Trfer Orders Vs Item Reclass Journal?

Trfer Order is a process so it involves physical proper trferred from one area to another with trit time, cargo date, receiving dates and so forth. Item reclass journal is greater like an adjustment than whatever else.

In the older versions of Navision, Trfer Order did not exist, so the best way to trfer objects from 1 vicinity to another changed into the Item reclass magazine.

Purchase/Sales in Item journal: it's far possible to submit purchases/income without an order for it. For the moment, I do not think all of us remains the use of it. Everyone uses Purchase/Sales orders.

Q21. What Is Import Worksheet?

The Import Worksheet is one of the few paperwork that you can not layout in Dynamics NAV that is used in the course of binary import of objects. If the import file includes handiest gadgets that are either new or were up to date, they will be imported. If, but, one or more objects with the same ID Property exist already, a decision have to be made about what to do. The Import Worksheet presentations information approximately both present and new items, and shall we you decide the way to take care of conflicts.

Q22. What Is "information Per Company Property"?

Sets a price that indicates whether or not the table information applies to all agencies inside the Database or simplest the contemporary company.

When you place the assets "DataPerCompany" to FALSE, the facts may be "Common to All Companies".

Q23. What Is Blob: (binary Large Object)?

Used to keep bitmaps and memos. Max size can be 2 GB.

FINDSET: for buying multiple information, you would like to loop through them

FINDFIRST: for purchasing simplest the primary report inside the filter out, simply one report

FINDLAST: for buying best the final report in the clear out, simply one record

Q24. What Are The Web Services?

Page Web Services: When a web page is uncovered as a Web carrier, a default set of operations is exposed to builders with a purpose to control not unusual file coping with operations which include Create, Read, Update, and Delete. Page-based totally Web services offer integrated constructive concurrency management. Each operation call in a page-based Web provider is managed as a single traction.

Codeunit Web Services: Codeunit Web services offer you with the maximum manipulate and flexibility. When a codeunit is exposed as a Web provider, no default set of operations is uncovered. You can decide which operations are available on a codeunit.

Q25. When You're Talking About Item Movement, Are You Talking About Trfer Order Or Warehouse Movement?

Basically both 'Movement' and Reclass can be used to modify/reclass your item ledger entries statistics (measurement, region, and bin).

The difference is that Movement has a right document (receipt and cargo), but your paintings is also increase because you want to do receipt and shipment for every item motion.

If you do not need to control receipt and shipment, then reclass is an awful lot less complicated in terms of labor load and information.

Q26. What Is Difference B/w Onaftergetrecord And Onaftergetcurrentrecord?

"OnAfterGetCurrentRecord" is precipitated most effective for the modern-day decided on file.

"OnAfterGetRecord" is triggered for ALL information that are shown.

Q27. Difference Between Tracking And Tracing?

Item Tracking is used to music Serial / Lot data on Items for Inbound or Outbound entries. Item tracing is used to trace the Serial / Lot no. That has been published in the tractions as to where it has been used.