upgradation from Nav 2009 to Nav 2013

Actually when I am trying to update the Nav2009 to Nav 2013 by using Upgradte tool kit ,After clicking Transfer Data I am getting following error

“Table data 90” does not exist

where I did wrong , can any body suggest me…

Did you check whether table 90 is existing in your database?

Did you customize Upgrade Toolki?

No, i did not do any customizations,

The table 90 is also not in my database.

Table 90 is a standard table and why didnt you have it in your database?

In my Demo database also not showing. is it virtual table, then why it is not showing.

It is not virtual table.

its BOM Component table.

which country database are you checking? and which version?

I am using US country database and the version is Navision 2009R2

If you don’t have table 90 in your old NAV 2009 database, then you should start by copy this from another database. But you should also check if you miss other tables.

And how come you don’t have this table? Did you delete it?

Erik,

Even i am doin some upgradation for US Database. I am also getting same error TableData 90 does not exist…I have not deleted that table 90 too…what might be the reason??

I think table 90 is not available in several NAV 2009 R2 databse. I am using Indonesian version and It doesn’t exists but It is available in W1 version.

so just like erik suggested, I copied that table object from NAV 2009 R2 W1 version to my database (Indonesian version) and it works.

hope this help.

regards,

yosa

This table 90 BOM Component existed in version 3.70 and was brought back in for 2013. Below is a snippet of the exported txt file. Once imported I was able to continue the upgrade process.

OBJECT Table 90 BOM Component

{

OBJECT-PROPERTIES

{

Date=05/21/03;

Time=12:00:00 PM;

Version List=NAVW13.70;

}

Use the Following table to import.
OBJECT Table 90 BOM Component
{
OBJECT-PROPERTIES
{
Date=02/04/16;
Time=[ 1:27:10 PM];
Modified=Yes;
Version List=NAVW16.00;
}
PROPERTIES
{
CaptionML=[ENU=BOM Component];

}
FIELDS
{
{ 2 ; ;Allow Posting From ;Date ;CaptionML=[ENU=Allow Posting From] }
{ 3 ; ;Allow Posting To ;Date ;CaptionML=[ENU=Allow Posting To] }

}
}

Hi Nagaraju,
please import fob of table_90 in your database.