The Microsoft Dynamics NAV 2009 SP1 upgrade toolkit has been updated for those countries/regions where Microsoft Dynamics NAV 2009 SP1 was not released. This upgrade applies to the following countries/regions and product versions.

Country/region Upgrade from product version For more information, see

Bulgaria

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Bulgaria

Croatia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Croatia

Czech Republic

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Czech Republic

Estonia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Estonia

Hungary

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Hungary

Latvia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Latvia

Lithuania

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Lithuania

Poland

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Poland

Romania

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Romania

Serbia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Serbia

Slovakia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Slovakia

Slovenia

Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1

Slovenia

Turkey

Microsoft Dynamics NAV 5.0 SP1

Turkey

If Microsoft Dynamics NAV 2009 SP1 was not released in your country/region, then you must follow the instructions in the Upgrade Toolkit Manual.pdf file that is provided on the Microsoft Dynamics NAV 2009 R2 installation media. You must also follow the instructions in this document for your country/region.

Bulgaria

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Bulgaria includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.BG.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.BG.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 173501..175000 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

16205

Customs Declaration

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added. For more information, see the following section.

Table 312, Purchases & Payables Setup

One field is added. For more information, see the following section.

Table 5911, Service Mgt. Setup

One field is added. For more information, see the following section.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507

114

Sales Cr. Memo Header

26508

254

VAT Entry

16200

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Croatia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Croatia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.HR.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.HR.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..173827 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

11815

VAT Correction

11826

VAT Form

11840

VAT Sales Rep. View Setup

11841

VAT Sales Rep. View

11842

VAT Sales Rep. View Line

11843

VAT Purch. Rep. View Setup

11844

VAT Purch. Rep. View

11845

VAT Purch. Rep. View Line

11848

SAD Buffer

11861

Reference Formula

11862

Reference Formula Parameter

11863

Remittance Purpose Code

11864

Bank Branch

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following tables have been assigned new IDs.

Previous table ID New table ID

11840

14140

11841

14141

11842

14142

11843

14143

11844

14144

11845

14145

11848

14148

11861

14161

11862

14162

11863

14163

11864

14164

The following fields have been assigned new IDs in various tables.

Table ID Old field ID New field ID

5

11800

14100

15

11802

14102

15

11803

14103

18

11800

14100

18

11801

14101

21

11800

14100

21

11801

14101

21

11802

14102

23

11800

14100

23

11801

14101

23

11802

14102

25

11801

14101

25

11802

14102

25

11803

14103

25

11804

14104

25

11805

14105

32

11801

14101

36

11802

14102

36

11814

14114

36

11815

14115

36

11816

14116

36

11817

14117

37

11805

14105

37

11806

14106

38

11802

14102

38

11814

14114

38

11815

14115

38

11816

14116

38

11817

14117

38

11818

14118

38

11819

14119

38

11820

14120

38

11821

14121

38

11822

14122

38

11823

14123

79

11803

14103

79

11826

14126

81

11802

14102

81

11805

14105

81

11814

14114

81

11820

14120

81

11821

14121

81

11822

14122

81

11823

14123

81

11824

14124

81

11825

14125

81

11826

14126

81

11827

14127

81

11828

14128

81

11829

14129

81

11830

14130

81

11831

14131

81

11832

14132

81

11833

14133

81

11834

14134

81

11835

14135

81

11836

14136

83

11801

14101

98

11812

14112

112

11814

14114

112

11815

14115

112

11816

14116

112

11817

14117

113

11805

14105

113

11806

14106

114

11802

14102

115

11805

14105

115

11806

14106

122

11814

14114

122

11815

14115

122

11816

14116

122

11817

14117

122

11818

14118

122

11819

14119

122

11820

14120

122

11821

14121

122

11822

14122

122

11823

14123

124

11802

14102

233

11800

14100

236

11800

14100

254

11802

14102

254

11803

14103

254

11804

14104

254

11805

14105

254

11812

14112

254

11813

14113

254

11815

14115

254

11820

14120

254

11830

14130

254

11831

14131

254

11832

14132

254

11833

14133

254

11834

