New ID fields in NAV 2018
Miklos_Hollender
Member Posts: 1,598
E.g. G/L Account Field No. 8000 name:Id Type: GUID
What is this stuff? And how is it supposed to be filled out as there is no code in the table to fill it out?
I am a bit worried as I am migrating from NAV 2009 W1 to NAV 2018 Italy without the toolkits, just importing the master data tables and posting the opening balances as if it was a new project. (Project motto: "Old mistakes don't have to be carried forever!"
)
What is this stuff? And how is it supposed to be filled out as there is no code in the table to fill it out?
I am a bit worried as I am migrating from NAV 2009 W1 to NAV 2018 Italy without the toolkits, just importing the master data tables and posting the opening balances as if it was a new project. (Project motto: "Old mistakes don't have to be carried forever!"
0
Best Answer
-
Hi,
Field 8000 is actual "some kind of surrogate key" that Microsoft uses in the API's.
Take a look at the pages that ends with Entity
Example:
5471 - Customer Entity
You don't use the PK, but the surrogate key.
Like you, I don't have a clue on how this field gets his value.
5
Answers
-
I was doing one upgrade per year now, from Classic to latest, and found nothing really "weird" up to NAV 2017 that is you more or less can carry developments and data from Classic without any big surprise, just redo Pages and Reports. Only big difference I remember is Dimension Sets, about 2013 R2 or so. I am kind of worried NAV 2018 is in some ways really new. Is there some docs for this?0
-
Hi,
Field 8000 is actual "some kind of surrogate key" that Microsoft uses in the API's.
Take a look at the pages that ends with Entity
Example:
5471 - Customer Entity
You don't use the PK, but the surrogate key.
Like you, I don't have a clue on how this field gets his value.
5
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
- 322 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