Wednesday, January 20, 2016

Error "Before you can perform printer-related tasks, you need to install a printer."


Before you can perform printer-related tasks, you need to install a printer

Ever got this error "Before you can perform printer-related tasks, you need to install a printer." While previewing a report in Microsoft Dynamics NAV Classic,

Error "Before you can perform printer-related tasks, you need to install a printer."



I got you a simple solution for this error.

How to get the SID of the User Account?


How to determine SID of User Account of Windows



Those who don't know what the SID is, I would like to tell you that the System ID or SID is a unique identifier assigned to each user in Windows Environment. SID is used to control access to various resources like Files, Registry Keys, network shares, etc.

Friday, January 15, 2016

Let us understand the ClientUserSettings.config file in Detail


ClientUserSettings config file logo in Microsoft Dynamics NAV


First of all, let's understand what the ClientUserSettings.config file does. When you first install the Microsoft Dynamics NAV Windows Client, the Specify parameters page in Microsoft Dynamics Setup asks you for the configuration information to enable the Microsoft Dynamics Windows Client to connect to Microsoft Dynamics NAV Server. This information is saved in ClientUserSettings.config file.

Infocodes in LS Retail V 5.05 ( Pos )



Infocodes In Ls Retail Pos microsoft dynamics navision


Infocodes :

Infocode is a trademark of LS Retail ehf. This are used to capture extra information regarding transactions made at the POS terminals in Dynamics NAV. You can apply an infocode to a particular action in Pos, for example when applying discount on particular transaction, Pos system will show a textbox with " Discount Reason " to cashier for an input. 

Tuesday, January 12, 2016

Quick Configuration of ClientUserSettings.config file for Microsoft Dynamics NAV 2013 R2


client user settings config file icon logo


Are you facing problem while configuring ClientUserSettings.config file? If Yes, then don't worry, sit back and relax as I am going to guide you through very easy steps of the configuration of the file. The file has been by default created in the folder

Monday, January 11, 2016

Dynamics Nav 2016 System Requirements


Dynamics Nav 2016 System Requirements

Microsoft has announced that new release of Dynamics Nav will be Microsoft Dynamics Nav 2016 on October 5. If you are planning to get it for your business or other purposes, First thing you have to know that is Minimum System requirements for running Microsoft Dynamics Nav 2016. I am sharing some useful information from MSDN where Microsoft has officially released System requirements for running Dynamics Nav 2016, which are as follows :

Sunday, January 10, 2016

Getting to know the 3 Types of Recovery Models in SQL Server


Types of Recovery Models in SQL Server
If you are looking for the 3 types of Recovery Models in SQL Server then Sit back and relax as you have reached the correct destination. I would be guiding you through the concepts of Recovery Model in detail. First of all, lets talk about what the Recovery Model is. The Recovery models are designed to control transaction log maintenance.

Friday, January 8, 2016

Just 100 days left for SQL Server 2005 Support: Time for Version Update


100 days left for SQL Server 2005 support time to update version


Yes, you heard it right! The time has come for you to discard your old SQL Server 2005 and replace it with new versions available in the market. You can either take it as an unfortunate event as you have to crush some money on the latest versions of SQL Server or you can think of it as an opportunity to upgrade your data platform which is your gold mine of information for your business to a new and advanced data platform with better features.

8 Things you may not clearly know about Dynamics NAV


8 Things you may not clearly know about Dynamics Nav


Hello Guys,

Today i am going to tell you about some topics in Dynamics NAV that you might not cleared in your mind yet.
Lets clear out Now,

Thursday, January 7, 2016

Virtual Tables in Dynamics NAV


Virtual Table

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 Setup Job Queue in Microsoft Dynamics NAV 2013 R2


Let us first understand what we are going to discuss in the next 20 minutes of your precious time. Lot of people ping me asking about the Job Queue in Navision so I thought of writing an article about it so that I could give a clear picture of the working of Job Queue in Microsoft Dynamics NAV 2013 R2.


setup job queue in microsoft dynamics nav 2013 r2

Job Queue is a collection of Jobs which are running in the background which can schedule a Codeunit or a Report to run automatically in the background performing operations. Job Queue can be recurring or a one time thing. If no Job Queue is running then none of the Job Queue Entries will be running either. Job Queues can also be scheduled using NAS. 

Wednesday, January 6, 2016

How to Copy a Company in Dynamics Nav 2013 R2


Copy Company


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 :

How to Copy a Company in Dynamics Nav 2013 R2


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

As Shown below : 
Companies List



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

As Shown below : 


Copy Company

4. A request window "Edit - Copy Company" will open,
write your new company name here and click "Ok" .
Naming New Company
 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 :  
New Company Added


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




Monday, January 4, 2016

Designing Microsoft Dynamics NAV 2013 Report without Microsoft Visual Studio


Microsoft Dynamics NAV 2013 Reports


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:


Create New Report in Microsoft Dynamics NAV 2013



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:


Select Data Item in NAV 2013 Reports




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 :

Select Fields for the Data Item in Dynamics NAV 2013 Reports



Selected columns will appears in "Report Designer" 


As shown below :

Selected columns in report designer





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 :


Insert Table in SQL Builder for design of reports Dynamics NAV 2013


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 : 


Adding a Table in SQL Builder



Insert Data Set in SQL Builder design report Dynamics NAV 2013




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 :

Microsoft Dynamics NAV 2013 Reports Preview Page


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

Consuming a Query in Excel PowerView in Microsoft Dynamics NAV 2013 R2



First things first, lets clear what we are going to discuss here today. We are going to configure Excel's PowerView feature to visually demonstrate the Navision tables data. Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting in Excel. This is a feature of Microsoft Excel 2013.

Prerequisites - Microsoft Excel 2013, Microsoft Silverlight.

PowerView feature in Excel Microsoft Dynamics Nav 2013 R2


Now, to demonstrate the feature we are going to visually represent the Profit by Country by using the data from Customer table. 

We are going to demonstrate it in just 3 very easy steps as follows:


Step 1 : Create a Query and Publish it as an OData WebService

  • Open the Development Environment and Create a New Query Object.
Object Designer Query in Microsoft Dynamics NAV 2013 R2
  • Define a Data Item. (i.e. you can use Customer table)
Create a Data Item in Query Object Dynamics Nav 2013
  • Open the Field Menu and Select the Field you want to include in the Query.
Field Menu in Query object Microsoft Nav 2013 R2

  • Save the Query.
  • Run the Query to verify the correctness of the Query.
  • Now from the RTC search for 'Web Services' and open it, a page opens.
    • Click on New to create a new Web Service.
    • Select 'Query' as Object Type, enter the Object ID, type in the Service Name and then Click on Publish to Publish the Web Service.
Publish Query Web Services in Microsoft Dynamics NAV 2013 R2

  • Copy the OData URL from the Web Services Page and paste it on Internet Explorer to check whether the Web Service is working or not.



Step 2 : Create an Excel Workbook and Insert a Powersheet into it.

  • Go to Insert and Click on PowerView to insert a PowerView Sheet.
  • When you Create a PowerView sheet for the first time, Excel asks you to enable the PowerView add-in. Click on Enable.


Step 3 : Establish a Data Connection from Excel directly to the new OData URL and visualize the data in the PowerView.

  • In the Excel, Click on PowerPivot and then Click on Manage.
  • Inside the PowerPivot, Click on From Data Service and then From OData Feed.
Power Pivot from OData Data Feed in Microsoft Excel 2013

  • In the Pop-up window, Paste the Copied OData URL and then Click Next then Click on Finish.
Power Pivot from OData Data Feed in Microsoft Excel 2013

  • Now close the PowerPivot and Refresh the PowerView Sheet. The CustomerSales is shown as Power View fields in the Right Menu.
  • Drag the Country Region Code field on the main page. As we want to see it visually so we select the Map option in the Design Menu on Top Bar.