14134

254

11835

14135

254

11836

14136

256

11800

14100

256

11801

14101

260

11800

14100

287

11800

14100

288

11800

14100

300

11800

14100

300

11801

14101

300

11802

14102

302

11800

14100

302

11801

14101

302

11802

14102

302

11803

14103

302

11804

14104

302

11805

14105

303

11800

14100

303

11801

14101

303

11802

14102

303

11803

14103

303

11804

14104

304

11802

14102

304

11803

14103

304

11804

14104

304

11805

14105

305

11800

14100

305

11801

14101

305

11802

14102

305

11803

14103

305

11804

14104

311

11809

14109

311

11810

14110

311

11811

14111

312

11804

14104

312

11805

14105

312

11807

14107

312

11808

14108

325

11806

14106

325

11807

14107

5200

11800

14100

5740

11800

14100

5802

11801

14101

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

92

Customer Posting Group

11801

98

General Ledger Setup

11803, 11811, and 11812

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

254

VAT Entry

11816

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Also, the following tables contain a Document Type field.

  • 272

  • 5625

  • 5629

  • 5907

In previous versions, this field had an Advance option value. This option is no longer valid, and you must ensure that the Document Type field is not set to Advance before you start the data transfer.

Czech Republic

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for the Czech Republic includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.CZ.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.CZ.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..173501 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26501, Stat. Reporting Setup

10 fields have been assigned new IDs.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields have been assigned new IDs in the Stat. Reporting Setup table.

Table ID Old field ID New field ID

26501

10

11760

26501

11

11761

26501

12

11762

26501

13

11763

26501

14

11764

26501

15

11765

26501

16

11766

26501

17

11767

26501

53

11753

26501

34

11734

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507

114

Sales Cr. Memo Header

26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

26501

Stat. Reporting Setup

30, 31, 32, 33, 11706, 11707, 11719, and 11720

Estonia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Estonia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.EE.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.EE.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about each of these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added. For more information, see the section below.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507

114

Sales Cr. Memo Header

26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Hungary

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Hungary includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.HU.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.HU.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

270

Bank Account

26550

315

Jobs Setup

1000

5900

Service Header

14533

8000

Notification Setup

4

26514

VIES Declaration Line

22

Latvia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Latvia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.LV.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.LV.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Lithuania

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Lithuania includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.LT.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.LT.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about each of these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Poland

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Poland includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.PL.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.PL.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..173001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field are added.

Table 5900, Service Header

Field 12303, Postponed VAT. is assigned ID 26506.

Table 5911, Service Mgt. Setup

One field is added.

Table 5994, Service Cr.Memo Header

Field 12303, Postponed VAT, is assigned ID 26506.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Romania

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Romania includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.RO.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.RO.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Serbia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Serbia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.RS.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.RS.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 173900..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

11815

VAT Correction

11820

KEPU Book First Line

11821

KEPU Book Report Line

11840

VAT Sales Rep. View Setup

11841

VAT Sales Rep. View

11842

VAT Sales Rep. View Line

11843

VAT Purch. Rep. View Setup

11844

VAT Purch. Rep. View

11845

VAT Purch. Rep. View Line

The following tables have been assigned new IDs and names.

Old table ID Old table name New table ID New table name

11820

KEPU Book First Line

28520

Sales Invoice Header

11821

KEPU Book Report Line

28521

KEPU Book Report Line

11840

VAT Sales Rep. View Setup

28540

VAT Sales Rep. View Setup

11841

VAT Sales Rep. View

28541

VAT Sales Rep. View

11842

VAT Sales Rep. View Line

28542

VAT Sales Rep. View Line

11843

VAT Purch. Rep. View Setup

28543

VAT Purch. Rep. View Setup

11844

VAT Purch. Rep. View

28544

VAT Purch. Rep. View

11845

VAT Purch. Rep. View Line

28545

VAT Purch. Rep. View Line

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup and VAT Sales Rep. View tables and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

11841

11800

28541

28500

11841

11801

28541

28501

The following fields have been assigned new IDs in various tables.

Table ID Old field ID New field ID

