Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV CRM field mapping.

Posted on by 160

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)

*This post is locked for comments

  • Preethi Saravanan Profile Picture
    Preethi Saravanan 160 on at
    RE: NAV CRM field mapping.

    Hi,

    We did separate mapping for Header and Line. But we are struggling to map the equivalent fields. Can you please suggest us.

    Thanks,

    Preethi

  • Verified answer
    Konstantin Levchenko Profile Picture
    Konstantin Levchenko 1,410 on at
    RE: NAV CRM field mapping.

    Hi,

    we did separate sync for Quote header and lines in two different maps.

    I'm not found a way how to sync correctly Custom Document by one map only (got same error as yours).

    Cheers,

    Konstantin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans