Virtual Tables in Dynamics NAV

Virtual Table : This tables store system provided information. You can use this tables as normal table , the difference is that you cannot change the information present in Virtual tables ie. Virtual Tables are only readable. Another difference is that, This tables are computed at runtime instead of storing in database as normal tables does.

How to Copy a Company in Dynamics Nav 2013 R2

Hello Readers, 

Today i am sharing a post regarding "How to Copy a Company in Dynamics Nav 2013 R2".

Microsoft added this new feature to copy a existing company in Dynamics Nav 2013 to a new one. Every time we need to create a new company while creating a new Database.Instead of making a new one you can copy a existing company also.

Here are some simple steps to do so 

Steps 

1. Open "Microsoft Dynamics NAV 2013 R2 RTC" and go to Search option and search "Companies".

As Shown below :

2. New page will open "Companies" where you can find a list of existing Companies.

As Shown below : 

 3.  Now Select the company you want to copy from the list and click "Copy".

As Shown below : 

4. A request window "Edit - Copy Company" will open,
write your new company name here and click "Ok" .

 5.  Now wait for few seconds (It may take longer according to your system performance) . After some time your Company name will reflect in the list.

As Shown below :  

6. Now you can select your company and start working on it.

Cheers, You have created your new company.

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

Thanks for Reading

Shubin Dongre

Designing Microsoft Dynamics NAV 2013 Report without Microsoft Visual Studio

Hello Readers,

I have posted earlier about Designing Nav 2013 Report with Visual Studio , today we are going to learn how to Design Report without Microsoft Visual Studio. This time we will use "Report Builder tool".

As compare to older versions of Microsoft Dynamics Nav, Making reports is so easy in Microsoft Dynamics Nav 2013 R2 .We can print our reports directly in Excel sheet , Word file and PDF formats that was not available in older versions.

Prerequisites:

• Microsoft Dynamics Nav 2013

Steps: 

Lets create your report in Microsoft Dynamics Nav 2013 with "Microsoft Report Builder Tool".Just follow this steps 

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

2). Go to "Tools">>"Options">>"Use Report Builder" then  type "Yes" in value and click "Ok".

3). Open "Object Designer"  , Select "Reports" and click on "New".

As Shown Below:

4). As you can see a new window will appears, where you can select "Data Source" for your Reports "DataItem" .

Lets select "Customer" Table as "Data Source".

As  Shown Below:

5). Now we select "columns" for your report, To do so go to 

"View">> "Field Menu" .

A new window will appears where you can select your required columns, after selection click "Ok".

As shown below :

Selected columns will appears in "Report Designer" 

As shown below :

6). For Layout designing , Go to "View" >> "Layout" , 

A new instance of "Microsoft Report Builder Tool" will open. Now Go to "Insert" tab.

As shown below :

6). And click on "Table" then "Insert table"  and drag it on design surface and add fields in data cells by clicking icon showed in

 Screenshots below : 

After selecting all columns Save and exit from Report Builder.

7).Now Save your report in Dynamics Nav and Run it,

Request form will appear asking for

•  Print : This will give you 4 options Print,Excel sheet , Word file and PDF. 

•  Preview : To show your result as a preview 

As shown below :

Congratulations! You have created your report in Microsoft Dynamics NAV 2013 with Report Builder Tool. Now that you have learnt How to Design NAV 2013 Report without Microsoft Visual Studio, its time to try your hands on Designing List Reports in Microsoft Dynamics NAV 2013 to get going.

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

Thanks for reading,

Shubin Dongre

Error "Overflow under type conversion of code to code. Value x"

Hello Readers, 

Today i am sharing a short post about this error "Overflow under type conversion of code to code. Value x"

Scenario : I got a call from client that they are facing this error "Overflow under type conversion of code to code. Value xxx " while punching a item with barcode.For instant or temporary resolution, I have told them to punch item with item number.After doing some research i found the root cause of the issue and resolved it permanently.That you can find below.

Platform : Microsoft Dynamics Nav 2009 SP 1

Cause : The maximum length of field is defined 10 characters but they are trying to flow a value of more than 10 characters. 

Resolution : First you have to find the source of the error, For that you have to just activate the Debugger (Follow the link to see the tutorial for debugger ).It will take you the code from where this error is getting generated.
Now you have to find the variable which is unable to store or flow this value and increase the length of the variable as per your requirement. 

Result : Now variable is able to flow the same value as we have increased the length of it.

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

Thanks for reading

Shubin Dongre

Designing Microsoft Dynamics NAV 2013 List Report using Visual Studio

Hello Readers,

Today we are going to make a list report in Dynamics Nav 2013 with very simple steps.

As compare to older versions of Microsoft Dynamics Nav, Making reports is so easy in Microsoft Dynamics Nav 2013 R2 .We can print our reports directly in Excel sheet , Word file and PDF formats that was not available in older versions.

Prerequisite:

• Microsoft Dynamics Nav 2013
• Visual Studio 2013

Note: If you don't have Microsoft Visual Studio installed on your system then you can also design reports using SQL Builder. Go through the link to read the whole process: Designing Nav 2013 Report without Microsoft Visual Studio

Steps: 

Lets create your first report in Microsoft Dynamics NAV 2013. Just follow this steps 

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

2). In "Object Designer"  , Select "Reports" and click on 

"New".

As Shown Below:

3). As you can see a new window will appears, where you can select "Data Source" for your Reports "DataItem" .

Lets select "Customer" Table as "Data Source".

As  Shown Below:

4). Now we select "columns" for your report, To do so go to 

"View">> "Field Menu" .

A new window will appears where you can select your required columns, after selection click "Ok".

As shown below :

Selected columns will appears in "Report Designer". 

As shown below :

5). For Layout designing , Go to "View" >> "Layout" , 

A new instance of "Visual Studio" will open. Now Press "Ctrl+Alt+X" to open "ToolBox" .

As shown below :

6). Now select "Table" from toolbox and drag it on design surface and add fields in data cells by clicking icon showed in

 Screenshot below : 

After selecting all columns Save and exit from Visual Studio.

7).Now Save your report in Dynamics Nav and Run it,

Request form will appear asking for

•  Print : This will give you 4 options Print,Excel sheet , Word file and PDF. 

•  Preview : To show your result as a preview 

As shown below :

Congratulations! You have created your first report in Microsoft Dynamics Nav 2013.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 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