5

11800

28500

6

11800

28500

15

11802

28502

23

11800

28500

23

11801

28501

23

11802

28502

32

11801

28501

32

11802

28502

32

11803

28503

36

11802

28502

37

11805

28505

37

11806

28506

38

11802

28502

79

11803

28503

81

11802

28502

81

11805

28505

83

11803

28503

113

11805

28505

113

11806

28506

114

11802

28502

115

11805

28505

115

11806

28506

124

11802

28502

233

11800

28500

236

11800

28500

254

11802

28502

254

11803

28503

254

11804

28504

254

11805

28505

254

11812

28512

254

11813

28513

254

11815

28515

260

11800

28500

300

11800

28500

300

11801

28501

300

11802

28502

302

11800

28500

302

11801

28501

303

11800

28500

303

11801

28501

303

11802

28502

303

11803

28503

303

11804

28504

305

11800

28500

305

11801

28501

305

11802

28502

305

11803

28503

305

11804

28504

305

11805

28505

311

11804

28504

313

11800

28500

325

11806

28506

325

11807

28507

5200

11800

28500

5740

11800

28500

5802

11803

28503

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507 and 26508

254

VAT Entry

11816

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Also, the following tables contain a Document Type field.

  • 272

  • 5625

  • 5629

  • 5907

In previous versions, this field had an Advance option value. This option is no longer valid, and you must ensure that the Document Type field is not set to Advance before you start the data transfer.

Slovakia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Slovakia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.SK.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.SK.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 173500..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

The following tables have been assigned new IDs.

Old table ID Old table name New table ID

11760

Detailed G/L Entry

28960

11785

Intrastat Currency Exch. Rate

28985

11786

Statistic Indication

28986

11787

Specific Movement

28987

11788

VAT Attribute Code

28988

11789

Depreciation Group

28989

11790

FA Extended Posting Group

28990

11792

SKP Code

28992

The following tables have been modified. For more information about each of these changes, see the information listed after this table.

Modified table Changes to table

Table 98, General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311, Sales & Receivables Setup

Two fields are added.

Table 312, Purchases & Payables Setup

One field is added.

Table 5911, Service Mgt. Setup

One field is added.

Table 26501, Stat. Reporting Setup

10 fields have been assigned new IDs.

Table 26512, VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields have been assigned new IDs in various tables.

Table ID Old field ID New field ID

17

11703

28903

17

11704

28904

17

11706

28906

17

11707

28907

17

11708

28908

27

11786

28986

27

11787

28987

37

11798

28998

37

11799

28999

39

11798

28998

39

11799

28999

81

11790

28990

81

11791

28991

84

11790

28990

85

11790

28990

85

11791

28991

98

11790

28990

98

11791

28991

98

11799

28999

113

11799

28999

115

11799

28999

123

11799

28999

125

11799

28999

204

11785

28985

252

11700

28900

256

11701

28901

256

11702

28902

256

11703

28903

256

11704

28904

262

11701

28901

262

11702

28902

263

11700

28900

263

11701

28901

263

11702

28902

263

11703

28903

263

11704

28904

263

11786

28986

263

11787

28987

290

11793

28993

290

11794

28994

290

11795

28995

290

11796

28996

290

11797

28997

290

11798

28998

290

11799

28999

331

11700

28900

331

11701

28901

331

11702

28902

5404

11785

28985

5600

11700

28900

5603

11789

28989

5603

11790

28990

5606

11700

28900

5606

11701

28901

5606

11702

28902

5611

11700

28900

5611

11701

28901

5612

11789

28989

5612

11790

28990

5612

11791

28991

5612

11792

28992

5612

11793

28993

5615

11700

28900

5813

11780

28980

5813

11781

28981

5813

11782

28982

5846

11700

28900

5846

11701

28901

5846

11702

28902

5846

11703

28903

26501

10

28960

26501

11

26501

26501

12

28962

26501

13

28963

26501

14

28964

26501

15

28965

26501

16

28966

26501

17

28967

26501

53

28953

26501

11700

28900

26501

11701

28901

26501

11702

28902

26501

11703

