Avatar of Cian Dev
Cian Dev
 asked on

Microsoft Dynamics NAV Query

Hi All,

I have a client that uses MS Dynamics NAV, I have never used it and have some knowledge of Databases.

My question is, is the underlying default database a relational database when you first buy the product or do you have to set it up from scratch,
The reason i am asking is because the client has a table with numerous entries in it all assigned to one key, we want to add another key to more clearly identify the data in that table and are being told be the vendor that this is not possible.

My understanding of relational databases, is that you should be able to do this, i will stand corrected on this.

How flexible is NAV as an application to change, if a business needs to change its process?, my client operates a simple warehouse with one item in and out, with some variances on that one item, but nothing complex

Regards
Microsoft ApplicationsMicrosoft DynamicsDatabasesMicrosoft DevelopmentMicrosoft SQL Server

Avatar of undefined
Last Comment
moonlight

8/22/2022 - Mon
Chinmay Patel

Hi Cian,

I am not a NAV expert but AFAIK Dynamics Products (And similar other products) do not allow a direct modification to the database. If you intend to add a secondary key, that can be facilitated but I do not think apart from being a record identifier it will add any value. If you can throw some light on what you want to achieve by adding this second key, I might be able to provide some help.

PS: Most ERP/CRM products do not allow direct database modification as it might adversely affect when you try to migrate/update database (product patch, version change, on premise to online migration, etc.)

Regards,
Chinmay.
ASKER CERTIFIED SOLUTION
moonlight

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy