Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 273 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Item Entry RelationError while upgrading 301 t0 400 Stage II
Jyoti_Kapoor
Member Posts: 56
We are working on an upgrade from Nav 3.10 to Nav 4.0. We are getting some data related errors while trying to convert the DB, which as follows:
The stage II upgrade codeunit 104049 "Item Trkg. Upgrade Step 2" splits the item ledger entries and value entries using the function SplitValueEntries() and SplitItemLedgerEntries() and after this it creates the "Item Entry Relation" entries with function CreateItemEntryRelations(). As per the splitted item ledger entries it gives "New Entry No." to the temporary item tracking entry table records with the "item ledger entry" No. created new after splitting. And these new entry nos. are used while creating the item entry relations. This gives an error for Duplicate "Entry No." while putting records into "Item Entry Relation" table. This should not happen ideaaly as these new entries for the multiple entries are made by the procedure only with new entry nos. Please suggest on this issue, i am stuck up at this error.
Thanks & Regards,
The stage II upgrade codeunit 104049 "Item Trkg. Upgrade Step 2" splits the item ledger entries and value entries using the function SplitValueEntries() and SplitItemLedgerEntries() and after this it creates the "Item Entry Relation" entries with function CreateItemEntryRelations(). As per the splitted item ledger entries it gives "New Entry No." to the temporary item tracking entry table records with the "item ledger entry" No. created new after splitting. And these new entry nos. are used while creating the item entry relations. This gives an error for Duplicate "Entry No." while putting records into "Item Entry Relation" table. This should not happen ideaaly as these new entries for the multiple entries are made by the procedure only with new entry nos. Please suggest on this issue, i am stuck up at this error.
Thanks & Regards,
0