How to use Debugger in Microsoft Dynamics NAV 2009 R2 and old Versions of Classic Client

Guidelines to use debugger in Microsoft Dynamics NAV 2009 R2 and old Versions of Classic Client :

Debugger is present in Microsoft Dynamics NAV Classic under“Tools” >> “Debugger”.

As you can see in screenshot below:

There are three options present under “Debugger” options which are:

1. Active: It will activate the Debugger. Every time an error occurs you will be redirected to Classic client Debugger Session and it will show the source of error in the code. As you can see in screenshot below:

2. Break point on Triggers: This functionality will work only if  ”Debugger” is active. If the breakpoints on trigger is active it will stop the current execution process on the point where you have marked breakpoints in code of particular trigger, Else the code will be executed normally. This is useful in understanding the flow of code through all triggers.

3. Code Coverage: The Code Coverage option allows you to check how much of the code is used by any given function. You can use this tool to capture code coverage during customization in Microsoft Dynamics NAV. This will provides you a list of objects in which you can find executed code in black colour text .

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.

Thanks for reading,

Shubin Dongre

How to optimize tables in Microsoft Dynamics Nav Classic Client

Guideline to optimize tables in Microsoft Dynamics Nav Classic Client :

Optimization process will perform two functions:

For every table of Microsoft Dynamics Nav, the SQL Server indexes, except the primary key will be reconstructed to optimize their usage and layout.

Every entry with zero values in numeric fields will be discarded for SIFT ( SumIndexField Technology  ) structure. This will increase the efficiency of SIFT which result in to fast summing of fields with huge entries.

For optimization of tables in Microsoft Dynamics Classic Client

1). Go to "File" >>  "Database" >> "Information".

      As shown in screenshot below:

2). You will see the Database Information window, in which you will find all relevant information about your database. Click on "Tables" button.

      As shown in screenshot below:

3). You will be redirected to a new window  "Database Information (Tables) " , Here you can select the desired tables you want to optimize and click "Optimize" button.

      As shown in screenshot below:

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.

Thanks for reading

Shubin Dongre