Migration: Navision 4 to Navision 5

Navision Articles

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Verified) This post has 1 verified solution | 3 Replies | 1 Follower

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri posted on Jul 3, 2009 7:31
How helpful was this post/question? Please rate here:
Dear all,

I'm migrating the database from NAV 4.0 to NAV 5.0.

I have seen a field named USER ID ( Field ID 16343 ) in the table Sales Header ( Table ID 36 ). This field contains the data.

But there is no such field in the merge objects of NAV 5.0. So when I importing the all merge objects(5.0) into the Customer database (Ref: Chapter 4, Task 6, Page 17 ), it throughs the following error message ......




How to solve this issue ?

Technical Consultant

Solution (Verified) Verified Solution

Top 25 Contributor
Male
863 Posts
18,980 Points
Joined: Sep 21, 2006
Last Online:
Mar 21, 2010 15:23
Location: Delhi-India
Moderator
Solution (Verified) Dhan Raj Bansal replied on Jul 30, 2009 15:28
How helpful was this comment/solution? Please rate here:
Verified by subrata.bauri

subrata.bauri:
I have seen a field named USER ID ( Field ID 16343 )

You will not be able to create a field with no. 16343, so the approach should be to create another field (in 50000 range and transfer the data from USER ID ( Field ID 16343 )) to this new field and then BLANK out your old field. You should also ensure that the new field is there in the objects that you are importing (after compare & merge step).

 

-Dhan Raj Bansal

Freelance Consultant--Looking for Projects

Email: bansal_dhanraj(AT)yahoo.com      replace (AT) by @

Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

All Replies

Top 25 Contributor
690 Posts
8,805 Points
Joined: Nov 17, 2003
Last Online:
Mar 19, 2010 11:26
jsrark replied on Jul 3, 2009 21:12
How helpful was this comment/solution? Please rate here:

Create that field in the table in the target database.

Creating new customer objects is an essential part of the migration process.

 

Jonathan.

Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Top 25 Contributor
Male
863 Posts
18,980 Points
Joined: Sep 21, 2006
Last Online:
Mar 21, 2010 15:23
Location: Delhi-India
Moderator
Solution (Verified) Dhan Raj Bansal replied on Jul 30, 2009 15:28
How helpful was this comment/solution? Please rate here:
Verified by subrata.bauri

subrata.bauri:
I have seen a field named USER ID ( Field ID 16343 )

You will not be able to create a field with no. 16343, so the approach should be to create another field (in 50000 range and transfer the data from USER ID ( Field ID 16343 )) to this new field and then BLANK out your old field. You should also ensure that the new field is there in the objects that you are importing (after compare & merge step).

 

-Dhan Raj Bansal

Freelance Consultant--Looking for Projects

Email: bansal_dhanraj(AT)yahoo.com      replace (AT) by @

Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

Top 10 Contributor
Male
5,053 Posts
94,835 Points
Joined: Oct 1, 1995
Last Online:
Mar 21, 2010 16:23
Location: Copenhagen, Denmark
DynamicsNAVMVP
Moderator
SystemAdministrator
Erik P. Ernst replied on Jul 30, 2009 16:33
How helpful was this comment/solution? Please rate here:

Hi Subrata,
Raj is correct in regard to the error message you describe. But as always it's also important that you before you're analyzing your system before you're actually starting your upgrade project. You have to ask the following question about field 16434:

Where does this field come from?

Where is this field used today?

Do we need this field in the new version?

And if you're not answering these question - and acting on them - then you'll just get more errors!

Best regards,
Erik P. Ernst

DUG’s Admin's Blog

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Page 1 of 1 (4 items) | Get this RSS feed | Bookmark and Share

Related Posts

    No Related Posts