Now the Fun part 
There is a lot to interact in the PowerView sheet that you have created. Play with the fields in the Customer Sales. 
  • Drag the Profit (LCY) to show the data in the Map with the Profit by the Countries.
  • You can also add colour to the Name of the Customer by dragging the Name field to the Colour box at the bottom.
  • You can add any field as a filter by dragging the field to the filter area. For example, you can filter the data by the Salesperson Code by selecting the particular Salesperson from the Filters menu. 
Powerview visual geographical representation microsoft excel 2013


I hope you are caught up with the whole process. Write your comments below if you are facing any problem with the configuration. Watch the whole process in the video below to understand the concept more clearly about Excel Powerview and its use in Microsoft Dynamics NAV 2013 R2 and also Subscribe to our Youtube channel.

   

Sunday, January 3, 2016

Designing Microsoft Dynamics NAV 2013 List Report using Visual Studio


Nav 2013 List Report\

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:


Design new report microsoft dynamics nav 2013



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:


Select Data Item in Report





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 :


Select fields of the Data Item in Report NAV 2013




Selected columns will appears in "Report Designer". 


As shown below :

Selected columns in report designer







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 :

Microsoft Visual Studio 2013Toolbox



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 : 



New Column in Report Layout in Visual Studio


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 :

Report Preview of Customer List in Microsoft Dynamics NAV 2013


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

Saturday, January 2, 2016

How to setup NAS (Navision Application Server) for Microsoft Dynamics NAV 2013 R2?


I am sure that whenever you had heard the word NAS, nightmares would have been ran through your mind. You must have assumed that it would be a very difficult thing to learn. Atleast, I have thought like this when I heard the word for the first time. 

If you think like me then here are really easy steps to configure NAS and i am sure after going through this article you will enjoy configuring NAS in Microsoft Dynamics NAV 2013 R2.

Prerequisites : LS Modified Navision Base DB, LS Retail Toolbox 7.1


Follow the below steps pointwise:
  • Open Microsoft Dynamics NAV 2013 R2 Administration.
  • Open the Instance in which you want to configure NAS.


NAS Setting Microsoft Dynamics 2013 R2 Administration


  • In General tab, 2 Fields are mandatory
    • Service Default Company (Your Company name).
    • Service Default Time Zone : It should be Server Time Zone.
  • In NAS Services tab, 3 fields are mandatory.
    • Startup Codeunit : 99001468
    • Startup Method : LSRSCHEDULER
    • Startup Argument : NASID,TYPEFILTER=HOSP,LOG=1,REPEAT=1



Note : The TYPEFILTER=HOSP can be changed according to you ‘Scheduler Job Type Code’ as you can find it in below snapshot.

Scheduler Job configuration NAS Microsoft Dynamics NAV 2013

  • After doing the settings above, restart the service.
Restart Service Microsoft Dynamics NAV 2013 R2 Administration


  • Open the Scheduler Setup page and do the following setup as shown in below snapshot.
Scheduler Setup Page enable NAS Scheduler NAV 2013 R2




  • Perform the following Setup in Scheduler Setup
    •  Enable NAS Scheduler should be checked to yes.
    • Scheduler sleep sec. can be set as requirement by default it is 10 sec.

  • Go to job and on the Schedule Detail tab and fill the following fields.
    • Time Units
    • Time between Check
    • Next Check Date.
    • Next Check Time.
    • Starting Time and Ending Time (Not Mandatory).
    • Valid on Sunday to Saturday. 

Schedule Details in Scduler Job configure NAS NAV 2013 R2

  • Now the NAS Services will be enabled, check the Scheduler Log of the particular Scheduler Job.


Check Scheduler Log of Scheduler Job in NAV 2013 R2


Note : Restart the service and monitor the Scheduler Log for job to ensure that the job is auto starting or not in case of system restart or power failure. 


Please post the comment below if you have any queries regarding the Configuring of NAS. Also, Follow us Facebook and Twitter to keep updated with more tutorials.