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
- 304 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
NAV-CRM Field Mapping.
preethisaravanan
Member Posts: 10
Hi,
I am integrating NA V-CRM and using NAV 2009 R2, CRM 2011. We are using Microsoft Dynamics NAV connector for integrating NAV and CRM. We need to map the fields of Quote in CRM to Sales Quote in NAV. We have used the following fields in sales header and sales line,
SALES QUOTE HEADER BASE NAV
Sell-to Customer No ----> Sell-to Customer No.
Bill-to Customer No ----> Bill-to Customer No.
Payment Terms Code----> Payment Terms Code
Order Date ----> Order Date
Posting Description ----> Posting Description
Salesperson Code ----> Salesperson Code
Ship-to Name ----> Ship-to Name
Requested Delivery Date ----> Requested Delivery Date
Ship-to County ----> Ship-to County
Ship-to City ----> Ship-to City
Ship-to Address2 ----> Ship-to Address 2
Ship-to Address ----> Ship-to Address
Assigned User ID ----> Assigned User ID
SALES QUOTE LINE
Document Type ----> Document Type
Document No ----> Document No.
No ----> No.
Type ----> Type
Quantity ----> Quantity
Amount Including VAT ----> Amount Including VAT
Requested Delivery Date ----> Requested Delivery Date
We get error stating that “LineIntegrationID” cannot be null. Please suggest us whether the mapping is done to appropriate fields and share your experience for mapping the Quote(CRM) and Sales Quote(NAV).
I am integrating NA V-CRM and using NAV 2009 R2, CRM 2011. We are using Microsoft Dynamics NAV connector for integrating NAV and CRM. We need to map the fields of Quote in CRM to Sales Quote in NAV. We have used the following fields in sales header and sales line,
SALES QUOTE HEADER BASE NAV
Sell-to Customer No ----> Sell-to Customer No.
Bill-to Customer No ----> Bill-to Customer No.
Payment Terms Code----> Payment Terms Code
Order Date ----> Order Date
Posting Description ----> Posting Description
Salesperson Code ----> Salesperson Code
Ship-to Name ----> Ship-to Name
Requested Delivery Date ----> Requested Delivery Date
Ship-to County ----> Ship-to County
Ship-to City ----> Ship-to City
Ship-to Address2 ----> Ship-to Address 2
Ship-to Address ----> Ship-to Address
Assigned User ID ----> Assigned User ID
SALES QUOTE LINE
Document Type ----> Document Type
Document No ----> Document No.
No ----> No.
Type ----> Type
Quantity ----> Quantity
Amount Including VAT ----> Amount Including VAT
Requested Delivery Date ----> Requested Delivery Date
We get error stating that “LineIntegrationID” cannot be null. Please suggest us whether the mapping is done to appropriate fields and share your experience for mapping the Quote(CRM) and Sales Quote(NAV).
0