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

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

Why do the Microsoft Dynamics Nav 2013 Certification exam has been withdrawn?

Its a nature's course that to give place to any new thing in life, an old thing has to be compromised. Similarly in the changing scenario and day by day updating technology, Microsoft Dynamics is gaining ground with its new version of Microsoft Dynamics Nav 2015 and newly arrived version of Microsoft Dynamics Nav 2016. 

The main reason for the withdrawal of Navision 2013 certification is to introduce a new certification exam for Microsoft Dynamics Nav 2015 which is likely to be launched soon. Still there are no news confirmation for the same by Microsoft. For the time there are no Certification exams being conducted for the Microsoft Dynamics Nav Professionals.

Microsoft has been updating its technology time to time and side by side replacing certification for the old technologies with the new ones. Here are the list of exams which are retired by Microsoft for Dynamics Navision from the beginning of time: 

MB7-221     Navision 4.0 C/SIDE Introduction                                            January 12, 2010

MB7-222     NAV 4.0 C/SIDE Solution Development                                  January 12, 2010

MB7-223     Navision 4.0 Warehouse Managemen                                     January 12, 2010

MB7-224     Navision 4.0 Manufacturing                                                      January 12, 2010

MB7-225     Navision 4.0 Financials                                                            January 12, 2010

MB7-226     Navision 4.0 Installation and Configuration                              January 12, 2010

MB7-227     Navision 4.0 Trade and Inventory                                            January 12, 2010

MB7-231     Navision 4.0 Relationship Management                                  January 12, 2010

MB7-232     Navision 4.0 Service Management                                          January 12, 2010

MB7-233     Navision 4.0 Costing                                                                January 12, 2010

MB7-514      Microsoft Dynamics NAV 5.0 C/SIDE Introduction                  November 30, 2012

MB7-515      Microsoft Dynamics NAV 5.0 Financials                                  November 30, 2012

MB7-516      Microsoft Dynamics NAV 5.0 C/SIDE Solution Development  November 30, 2012

MB7-517      Microsoft Dynamics NAV 5.0 Installation and Configuration    November 30, 2012

MB7-700      Microsoft Dynamics NAV 2013 Installation and Configuration July 31, 2015

MB7-701      Microsoft Dynamics NAV 2013 Core Setup and Finance         July 31, 2015

MB7-702      Microsoft Dynamics NAV 2013 C/Side Development               July 31, 2015

MB7-838      NAV 2009 Installation & Configuration                                     June 30, 2014

MB7-839      NAV 2009 Core Setup and Finance                                         June 30, 2014

MB7-840      NAV 2009 C/SIDE Introduction                                                June 30, 2014

MB7-841      NAV 2009 C/SIDE Solution Development                                June 30, 2014

MB7-842      NAV 2009 Trade & Inventory                                                    June 30, 2014

MB7-843      NAV 2009 Warehouse Management                                        June 30, 2014

MB7-846      NAV 2009 Relationship Management                                       June 30, 2014

MB7-848      NAV 2009 Service Management                                               June 30, 2014

MB7-849      NAV 2009 Manufacturing                                                          June 30, 2014

MB7-849      NAV 2009-Produktion (Danish)                                                 June 30, 2014

MB7-849      NAV 2009-Produktion (German)                                               June 30, 2014

Follow us on Facebook and Twitter. We'll keep you posted when the certification for Nav 2015 arrives. Till then Happy Coding!

.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