I am working with a client that is in the process of upgrading. They have multiple NAV installations in multiple countries and differing versions. For a number of reasons, it looks like the best path will be to close out all the existing databases and then start each new with opening balances brought into 2009R2 databases.
The issue is that from time to time they need access to the old data, and we would manage that with a mix of Linked Views for data they access regularly (mainly sales history) and for data they access less often (like printing old sales invoices and reviewing old inventory) they will just log into the old database and check the data. To make this simpler, the plan is to do an exe only upgrade on the old databases so they can just connect in with the current client.
So now we come to licensing. How does that work. The historical database is not technically active, its just a repository of data, all processing happens in the new database, but what about when they (for example) reprint an old invoice? Do they then need to have a separate license for the old and new databases? Or can they access the data using their current license.
To add to the complication, for initial inquiries, it seems that the rules are different in different countries.
Does anyone have any experience with this. For sure this is not the first time a NAV customer has upgraded this way, so there must be thousands of cases like this out there.
David Singleton
0
Comments
I think what you describe is a common practice with accounting upgrades, and not just NAV. Whether it's actually covered by the license is a question.
Exactly, there must be thousands just in Navision alone, but are they legal?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Yeah, it's very clear one database per license. Otherwise you could customize each database with different code. You might still be limited by concurrent users, but there's more than just users in that license.
My Blog - nav.education
From the SLT
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
LS Retail licensing is very specific, the granule "Store License is the server in each store and the POS license is the client. Because of the way its done all the granules are in the one license though, so managing it can sometimes be complex, but it give flexibility which is necessary.
The issue is going to get bigger, as currently many clients that I have spoken with are of the opinion that either a lot of their customizations do not suit the RTC platform, or more commonly they see advantages in the RTC that mean redesigning (aka throwing away) a lot of their Classic client customizations. Thus leading to the point of stating clean in 2009 and especially in preparation for NAV7.
I think its time this can of worms is opened.
With the RTC I can see that a larger number of customers who are on 2.x and 3.x will reimplement rather than upgrade since the application features have just exploded and many customisations are no longer nessesairy.
Given that fact it is important to have best practices on how to handle reading from the old database.
You hit the nail on the head.
My Blog - nav.education
So you can view those old databases as non-production db.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I think this is how it should work, but if I was selling licenses I wouldn't. The company is running part of their business out of that database, even if it is a really small part and only periodically.
My Blog - nav.education
Is that actually spelled out in the SLT? Or is it just an assumption we all tend to make?
The thing is that these are not backup or development databases, they are clearly a part of the customers active Navision system, even if they just reprint one invoice per year.
My Blog - nav.education
Those databases are also going to have extra tables and forms at the minimum, plus other granules, so those also need to be licensed. Also Add-ons, so then add eShip and LS Retail. It soon adds up.
In that case they also go into NAV every now end then to look at old data, maybe print and invoice.
That is a different situation, because they are only using the license on the old database, so there is no breach of license. In the upgrade case they would be using one icense to access two databases.
The argument can be made that it is not, though. Definitions include "A system where application programs that are already developed and tested run on a regular basis." and "The system used for day-to-day business operations." Is it run on a "regular" basis? Used for "day-to-day" operations? It truly is an interesting issue and until it is challenged by either side, customer or Microsoft, you just have to do what you think is right.
My Blog - nav.education