Hi,
I am using the developers toolkit(3.0) to upgrade from 4.0 SP3 to NAV 2009.I have compared and merged the three versions also. Its not aproblem.
In the database 4.0 SP3 they have imported the Quality control module where the range starts from (33000250.....33000500). The fields which range from 33000250.....33000500 is also included in the base table of Item, vendor ....
When i try to import the Item table to NAV 2009 from developers toolkit the message populates that" Your program license does not allow you to create "SETUP ID" in the table item". The reason is "SETUP ID" is in the range of 33000250.
What should i have to do. I have to import the objects quickly to NAV 2009????
Plz help me out. Waiting for ur valuable solutions???????
Jai
0
Comments
You could also maybe do these merges manually on the tables affected with copy and paste.
You must import a fob.
If you made any corrections of the code you must send it the addon-company who merge it into their database and supply you with a new fob.
Dan Lindström
NCSD Navision 2.00 since 1999 (Navision Certified Solution Developer)
MBSP Developer for Microsoft Dynamics NAV 2009
If a field outside your range does not exist then you cannot paste it. You need to import it with a fob.
In addition to this, if your license allows you to modify the objects but not create the fields, you can import the fob and select Merge New to existing to create the fields and then modify the code you need.
Try it...
Thank you for ur valuable suggestions. But even when i copy the field range from (33000250...) and copied in the NAV 2009 db. when i close the table it gives an error, your program license does not allow.Bcoz due to this fields we have a lot of codings related to the base table.whether i have to contact microsoft regarding this.
This fieldrange and table is imported into the database for processing the quality control...
can anyone help me out
1) I have the objects in fob format. In 4.0 SP3 quality control granule is included with the number range of (33000250 ....).
2)By using Dev toolkit i have compared and merged the objects of 4.0 SP3Base, 4.0 Sp3 cust and NAV 2009 Base.
3)When i try to import the compared objects to new database(NAV 2009). I get an error ,your program license does not allow to import the field(field is in the range of 3300250)
4) This field is included in most of the base tables. so when i try to import i am facing the problem???
Plz give me the solution for this????
When you import a FOB file into a database, before you hit the "replace all" button tables will have the the "Action" "Merge: Existing <- New". If you let Navision do this the result table will have columns from both the old object and the new one you're importing. Once you have done this you can load your text objects on top without Navision having to create new columns.
If the merge import throws an error you can try it the other way (New <- Existing) but that's also likely to error too. To fix that you have to clear all code from the existing objects; the dataport below creates a text object that'll do it for you. Obviously none of this works properly with data in the database.
Or you could try hacking it through SQL. :twisted:
TVision Technology Ltd
It will be useful in merging/upgrading db with multiple addons
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Thanks for ur reply. I have a fob object which range from (33000250...).I have a doubts.
1) In which database should i have to import this object whether in NAV 2009.
2) say if i am going to import this object in NAV 2009 then, what will happen when i import the object from the developer toolkit.
ex: 33000250 obj imported into NAV 2009 db( this no range deals with base tables also)
a)In item table i have two fields in the range of 33000250 and 33000251.
b)In developers toolkit i have merged and compared, i have the fourth version where the item table contain these two fields.
Is it will overrite???????
I need ur valuable suggestions.....
So again ...
TVision Technology Ltd
Thanks for ur reply. As you told i imported the objects which have 33000250 range into the NAV 2009 database. when i import the table Item (27) i am getting the error 'field 71 is not included'. when i check the item table, a variable is used which is related to the table 5902(Service Invoice Line).
In NAV 4.0 SP3 , the name of the table is Service Invoice Line
In NAV 2009, the name of the table is Service Line
The field which is not in NAV 2009 is Document Type, it's the first field in the table Service line.
How should i have to sort it out. Can anyone help me out???????
What is the exact error message, which of the many different copies of the object are you loading at each stage.
And so forth.
But, you seem to be saying you're having problems with the standard fields, presumably in your text object, if so you've messed up the merge. :roll:
Perhaps you need to buy an application that can show you a proper 3-way comparison like Araxis merge.
TVision Technology Ltd
I will explain you the scenario.
1)I have NAV 4.0 SP3 database with customized objects.
2)In this database they have imported the objects which is related to the quality control. Here the number range starts from 33000250....when they have imported these objects, the fields in the range of 33000250 got imported into the base table like Item,Vendor,Item Journal Line,Prod Order Line
3) As you told i imported the objects in the range of 33000250 and fields which contain this range table also i imported by using the option Merge:Existin=> New into the NAV 2009 DB.
4) The Item table couldn't import it throws an error 'Field No 71 does not exist'.
5) In NAV 2009, the service line table(5902) does not have the field 71
In 4.0 SP3 , the table name itself is Service Invoice Line(5902)
This is the scenario . could you plz help me out
TVision Technology Ltd