Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

CRM Integration with GP

Posted on by 470

Good day.

When I save a debit note on CRM, the integration should automatically start on the back-end. On the map (sales order to GP) on the connector for microsoft dynamics, it shows on the status column  “attempting to integrate” and the error displayed on the map column-- “error validating NIO currency with GP’

Also Note that the currency ID for Naria in GP is NGN and that of CRM is NIO.

I don't know if there is anyone who has a useful suggestion to the above error.

Thank you.

*This post is locked for comments

  • Alawode Tobi Profile Picture
    Alawode Tobi 470 on at
    RE: CRM Integration with GP

    Before I got the post by Muhammad, i resolved the currency error by changing the currency in GP to NIO. I saw another issue different from the first one when i started the process afresh and checked at the backend.

    The error description is as follows:

    CRM Order to GP Sales Order] has encountered an error……….Sales order id=4cfdae……….does not exist.

    I will be glad if you can help out.

  • Muhammad Adeel Javaid Profile Picture
    Muhammad Adeel Javaid 5,580 on at
    RE: CRM Integration with GP

    Currency information is used differently in Microsoft Dynamics CRM and Microsoft Dynamics GP. Because of these differences, currency information must be slightly converted during the integration process.

    Here are the ways to Map Currency Information for integration purpose:

    1). Open Connector for Microsoft Dynamics.

    2). Go to the integration to work with, and then click the Maps node in the left pane.

    3). Select the GP Currency to Transaction Currency map.

    4). In the Status area, click Activate.

    5). Click the Edit link next to the Check for changes area to open the Map Run Schedule window. Change the map run schedule to run every 45 seconds. Make sure that the Start Date field value is before the date that you first entered data into Microsoft Dynamics GP. Click OK to close the Map Run Schedule window. If your business needs require a longer run time, you can set the Map Run Schedule to any duration.

    6). Verify that the date listed in the Check for data modified after area is before the date that you entered your Microsoft Dynamics GP UofM schedules. To change this date, click the Edit link next to the Check for data modified after area to open the Check for data modified after window. Enter the new value, and then click OK. Start the Connector for Microsoft Dynamics service again.

    7). Click Save on the top command bar. In the Status section of the Map page, the Last run status is displayed. While the integration is running, the Last run status will be displayed as Currently running and displays the numbers of changes found, changes written, deletions found, records deleted, and failures. Wait until Currently running is no longer displayed and the Last run status is displayed to allow the integration to run and move the Microsoft Dynamics GP UofM schedules to Microsoft Dynamics CRM.

    8). Open Microsoft Dynamics CRM and go to Settings, select Business Management, and then select Currencies. All of the currencies that integrated from Microsoft Dynamics GP are displayed. Double-click any existing currency to open the Currency window.  

    9). Verify that all the currencies have been fully integrated.

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