28903

26501

11704

28904

26501

11708

28908

26501

11709

28909

26501

11710

28910

26501

11711

28911

26501

11712

28912

26501

11713

28913

26501

11714

28914

26501

11715

28915

26501

11716

28916

26501

11717

28917

26501

11718

28918

26513

34

28934

26513

11700

28900

26513

11701

28901

26513

11702

28902

26513

11703

28903

26513

11705

28905

99008500

11700

28900

99008502

11700

28900

99008504

11700

28900

99008506302

11700

28900

99008508

11700

28900

The following fields have been assigned new IDs in the Stat. Reporting Setup table.

Table ID Old field ID New field ID

26501

10

11760

26501

11

11761

26501

12

11762

26501

13

11763

26501

14

11764

26501

15

11765

26501

16

11766

26501

17

11767

26501

53

11753

26501

34

11734

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507

114

Sales Cr. Memo Header

26508

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

26501

Stat. Reporting Setup

30, 31, 32, 33, 11706, 11707, 11719, and 11720

Slovenia

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Slovenia includes files that are specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import these files as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP1FP12009SP1.SI.1.fob

Step 1

Task 2

Upgrade500SP1FP12009SP1.SI.2.fob

Step 2

Task 8

Each file contains a codeunit that modifies the existing product. In step 1, codeunit 175001 copies information from fields into temporary tables and empties initial fields. In step 2, codeunit 175002 copies information from temporary tables into Microsoft Dynamics NAV 5.0 SP1 Feature Pack 1 tables and other modifications.

Database Changes

Temporary tables are created that you can delete after the upgrade. The temporary tables are in the 175000..175001 ID range.

The following tables are no longer used in Microsoft Dynamics NAV 2009 R2. The tables were used in the previous release for this country/region.

Table ID Table name

26579

Acc. Schedule Dim. Filter

11805

Customs Procedure

11813

Link Excel Inst. Sector

11814

Link Excel Fin. Instrument

11815

VAT Correction

11817

Transition Period

The following tables have been modified. For more information about these changes, see the information listed after this table.

Modified table Changes to table

Table 98 General Ledger Setup

Fields are deleted and are now implemented on other tables.

Table 311 Sales & Receivables Setup

Two fields are added.

Table 312 Purchases & Payables Setup

One field is added.

Table 5911 Service Mgt. Setup

One field is added.

Table 26512 VAT Clause Setup

Primary key is changed from:

VAT Bus. Posting Group,VAT Prod. Posting Group,Standard Text Code

to:

VAT Bus. Posting Group,VAT Prod. Posting Group.

The following fields have been removed from the General Ledger Setup table and replaced by new fields on other tables.

Old table ID Old field ID New table ID New field ID

98

26504

312

26504

98

26505

311

26504

98

26506

5911

26504

98

26509

311

26509

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

114

Sales Cr. Memo Header

26507

114

Sales Cr. Memo Header

26508

254

VAT Entry

11816

270

Bank Account

26550

315

Jobs Setup

1000

8000

Notification Setup

4

26514

VIES Declaration Line

22

Also, the following tables contain a Document Type field.

  • 272

  • 5625

  • 5629

  • 5907

In previous versions, this field had an Advance option value. This option is no longer valid, and you must ensure that the Document Type field is not set to Advance before you start the data transfer.

Turkey

The Microsoft Dynamics NAV 2009 R2 upgrade toolkit for Turkey includes a file that is specific to this country/region and are not described in the Upgrade Toolkit Manual.pdf file. The following table describes when you must import this file as you follow the upgrade instructions in chapter 4 in the Upgrade Toolkit Manual.pdf file.

File name Import at step number Import at task number

Upgrade500SP12009SP1.TR.fob

Step 1

Task 2

The file contains a codeunit that modifies the existing product. Codeunit 171201 empties initial fields.

Database Changes

The following fields are no longer used in Microsoft Dynamics NAV 2009 R2. The fields were used in the previous release for this country/region.

Table ID Table name Field ID

110

Sales Shipment Header

5900

315

Jobs Setup

1000

8000

Notification Setup

4