NAV Autoincrement property not working in Connector

jwilder
Member Posts: 263
Does the Connector support using a table with a primary key of Entry No. which has autoincrement = true.
We are getting the following error:
[Contact to NAV CRM Contact] has encountered an error while processing key Nate Boyd, 1335117f-d58c-e211-9301-00155d015a02. You cannot change the value of an AutoIncrement field. Field: Entry No. Table: CRM Contacts Identification fields and values: Entry No.='139659'
This is a CRM to NAV map. We did not set the Entry No. in the map and we tried setting the Entry No. to zero. Both give an error. Any thoughts on how to make this work (besides turning AutoIncrement off and writing code on the OnInsert trigger)
We are getting the following error:
[Contact to NAV CRM Contact] has encountered an error while processing key Nate Boyd, 1335117f-d58c-e211-9301-00155d015a02. You cannot change the value of an AutoIncrement field. Field: Entry No. Table: CRM Contacts Identification fields and values: Entry No.='139659'
This is a CRM to NAV map. We did not set the Entry No. in the map and we tried setting the Entry No. to zero. Both give an error. Any thoughts on how to make this work (besides turning AutoIncrement off and writing code on the OnInsert trigger)
Jason Wilder
jwilder@stonewallkitchen.com
jwilder@stonewallkitchen.com
0
Comments
-
A little more research shows that even if I turn Autoincrement off and try to increase the Entry No. with code I get the same problem. The problem restate is this:
On a CRM to NAV map it seems that the primary key on the NAV table cannot be an Entry No. (integer).
Has anyone done this before?Jason Wilder
jwilder@stonewallkitchen.com0 -
Hi,
Are you pass particular value in Entry No. and still have an error?
Trough Connector you should always pass particular value for primary Fields.http://nav-connector.com/ - blog about Dynamics Connector0 -
No value is passed. It is filled in with code in the OnInsert trigger in NAV.Jason Wilder
jwilder@stonewallkitchen.com0
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