Field No. 6207 is not defined in customer table

yekede
Member Posts: 96
Hi all,
I'm in an upgrade process from nav 4.0 to 5.0 and following the instruction in the manual. In upgrading company specific data task 12 it is sais run codeunit 2 but then i get this error Field No. 6207 is not defined in customer table. I checked this field is in the customer table in nav4 but not in 5.0. Can anybody tell me why i am getting this error and how i can solve this please?
I'm in an upgrade process from nav 4.0 to 5.0 and following the instruction in the manual. In upgrading company specific data task 12 it is sais run codeunit 2 but then i get this error Field No. 6207 is not defined in customer table. I checked this field is in the customer table in nav4 but not in 5.0. Can anybody tell me why i am getting this error and how i can solve this please?
0
Comments
-
Hi all,
Any idea pls?0 -
Add it-easiest way out.
I presume you are a technical geek in NAV and you would know how to do this.
==Just find out where it is being refenced in CU 2...0 -
Hi,
I think i got a solution to the problem. But experts please confirm if this is the right way to do this: the following code is the RunSetupDataFieldRelation function of codeunit 8611. the line creating error is highlighted. I think this error occurs because there are some fields in the migration table field Table that no more exist in Nav 5.0 and these are creating problems. So i delete those fields from table 8616 and the error disapears. But my question is: is this the right way to do this?RunSetupDataFieldRelation(VAR MigrationTable : Record "Migration Table") RecRef.OPEN(MigrationTable.TableID); IF RecRef.FIND('-') THEN REPEAT MigrationRecord1.SETRANGE(TableID,RecRef.NUMBER); IF MigrationRecord1.FIND('+') THEN MigrationRecord."No." := MigrationRecord1."No." + 1 ELSE MigrationRecord."No." := 1; MigrationRecord.TableID := RecRef.NUMBER; MigrationRecord.INSERT; MigrationFields.SETRANGE(TableID,MigrationRecord.TableID); IF MigrationFields.FIND('-') THEN REPEAT [b]FieldRef := RecRef.FIELD(MigrationFields.FieldID)[/b]; MigrationData.TableID := MigrationRecord.TableID; MigrationData."No." := MigrationRecord."No."; MigrationData.FieldID := MigrationFields.FieldID; MigrationData.Value := FORMAT(FieldRef.VALUE); MigrationData.INSERT;
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions