Viewing Documents from One Responsibility Center

Consider a scenario where a company has different work locations/branches across the country, where each location handles their own sales operation. From an end user perspective the requirement would be in a way that users should only see the records & documents related to his/her location and not the sale orders from other locations.

How this can be achieved? Continue reading »

Tags: Dynamics NAV

Creation of ODATA Web Services in NAV 2013 and consuming data in excel

The Open Data Protocol (OData) is a Web protocol for querying and updating data that provides a way to unlock your data. OData does this by applying and building upon Web technologies such as HTTP, Atom Publishing Protocol (Atom Pub) and JSON to provide access to information from a variety of applications, services, and stores.

If you see the service console of NAV 2013, Microsoft Dynamics NAV Administration you will see a separate tab for ODATA Services as shown below – Continue reading »

Tags: Dynamics NAV

Accessing Nav Database


Consider a situation where you have a full backup of your customer database and restored it on your server.

Once the restore is done, you have to create a user in NAV that is known on your server. The user has to be created before getting out of NAV.

Say, you have missed to do the usual procedure and now faced with difficulties to enter your NAV Database.

What can be done?

If you have done a restore in a Native Database, there is no other option than to redo the complete restore.

But on the other hand, if you have a SQL Database, then there are some methods/workarounds to fix it.

  1. First try to login with user ’sa’. A lot of times, ‘sa’ is defined as a NAV database login.
  2. One more way is, if you know any NAV Database login that has super user rights, you can just use that user in SQL.
  3. Also, Add the user whom you want to access the tables of SQL Continue reading »
Tags: Dynamics NAV

Enhancements in NAV 2013

It’s almost half a year gone since the latest version of NAV got released. There are several new features that have been included to make the product more robust. The improvements have enabled both the developer and users very happy to work with. I have listed some of the features which I personally feel very resourceful.

User Productivity Enhancements:

1. Finding and Filtering Enhancements:

  • We can use Find and Filters on lines of any page.
  • This will be useful for End-users to look for a specific line.
  • In prior versions, we need to look for Actions and Select Filter which users found it to be very difficult to locate and access.
  • Now, it is more visible in the Ribbon, so it is easy for the users to know these features are available and make us of it. Continue reading »
Tags: Dynamics NAV