Howdy, Stranger!
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
- 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
- 310 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problems concerning Dynamics Connector
Christ
Member Posts: 24
Is there a possibility to make filters from NAV to CRM? We have pricebooks that have to be transfered from NAV to CRM only if the pricebook is public, so the field public is a boolean and this has to be the criterium to transfer it from nav to crm.
0
Comments
If i'm not mistaken, i didn't see filter option at Connector. But i think, you can filter at your public page and public to ws.
If you see any option at connector. Kindly, please let me know.
Best Regards,
Yukon
If the filter is static (which it looks like) and does not concern a lot of tables, you can edit the code in CU5150 to filter those record out of the synchronisation.
In the funciton InsertUpdateIntegrationRecord(RecRef : RecordRef;IntegrationLastModified : DateTime)
one can see that the contact table is filtered standard so that contacts of type company are skipped.
the filtering happens on 2 places, at the update the integration record is marked as deleted, in the insert part the code is skipped (by exit)
Based on that code you can work further I presume.
|To-Increase|