Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
CRM-NAV integration through connector.
SuD
Member Posts: 102
in Dynamics CRM
Hello experts.
I have just integrated NAV(2015) with CRM(2015) through connector. All gone ok with connector including Adapter setting, initial synchronization etc.
But when I monitored the synchronization for NAV Item card to Product in connector, initially all items didn't synchronized in CRM but after recurring attempt all items were synchronized.
But when I m created a new item in NAV , it is not synchronizing in CRM, even connector does not showing any log for this.
No error, warning, info etc. Although synchronizing is going on in a given time(55 sec) interval.
What should be the issue?
Thanks in advance.
I have just integrated NAV(2015) with CRM(2015) through connector. All gone ok with connector including Adapter setting, initial synchronization etc.
But when I monitored the synchronization for NAV Item card to Product in connector, initially all items didn't synchronized in CRM but after recurring attempt all items were synchronized.
But when I m created a new item in NAV , it is not synchronizing in CRM, even connector does not showing any log for this.
No error, warning, info etc. Although synchronizing is going on in a given time(55 sec) interval.
What should be the issue?
Thanks in advance.
0
Best Answer
-
Options
rom2018
Member Posts: 14
To work with Item inside Nav, the superuser is not needed.
From the actions of any user with the items, tab 5151 should change (first - create, next - change "Modified On", for test connector "Modified On", make change manualy, direct table 5151).
To work connector, need login for nav-side: navuser with SUPER permission.
Nav-Connector-CRM - first direction
CRM-Connector-NAV - second direction
first and second independent.
solve the issue completely with the first direction
second....
more conditions...
- if may be delete Item in nav... (have open posting entries)
- if CRM not delete Product, because deactivate product.
...... recommendation...... may be....
- set ERROR('Test delete table for connector') In OnDelete trigger tab27 Item
- set ERROR('Test delete page for connector') In OnDelete trigger Page30 ItemCard
and check connector logs, after delete\deactivation Product in CRM (Product is set from Nav previously)5
Answers
1. Create/Update Item in Nav.
2. What do you see in Tab. 5151 "Integration Record".
Is there a records for table 27?
What data in field "Modified On"?
Yes, I created a new item , and then check the table 5151.
I found a newly created entry for this item.
Modified on 3/23/2018 10:36:17.843 AM.
Now what?
One more thing I want to share with you. I created a new user in NAV with super permission , when this user create any item in NAV. Then it is synchronizing in CRM successfully(I m able to see newly created item in CRM). But when delete from CRM that item then it is not deleting from NAV.
Is it something related to permission?.
From the actions of any user with the items, tab 5151 should change (first - create, next - change "Modified On", for test connector "Modified On", make change manualy, direct table 5151).
To work connector, need login for nav-side: navuser with SUPER permission.
Nav-Connector-CRM - first direction
CRM-Connector-NAV - second direction
first and second independent.
solve the issue completely with the first direction
second....
more conditions...
- if may be delete Item in nav... (have open posting entries)
- if CRM not delete Product, because deactivate product.
...... recommendation...... may be....
- set ERROR('Test delete table for connector') In OnDelete trigger tab27 Item
- set ERROR('Test delete page for connector') In OnDelete trigger Page30 ItemCard
and check connector logs, after delete\deactivation Product in CRM (Product is set from Nav previously)
Thanks very much for your help.
Now I am able to delete item from NAV and it is deleted same product in CRM also.