Simple tool to replace a string or character in Microsoft Dynamics NAV

Ever got a task to replace a string or character in a string in Microsoft Dynamics NAV but unable to find the simplest solution for this problem.

Don't worry I have a simple solution for this task.

How to make a line discount in Dynamics Nav 2013 R2

Hello readers,
Today i am going to tell  you about " How to make a line discount in Dynamics Nav 2013 R2

Line Discount : Line discount is a simple discount on a particular item like '10 % off ' or 'Rs. 10 off'.
It's depends upon your requirement whether to use discount percentage or discount amount .

Scenario : I want to give 10 %  off on item named 'Butter' whose MRP is " Rs. 100" , after 
10 % discount it will become "Rs. 90".

Steps : 

1). First go to "Microsoft Dynamics NAV 2013 R2 Development Environment " and open Page "Discount Offer".

2 ). Press "New" to create a new discount offer.

As shown below:

3). Fill the fields In 'General' Tab'. 

As shown below:

• No. : This will be your unique Discount ID.

• Description : To recognize your discount.

• Price Group : To make valid this discount for a particular price group.

• Priority : To decide your priority to make your discount valid among other enabled discounts.(Lowest priority will be activated first)

• Validation Period Id : This will decide your discount validation period in which you can select a specific Date and time period for your discount.

After filling these fields go to next step


4). Now go to 'Lines'  Tab and fill the following details

As shown below:

• Type : In this field you can Select Item,Item category,Product group,All and Special group.

• No : Specify Item no here.

• Disc % : Specify discount  percentage.

Others options are also available like Triggers, Settings, Benefits, Additional Benefits and Store Group .If you want to know about these options also , Just comment below to let me know.


5). Now Click 'Enable' to activate your Discount offer

As shown below:

6). You can Test your discount in "Test Offer" in 'Action' Tab, As shown below:

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


Thanks for reading

Shubin Dongre

FlowField V/S FlowFilter in Dynamics Nav

People always ask this question "What is difference between FlowField and FlowFilter ? " in Dynamics Nav.

Lets find out here.

You can find both FlowField And FlowFilter in Fieldclass property of a table's field.

As shown below:

FlowField is a type of Fieldclass property in Dynamics Nav table's field,which shows the output of the calculation mentioned in the CalcFormula Property. Eg the Inventory field in the Item table shows the total of the quantity of an item and is calculated as the sum of the Quantity field for all entries in the Item Ledger Entry table for an particular item.

As per MSDN You can use FlowFields to do the following:

• Calculate the total of a field over a set of records and display the results.
• Calculate averages.
• Determine the existence of records in a table.
• Determine the number of values in a table.
• Determine the minimum value.
• Determine the maximum value.
• Look up a value in another column in another table.

FlowFilter is a also a type of Fieldclass property  in Dynamics Nav table's field, which is use to set ranges on the calculations that are calculated in FlowFields. Eg if the FlowField contains the total inventory of an item, then you can use a FlowFilter to see the total for a period of time slot like month, day etc. 

Note : Both FlowField And FlowFilter are virtual fields. Thats why at the time of data extraction from SQl Server, both will be not extracted.

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

Thanks for reading

Shubin Dongre

.Zup file In Dynamics NAV

Ever wondered why we get pop up "Do you want to replace the .zup file" on closing of Dynamics NAV Development Environment and what does it mean,

Lets Clear out here.

.Zup File :  All setup parameters that are responsible for running Dynamics NAV Development Environment are stored in .Zup file , which has default name fin.zup .

Locations:

• Windows XP :  C:\Documents and Settings\<Username>\Application Data.

• Windows 7 and up :  C:\users\<User name>\AppData\Roaming\ .

.Zup File contains:

• Database name.

• Database server name.

• All parameters defined in Options window.

• User-specified personalization of development environment windows, such as window size, window position, column order, column visibility, and column width.

Why it's not a good practice to replace .Zup file :


