web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics connector
Microsoft Dynamics CRM (Archived)

Dynamics connector

(0) ShareShare
ReportReport
Posted on by Marco Tazelaar 375

Hi, I have a question regarding the connector between CRM and NAV. I want to synchronize the orders from CRM to NAV.

I do receive the error:

 

Map: Order to NAV Sales Order
Severity: Warn
Text: [Order to NAV Sales Order] has encountered an error while processing key [67a7765f-1703-e211-8ca2-3c4a92dbdc51]. There is no Currency Exchange Rate within the filter.  Filters: Currency Code: EURO, Starting Date: ''..09/20/12
Error Code: Microsoft.Dynamics.Integration.Adapters.Nav2009::0x80131501
In both systems I'm working with the same currency "Euro"

Does somebody know how to solve this issue?

Thanks,

Marco

*This post is locked for comments

I have the same question (0)
  • Konstantin Levchenko Profile Picture
    Konstantin Levchenko 1,410 on at

    Hi,

    This is NAV error. Try to create Sales Order in NAV manually with the same date and Currency and you should get same error.

    Once you will fix it in NAV, Connector should have not issues with this SO.

    Cheers,

    Konstantin

  • Suggested answer
    Surmeet Singh Profile Picture
    Surmeet Singh 3,075 on at

    Hi,

    It might be probem that EURO is the base currency in NAV, generally in NAV LCY is denoted by blank so you might have to use the function [=If(EqualTo(Currency\Dynamics Integration Key, "EURO"), "", Currency\Dynamics Integration Key] while integrating orders from CRM to NAV.

    It must work..

    Regards,

    Surmeet

  • Suggested answer
    Muhammad Adeel Javaid Profile Picture
    Muhammad Adeel Javaid 5,580 on at

    Are you running against NAV 2009 R2?  You must be using R2 for the connector to work.

    If you are running against R2, please ensure that you have the Connector enabled in the NAV client.

    Also try to grant the Dynamics Integration role organizational level access to the entities that it needs increased access to.

     http://blogs.msdn.com/b/dynamicsconnector/archive/2012/05/23/dynamics-integration-security-role-create-permissions.aspx

  • Suggested answer
    Muhammad Adeel Javaid Profile Picture
    Muhammad Adeel Javaid 5,580 on at

    This link could also be of help for you:

    community.dynamics.com/.../67628.aspx

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans