Tuesday, May 27, 2014

NAV 2013 & NAV 2013 R2 - You do not have access to Microsoft Dynamics NAV - Create User From SQL.

Hi all,

This post is based on suggestion from +Ami Paneri Upadhyay

* The Screen Shots and Query Applies - TO NAV 2013 R2. Steps Remain Same for NAV 2013 but query will get change.

* The Query for NAV 2013 can be found in my Skydrive, Link at the end of the post.

Let's see what was required and how we can achieve it.

CASE -

I received a database from customer and my windows login is not there in the database. I don't want to delete Customer Users from the database but want to add myself in the Users. How can we do this?

OR

We have a database internally for development. All the consultants having User ID's in the database are not available. I want to access the database, How can i achieve it?

If you are using NAV 2013 R2 or Higher Please refer this article.

Friday, May 23, 2014

NAV Classic & RTC - How to Add Users in Database.

Hi all,

I know most of us know this but its a post for the New Consultants.

This post is based on requirement of one of my friend +Shrikant Sharma

In this post we will see How to Add Users  in the Database, so if you know how to do you can skip the post.


Monday, May 19, 2014

NAV 2013 R2 - Cumulative update 7 Released.

Hi all,

Please find below the details of Update Rollup Cumulative Update 7 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 7 for Microsoft Dynamics NAV 2013 R2
Build No. - 36703
Release Date - May, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Friday, May 16, 2014

Microsoft Dynamics NAV Localization Portal.

Hi all,

I found a great page on Partner source which i always wanted to have.

I thought you might also be interested to know about the page.

Microsoft Dynamics Localization Portal - Microsoft Dynamics NAV is what i am taking about.

So lets see what is it -

What Microsoft Says about the Page -

"This Dynamics Localization portal provides partners information by country about localization features including info on regulatory features, documentation, plus associated ISV solutions. "

Thursday, May 15, 2014

NAV 2013 - cumulative update 14 Released.

Hi all,

Please find below the details of Cumulative Update 14 released for Microsoft Dynamics NAV 2013.

Title - Update Rollup 14 for Microsoft Dynamics NAV 2013
Build No. - 36605
Release Date - May, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link

Thursday, May 8, 2014

NAV 2013 & NAV 2013 R2 - Comman Issue Related to Dimension in Step 2 Continued.....

Hi all,

As discussed and Found the Cause of Issue related to Dimension During Upgrade, Lets' see how to Resolve Same Before Upgrading or During Step 2.

If you haven't Read the Earlier Post Use The Link.

NAV 2013 & NAV 2013 R2 - Comman Issue Related to Dimension in Step 2 

There are two points which make our life Easy -

1. In Earlier Version i.e 2009 / 2009 SP1 / 2009 R2, the Dimension Values were used to Store in a seprate Table.

2. The Upgrade Step Batch Job Commits the Transaction Before the Error Occurs, i.e If Table X have Issue in Data Everything done before Table X is Committed.


Wednesday, May 7, 2014

NAV 2013 & NAV 2013 R2 - Comman Issue Related to Dimension in Step 2.

Hi all,

This is one of the most Comman error that most of us are facing while upgrading to NAV 2013 or NAV 2013 R2 From NAV 2009 / 2009 SP1 / 2009 R2.

What we had Completed?

A. We completed Step 1 Successfully.
B. Converted the Database to NAV 2013.
C. Converted the Database to NAV 2013 R2.
D. Imported the Merged Objects & Toolkit Step 2 Objects.

What we are Currently Doing?

A. Run the Upgrade Step 2.
B. Tested the Connection.
C. Clicked on Transfer Data.

What is the Error Message While Transferring Dimension?

Dimension Value ID must have a value in Dimension Set Entry: Dimension Set ID=0, Dimension Code=<Dimenion Code>. It cannot be zero or empty.



Monday, May 5, 2014

How to Use an Embedded Picture in a RTC Report.

Hi all,

Let's see how to Display an Embedded Picture in a Report.

* The Steps Shown below are from NAV Version 2013 R2.

It was a query from one of my friend +shubhangi verma  about how to add Embedded Picture in Report.

I am using Standard report 405 Which can be downloaded from the link provided at the end of the Post.

There are certain steps that we need to follow while adding an Embedded Picture in a Report. Let's see them.

Friday, May 2, 2014

NAV 2013 R2 - How to Sync Tenant?

Hi all,

A common Command referred in many of the Forums that can be used to Sync Changes of Navision in SQL is Sync Tenant.

Most of us are not aware how to run this command. In this post we will see how to Run and When to Run this Command?

When to Run?

A- When Upgrading Database from NAV 2009 / NAV 2009 SP1 / NAV 2009 R2 to NAV 2013 R2.

After Opening Database in NAV 2013 R2, Compiling System Tables and Importing Merged Objects of NAV 2013 R2.