When we are working on more than one Databases of Dynamics Nav  on a same PC  e.g. Database 'A' and Database 'B'.When i will open Database 'A' a .Zup file be created for the same which contain user setup information for Database 'A' . And when i will open Database 'B' ,at the time of closing it will pop up "Do you want to replace the .Zup file"  .

• If Click 'Yes' : It will replace the .Zup file and makes a new one for Database 'B.

• If Click 'No' : It will not change user setup information in .Zup file.

Issue resolution for .Zup File :

Any issue occurs regarding .Zup file in Dynamics Nav , best to delete the .Zup file because a fresh file will created again .

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

Thanks for reading,

Shubin Dongre

Code coverage tool for Microsoft Dynamics Nav 2013 R2

We all are missing code coverage tool in Microsoft Dynamics Nav 2013 R2 that we have used in Microsoft Dynamics Nav 2009 R2 and older versions to make debugging simple, Code Coverage  is a tool which shows the executed code of functions.

Microsoft launched "Application Test Toolset for Microsoft Dynamics NAV 2013", in this set of tools you can find code coverage also.

If you want to download whole set of "Application Test Toolset for Microsoft Dynamics NAV 2013" you can follow this link.

To download only  Code Coverage  tool you can follow MIBUSO link.


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

I will share more posts regarding other tools for "Application Test Toolset for Microsoft Dynamics NAV 2013"  in future.


Till then happy coding!



Thanks for reading,

Shubin Dongre

How to save license in Microsoft Dynamics Nav 2013 R2

Its a tedious task for developers to upload license file in  Microsoft Dynamics Nav 2013 R2 again and again.You can save license file in your Microsoft Dynamics Nav 2013 R2 database permanently by just clicking one option "Save license in Database".
You can find this option in "Microsoft Dynamics NAV 2013 R2 Development Environment"

Steps are follows:

1). Open"Microsoft Dynamics NAV 2013 R2 Development Environment".


2). Then Open your respective Database in which you want to save the license.


3). Go to  "File" >> "Database"  >>  "Alter".

As you can see in screenshot below:

4).A new window will appear  "Alter database" , In which you have to go to "Integration"   Tab

and put a tick on "Save license in Database"  option.

As you can see in screenshot below:

Now you are free to work without uploading license again and again.

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 Define a Temporary table in Microsoft Dynamics Nav

Temporary Table : A temporary variable that’s carry a table is called temporary table. It is basically used as a buffer  in C/AL programs for table data. Temporary table can be used in a same way as a database table is used. Temporary table is only present in the memory till the table is open.

Advantage: 

All the exchange with a temporary table only occurs on client side. If you want to perform a large amount of calculations, a temporary table can used to load the data. This will increase processing speed because all the operations are processed on the client.

How to define a temporary table:

1). Click on Tools >> Object Designer>> create a new table.

2). Then go to View >> C/AL Globals or C/AL Locals. If you  have selected   C/AL Globals, the C/AL Globals window appears.

3). Write a name for the temporary table variable, and select Record as the data type ,Select the desired table in Subtype field.

4). Select your variable line and click View>> Properties, It display the Properties window.

5). Make the value of the Temporary property to Yes.

After you have successfully created a temporary table, you can use it in your C/AL code.

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

Thanks for reading

Shubin Dongre

Error : “The license information on the Microsoft Dynamics NAV Database Server is invalid.”

Facing the following error while accessing 2013 R2 RTC : “The license information on the Microsoft Dynamics NAV Database Server is invalid.”

Follow the steps mentioned below:

1. Open ‘Microsoft Dynamics NAV Development Environment‘.

2. Go to ‘Tools‘ and select ‘License information‘ option.

3. Click ‘Upload‘ button.

4. Select your respective license file (.flf).

5. Open ‘Microsoft Dynamics NAV Server Administration Tool‘.

6. Restart Instance for updation of changes.

7. Restart ‘Microsoft Dynamics NAV Development Environment‘.

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

Thanks for reading,

Shubin Dongre