locked
integrating NAV-CRM using Microsoft Dynamics NAV connector RRS feed

  • Question

  • Hi,
    I am integrating NAV-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)
    Wednesday, June 26, 2013 1:56 PM

All replies